Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | "Deleting in merged ranges not possible" Calc 3.2.12 | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | ewallace <erik.wallace> | ||||
Component: | editing | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | elish, issues, rb.henschel | ||||
Version: | OOO320m12 | Keywords: | needmoreinfo, oooqa | ||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | Windows XP | ||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
ewallace
2010-04-28 01:06:01 UTC
Created attachment 69153 [details] Issue 111211 example from Erik Wallace I can see the error message, when working with your document. But I cannot produce such a document. In all new documents, which I have tested, deleting cells was possible with the desired "shift cells up". I use DEV300m77 on WinXP. Please try it with a _new_ small document. Please use the actual version of OOo. Workaround: Delete the content and then select the cells below and drag them up. Thank you for the quick response. Upon further testing on this issue: 1. The behavior of Open Office is the SAME whether or not the document has been created in Open Office Calc or MS Excel. I made a mistake in getting rid of a merged cell at the bottom of the spreadsheet that had 8 merged cells on a row before sending in the issue. 2. Deleting cells that lie ABOVE merged cells WILL work as long as you select the same number of cells to delete as are in the LARGEST MERGED CELL below the range you are deleting. EX: you have a spreadsheet with cells A5 to D5 merged (as a column heading). You have data in cells in rows 6 to 10. A12 to D12 are also merged (as a column heading). Further down, you merge A20 to F20 (as a PAGE footer - it is 8 cells merged as opposed to 4 cells merged in the column headers). You will NOT be able to delete and 'move up' in cells A7 to D7 (as an example) - you will get the error message "Deleting in merged ranges not possible". However, if you delete and 'move up' cells A7 to F7 this WILL work - and you will not get an error message. 3. In Excel, a similar behavior exists. The difference is that when you delete and 'move up' a smaller subset of cells (a7 to d7) than the range of the largest merged cell below (a20 to f20) Excel warns you that "doing this will unmerge some already merged cells". It allows the operation to happen, but Excel unmerges cells a20 to f20. Therefore - the difference in behavior of unmerging cells a20 to f20 in Open Office, vs deleting the cells and having Excel unmerge them for you, is that Excel is doing one step (unmerging the large merged cell) for you. Also, the message information given back to the user is probably more intuitive in Excel than in Open Office. This Issue requires more information ('needmoreinfo'), but has not been updated within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download Please report back the outcome of your testing, so this Issue may be closed or progressed as necessary - otherwise the issue may be Resolved as Invalid in the future. Highlight cells A28:D28 - right click - Delete... - Shift cells up Calc Rev. 1505643 Win 7: "Deleting in merged ranges not possible" Excel 2007: "This operation will cause some merged cells to unmerge. Do you wish to continue? - OK -> cells are deleted. |