Tried Shift+Ctrl+F9. No change. http://www.ezziarts.com/calc03.jpg
"Johnny Rosenberg" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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] > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
