https://bugs.documentfoundation.org/show_bug.cgi?id=49540
Laurent BP <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |NEW
CC| |[email protected]
Resolution|FIXED |---
--- Comment #10 from Laurent BP <[email protected]> ---
The problem is coming from the interpretation of the decimal separator. Your
table contains a comma as decimal separator. When you switch to a language
which use a point as decimal separator, the contents of your cells are no more
recognized as a value and is converted to a text, which sum is 0.
The pb is not fixed for me with Version: 6.0.4.1 (x64)
Build ID: a63363f6506b8bdc5222481ce79ef33b2d13c741
Threads CPU : 4; OS : Windows 6.1; UI Render : par défaut;
Locale : fr-FR (fr_FR); Calc: CL
Set it back to NEW as no fix was identified
@Johannes Weberhofer: "RESOLVED FIXED" is used only if we know which commit
fixed the bug. In your case, you should have selected "RESOLVED WORKSFORME"
The result of the sum in A3 is 0 when switching to a language of the number
format using point as decimal separator.
More precise procedure to reproduce the bug:
1. Tools > Options > Language Settings > Languages: Locale setting: choose a
language using comma as decimal separator like French (France) or German
(Germany)
2. Open attachment 79985
=> Result in 3rd cell is 2,5 (two and half)
3. Select all cells (click in table and hit twice Ctrl+A)
4. Right click in a cell > Number Format
5. Change language to a language using point as decimal separator, such as
English (USA). OK
Actual result:
Display of values in two first cells are the same and sum in 3rd cell is 0
Expected result:
Display of values should change decimal separator to a point (1.2 and 1.3), and
sum should be 2.5
--
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
