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]
