Folks,
Thanks to everybody who replied. I still don't understand all of the problem,
but I have found a solution that works for me.
First in more detail what I'm doing and trying to do: In a Linux xterm, I get
lines containing a special marker out of a file and onto the screen:
[herbert@wardlaw10 NEB-test]$ grep @ scan4.xyz
@ 180.00 -.2781258475E+03
@ -175.00 -.2781257976E+03
@ -170.00 -.2781256549E+03
@ -165.00 -.2781254333E+03
@ -160.00 -.2781251459E+03
I copy and paste that into a spreadsheet, the way you do it in Linux: left mouse
button, middle mouse button. Of course it's text. When pasting (or afterwards in
"text to columns"), I choose "space" as an additional delimiter, and "merge
delimiters". The spreadsheet splits the columns as expected, interprets the
first number as a number and the second as text. I think it's the exponent that
causes the problem, but this should be a valid number format.
I doesn't help is to change the number format of that column (as somebody
proposed). What does help is the =value(...), BUT somehow (from the pasting, I
guess) some columns behind the newly filled ones end up being "protected"
(whatever that is) and refuse to evaluate a formula, which took some figuring out.
Anyway, after all this, I noticed a "detect special numbers" button in the paste
menu, which seems to be the easiest solution for me.
Thanks again
Herbert
--
Herbert Fruchtl
Senior Scientific Computing Officer
School of Chemistry, School of Mathematics and Statistics
University of St Andrews
--
The University of St Andrews is a charity registered in Scotland:
No SC013532
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted