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". Best regards Johnny Andersson --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
