https://bugs.documentfoundation.org/show_bug.cgi?id=153993
--- Comment #2 from Matt Keveney <[email protected]> --- > A_ Have you tried testing with a dev. release or testing version? > B_ Have you tried the same steps using other software > (e.g. AOO and/or Excel for MacOS or any other) to see how the > behavior is there? I just tried google sheets, since that was easiest. It does not accept format I reported above. Instead it says 'invalid format' right in the format editor, which would be a great thing to add to LibreOffice. I _could_ however enter the equivalent format: ###.000 e-0 This behaves as expected: https://docs.google.com/spreadsheets/d/1ecDo2_sJ_ag33H7Yf4VhVSoR60u6d24Z7XsgraPgaDc The format with the added '-' does not help in LibreOffice; again, it's replaced with ###.000E0" " on save/reopen. Aside: this format is just a stopgap. What I _really_ want is support for SI prefixes (k,M,G,T,P,m,ยต,n,p,f) and so forth. I'll make an entry at https://ask.libreoffice.org/tag/feature-request... just thought I'd put a bug in your ear _here_, while I have your attention :-). Very useful for electronics calculations. Thanks! -- You are receiving this mail because: You are the assignee for the bug.
