Bug 120798 - LO Calc: Cell Format "Center on Columns" impossible without cell merging
Summary: LO Calc: Cell Format "Center on Columns" impossible without cell merging
Status: RESOLVED DUPLICATE of bug 159654
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.0.3 release
Hardware: All Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Merge-Split
  Show dependency treegraph
 
Reported: 2018-10-22 15:28 UTC by Jean-Marc SIMIAND
Modified: 2024-02-09 10:28 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
exemple Excel (52.61 KB, image/jpeg)
2018-10-22 15:33 UTC, Jean-Marc SIMIAND
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jean-Marc SIMIAND 2018-10-22 15:28:09 UTC
Description:
Excel permet la fonctionnalité très utile de format de cellules : "centrer sur colonnes". 
LBO Calc 6.1 permet de fusionner les cellules mais jamais de centrer sur colonnes SANS fusion de cellules.

Cette fonctionnalité est utile pour améliorer la présentation sans fusionner les cellules. Je n'utilise JAMAIS la fusion de cellules qui est un non sens sur un tableur puisque cela bloque tous les filtres ou tris !

Actual Results:
Obligation de fusionner les cellules pour centrer sur plusieurs colonnes !

Expected Results:
Centrer sur colonnes SANS fusionner les cellules !


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Jean-Marc SIMIAND 2018-10-22 15:33:43 UTC
Created attachment 145910 [details]
exemple Excel

Excel peut le faire !
Comment 2 m_a_riosv 2018-10-22 23:03:05 UTC
Agree, it's very useful, it was also in 123.
Comment 3 BogdanB 2023-05-06 18:56:01 UTC
Excel allows the very useful function of cell format: "center on columns".
LO Calc 6.1 allows merging the cells, but never to center on columns Without cell merging.

This feature is useful to improve the presentation without merging the cells. I don't use never merging of cells that is a non-sensual on a spreadsheet since it blocks all filters or tries!

Actual Results:
Must merge the cells to center on several columns!

Expected Results:
Center on columns Without merging the cells!
------------------
Description translated with libretranslate
Comment 4 Heiko Tietze 2024-02-09 10:28:53 UTC
Realized after commenting on the other bug that this one has been created before. We usually make the newer ticket a duplicate but I added some comments, screenshots, and a test document on the other ticket.

*** This bug has been marked as a duplicate of bug 159654 ***