F9 does not recalculate everything, try Shift+Ctrl+F9. However, I would like to see a screenshot of the file in Calc when K49 is highlighted, so I can see it's formula.
J.R. 2007/9/15, musomba <[EMAIL PROTECTED]>: > > 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] > >
