Thanks you so much for your quick response. It is encouraging that your computer opens up this document correctly.
In order to try and solve the problem i downloaded and installed open office (version 2.2.1) on my laptop so the screen caps are from my computer. Both my boss and myself have this problem when opening mullah.xls with open office. The hidden column is for chipped panels. Its hidden because the data is not important. I have updated mullah.xls so this column is now visible. The problem remains even after unhiding column I and starts as early as cell K49 I have had a look at the recalculation issue. It is set for auto recalculation. Pressing F9 does not make the problem go away. See http://www.ezziarts.com/calc02.jpg "Adrian Try" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi Musomba > > > When opened in calc, the 'balance owed' column gets all jumbled up. see > > screen cap here:- > > I and every one else at work uses excel, My Boss has begun to use open > > office on his laptop and wants me to solve this problem. he does not > > believe > > its an open office problem. > > I agree with your boss - it's not a problem with OpenOffice. When I open > the spreadsheet with OpenOffice, I get the same results as your Excel > screenshot. > > The question is: Why is your boss's Calc giving different results? The key > seems to be the formula in K54. > > Is the spreadsheet that your boss is opening the same spreadsheet that > everyone else is opening, or a copy that may have been modified? The > formula refers to cell I54. Column I is hidden. Is it possible that there > is a value entered there? > > Or is it possible that he has turned recalculation off? Check the Tools / > Cell Contents menu section. > > Adrian > > > -- > Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
