On Sat, 2006-03-25 at 15:26 +0100, Johnny Andersson wrote:
> This is, to me, very strange....
>
> The E column of a spreadsheet... there are some calculated values, shown with
> 2 decimals. E2 contains =max(E3:E1000) or something like that.
>
> I thought that 2 decimals was not enough so I changed to 3. I highlighted the
> E column and changed the number of shown decimals to 3. Each one of the cells
> in the E column (E3:E1000) contains contidtional formatting. They are all
> compared to E2 and if they are equal to E2 the background colour of that
> cells turns green. This is a typical example where the precision of the
> calculations are critical (and I have had a lot of problems in that matter
> with OpenOffice Calc, but no one seems to care at all). So when I change to 3
> decimals, the cell with the highest value (the same value as E2), which was
> green before, is no longer green (sometimes, but sometimes it is... which
> make the whole thing even more strange). As if this would not be enough, it
> only shows 2 decimals!
>
> If anyone is interested, I can send the whole file. If you can manage how to
> fix this, then you certainly can do something that I can not... As long as I
> keep using 2 decimals, everything works fine, in any other case it doesn't.
>
> I made some changes in Tools - Options - Spreadsheet - Calculate, but all
> with no seccess at all. Like I changed the decimal field to 3 instead of 2
> and I unchecked a checkbox called something like "precision as shown".
>
Better bring this to the attention of the developers. Therefore, I
suggest that you enter an issue into Issue Tracker as this is the best
way to have requests such as this evaluated.
If you haven't already registered, do the following:
1. To file an issue you must register with OOo by clicking the
My Pages tab and selecting the Register link
http://www.openoffice.org/servlets/Join
2. Fill in your information
3. Reply to the confirmation email that will be sent to the address
you provided.
4. Once you have confirmed, go to www.openoffice.org again
5. And click on the "My Pages" tab from which you can file and find
issues.
Thanks for bringing this to our attention. It is important that you file
any examples with the issue to ensure your need is understood.
--
PLEASE KEEP MESSAGES ON THE LIST.
OpenOffice.org Documentation Co-Lead
http://documentation.openoffice.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
