On 2/14/2018 4:40 PM, Martin Groenescheij wrote:
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.
I had just opened the Sheet. There was no formatting. I understand the
distinction in how to see if it is text. It did not appear to be text. I
copied the values from the cells into the adjacent column and still it
did not recognize the numbers as text. I was programming in HEX
modularly when you were in Kindergarten. I have an IQ over 160. I do not
need your condescension in remarking that perhaps I need something
simple. Your job as tech support is to consider the input from your
customers not to take amateurish cheap shots. You have a problem with
your product. Perhaps if you would listen to your customers instead of
taking juvenile asinine responses.
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