[Libreoffice-bugs] [Bug 129878] New: Using fraction format results in wrong "###" output

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com
                CC: erack at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200108/f55e2e57/attachment.htm>