[Libreoffice-bugs] [Bug 118324] Certain Number Formats not saved correctly in ODF spreadsheets (works in .xlsx)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118324

Laurent BP <jumbo4444 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED
                 CC|                            |jumbo4444 at yahoo.fr
           Severity|normal                      |enhancement
                 OS|Linux (All)                 |All
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=11
                   |                            |7575
           Assignee|libreoffice-bugs at lists.free |jumbo4444 at yahoo.fr
                   |desktop.org                 |

--- Comment #5 from Laurent BP <jumbo4444 at yahoo.fr> ---
(In reply to Jim Avera from comment #0)
>   ###,###,##0.00 changed to #,##0.00
This is intentional: format is simplified and display is the same
>   ########0.00 change to 0.00
same
>   ########.##### changed to #.#####
same: optional figures with '#' are automatically added if necessary, so no
need to add more than 1 '#', except with thousand separator.

>   ???????0.00??? changed to #,###.00
This would be a bug:
- decimal part is modified
- thousand separator is added
However, I can NOT reproduce. I get #.00??? which is "correct" as '?' cannot
yet be saved in integer part (but '0' should)
>   ???,???,??0.00??? changed to #,###.00???
This should also be enhanced to take into account the number of '?' in addition
to the number of '0' in decimal part.

About attachment 143047 formatMS.xlsx demo file: '?' are intended to get
alignment of digits, so you should use default horizontal alignment of cell
(not center)

-- 
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/20180623/27a5347a/attachment.html>