Bug 33621 - Sum function in formula bar in Calc makes results under the formated cells
Summary: Sum function in formula bar in Calc makes results under the formated cells
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.3.0 release
Hardware: x86 (IA32) All
: medium normal
Assignee: Kohei Yoshida (inactive)
QA Contact:
URL:
Whiteboard: target:3.4
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-27 13:27 UTC by Łukasz
Modified: 2011-03-22 10:43 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:

Attachments
Image shows bug in details (93.33 KB, image/jpeg)
2011-01-27 13:27 UTC, Łukasz 		Details
The file itself (9.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-01-27 13:41 UTC, Łukasz 		Details
View All

Description Łukasz 2011-01-27 13:27:08 UTC 
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-3.2.99.2 (3.3-beta2) on Windows
Comment 1 Jorendc 2011-01-27 13:34:27 UTC 
Can't reproduce in Mac OS X, LibreOffice 3.3 final.
Is it possible to attach the document?
Comment 2 Łukasz 2011-01-27 13:41:08 UTC 
Created attachment 42612 [details]
The file itself
Comment 3 Jorendc 2011-01-27 13:45:45 UTC 
Reproduced with attached file. (Mac OS X, LibreOffice 3.3).
Comment 4 Cor Nouws 2011-01-27 13:55:14 UTC 
confrim the behaviour in LibO330 on Linux.
Thanks for submitting the issue. Łukasz.
Comment 5 Kohei Yoshida (inactive) 2011-03-21 19:18:40 UTC 
Ah, I know why this is.

Remove the borders from rows 13:14 and try the sum again.  It should work as expected.
Comment 6 Kohei Yoshida (inactive) 2011-03-21 19:19:39 UTC 
Believe or not, this is related to Bug 33671.  I'll take care of this for 3.4.
Comment 7 Kohei Yoshida (inactive) 2011-03-22 10:43:53 UTC 
Fixed on master for 3.4.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.