Created attachment 42611 [details]
Image shows bug in details
It is about the Sum function on Formula Bar. I have a "xls" file with formated cells (0,05 pt style). When I select the columns and try to make a sum of all selected values using Sum button as shortcut, Calc makes the sum under the formated cells. I know it's hard to explain. To show you what it is all about, I'm sending sceen from the file. Even when I converted it to "ods", the problem still exists.
Steps to Reproduce:
Make a file with various numbers and format cells. Then select one column and try to make a sum of it using Sum button on Formula Bar.
Build & Platform:
libreoffice-22.214.171.124 (3.3-beta2) on Windows
Can't reproduce in Mac OS X, LibreOffice 3.3 final.
Is it possible to attach the document?
Created attachment 42612 [details]
The file itself
Reproduced with attached file. (Mac OS X, LibreOffice 3.3).
confrim the behaviour in LibO330 on Linux.
Thanks for submitting the issue. Łukasz.
Ah, I know why this is.
Remove the borders from rows 13:14 and try the sum again. It should work as expected.
Believe or not, this is related to Bug 33671. I'll take care of this for 3.4.
Fixed on master for 3.4.