| View previous topic :: View next topic |
| Author |
Message |
LGLisle
General User
Joined: 28 Nov 2011
Posts: 5
Location: W-S NC USA
|
 Posted: Tue Apr 17, 2012 6:54 am Post subject: |
 |
|
| Villeroy wrote: | | Quote: | | That's nice for you, but doesn't answer the question. |
I have answered this a hundred times in 3 different ways. |
To my eye, all of them are obscure and complicated.
| Quote: | | Quote: | | I don't see how a text editor is going to do anything for me. |
A text editor stores raw data in plain text. A spreadsheet template can store preformatted areas. So you can import raw text data into your own preformatted cell range. |
You seem to assume we are doing massive, repetitive tasks. Most of us don't fit that model. I do a little of this, a little of that, go off and do something else. I want simple; not special directories, not templates, not complex macros. What is the point of allowing pasting unformatted text, if I have to use a text editor to unformat it further?
The biggest reason this issue bugs me is that I have to remember to select the separator each time. One of the things computers are supposed to do is relieve the need for the user to remember minutia.
_________________
Using OO 3.3.0 on Windows 7/64 |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Tue Apr 17, 2012 12:17 pm Post subject: |
|
|
As a matter of fact you paste data into a CALCulator. If you can not live with the way how the CALCulator interpretes your input, then you have to use a different software or you have to actually use this software beyond plain copy&paste. This is exactly why all the bells and wistles had been programmed.
| Quote: | | I want simple; not special directories, not templates, not complex macros. |
There is absolutely no point in using an office suite like this one if you reject using styles, templates and file systems.
I rarely recommend any macros although most non-users on this forum want macros to be written by someone so they don't have to learn using the software. But configuration should be a matter of course if you want to customize certain tasks.
| Quote: | | You seem to assume we are doing massive, repetitive tasks. Most of us don't fit that model. |
As a matter of fact, most of you pretend to fit that model. ("I don't want to do that extra click every time!") And this topic was about setting the default delimiter to save two keystrokes per import.
| Quote: | | What is the point of allowing pasting unformatted text, if I have to use a text editor to unformat it further? |
The distinction between numbers and text has nothing to do with formatting. The charcter "1" as a text value is a completely different value than number 1. Simply mark your column to be imported as "Text" and you are done. But that was not the topic of this thread.
"1"=1 returns FALSE in all spreadsheets. When you import or type the character "1" into a normal spreadsheet cell, this input will be evaluated as a number which is the wanted behaviour and there are many, many ways to supress all evaluation, the evaluation of dates, the evaluation of formulas if -- and only if-- you are willing to actually use this software.
If not, there is the Writer component for text.
Since you don't even care about styles and templates, I'd recommend to uninstall this software all together and use the WordPad on your Windows machine.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
