Apache OpenOffice (AOO) Bugzilla – Issue 18330
formulas hidden on multi-sheet spreadsheets
Last modified: 2003-09-08 16:55:29 UTC
Prepare a spreadsheet with more than one sheet, including cell formulas on each. Save the spreadsheet. Load the spreadsheet, and the cell formulas are not displayed! They appear to still be there and functioning; it's just that they're invisible now. Is this some kind of security feature (e.g., lock the spreadsheet so that formulas aren't visible) that ran amok?
Could not reproduce on OOo1.1rc3. Please check on this version. Closing worksforme. Frank
closed worksforme
Something I forgot to mention is that the sheets have links to cells in one or more of the other sheets. E.g., sheets 1 through 3 are January, February, and March sales, and sheet 4 is the First Quarter totals, referencing cells in the first three sheets. That may have something to do with it (or it's been fixed since 1.1 Beta 2).
Hi, I've tried it with several links on the same sheet, on different sheets, across sheets and so on. I was not able to reproduce it on OOo1.1rc3. So please check it on this version. OOo1.1beta2 is really outdated. Closing this one as worksforme. Frank