Author |
Message |
jpr
Joined: 01 Apr 2009 Posts: 102
|
Posted: Fri 10 Dec 2010, 00:07 Post subject:
Gnumeric - How to have Windows newline character? |
|
Hi,
I am using Puppy-421. It came with Gnumeric which is great.
I need to move my work between Puppy and Windows.
If I create a spreadsheet in Gnumeric and save it as .xls then I can open it in Excel in Windows. But I have one problem.
If a cell contains a multi-line text (created using ALT + Enter), then the newline character is encoded Linux-style and Excel does not read it correctly. It shows a little square where the newline character should be.
How do I work around this, other than manually editing all bad entries?
Thanks.
|
Back to top
|
|
 |
jpeps
Joined: 31 May 2008 Posts: 3217
|
Posted: Fri 10 Dec 2010, 02:11 Post subject:
Re: Gnumeric - How to have Windows newline character? |
|
jpr wrote: | Hi,
I am using Puppy-421. It came with Gnumeric which is great.
I need to move my work between Puppy and Windows.
If I create a spreadsheet in Gnumeric and save it as .xls then I can open it in Excel in Windows. But I have one problem.
If a cell contains a multi-line text (created using ALT + Enter), then the newline character is encoded Linux-style and Excel does not read it correctly. It shows a little square where the newline character should be.
How do I work around this, other than manually editing all bad entries?
Thanks. |
Strange...saving in xlsx loads up fine in OO. I tested with ver 1.10.1
|
Back to top
|
|
 |
fluxit

Joined: 24 Jun 2006 Posts: 326 Location: Ketchikan, AK USA
|
Posted: Fri 10 Dec 2010, 03:16 Post subject:
Re: Gnumeric - How to have Windows newline character? |
|
jpr wrote: | How do I work around this, other than manually editing all bad entries?
|
Have you tried saving in all of the xls variants that gnumeric allows?
What about odf/ods? I was under the impression that there were import filters available for MS Office that allow for the use of odf documents.
Does Excel have search and replace?
You could fix the bug in gnumeric's xls support or write a macro for Excel
|
Back to top
|
|
 |
amigo
Joined: 02 Apr 2007 Posts: 2641
|
Posted: Fri 10 Dec 2010, 13:12 Post subject:
|
|
There are a couple of tools to convert any sort of plain-text files between unix/dos.
unix2dos/dos2unix
fromdos/todos
One pair of these should available on any half-complete distro you choose.
|
Back to top
|
|
 |
RetroTechGuy

Joined: 15 Dec 2009 Posts: 2849 Location: USA
|
Posted: Fri 10 Dec 2010, 14:53 Post subject:
|
|
amigo wrote: | There are a couple of tools to convert any sort of plain-text files between unix/dos.
unix2dos/dos2unix
fromdos/todos
One pair of these should available on any half-complete distro you choose. |
For text operations, there is also a program called "flip"
for dos endings:
for linux endings:
And the Debian package works fine (probably need no additional dependencies):
http://packages.debian.org/squeeze/flip
http://http.us.debian.org/debian/pool/main/f/flip/flip_1.20-1_i386.deb
_________________ Add swapfile
WellMinded Search
|
Back to top
|
|
 |
jpeps
Joined: 31 May 2008 Posts: 3217
|
Posted: Fri 10 Dec 2010, 19:58 Post subject:
|
|
gnumeric has ssconvert.
example:
ssconvert --export-type=Gnumeric_Excel:excel_dsf foo.gnumeric foo.xls
http://linux.die.net/man/1/ssconvert
Code: |
~ $ sudo ssconvert --list-exporters
ID | Description
Gnumeric_Excel:xlsx | MS Excel (tm) 2007
Gnumeric_Excel:excel_dsf | MS Excel (tm) 97/2000/XP & 5.0/95
Gnumeric_Excel:excel_biff7 | MS Excel (tm) 5.0/95
Gnumeric_Excel:excel_biff8 | MS Excel (tm) 97/2000/XP
Gnumeric_dif:dif | Data Interchange Format (*.dif)
Gnumeric_glpk:glpk | GLPK Linear Program Solver
Gnumeric_lpsolve:lpsolve | LPSolve Linear Program Solver
Gnumeric_html:roff | TROFF (*.me)
Gnumeric_html:latex_table | LaTeX 2e (*.tex) table fragment
Gnumeric_html:latex | LaTeX 2e (*.tex)
Gnumeric_html:xhtml_range | XHTML range - for export to clipboard
Gnumeric_html:xhtml | XHTML (*.html)
Gnumeric_html:html40frag | HTML (*.html) fragment
Gnumeric_html:html40 | HTML 4.0 (*.html)
Gnumeric_html:html32 | HTML 3.2 (*.html)
Gnumeric_OpenCalc:odf | ODF/OpenOffice with foreign elements (*.ods)
Gnumeric_OpenCalc:openoffice | ODF/OpenOffice without foreign elements (*.ods)
Gnumeric_sylk:sylk | MultiPlan (SYLK)
Gnumeric_stf:stf_csv | Comma separated values (CSV)
Gnumeric_stf:stf_assistant | Text (configurable)
Gnumeric_XmlIO:sax | Gnumeric XML (*.gnumeric)
Gnumeric_pdf:pdf_assistant | PDF export
~ $
|
|
Back to top
|
|
 |
aragon
Joined: 15 Oct 2007 Posts: 1698 Location: Germany
|
Posted: Thu 06 Jan 2011, 17:04 Post subject:
Re: Gnumeric - How to have Windows newline character? |
|
jpr wrote: | Hi,
I am using Puppy-421. It came with Gnumeric which is great.
I need to move my work between Puppy and Windows.
If I create a spreadsheet in Gnumeric and save it as .xls then I can open it in Excel in Windows. But I have one problem.
If a cell contains a multi-line text (created using ALT + Enter), then the newline character is encoded Linux-style and Excel does not read it correctly. It shows a little square where the newline character should be.
How do I work around this, other than manually editing all bad entries?
Thanks. |
Well, maybe i'm thinking to simple but the best way should be to not use newlines within cells. This allways leads to conversion problems (same as combined cells and such things).
aragon
_________________ PUPPY SEARCH: http://wellminded.com/puppy/pupsearch.html
|
Back to top
|
|
 |
|