Hello,
I think I found a bug in Writer, when using custom number formats inside
tables. I make a certain cell text green, then I apply the following
number format:
[<-0.1][RED]0%;[>0.1]0%;[BLACK]0%
Basically, if it's below -10%, make it red. If between -10% and +10%,
make it black. If it's above +10%, leave it green.
However, when a cell contains a number between 0% and -10%, it's shown
as a positive value. E.g. -7 will get formatted as 7%, not as -7%. I
have checked the content.xml inside the ODF and the cells really contain
the negative number, not the positive number.
I have created a test document that you can download at:
http://www.jejik.com/sander/temp/number-format-error.odt
The test document contains 4 tables. The top table is the original table
without a number format applied. Table 2 is the same, but with the
number format added in. Tables 3 is what I see in OOo Writer (manually
formatted). Table 4 is what I am supposed to see (manually formatted).
Is this a (known) bug in OOo Writer? Is there something wrong with my
number-format code? I'd greatly appreciate any help here.
Kind regards,
--
Sander Marechal
Product Developer
[EMAIL PROTECTED]
Tribal Internet Marketing &
Internet MARKeting van Werven
Larenweg 24
5234 KA 's-Hertogenbosch
The Netherlands
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
