[Solved] Help with XBackground.oxt from topic 98070

Discussions about using 3rd party extension with OpenOffice.org

[Solved] Help with XBackground.oxt from topic 98070

Postby jeffbraak » Wed Jan 08, 2020 5:40 pm

 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.
Last edited by MrProgrammer on Thu Jan 09, 2020 10:18 pm, edited 4 times in total.
Reason: New question from new person needs new topic; Tagged ✓ [Solved]
Openoffice 4.1.7
jeffbraak
 
Posts: 4
Joined: Wed Jan 08, 2020 5:29 pm

Re: Help with XBackground.oxt from topic 98070

Postby Zizi64 » Thu Jan 09, 2020 7:52 am

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.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.4; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8644
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Help with XBackground.oxt from topic 98070

Postby RoryOF » Thu Jan 09, 2020 8:00 am

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.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30161
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Help with XBackground.oxt from topic 98070

Postby jeffbraak » Thu Jan 09, 2020 9:36 am

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 https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=98070
Openoffice 4.1.7
jeffbraak
 
Posts: 4
Joined: Wed Jan 08, 2020 5:29 pm

Re: Help with XBackground.oxt from topic 98070

Postby jeffbraak » Thu Jan 09, 2020 9:45 am

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.
Attachments
Geen titel 1.ods
(15.52 KiB) Downloaded 9 times
Openoffice 4.1.7
jeffbraak
 
Posts: 4
Joined: Wed Jan 08, 2020 5:29 pm

Re: Help with XBackground.oxt from topic 98070

Postby hubert lambert » Thu Jan 09, 2020 3:23 pm

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.
Attachments
XBackground.oxt
(4.05 KiB) Downloaded 5 times
AOOo 4.1.2 on Win7 | LibreOffice on various Linux systems
hubert lambert
 
Posts: 134
Joined: Mon Jun 13, 2016 10:50 am

Re: Help with XBackground.oxt from topic 98070

Postby jeffbraak » Thu Jan 09, 2020 5:46 pm

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.
Openoffice 4.1.7
jeffbraak
 
Posts: 4
Joined: Wed Jan 08, 2020 5:29 pm


Return to Extensions

Who is online

Users browsing this forum: No registered users and 2 guests