[Solved] Sum function does no work

[giampaolosf]

sum function does not process simple numbers, or currency data

[RoryOF]

Verify your data types with /View /Value highlighting. Anything that is not a number will not add.

Edit: Your file adds up without adjustment on my computer.

[giampaolosf]

Did that. Nothing happens. No change. Sum is not working. Same file works fine in Google Spreadsheet. Where is the glitch?

[RoryOF]

Please try the attached file.

[giampaolosf]

No difference. No computation.

[RoryOF]

I suggest you rename your OO user profile:
As you are using Windows close OpenOffice and the Quickstarter. Open File Explorer (sometimes called Windows Explorer). Copy and paste %appdata%\OpenOffice\4 in the File Explorer Address Bar and press Enter. Rename the "user" folder - "user.old" is a good choice. Start OpenOffice.

[giampaolosf]

KUDOS to RoryOF!
Your suggestion made it work. I will review all files that did not work before and hopefully I won't see that nasty problem again.
Thank you very much!