To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111732 Issue #|111732 Summary|Using SUM over more than 28 sheets will result in #N/A Component|Spreadsheet Version|OOo 3.0 Platform|Unknown URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|wmgysi
------- Additional comments from [email protected] Thu May 20 17:49:32 +0000 2010 ------- I want to use the Sum command to add one field (in the same location on the sheet for all sheets) on lets say 52 sheets. I put the cell with the result on sheet 53. That works fine and I save the document. Next time I call up the document and the value in the cell on sheet 53 is now #N/A. The formula which was in there and was saved is gone! This is the formula: =SUM('32 Books'.G24;Armchair.G24;'Bacchus '.G24;'Beryls Sorrento'.G24;Blackberry.G24;Blackbond.G24;'Blue Heron'.G24;Bookingham.G24;'Bookland Kamloops'.G24;'Bookland Vernon'.G24;'Book Nook'.G24;'Bosun''s Locker'.G24;'Cafe '.G24;Cash.G24;C_Burnaby.G24;C_Coquitlam.G24;'C_Granville_St.'.G24;C_Kamloops.G24;C_Kelowna.G24;C_Langley.G24;C_Richmond.G24;C_Surrey.G24;C_Victoria.G24;Coho.G24;'Curious Coho'.G24;'Gallery Vertigo'.G24;'Gorilla Foods'.G24;'Grinders Kamloops'.G24;'Grizzly Revelstoke'.G24;Hanna.G24;'Hidden Gem'.G24;'Ivy''s'.G24;'Jamie''s Whaling'.G24;'K&K'.G24;'Laughing Oyster'.G24;'Library Ferni'.G24;'Massey''s'.G24;'Mermaid Tales'.G24;Mosaic.G24;'Nico''s'.G24;'Pages Calgary'.G24;'People''s Coop'.G24;'Russel Victoria'.G24;Salamander.G24;'Sign Of The Fish'.G24;Sorensen.G24;'Tall Tales'.G24;Tanners.G24;'The Book Place'.G24;'The Crow''s Nest'.G24;The_Good_Planet.G24;'United Library'.G24;'The Travel Bug'.G24;'Volume One'.G24;Wanderlust.G24;'Wild Heather'.G24) I tried to find the problem and narrowed it down to the fact that if I have more than 28 cell references it will not work anymore (it will work as long as you don't reload the saved spreadsheet). So I did 3 sums each with less than 28 cell references, add them togeter and it works. It also works iif you just use the + function. However I did use the Sum function and became quite frustrated. It would be nice for other users to know about this. I could not find anything in the FAQ list or bug reports so I like to report it here. And I feel the SUM function should not be limited to a certain number of cell references. Take care Werner Gysi --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- 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]
