https://bugs.documentfoundation.org/show_bug.cgi?id=155622
Bug ID: 155622
Summary: Libreoffice Calc skips the first line during summation
Product: LibreOffice
Version: 7.5.3.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: tamas.nagy....@gmail.com
Description:
If I give fractions in the lines and I use the SUM(B1:B10) it skips the first
line, but only and only if I use fractions. If I use whole numbers, it works
perfect.
Steps to Reproduce:
1. Give the following numbers in separate lines:
7,5
8,25
8,25
8,58
8,25
8,87
9,22
8,12
7,07
7,75
-----
2. Use the SUM(B1:B10) or SUM(A1:A10). Also try to remark the area to omit
skipping any of those numbers:
3. Result: it forgets to add the 7,5 to the whole SUM...
Actual Results:
74,36
Expected Results:
81,86
Reproducible: Always
User Profile Reset: No
Additional Info:
Windows 11 Pro,
22H2
Build: 22621.1702
Windows Feature Experience Pack 1000.22641.1000.0
--
You are receiving this mail because:
You are the assignee for the bug.
