https://bugs.documentfoundation.org/show_bug.cgi?id=129878
Bug ID: 129878
Summary: Using fraction format results in wrong "###" output
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: difficultyBeginner, easyHack, skillCpp
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
CC: er...@redhat.com
In Calc, "###" code means "The cell is not wide enough to display the contents"
[1].
In a spreadsheet put number '2E306' into a cell, and format it with a fraction
format, e.g. '# #/#'.
Or use a time span format, like '[HH]'.
Or use a percent format, like '0%'.
This results in "###" displayed in the cell, which has nothing to do with "cell
not wide enough", but is an error string from the formatting function.
This easy hack is for changing the error string in the number formatter to
something else - e.g., '#FMT'.
The string is defined in ImpSvNumberformatScan::sErrStr (see its declaration in
svl/source/numbers/zforscan.hxx), and it's used in
svl/source/numbers/zformat.cxx through calls to
ImpSvNumberformatScan::GetErrorString.
[1] https://help.libreoffice.org/6.4/en-US/text/scalc/05/02140000.html
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
