[Issue 127335] Unable to sum column

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127335

Marcus <ma...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|Major                       |Normal
          Component|programming                 |editing

--- Comment #1 from Marcus <ma...@apache.org> ---
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.