To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111211
------- Additional comments from [email protected] Wed Apr 28 16:40:13 +0000 2010 ------- 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. --------------------------------------------------------------------- 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]
