Bug 33749 - Inconsistencies with Help texts, Tooltips, Translations regarding Cell Merging and Splitting in Calc
Summary: Inconsistencies with Help texts, Tooltips, Translations regarding Cell Mergin...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard: target:3.5
Keywords:
Depends on:
Blocks: Help-Changes-Features
  Show dependency treegraph
 
Reported: 2011-01-31 01:30 UTC by Winfried Donkers
Modified: 2018-09-29 21:05 UTC (History)
9 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshots, See Comment 1 (106.44 KB, application/pdf)
2011-05-29 07:48 UTC, Rainer Bielefeld Retired
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Winfried Donkers 2011-01-31 01:30:35 UTC
The toolbar button 'join cells' works as a toggle switch. It joins or devides cells depending whether seperate cells are selected or a previously joined cell. This functionality is not mentioned in the help and gives confusion with the toolbar button 'devide cells'.
Comment 1 Rainer Bielefeld Retired 2011-05-29 07:46:37 UTC
Some inconsistences reproducible with "LibreOffice 3.4.0RC2  – WIN7  Home Premium  (64bit) English UI [OOO340m1 (Build:12)]". There are some additional strange effects and inconsistencies, pls see attached screenshots.

A. Button 'Merge and Center' toggles function, 'Merge' does not. That's unexpected (and also that the 'Merge and Center' icon becomes active after 'Merge' icon has been used.

B. 'Split Cell' icon  always is shown active, although function is impossible

C.: "Center" Missing in Tooltip and short help

D.: Same icon for different functions

E.: Wrong description of possible function

Translation / Localisatoin issues
----------------------------------
L. Tooltips and at least one translation [DE][FR] (expected: all) missing, please see attached sceenshots

M. Description wrong, no submenu, but toggling


@Dnk1287:
What "Help" are we talking about? Short help of can you also contribute a Help text reference for those buttons?

@all:
Please feel free to shift some of my items to separate bug reports.

@Kohei:
Please feel free to reassign if it's not your area!
Comment 2 Rainer Bielefeld Retired 2011-05-29 07:48:54 UTC
Created attachment 47274 [details]
Screenshots, See Comment 1
Comment 3 Christoph 2011-05-29 14:31:24 UTC
Good catch, Dnk1287, Rainer! It seems that some functionality of Calc has been "Excel-fied" to a certain degree - and quite some issues have been introduced.

For the record, OOo 3.3.0 (OOO330m20) behaves rather consistently:
* Only one item in the toolbar: "Merge Cells" toggles cell merging without (!) centering
* Only one item in the application menu: "Format -- Merge Cells" works like the toolbar item
* Option item "Merge Cells" can be added to the toolbar that only (!) activates merged cells. After merging, icon becomes inactive. (This seems strange ...)

Concerning the current LibO behavior, some other things that are weird:
a) Undoing the cell merge is called "split cells" - which is partly true with regard to similar Writer functionality (Excel: Unmerge cells)
b) "Merge and Center" sets both format "center" and "middle" - Excel behaves differently (just center, if I remember correctly)
c) The menu item "Merge and Center Cells" is inaccurate, since it is "Merge Cells and Center (Content)"
d) Extending Rainer's description for B (Split Cell always shown active), the menu item seems to reveal something very interesting. The menu item is grayed out, but the icon is not (???).

Is there any specification / EasyHack description that explains the initial idea for the change - unfortunately, at the moment, it seems barely usable.
Comment 4 Winfried Donkers 2011-06-06 08:50:05 UTC
(In reply to comment #1)
> Some inconsistences reproducible with "LibreOffice 3.4.0RC2  – WIN7  Home
> Premium  (64bit) English UI [OOO340m1 (Build:12)]". There are some additional
> strange effects and inconsistencies, pls see attached screenshots.
> 
> A. Button 'Merge and Center' toggles function, 'Merge' does not. That's
> unexpected (and also that the 'Merge and Center' icon becomes active after
> 'Merge' icon has been used.
> 
> B. 'Split Cell' icon  always is shown active, although function is impossible
> 
> C.: "Center" Missing in Tooltip and short help
> 
> D.: Same icon for different functions
> 
> E.: Wrong description of possible function
> 
> Translation / Localisatoin issues
> ----------------------------------
> L. Tooltips and at least one translation [DE][FR] (expected: all) missing,
> please see attached sceenshots
> 
> M. Description wrong, no submenu, but toggling
> 
> 
> @Dnk1287:
> What "Help" are we talking about? Short help of can you also contribute a Help
> text reference for those buttons?
> 
> @all:
> Please feel free to shift some of my items to separate bug reports.
> 
> @Kohei:
> Please feel free to reassign if it's not your area!

The help I meant is the help you get when pressing F1. As the functionality of the buttons is confusing now (I don't know whether the present functionality is the wished-for functionality) I do not feel able to contribute a help text reference. Also, my English may not be adequate.
Comment 5 Kohei Yoshida 2011-11-30 17:35:11 UTC
Hi Christoph,

Well, I need some help from you turning this into an actionable item.

(In reply to comment #3)
> Good catch, Dnk1287, Rainer! It seems that some functionality of Calc has been
> "Excel-fied" to a certain degree - and quite some issues have been introduced.
> 
> For the record, OOo 3.3.0 (OOO330m20) behaves rather consistently:
> * Only one item in the toolbar: "Merge Cells" toggles cell merging without (!)
> centering
> * Only one item in the application menu: "Format -- Merge Cells" works like the
> toolbar item
> * Option item "Merge Cells" can be added to the toolbar that only (!) activates
> merged cells. After merging, icon becomes inactive. (This seems strange ...)

Yes, that was the old behavior we replaced.  For the record, the Oracle folks (I don't remember who it was we were talking to) were quite receptive of our proposed change, which was never incorporated but now is in libreoffice.

> Concerning the current LibO behavior, some other things that are weird:
> a) Undoing the cell merge is called "split cells" - which is partly true with
> regard to similar Writer functionality (Excel: Unmerge cells)

Do you suggest that we change the wording here to Unmerge cells, instead of split cells?

> b) "Merge and Center" sets both format "center" and "middle" - Excel behaves
> differently (just center, if I remember correctly)

Ok. Which behavior do you think is more appropriate?  Center and middle, or just center?  I'm okay either way.

> c) The menu item "Merge and Center Cells" is inaccurate, since it is "Merge
> Cells and Center (Content)"

Do you suggest that we change it?  For comparison, Excel calls it "Merge and Center".

> d) Extending Rainer's description for B (Split Cell always shown active), the
> menu item seems to reveal something very interesting. The menu item is grayed
> out, but the icon is not (???).

Yeah.  I think we were supposed to provide two sets of the same icon: one for the active state and one for the inactive state.  I guess we forgot to include the one for the inactive state.  Easy to fix I think.

> Is there any specification / EasyHack description that explains the initial
> idea for the change - unfortunately, at the moment, it seems barely usable.

Unfortunately not.  I believe it was an ad-hoc change to bring this functionality closer to Excel's.  Let's just say that we now have the opportunity to right the wrong.  Your feedback to my above questions will certainly help us improve this. :-)

Thanks.
Comment 6 Kohei Yoshida 2011-12-12 10:17:16 UTC
I need input from Christoph in order to proceed.
Comment 7 Florian Reisinger 2012-08-14 14:01:47 UTC Comment hidden (obsolete)
Comment 8 Florian Reisinger 2012-08-14 14:02:50 UTC Comment hidden (obsolete)
Comment 9 Florian Reisinger 2012-08-14 14:07:25 UTC Comment hidden (obsolete)
Comment 10 Florian Reisinger 2012-08-14 14:09:31 UTC Comment hidden (obsolete)
Comment 11 Winfried Donkers 2012-08-15 05:52:55 UTC
Reopened this bug;

version 3.6.0.4 still lacks the help text that explains the behaviour of the toolbar button 'merge and centre cells'. The button acts as a toggle switch, e.g. either merges or splits the selected cell(s), but the help text (Libreoffice help, serach for merge cells or split cells) does not mention the double action of the button. It just mentions two separate menu options to either merge or split cells.
Comment 12 Winfried Donkers 2012-08-16 07:10:12 UTC
(In reply to comment #11)
Addition:
The tooltip (hint when mouse is above button) says 'merge and centre cells', even when the button action will be 'split merged cells'.
Comment 13 Julien Nabet 2014-08-24 07:05:04 UTC
Merge and Center Cells doesn't exist anymore, at least with 4.3.0.3, and certaily oldest version according to this commit:
http://cgit.freedesktop.org/libreoffice/core/commit/?id=a747ad22d5c44ce291fd1e502c3fa29008ae653a

I put it as WFM.
Don't hesitate to reopen this one if I missed something or simply am wrong.
If not, some cleaning could be useful, see:
- http://opengrok.libreoffice.org/search?q=%22.uno%3AToggleMergeCells%22&project=core&defs=&refs=&path=&hist=
- http://opengrok.libreoffice.org/search?q=ToggleMergeCells&project=core&defs=&refs=&path=&hist=
Winfried: If ok, I could do it
Comment 14 Winfried Donkers 2014-09-09 05:34:06 UTC
(In reply to comment #13)
> Merge and Center Cells doesn't exist anymore, [...]

In master (4.4.0.0alpha0+) the button 'merge and centre cells' still exists and the tooltip does not change with the functionality of the button (i.e. merge or unmerge).

I probably don't understand your comment, so I haven't changed the status reopened(yet).
Comment 15 Julien Nabet 2014-09-09 05:39:20 UTC
You're right Winfried! It doesn't appear with right click contextual menu but it's there in Format/Merge menu
Comment 16 Joel Madero 2014-11-03 04:47:44 UTC
Status should be NEW not REOPENED.
Comment 17 QA Administrators 2015-12-20 16:08:41 UTC Comment hidden (obsolete)
Comment 18 Winfried Donkers 2015-12-21 08:23:13 UTC
Bug report is still valid
Comment 19 Olivier Hallot 2016-02-09 11:56:47 UTC
I put this bug as a blocker of bug 80430 because it is a help text / documentation issue on the merge and center cell UI button.
Comment 20 Sophia Schroeder 2017-05-03 07:52:48 UTC
Maybe I can work on it in the near future, but I don't want to hold back others to take this task.