https://bugs.documentfoundation.org/show_bug.cgi?id=171379
--- Comment #5 from Regina Henschel <[email protected]> --- (In reply to ady from comment #3) > What happens in Calc if you modify the following setting? > > Tools > Options > LibreOffice Calc > View > (Display) > Zero Values The setting has no effect on the result of the SORT function. It effects the display of value 0 in cells outside the result of the SORT function. (In reply to ady from comment #4) > The second place in Calc to test what happens would be: > > Tools > Options > LibreOffice Calc > Formula > (Detailed Calculation > Settings) > Custom > Details > Treat empty string as zero > > In that case (on/off), some other settings in the same "Detailed Calculation > Settings" dialog _might_ also influence the result. Those settings have no effects at all. I had also tried a custom number format without success, the zero is not shown. -- You are receiving this mail because: You are the assignee for the bug.
