On Sat March 25 2006 14:26, + Johnny Andersson wrote: > [ MODERATED ] *********************** > 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". >
Can you please report this in issuezilla ? ( http://openoffice.org -> "My Pages" -> "Register", then when you receive a confirmation email, "Login" and "File an issue" ) In this way the relevant developers will see your bug report / suggestion and you will also see the progress of this feature / bug report if it is accepted. Please reply to [email protected] only -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
