For some reason my formulas are changing from style to ORG.OPENOFFICE.STYLE, creating a #NAME in my cell. When I change this back style it works fine until you reopen the form it has changed back.
Any ideas?
Thanks!
ORG.OPENOFFICE.STYLE Problems
ORG.OPENOFFICE.STYLE Problems
OOo 3.0.X on Linux-Other + XP Pro
- Hagar Delest
- Moderator
- Posts: 32654
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: ORG.OPENOFFICE.STYLE Problems
Have found some similar problems:
- MOD missing from Danish version
- [Solved] HLOOKUP() and #NAME? error
- Avoiding function language problems
Can you give more details? The full formula for example?
- MOD missing from Danish version
- [Solved] HLOOKUP() and #NAME? error
- Avoiding function language problems
Can you give more details? The full formula for example?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: ORG.OPENOFFICE.STYLE Problems
None of those look related to what I'm experiencing, but I probably didn't explain it well. Here is the code:
The problem is with the:
Before it was simply:
Now it is adding on the additional ORG.OPENOFFICE. and not working. If I truncate it the formula works fine, but on saving it and re-opening it the ORG.OPENOFFICE is back.
Code: Select all
=IF(IF(TRUNC(E12;0)>TRUNC(E11;0);SUM(((MOD(E12;1))+(0.6-MOD(E11;1))))*100;SUM((MOD(E12;1)-MOD(E11;1)))*100)+IF((TRUNC(E12;0)-TRUNC(E11;0))=2;60;0)<29.99999999999;org.openoffice.style("<");org.openoffice.style(">"))
Code: Select all
org.openoffice.style("<")
Code: Select all
style("<")
OOo 3.0.X on Linux-Other + XP Pro
Re: ORG.OPENOFFICE.STYLE Problems
You are using one of the broken compilations of OOo from one of those Linux distributors constantly trying to improve this software for the worse. Just install the original compilation by Sun from http://download.openoffice.org, prove the md5 check sum, remove the distributor's packages, install the "real ones" and reject the offer to take over user settings from previous installations.
[Tutorial] Installing OOo on Ubuntu, Debian and Co.
[Tutorial] Installing OOo on Ubuntu, Debian and Co.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice