Summary: | A new item in cells in Calc | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Louis DeWald <Netherlands.DeW> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | CLOSED DUPLICATE | ||
Severity: | enhancement | CC: | erack |
Priority: | medium | ||
Version: | 7.6.4.1 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
Louis DeWald
2024-01-05 15:00:16 UTC
Where even is your problem? The default formatting depends on the current locale, either as set under Tools -> Options -> Language Settings -> Languages, or if Default there then inherited from the system locale. Individual cells can be attributed with a specific locale from the number format dialog (Ctrl+1 or Format -> Cells..., Numbers, Language). Dear Eike, Thank you for the quick response. I have no problem, but an idea. The space instead of the comma or the dot doesn't exist. So, maybe a space in every language is a possibility. Just to set a new international quotation. ;) Yours faithfully, Louis DeWald Ah so you want a space instead of what the locale says to use as group separator.. as such I'm closing this as a duplicate of bug 46448 in case that gets ever implemented. *** This bug has been marked as a duplicate of bug 46448 *** (In reply to Louis DeWald from comment #0) > Is it possible to enter this new item in the cell formatting. I know this is closed already, but IMHO it should not be a dupe of tdf#46448, as the request of using a space as digit group delimiter is already possible in LO 7.6. For example, if I have the following number format code: #,##0.00 I can replace that comma to a space character: # ##0.00 Dear Ady, Thank you for your solution. I did it and it worked! Thank you again. Yours faithfully, Louis DeWald That (using any character that is not the locale's group separator) does not act as a group separator though, but as literal character at that position only. The number 1234567.89 is displayed as 1234 567.89 not 1 234 567.89 Furthermore it _always_ outputs the space character also for smaller numbers, e.g. the value 1 would produce the output string " 1.00", you usually don't see with right aligned numbers but would with left aligned or when copy-pasting through clipboard. |