Page 1 of 1

[Solved] Help with XBackground.oxt from topic 98070

Posted: Wed Jan 08, 2020 5:40 pm
by 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.

Re: Help with XBackground.oxt from topic 98070

Posted: Thu Jan 09, 2020 7:52 am
by 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.

Re: Help with XBackground.oxt from topic 98070

Posted: Thu Jan 09, 2020 8:00 am
by 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.

Re: Help with XBackground.oxt from topic 98070

Posted: Thu Jan 09, 2020 9:36 am
by jeffbraak
Zizi64 wrote:
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

Re: Help with XBackground.oxt from topic 98070

Posted: Thu Jan 09, 2020 9:45 am
by 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.

Re: Help with XBackground.oxt from topic 98070

Posted: Thu Jan 09, 2020 3:23 pm
by 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.

Re: Help with XBackground.oxt from topic 98070

Posted: Thu Jan 09, 2020 5:46 pm
by jeffbraak
hubert lambert wrote: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.