https://bugs.freedesktop.org/show_bug.cgi?id=41113
Stephan van den Akker <stephanv...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #4 from Stephan van den Akker <stephanv...@gmail.com> 2012-03-06
05:21:15 PST ---
@Rainer Bielefeld: Good questions.
Copying cell content without formatting is something I use a lot. It is an
invaluable part of a workflow that re-uses heavily formatted sheets with new
data.
Writer actually behaves in the way i would expect and prefer for Calc (see
"Expected behavior" in my original post).
But, then Calc's help on merging cells says:
"You can select adjacent cells, then merge them into a single cell. Conversely,
you can take a large cell that has been created by merging single cells, and
divide it back into individual cells.
When you copy cells into a target range containing merged cells, THE TARGET
RANGE GETS UNMERGED FIRST, then the copied cells are pasted in. If the copied
cells are merged cells, they retain their merge state." (capitalization mine)
I guess the second paragraph is trying to tell me to expect the actual
behavior, but it still doesn't make sense to me. It just seems to me that the
user is exposed to the implementation details of merging.
I would prefer and expect merged cells to behave as a single cell, just as the
first help paragraph says and just like in Writer. I like programs with little
or no exceptions to their own base rules (just like a good Sci Fi movie...).
How do other speadsheets do it:
Excel 97, Excel 2007, Gnumeric: Error message, whining about the target range
not being compatible with the copied content. No copying possible...
Calligra Tables: same as present behavior of Calc
So, to recap, my arguments to change Calc's behavior:
1: I expect merged cells to behave as 1 cell
2: Writer does it the way I prefer: Calc is behaving inconsistenly
3: Calc's behavior is unexpected for you too (that makes 2 out of 2).
But basically, it comes down to taste and consistency. What do
other users expect?
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
