| Summary: | Sum function in formula bar in Calc makes results under the formated cells | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Łukasz <mrmangas> |
| Component: | Spreadsheet | Assignee: | Kohei Yoshida (inactive) <libreoffice> |
| Status: | RESOLVED FIXED | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | cno, jorendc |
| Version: | 3.3.0 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | All | ||
| Whiteboard: | target:3.4 | ||
| i915 platform: | i915 features: | ||
| Attachments: |
Image shows bug in details
The file itself |
||
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. |
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.
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