[Solved] Help with XBackground.oxt from topic 98070

[jeffbraak]

Edit: Split from [Solved] Set Cell Color based on RGB values in a cell in the Calc forum where XBackground.oxt can be found — MrProgrammer 2020-01-08 09:58 UTC

Hi!
Im trying to use the XBackground.oxt and need some help.
When i type the function it works just fine. When i drag the function to - lets say - row 200, it stops at row 135.
Row 136 gives #value!
Other functions are working just fine.

Is there an easy solution? My level of expertise in OpenOffice is just 1 hour.

[Zizi64]

Im trying to use the XBackground.oxt and need some help.

I do not know anything about this extension. Where we can download it from?
- from the LibreOffice Extensions page?
- from the Apache OpenOffice extensions page?

Please give us a download link.

[RoryOF]

I had a quick look at the internals of the extension and see no inbuilt limits (it uses python code). It would be helpful lto have hands-on of the file in question.

[jeffbraak]

Im trying to use the XBackground.oxt and need some help.

I do not know anything about this extension. Where we can download it from?
- from the LibreOffice Extensions page?
- from the Apache OpenOffice extensions page?

Please give us a download link.

It comes from this form post viewtopic.php?f=9&t=98070

[jeffbraak]

Here you'll find the document.
When i drag the function or dubble click the black square in the cell, the function only goes X far... not the whole colum.

Thanks for looking into it.

[hubert lambert]

Hi,

In the previous post, I tried using threads to workaround a undo problem. It was obviously a bad idea.
I've "rewound" this little extension to a simpler implementation, that should solve your error.
Please note that this was provided as a proof of concept, far from being fully tested and without any warranty...
Regards.

[jeffbraak]

Hi,

In the previous post, I tried using threads to workaround a undo problem. It was obviously a bad idea.
I've "rewound" this little extension to a simpler implementation, that should solve your error.
Please note that this was provided as a proof of concept, far from being fully tested and without any warranty...
Regards.

But this works perfectly! Just what i needed to continue.