ORG.OPENOFFICE.STYLE Problems

[jokker]

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!

[Hagar Delest]

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?

[jokker]

None of those look related to what I'm experiencing, but I probably didn't explain it well. Here is the code:

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(">"))

The problem is with the:

Code: Select all

org.openoffice.style("<")

Before it was simply:

Code: Select all

style("<")

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.

[Villeroy]

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.