To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100252
------- Additional comments from [email protected] Fri Apr 17 16:30:52 +0000 2009 ------- I attached a stripped down version of my spreadsheet that still displays the same faults to the email I received a month ago. I guess I was supposed to add it here. A stripped down version of my spreadsheet is attached. The following will demonstrate 2 separate errors. I feel that they are linked however, because they appear only when cells are hidden from view. That's the common element. Place the sheet where macro execution is enabled as it relied on macros to function. Any time you want to start over again, just save the sheet and the 522 error will return. I removed huge portions of this spreadsheet so you have less to consider when analysing it. I didn't remove lots of the macro code, but because about 30 sheets are missing, please don't hit any buttons present on the sheets. Normally, all the sheets are protected during macro execution, but to demonstrate these errors protection makes no difference, so I unprotected the Now sheet. Hit enter on the “Ready” message. Set your autosave off so it won't interfere. Go to the Now sheet Fix your screen so that cell T47 is NOT visible. Go to B27 Enter 1 You now have a 522 error in U41 and a few other places. Go to B27 Enter 2 The error is gone. Make cell T47 visible by scrolling to see it. Make cell T47 invisible by scrolling to hide it. Execute macro Standard/tableReceipt Go to sheet Receipt and look at it. The total is correct. Go to the Now sheet Go to B27 Enter 1 No more 522's till the next save. Execute macro Standard/tableReceipt Go to sheet Receipt and look at it. The total is wrong. Go to the Now sheet Make cell T47 visible by scrolling to see it. Make cell T47 invisible by scrolling to hide it. Execute macro Standard/tableReceipt Go to sheet Receipt and look at it. The total is now correct. Go to the Now sheet Highlight columns G and T and right click / show the columns in between. Save the spreadsheet to start over again, but this time there will be no 522 errors because the hidden columns are now visible. Fix your screen so that cell T47 is NOT visible. Go to B27 Enter 1 No more 522's under any circumstances. By un-hiding the formerly hidden columns, the 522 error is permanently gone. However, the other error still persists. Make cell T47 visible by scrolling to see it. Make cell T47 invisible by scrolling to hide it. Execute macro Standard/tableReceipt Go to sheet Receipt and look at it. The total is correct. Go to the Now sheet Go to B27 Enter 2 Execute macro Standard/tableReceipt Go to sheet Receipt and look at it. The total is NOT correct Because T47 is not visible, it contains a bogus total. The 522 error can be made to go away via ctrl-shift-F9 as well, but just an F9 won't do it. If you read the code for the tableReceipt macro and what it in turn calls, you'll note that only the following line is worth your concern: grandTotal=sheet.getCellRangeByName("Table.tabLemps").getValue() When T47 (aka tabLemps) is not visible it contains what it did the last time it was visible, so the getValue returns an incorrect value. Obviously, cells that are not visible are not getting updated. Therefore macros that interrogate cells are given wrong answers. Regardless of visibility, all the cells within the spreadsheet MUST get updated or else the spreadsheet will give different answers depending on what cells are visible at any particular time and that means the spreadsheet is absolutely unreliable. --------------------------------------------------------------------- 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]
