Bug Hunting Session
Bug 82481 - SUM() copies cell formats
Summary: SUM() copies cell formats
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: low enhancement
Assignee: Not Assigned
Depends on:
Blocks: Function-Sum
  Show dependency treegraph
Reported: 2014-08-11 22:18 UTC by bugzilla1533
Modified: 2018-03-16 19:54 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description bugzilla1533 2014-08-11 22:18:52 UTC
Create a spreadsheet. In one column have a few numbers. Format that column as Fraction. In a cell in another column, SUM() the first column's numbers. You will see that the format of the SUM() cell has been changed from Number-General to Fraction. This seems totally wrong to me, SUM() should only be returning the value of the cells it's summing, not their other properties.
Comment 1 ign_christian 2014-08-12 05:22:40 UTC
Possibly NOTABUG. I think it's make sense that SUM result should have same format as source data.

Please consider to ask for help here: http://ask.libreoffice.org/en/help/
Comment 2 bugzilla1533 2014-08-12 05:30:23 UTC
Why shouldn't SUM have the same format as the cell it's in? I don't recall other formulas changing the format of their cells to that of their source data. SUMIF doesn't, for example.
Comment 3 ign_christian 2014-08-12 05:48:30 UTC
I understand your objection, also saw Kingsoft behaves like what you expected.

So lets wait others opinion regarding this issue :)
Comment 4 Cor Nouws 2014-08-12 09:23:57 UTC
Note that the formatting of the cell with Sum does not change if you apply a formatting other then the default.
(also when counting with times, formatting of the cell with the result does matter a lot, IIRC)
Comment 5 ign_christian 2014-08-12 09:56:38 UTC
I think what bugzilla1533@rule506.net meant can be seen with this steps:
1. Right-click Column A > Format Cells > Fraction > OK
2. Select cell B1 > hit 'Sum' button > select cells A1:A2 > hit Enter
3. Verify that cell B1 have 'Fraction' format

bugzilla1533@rule506.net claimed that cell B1 should keep its default format (Number-Standard).

Tested with LO - Ubuntu 12.04 x86

@Cor, what do you think regarding that behavior? Is that a bug?
Comment 6 Cor Nouws 2014-08-12 11:51:03 UTC
(In reply to comment #5)
> I think what bugzilla1533@rule506.net meant can be seen with this steps:
> [...]

This does not conflict with my comment 4 :)
My comment is more an addition.

> @Cor, what do you think regarding that behavior? Is that a bug?

Along the line of my comment 4, I would say no. 
But if others have arguments to disagree, I'm open to see those.
Comment 7 Alex Thurgood 2014-10-18 14:20:49 UTC
At the least, this could be set as RFE, but seeing  as several of us already feel that this is not a bug, there might well not be any takers for development
Comment 8 eisa01 2018-03-16 18:51:43 UTC
Setting version to all, this is not mac specific