https://bugs.documentfoundation.org/show_bug.cgi?id=95338
Bug ID: 95338
Summary: Not plausible behaviour when combining cells
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: hl...@gmx.at
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:41.0) Gecko/20100101
Firefox/41.0
Build Identifier: LibreOffice 5.0.3.1
When some cells are combined, the result of calculations using these cells is
not plausible (and different from old behaviour / Excel behaviour). Probably,
this should be regarded as regression.
Reproducible: Always
Steps to Reproduce:
1. create a spreadsheet, fill Cells B1 through B8 with the values from 1 to 8
2. insert the formula "=SUM(B1:B8)" into cell D8
3. D8 shows the value 36
Example 1:
combine cells B2 through B5 and use default option no0 for moving the contents
to the first cell.
Result:
the combined area show the value 2, D8 still shows 36 (which does not relfect
what you see and probably would expect)
the values in B3 to B5 are maintained but hidden, nevertheless used in the
computation.
Example 2:
combine cells B2 to B5 and use the option yes for moving the contents to the
first cell
Result:
the combined area shows "2 3 4 5", D8 shows 22 as sum (which probably would not
be expected either)
the content of cell B2 is changed from numeric to a text and therefor not
included in the sum, cells B3 to B5 are cleared
Old (an Excel) behaviour:
when combining cells B2 through B5, the value in B2 is maintained, cells B3
throght B5 are cleared. The combined area shows 2, D8 shows 24 as sum (which
matches what you see).
[Information automatically included from LibreOffice]
Locale: de
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes
Reset User Profile?No
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
