Bug 43104 - [UI]Warning Message for merging cells with contents should reflect application's behaviour more accurately
Summary: [UI]Warning Message for merging cells with contents should reflect applicatio...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Master old -3.6
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-Merge-Split
  Show dependency treegraph
Reported: 2011-11-20 03:38 UTC by camillem
Modified: 2017-06-03 20:44 UTC (History)
0 users

See Also:
Crash report or crash signature:

Patch for the proposed new message (557 bytes, patch)
2011-11-20 03:38 UTC, camillem

Note You need to log in before you can comment on or make changes to this bug.
Description camillem 2011-11-20 03:38:44 UTC
Created attachment 53700 [details]
Patch for the proposed new message

Calc's behaviour when merging several cells with contents is quite different from other applications, and not obvious to guess. 
In other applications, like gnumeric or Google spreadsheet, the contents of the cell resulting of the merge is the contents of the first cell, while the contents of the others is deleted. When you un-merge the cell, the first cell has its original contents while all the others are empty.
In Calc, you can choose to merge the cells' contents or to use the contents of the first cell and hide the other contents. With the first choice, unmerging the cell gives you a first cell with the merged content and the other cells that are empty ; with the second choice, you get all your cells with their initial contents.

Whether Calc's behaviour should be changed is a tough question that won't be discussed here. The point raised in this bug report is that the warning message issued for this action ("Should the contents of the hidden cells be moved into the first cell?") is quite confusing for the user and technically inaccurate.

I propose the following phrasing instead: 

"Also merge the contents of the cells ? (if not, only the content of the first cell will be shown, the rest will be hidden)"

As I'm no native English speaker, the wording may be sub-optimal, but it was chosen with the following points in mind : 

- Underline the fact that the cells will be merged anyway, but that the question is about *content* merging (hence "Also").
- Allow to keep the same type of dialogue (Yes/No/Cancel).

This should allow a simple correction of STR_MERGE_NOTEMPTY in /core/sc/source/ui/src/globstr.src
Comment 1 camillem 2011-11-20 08:26:18 UTC
Other Patched posted on dev list