[opensuse] libreoffice calc import CSV
I don't use this suite much, sticking mostly to Quattro Pro for DOS, where file->import->CSV works fine only as long as the line lengths aren't too long. How long is too long I've been unable to figure out. QPro's been rejecting Fedex CSV files, so I want to import CSV file(s) into LibreOffice Calc, but it has no import menu I can find, only export. How does one get a CSV file into a spreadsheet? Is there a separate package for this function that I don't have installed? # rpm -qa | grep eoffi libreoffice-3.4.5.5-97.1.i586 libreoffice-base-3.4.5.5-97.1.i586 libreoffice-branding-upstream-3.4.5.5-97.1.noarch libreoffice-calc-3.4.5.5-97.1.i586 libreoffice-icon-theme-crystal-3.4.5.5-14.1.noarch libreoffice-kde-3.4.5.5-97.1.i586 libreoffice-pyuno-3.4.5.5-97.1.i586 libreoffice-writer-3.4.5.5-97.1.i586 -- "The wise are known for their understanding, and pleasant words are persuasive." Proverbs 16:21 (New Living Translation) Team OS/2 ** Reg. Linux User #211409 ** a11y rocks! Felix Miata *** http://fm.no-ip.com/ -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Hi,
2012/5/18 Felix Miata
How does one get a CSV file into a spreadsheet? Is there a separate package for this function that I don't have installed?
It should be enough to open the csv file as an ordinary ods file. Calc should ask you how to import values. Best, Andrea -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2012-05-18 16:15, Felix Miata wrote:
Calc, but it has no import menu I can find, only export. How does one get a CSV file into a spreadsheet? Is there a separate package for this function that I don't have installed?
Just open it. - -- Cheers / Saludos, Carlos E. R. (from 11.4 x86_64 "Celadon" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk+2XIIACgkQIvFNjefEBxpKPACgybaPwx50KJk7JIRR/gq186zp 28MAoLtxu/lOLFJgPEXwex/yr6nOErPF =mWzs -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
To open a CSV file using calc File --> Open --> You can change the Filter at the bottom of the Dialog box to "Text CSV" from the drop down list. This will show only files matching that criteria. -- Regards, Graham Smith -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 05/18/2012 09:15 AM, Felix Miata wrote:
I don't use this suite much, sticking mostly to Quattro Pro for DOS, where file->import->CSV works fine only as long as the line lengths aren't too long. How long is too long I've been unable to figure out. QPro's been rejecting Fedex CSV files, so I want to import CSV file(s) into LibreOffice Calc, but it has no import menu I can find, only export. How does one get a CSV file into a spreadsheet? Is there a separate package for this function that I don't have installed?
# rpm -qa | grep eoffi libreoffice-3.4.5.5-97.1.i586 libreoffice-base-3.4.5.5-97.1.i586 libreoffice-branding-upstream-3.4.5.5-97.1.noarch libreoffice-calc-3.4.5.5-97.1.i586 libreoffice-icon-theme-crystal-3.4.5.5-14.1.noarch libreoffice-kde-3.4.5.5-97.1.i586 libreoffice-pyuno-3.4.5.5-97.1.i586 libreoffice-writer-3.4.5.5-97.1.i586
Felix, This is a *very* frustrating aspect of LO/OO that showed up in 3.1 or so. They have taken the traditional File->Import->sub_menu and tried to wizardize it all in File->open. This causes more problems than it fixes. The wizard seems to weigh the .ext in guessing at what import filter to use quite heavily. Where in the past you could manually tell it what import filter you wanted to use, I've found that I have to rename files on occasion to get the wizard to guess correctly between csv, fixed length fields or other delimited values to make it work correctly. If the wizard interprets the file you are trying to open being in a format other than what you want to import it as -- you are largely screwed. That being said, the File-open wizard for importing into calc can be made to work in most instances. I don't know that there is a "too long" limit for imports as long as calc can correctly identify the delimiting logic to use. Good luck. Any LO devs reading this put *manual* file->import selection back into calc. It is so Microsoft like to have a darn program try to out-think you and end of getting it wrong more times than not on basic features that worked fine for years. -- David C. Rankin, J.D.,P.E. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (5)
-
Andrea Turrini
-
Carlos E. R.
-
David C. Rankin
-
Felix Miata
-
Graham Smith