Gnumeric - How to have Windows newline character?

[jpr]

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.

[jpeps]

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

[fluxit]

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

[amigo]

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.

[RetroTechGuy]

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:

Code: Select all

flip -m filename

for linux endings:

Code: Select all

flip -u filename

And the Debian package works fine (probably need no additional dependencies):

http://packages.debian.org/squeeze/flip

http://http.us.debian.org/debian/pool/m ... 1_i386.deb

[jpeps]

gnumeric has ssconvert.

example:
ssconvert --export-type=Gnumeric_Excel:excel_dsf foo.gnumeric foo.xls

http://linux.die.net/man/1/ssconvert

Code: Select all

~ $ 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
~ $ 

[aragon]

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