Numbers don't add up

Originator:axello
Number:rdar://30891514 Date Originated:7-3-2017
Status:Open Resolved:
Product:Numbers Product Version:4.0.5
Classification:UI/Usability Reproducible:yes
 
Highly annoying for a *spreadsheet* that somehow the calculation is wrong. I checked and double-checked and calculated manually but I really do add up to 12,50 in the "Geld" column.
Turns out, some of the cells stayed as 'Text' instead of converting automatically to number, and the Sum field gives NO INDICATION something is wrong.


1. open spreadsheet
2. change number in field E23
3. the 11 sum at the bottom does not change

I expected 12,50 as a total to begin with

11

I now have to manually go over all the cells to see which are wrong, or select all cells and convert them to 'number' instead of automatic.

Comments


Please note: Reports posted here will not necessarily be seen by Apple. All problems should be submitted at bugreport.apple.com before they are posted here. Please only post information for Radars that you have filed yourself, and please do not include Apple confidential information in your posts. Thank you!