Bug 138306

Summary: CALC would benefit from numerical tab formatting just like writer
Product: LibreOffice Reporter: Colin <that.man.colin>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WONTFIX    
Severity: enhancement    
Priority: medium    
Version: 7.0.3.1 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description Colin 2020-11-18 10:41:29 UTC 
Description:
So much time is expended trying to manipulate the alignment and decimal leading or trailing zeros/spaces in numerical CALC cells that a decimal tab in numerical cells with the identical function to the decimal tab in LO Writer would obviate all that effort.
There are already a number of Bug Reports concerning the alignment anomalies in numerical cells which are quite likely to have been inspired by users' efforts to achieve a simple decimal alignment.
Right indent is implemented in eXcel but decimal alignment is not a feature.

Steps to Reproduce:
Feature request to be integrated into cell format

Actual Results:
Not a bug report

Expected Results:
Not a bug report


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Seems to be a new feature in 7.0.3.1 (x64) It's not possible to highlight any data in the About LibreOffice pane.
But I can reproduce the URL containing the Build ID here :)
https://git.libreoffice.org/core/+log/d7547858d014d4cf69878db179d326fc3483e082
7.0.3.1 was newly installed today
Comment 1 Mike Kaganski 2020-11-18 10:57:34 UTC 
FTR: in Calc, alignment of decimal separator is currently done using "?" decimal placeholder instead of "#" [1], and monospace font.

So the missing decimal places are not dropped, but replaces with spaces, and that allows to have all cells formatted that way with aligned decimal separators.

[1] https://help.libreoffice.org/7.0/en-US/text/shared/01/05020301.html
Comment 2 Colin 2020-11-18 11:30:35 UTC 
(In reply to Mike Kaganski from comment #1)
> FTR: in Calc, alignment of decimal separator is currently done using "?"
> decimal placeholder instead of "#" [1], and monospace font.
> 
> So the missing decimal places are not dropped, but replaces with spaces, and
> that allows to have all cells formatted that way with aligned decimal
> separators.
> 
> [1] https://help.libreoffice.org/7.0/en-US/text/shared/01/05020301.html

Is it my job to pull the request or do you just mark it as discarded?

Thanks by the way, It took me ages of frustration to become desperate enough to file the request - may I have your home phone number for next time :)))
Comment 3 Mike Kaganski 2020-11-18 12:11:21 UTC 
(In reply to Colin from comment #2)

I didn't intend to disregard it; I only posted something that might be called a workaround. But OTOH, there's no notion of tab stops in Calc...

So if you are happy with it, then yes, let me close it WONTFIX (but it doesn't mean it's a final decision, and if someone finds appealing reasons, no problem to reopen).
Comment 4 Colin 2020-11-18 12:21:05 UTC 
(In reply to Mike Kaganski from comment #3)
> (In reply to Colin from comment #2)
> 
> I didn't intend to disregard it; I only posted something that might be
> called a workaround. But OTOH, there's no notion of tab stops in Calc...
> 
> So if you are happy with it, then yes, let me close it WONTFIX (but it
> doesn't mean it's a final decision, and if someone finds appealing reasons,
> no problem to reopen).

I'm happy to disregard it as the workaround is fine for me. I've placed links to your solution on my earlier interactions so it should go viral.

Also, I've reported a seperate issue of the failure to permit Cut & Paste on the About LO pane which I discovered trying to comply by pasting it to this report.
Not sure if "trivial" issues being reported are more of a nuisance when there's so much more productive work to be done.
Feel free to advise me to take up crochet - I won't be offended.