https://bugs.documentfoundation.org/show_bug.cgi?id=64518
Laurent BP <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
CC| |[email protected]
Resolution|--- |DUPLICATE
--- Comment #11 from Laurent BP <[email protected]> ---
(In reply to ign_christian from comment #9)
> After observing Bug 66089, I found same cause for this problem: "Use printer
> metrics for text formatting" enabled.
So it should be marked as duplicate
> But if we disable "printer metrics", alignment not working at all on cells
> B4:B21.
With Tools>Options>LibreOffice cal>General - "Use printer metrics for text
formatting" disable I don't see any bug. LibO is trying to do its best with
this format:
_(* #.##0_);_(* \(#.##0\);_(* -_);_(@_)
You set alignment center, while in the same time you fill with space left part
of the cell "_(* ". So your cells appear right aligned because LibO adds as
much as possible spaces characters on the left.
You must also be careful with some points:
- decimal and thousand separators are different according to the language
indicated in Format > Cells > Numbers. So a dot or space in your language may
be a different separator in another language, making confusion. Moreover, XLSX
does not save the language, so your file open differently according to the
language used by user.
- there is 4 alignment positions: left, center, right or default. Default is
right for number and left for text. So clicking on left/center/right alignment
buttons will activate default alignment or force a specific alignment.
As I do no see alignment problem with Version: 5.0.4.2
Build ID: 00m0(Build:2)
Locale : fr-FR (fr_FR.UTF-8)
on Linux OpenSuse 13.2
I close it as duplicate. If you do not agree, please feel free to set it at NEW
again and explain what should be expected.
*** This bug has been marked as a duplicate of bug 66089 ***
--
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
