https://bugs.documentfoundation.org/show_bug.cgi?id=118324
Laurent BP <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |ASSIGNED
CC| |[email protected]
Severity|normal |enhancement
OS|Linux (All) |All
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=11
| |7575
Assignee|[email protected] |[email protected]
|desktop.org |
--- Comment #5 from Laurent BP <[email protected]> ---
(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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs