LO Writer misses an important feature of a text editor, to insert and delete cells in table, and not the entire rows/columns.
How do you insert a cell without inserting a row/column? Just curious, thanks for clarifying for me
LO's spreadsheet. It can insert and remove cells.
I've tested with the 2003 version of a different office suite.
Some of the insert/delete cell options can be achieved inserting/removing rows/columns, but there are some that can not, or are not so convenient.
I've created a table with 5 rows and 3 columns, see attachments, and I put the cursor on the row 3, column 3.
In the other program we have something like:
Table -> Insert -> Cells...
- "move cells right" produces current row with 4 columns, the other rows unchanged! (cell_insert_move_right.png)
- "move cells down" adds a cell in the current position, moves below cells down adding a row at the bottom of the table (with first and last column empty) (cell_insert_move_down.png)
- "insert whole row" inserts an entire row above current one
- "insert whole column" inserts a column on the left of the current one
Table -> Delete -> Cells...
- "move cells to the left" removes current cell and produces row 3 with only 2 columns, other rows unchanged (you have a "hole") (cell_remove_move_left.png)
- "move cells up" removes the current cell and moves below cells upward (cell_remove_move_up.png)
With Calc 4.0 and older I've not found such features.
Created attachment 71769 [details]
move cells right
Created attachment 71770 [details]
move cells down - cell_insert_move_down.png
Created attachment 71771 [details]
move cells to the left - cell_remove_move_left.png
Created attachment 71773 [details]
move cells up - cell_remove_move_up.png
I would like to clarify what Urmas probably means.
Steps to reproduce:
1. Select some cells in Calc.
2. Copy the selected cells.
3. Create a table in Writer and place the cursor into it.
4. Paste the clipboard content (Edit -> Paste or Ctrl+V).
-- or alternatively --
5. Open special paste dialog (Edit -> Paste special or Ctrl+Shift+V) and then select any paste method.
The table is inserted as cell-to-cell. Roughly speaking, each source cell's content is inserted into the appropriate destination cell. If the source cell set has more columns and/or rows then the destination one a dialog should be displayed. The user then choose how to handle this situation (truncate or extend).
-- or alternatively --
The default behavior remains the same as now. But the special paste method list contains another item (e.g. "Cells") which provides the way described above.
The whole table is inserted into the current cell (where the cursor is located). There is no way (even in Paste special) how to accomplish the "expected" behavior.
Urmas' description not clear. Lukas's description seems to related to Bug 37223.
I close as duplicate. Feel free to reopen or to make a new bug if there's better explanation.
*** This bug has been marked as a duplicate of bug 37223 ***
Do not vandalize.
*** Bug 103141 has been marked as a duplicate of this bug. ***