To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111211 Issue #|111211 Summary|"Deleting in merged ranges not possible" Calc 3.2.12 Component|Spreadsheet Version|OOO320m12 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|ewallace
------- Additional comments from ewall...@openoffice.org Wed Apr 28 00:06:01 +0000 2010 ------- Now - I understand that this issue was submitted as far back as 2002. It has also been reported a few times since, and in at least a couple of cases the issues were closed as 'duplicate'. I then found a reference in the "What's new in 3.2" read me that this function has been fixed in version 3.2. However, the behaviour seems to remain the same in this version. I have a spreadsheet (an order form) that is populated from columns A to L. Columns A to F form 'one big column', G to L form 'another big column'. In 'big column' A to F, headings appear, which consist of cells A to D merged and cells E and F merged, within one row. (The rows that are NOT headings retain their individual identities, and are populated with various values (SKU, size, etc) ) The contents of the order form vary from week to week, and I have to go in and remove items, which mean I am removing 6 cells (a26,b26,c26,d26,e26,f26) from a row. However, when I go to delete the cell contents, and am presented with the "Shift cells up" I receive the same error message as in all other versions of OpenOffice that I have tried "Deleting in merged ranges not possible" To recap - I am deleting non merged cells from a range in the spreadsheet that has merged cells in the same columns below the cells I am deleting, that span the SAME RANGE as the cells that I am deleting (ie: the merged cells a28-d28) and I am trying to delete (a26-d26) and shift the cells below up. This works in MS Excel - the cells are deleted, and the cells below are moved up. It seems intuitive that that is the way this function should behave - it is not as if I am removing a smaller subset of cells in this virtual 'big column' - I am in essence removing one row from the 'big column'. I downloaded and tried the CalcEasy Toolbar 1.1.2 - and it is very good at removing the whole row across ALL of the cells (BOTH 'big columns' A-F and G-L at once, but it can not remove A-D, for example. I have never explored what goes in to the 'built in' macros of a spreadsheet, but I am an IT veteran, former programmer, and would be willing to assist in any way that I was capable towards resolution of this problem. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
