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.
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/
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.
I understand your objection, also saw Kingsoft behaves like what you expected.
So lets wait others opinion regarding this issue :)
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)
I think what firstname.lastname@example.org 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
email@example.com claimed that cell B1 should keep its default format (Number-Standard).
Tested with LO 126.96.36.199 - Ubuntu 12.04 x86
@Cor, what do you think regarding that behavior? Is that a bug?
(In reply to comment #5)
> I think what firstname.lastname@example.org 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.
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
Setting version to all, this is not mac specific
Seems like this needs an assessment by UX too
LibreOffice has the same behavior as Excel, so I would not recommend to accept this enhancement
I wouldn't even see it as an enhancement.. A sum of values inheriting the same format category (or even format if possible) if the target/sum cell isn't formatted already is a nice feature.
Agree with WF.
Enter 0.1,0.2,0.3 as fractions and format as number (all become) zero, the sum with general format will show .6 instead of "copying the format". Format the cell where you plan to put the sum in advance as currency and it will use that.