To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=54210 Issue #:|54210 Summary:|MASSIVE DEFECT: Calc destorys data connected to |names when inserting cells Component:|Spreadsheet Version:|680m125 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P1 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|nigelenki
------- Additional comments from [EMAIL PROTECTED] Sun Sep 4 20:16:51 -0700 2005 ------- If you name a cell like A5 with "Fubar" and then write formuli in other cells in other sheets in the book using "Fubar", then insert a row above row 5, the actual content (not just the display) of the cells using "Fubar" will become "#REF!" Here are two issues for you to consider: 1. DO NOT. EVER. Destroy the data in cells. Change the DISPLAY to say "#REF!", but leave the content as "=Fubar * Bizbaz". I have sheets where HUNDREDS of cells are tied to names! A corporate environment may find accounting quite pissed if this ever has an affect on them. . . 2. Please TRY to move the names affected by movements of data. If I cut (not copy) and paste a cell or row, if I insert a column, if I delete a row, if I drag a cell upwards, TRY to make sure the names attached to the data that changes its physical location is still attached to that data. 3. If a name is changed, PLEASE OFFER to change all references to it. I may not quite want to do that; but hey, I may want to. I can think of a few reasons to, no great ones but they could happen. Maybe I want to date my margin on sales, caching the old ones (I could design a better sheet to get the same effect of course but eh). Fixing (2) will suppress (1) unless someone deletes a name, of course; in such an event (1) becomes critical again. (1) is probably an easier fix than (2) and will deaden the severity of (2) and (3) as well as cover problems that can't be helped (deleting a name) and SHOULD BE DONE ASAP. I would have submitted 3 separate issues, but this stuff makes sense grouped. I'll submit a separate issue for (1), (2), and (3) and note that this bug explains in better detail why they're needed. --------------------------------------------------------------------- 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]