This mailing list is to get help from users like you and me.
As you're not subscribed to this mailing list and haven't asked for help
On 15/02/18 8:31 AM, Winter wrote:
This is why after years I have now stopped using Open Office and
switched to Google Apps. I am a programmer.
I expect from programmers that they know the difference between
importing Numbers and Text.
I quickly dump software that does not comply to User Ergonomics. It
should be simple and intuitive. Especially the simplest task.
Then Google Apps. is the tool for you, please come back when you need to
do more complex tasks.
All I wanted was to set up a budget like I have many time in Open
Office but the Sum command now does not sum. Why? I read online
suggestions which mentioned it could have something to do with the
value being treated as Text with no explanation to convert them to
numerical values.
If you have Cells formatted as Text it will store imported values as
text, at the top you can see a ` in front of the number when stored as text.
Changing the Cell format to numeric doesn't help. You can use a formula
like =VALUE(A1:A25) in a empty column and Paste Special the result
back into Column A with only the numeric option ticked.
It seemed quickly much easier to sign in to Google. Goodbye. I have
little patience when companies make simple tasks complicated.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
