Bug 42989 - FORMATTING: Selecting Multiple Cells with Different Formats Show as Same Format and Can't Be Changed as a Group
Summary: FORMATTING: Selecting Multiple Cells with Different Formats Show as Same Form...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
: 77571 (view as bug list)
Depends on:
Blocks: Cell-Format-Dialog
  Show dependency treegraph
Reported: 2011-11-16 05:56 UTC by webmeister
Modified: 2023-08-05 22:01 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

ODS File contains fields with different formats. (10.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-11-16 05:56 UTC, webmeister

Note You need to log in before you can comment on or make changes to this bug.
Description webmeister 2011-11-16 05:56:35 UTC
Created attachment 53600 [details]
ODS File contains fields with different formats.

Problem description: Cell formats show as same when they aren't.

Steps to reproduce:
1. In the attached document, select cells A3 through A12.
2. Select Format>Cells.  You see Number>General.  (This is not true.)  Click OK.
3. Select cells A5 through A12.
4. Select Format>Cells.  Now you see Text.

Current behavior: Shows cells A3 through A12 as same.  Click OK and nothing changes.

Expected behavior: Show cells as various.  (Give me some indication.)  Let me change the whole group in one setting.

Platform (if different from the browser): 
Browser: Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.4; fr; rv: Gecko/2011091218 Camino/2.0.9 (MultiLang) (like Firefox/3.0.19)
Comment 1 sasha.libreoffice 2012-04-20 09:47:44 UTC
reproduced in 3.3.4 and 3.5.2 on Fedora 64 bit
Comment 2 Harald Koester 2012-05-25 01:41:10 UTC
The same problem exists with tables in Writer.

Steps to reproduce:
(1) Create table. 
(2) Assign category Percent to first cell. 
(3) Assign category Currency to next cell. 
(4) Mark both cells. 
(5) Display dialog “Number Format”. Now “Number” is displayed as Category and “Standard” is displayed as Format. I expect a display, that indicates, that the format is different. (e. g. for Category “different
categories” and for Format “different formats”).
Comment 3 Harald Koester 2012-12-07 11:27:34 UTC Comment hidden (obsolete)
Comment 4 sophie 2014-04-29 14:55:10 UTC
*** Bug 77571 has been marked as a duplicate of this bug. ***
Comment 5 QA Administrators 2015-06-08 14:42:16 UTC Comment hidden (obsolete)
Comment 6 Harald Koester 2015-06-18 09:17:09 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2016-09-20 10:01:16 UTC Comment hidden (obsolete)
Comment 8 Harald Koester 2016-09-30 21:27:48 UTC
I did some more research: 

(1) In Calc it is possible to change cells with different number formats as a group if you change the category. E.g. step 2 of initial report:

Format > Cells... > select category 'Currency' > OK

In this case all cells are formated as currency. The bug only appears, if you keep the displayed category.

(2) In Writer it is always possible to change cells with different number formats as a group. Only the displayed number format is wrong.

Bug still exists in version 5.2.2 with Win7.
Bug already exists in version 3.3.0. Hence inherited from OOo.
Comment 9 QA Administrators 2018-07-18 02:38:51 UTC Comment hidden (obsolete)
Comment 10 mosesantony2013 2019-12-19 06:32:33 UTC Comment hidden (spam)
Comment 11 Harald Koester 2020-03-31 12:58:48 UTC
Checked with version 6.4.2. (Win10)
Bug still exists in Calc and Writer.
Comment 12 Rosemery2511 2020-09-24 00:26:32 UTC Comment hidden (spam)
Comment 13 Henry 2021-01-06 09:33:57 UTC Comment hidden (spam)
Comment 14 techfixya 2021-01-14 06:15:50 UTC Comment hidden (spam)
Comment 15 fixofflineprinters 2021-06-18 15:51:20 UTC Comment hidden (spam)
Comment 16 Rosemery2511 2021-07-14 19:44:50 UTC Comment hidden (spam)
Comment 17 weddingvedas 2021-08-26 20:50:00 UTC Comment hidden (spam)