On Sat, 2006-03-25 at 15:26 +0100, Johnny Andersson wrote: > This is, to me, very strange....
I'd be happy to look at your file if you want to send it to me privately. I tried to reproduce the error but no-doubt my table was inadequate. > 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". > > Best regards > > Johnny Andersson > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
