Bug 76371 - indent working randomly on right aligned cells containing numbers
Summary: indent working randomly on right aligned cells containing numbers
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
: 65828 80794 (view as bug list)
Depends on:
Blocks:
 
Reported: 2014-03-19 20:34 UTC by rreno56
Modified: 2016-12-10 23:29 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
faulty behaviour can be checked on attached file (132.15 KB, application/vnd.openxmlformats-officedocument.spreadsheetml)
2014-03-19 20:34 UTC, rreno56
Details

Note You need to log in before you can comment on or make changes to this bug.
Description rreno56 2014-03-19 20:34:48 UTC
Created attachment 96070 [details]
faulty behaviour can be checked on attached file

Problem description: 

Steps to reproduce:
1. take the attached xlsx file
2. select all cells containing numbers (you can try on each sheet)
3. apply right alignement
4. increase indent from the toolbar

==> few cells will take the indent but most of them won't moove

Problem not present when file saved in .ods
              
good luck
:)
Comment 1 m_a_riosv 2014-03-20 02:20:26 UTC
Hi rreno56, thanks for reporting.

Sorry but I think toolbar indent is only for left indent.

Activating the extending tips in Menu/Tools/Options/LibreOffice/General - Tips. Shows the explanation when the mouse is over the icon in toolbar, explicitly about left indent.
Comment 2 rreno56 2014-03-26 17:07:34 UTC
Hi m.a.riosv


Right indent is implemented in MS Office and usable in xlsx format.

In LO right indent is working when done with the toolbar(and works fine in ods). Even if it has not been documented.

It is not yet available in FORMAT - CELLS dialog but it's beeing looked after( bug 76372 )


The issue here is that right indent is applied randomly in the attached file.
It should either work for all identical cells or not work at all.


I hope these complementary info would help you out ?


Have a nice day,

Renaud
Comment 3 Buovjaga 2014-11-26 11:16:11 UTC
Reproduced in Windows by selecting the numbers in C-E columns (with the empty column in between). Only the numbers in C are indented.
Sheet: Communautés_espagnoles.

Yet, in Linux, if I first select all the three columns and set right alignment, indenting happens correctly.
If I don't set it and simply start indenting right away, they indent correctly once, but then they start moving to the right.

Either in Linux or Windows, If I do from scratch and type in several numbers per column, align right and then select the three columns (same with only two), only the numbers in the topmost cells get indented.

So yeah, it seems quite wonky -> NEW.

Tweaked severity per https://wiki.documentfoundation.org/images/0/06/Prioritizing_Bugs_Flowchart.jpg

Win 7 64-bit Version: 4.5.0.0.alpha0+
Build ID: b144f0ac8695dd62a2053b4e88212d0b109c9a41
TinderBox: Win-x86@51-TDF, Branch:MASTER, Time: 2014-11-25_00:14:54

Ubuntu 14.10 64-bit Version: 4.5.0.0.alpha0+
Build ID: 6b219f012edbe069c461f4e0746898e33fa1dd49
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-11-25_21:56:46
Comment 4 Buovjaga 2015-01-10 18:09:50 UTC
Same thing from my comment 3 happens with 3.3.0 already.

Ubuntu 14.10 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 5 Matthew Francis 2015-01-30 05:27:38 UTC
*** Bug 80794 has been marked as a duplicate of this bug. ***
Comment 6 Matthew Francis 2015-01-30 06:53:18 UTC
Despite comment 4, I see a distinct regression boundary before which indenting with right alignment doesn't work at all (but rather forces left alignment). After the below commit, attachment 102120 [details] of duplicate bug 80794 shows *some* right indentation, but it still doesn't work completely.
(on current master, e.g. A1:A4 and A12:A15 of the above file. The rendering can be unstable; scrolling around a bit can reveal unexpected changes)

Adding Cc: to aalabdulrazzaq@kacst.edu.sa; Any chance you could take another look at this? Thanks


commit af169a601dee381b17d1e87c346f2d97bad9a69f
Author: abdulmajeed ahmed <aalabdulrazzaq@kacst.edu.sa>
Date:   Fri May 31 10:05:55 2013 +0200

    Fix fdo#51835  Indent changes in Calc forces alignment to left
    
    Change-Id: Ifef68cdd62a11b5cdc032a91a7dd96fa0357a42c
Comment 7 Robinson Tryon (qubit) 2015-12-13 11:09:24 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2016-05-04 09:49:51 UTC
*** Bug 65828 has been marked as a duplicate of this bug. ***
Comment 9 Bartosz 2016-12-10 23:29:00 UTC
With LibreOffice 5.3 it is no longer reproducible.