I can edit number format to add thousand separator to decimal part like that
It works fine until document closed and opened again
format string is lost and i see that
So, how do i format decimal part format and save it?
(tried 6 somthn version and now it is 7.0.4.2 on windows)
First, your locale thousand separators are not spaces, but commas, as shown on your screenshots. But that is not relevant here, because it seems that the correct thousand separators are not handled properly after decimal separator, too.
But when you insert literal text, it’s best to put it explicitly in double quotes:
#,##0.000" "000" "000Tried that, after save and reload, string will be exacly same as in the picture above. Basically, no mater what separator i use, after reload of the document, it will be put at the end of the string and in quotes.
minus, - for example
#,##0.000000000"--"
Spaces in quites become #,##0.000000000" "
Looks similar to tdf#67822, although that one was closed. You might want to file a new bug (and put that old one to See Also).
I have this exact problem too, and no, the suggested formatting doesn’t unfortunately work. Was a solution found, or was this logged as a bug and hopefully in the works to be fixed? I’m running latest autoupdated version of Libreoffice and this is still happening to me also. Any help greatly appreciated. I created a user account here specifically to ask about this issue, after many hours of varied formatting attempts and web searches, and then found your post just as I was starting to type in my own new post… Anyhow, any fixes greatly appreciated, thanks in advance. [edit:corrected wrong word used]
OpenOffice is a separate project. This site is for LibreOffice.
Sorry… yes LibreOffice… I’m using LibreOffice. I’m tired and typed the wrong name. I’m really sorry i started websearches with OO as well as LO and just typed the wrong name accidentally.
I’m definitely using LibreOffice Calc, thank you for catching that Mike.
Ok, thanks for correction.
It also looks odd. Which specific version do you use? Is that an app store version? Because the LibreOffice from TDF site doesn’t autoupdate on any platform.
I started with a portable version but I’m pretty sure I downloaded this install from LibreOffice.org. I “was” sure Calc occasionally showed “there’s an update available” style message above the sheet cells and i updated occasionally, but now you mention it, the version info, pasted below, is lower than the current downloadable version, so I must’ve imagined that in some weird way. Thank you for picking up my unfocussed thinking/writing. But settings do show check for updates is turned on… I’m not sure what’s going on then… anyway the version info is pasted from LibreOffice Calc → Help Menu → About.
Version: 7.1.6.2 (x64) / LibreOffice Community
Build ID: 0e133318fcee89abacd6a7d077e292f1145735c3
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: en-AU (en_AU); UI: en-GB
Calc: CL
Automatic update is not implemented. Only automatic checks.
Please try updating. And if the problem is still there, please do file a bug report.
Thanks, am downloading now, and will follow your advice. Really not sure where my head’s at presently… I really believed Calc was updating/updated… Anyhow, thank you for your patience and assistance.
Updated to 7.3.3.2 and still happening on .ods files. Doesn’t happen with .xlsx or .xlsm files, but I lose all my macros and buttons which I need… so I’ll log a bug report as you suggest; thanks Mike for your guidance and patience.
Bug submitted https://bugs.documentfoundation.org/show_bug.cgi?id=149428
Thanks and good luck to us all.
Thanks for the tip, tried that. If done that way, all decimals part shown as 000 always. And, only last space survive reloading. Even if i try ’ as separator it all get moved at end of the format string and put into bracers like “’”. Seems like bug.
A patch for this issue has kindly been created by Laurent BP and will be available in LibreOffice 7.5. In the meantime an alpha version which I’ve tested, and it saves the formatting, is available in the daily build versions
Thanks to everyone involved in this thread, bug reporting and patching, thanks!
