I forgot a fifth option for the move cell-range option:
IF the range is moved over an area that already is populated with some
data, then Calc should open a warning box having the following 5 buttons:
'Cancel'
'Overwrite existing data.'
'Insert. Shift right.'
'Insert. Shift down.'
'Swap ranges'
The last option would swap the 2 regions. This is most useful with full
columns/rows (but may be useful with ranges, too).
Thnaks,
Leonard
Leonard Mada wrote:
Hi,
Thomas Benisch wrote:
Currently in Calc neither rows nor columns can be easily moved
manually.
It is possible to drag & drop e.g. a column into a new position,
but the dropped column is not inserted, but overwrites the existing
cells.
...
3.) ask user when dropping
----------------------
Another approach may be to ask the user, that means opening a dialog
after releasing the mouse button. The user may choose between
overwriting existing cells or simply inserting.
cons: - No visual indicator for the exact drop position.
- The dialog may be bothersome.
Any ideas and comments are welcome.
I usually disfavour approaches involving user action. However, IF the
move overwrites existing data, I believe that at least a warning is
warranted. [For people who do NOT like such warnings, an option may be
implemented to disable this.]
IF such a warning message is implemented, then a more advanced
Messagebox seems the logical consequence:
There should be a small message box (quite small, not very big), with
4 buttons (radiobuttons involve an additional click, so there should
be really 4 buttons):
'Overwrite existing data.'
'Shift cells right.'
'Shift cells down.'
'Cancel'
The 'Shift cells' action would insert additional cells and shift the
old cells accordingly. Therefore, cell ranges are handled correctly
with this approach. And overwriting existing data is avoided (which
Calc currently does).
Of course, there remains a problem, IF the move DOES NOT overwrite any
data. I think that in this situation a simple move is warranted
(without prompting any user action).
Well, I will think more thoroughly about this feature in the next few
days.
Sincerely,
Leonard
---------------------------------------------------------------------
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]
