https://bz.apache.org/ooo/show_bug.cgi?id=127335
Marcus <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|Major |Normal Component|programming |editing --- Comment #1 from Marcus <[email protected]> --- Thanks for the sample spreadsheet. This helped to see the reported problem in cells AF30 - AF49. When looking closer I can see that these cells begin with an apostrophe - which means that the cells should be interpreted as text. To get this select the cells, set the cell format to "Numbers - Standard", then you can see the apostrophe at the beginning of every cell. I've recreated the AF column on "Sheet2", pure numbers and formulas, no formatting and then it worked. I assume that this spreadsheet file is used since a longer time and so this text problem came in over the time. At the end, there is no problem in Calc but with the content (numbers vs. text). I hope this quick analysis helps you to see the same. -- You are receiving this mail because: You are the assignee for the issue.
