Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Libre office works differently

  1. #1

    Default Libre office works differently

    I tried opening a .CSV file on Windows 7 with Open Office and it opens it just fine.
    However when I try the same file in openSUSE it comes in all scrambled.

    Who do I talk to about this ?

    Or I imagine that Open Office is available instead. Let me see.

  2. #2
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: Libre office works differently

    On 2013-08-09 20:26, hextejas wrote:
    >
    > I tried opening a .CSV file on Windows 7 with Open Office and it opens
    > it just fine.
    > However when I try the same file in openSUSE it comes in all scrambled.


    Can you post two lines of that csv for us to try?

    > Or I imagine that Open Office is available instead. Let me see.


    nope.

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 12.3 x86_64 "Dartmouth" at Telcontar)

  3. #3
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,450

    Default Re: Libre office works differently

    OpenOffice normally shows you a preview and you can change the default separator and default text delimiter at this stage. If you open the .csv file in a text editor, you should see what these are.

    Ever since year dot there have been different conventions for .csv separators and delimiters; it is easy in Windows to set the default to the Windows style but in Linux you may be importing files from several different sources; hence the preview.

  4. #4
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    17,069

    Default Re: Libre office works differently

    On Fri, 09 Aug 2013 18:26:02 +0000, hextejas wrote:

    > However when I try the same file in openSUSE it comes in all scrambled.


    Please define "all scrambled". An example of the input and the output
    would be useful.

    Jim



    --
    Jim Henderson
    openSUSE Forums Administrator
    Forum Use Terms & Conditions at http://tinyurl.com/openSUSE-T-C

  5. #5

    Default Re: Libre office works differently

    Sorry that I wasn't more clear on my description and I will post some lines when I get back to my desk sometime tomorrow.

    When I say scrambled, the preview of the file has what looks like a bunch of @@@@@ ampersands only they look like they have been shaded in. Kinda like what you will see if a font is missing.

    I will post more and better info tomorrow.

    Other CSV seem to work fine.

    If I can't figure out how to show you, the file is pretty small so I could upload it somewhere or email it.

  6. #6
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    17,069

    Default Re: Libre office works differently

    On Fri, 09 Aug 2013 23:56:03 +0000, hextejas wrote:

    > Sorry that I wasn't more clear on my description and I will post some
    > lines when I get back to my desk sometime tomorrow.
    >
    > When I say scrambled, the preview of the file has what looks like a
    > bunch of @@@@@ ampersands only they look like they have been shaded in.
    > Kinda like what you will see if a font is missing.
    >
    > I will post more and better info tomorrow.
    >
    > Other CSV seem to work fine.
    >
    > If I can't figure out how to show you, the file is pretty small so I
    > could upload it somewhere or email it.


    You should be able to just copy/paste a line or two from the file
    (obscuring anything that's sensitive) inside code tags here.

    Jim



    --
    Jim Henderson
    openSUSE Forums Administrator
    Forum Use Terms & Conditions at http://tinyurl.com/openSUSE-T-C

  7. #7
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: Libre office works differently

    On 2013-08-10 02:13, Jim Henderson wrote:
    > You should be able to just copy/paste a line or two from the file
    > (obscuring anything that's sensitive) inside code tags here.


    That should be enough - unless there is a text coding difference, like 8
    bit chars to utf, because the pasting (and mailing) does a conversion.
    In that case the real file would be necessary, I think.

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 12.3 x86_64 "Dartmouth" at Telcontar)

  8. #8
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    17,069

    Default Re: Libre office works differently

    On Sat, 10 Aug 2013 00:28:06 +0000, Carlos E. R. wrote:

    > On 2013-08-10 02:13, Jim Henderson wrote:
    >> You should be able to just copy/paste a line or two from the file
    >> (obscuring anything that's sensitive) inside code tags here.

    >
    > That should be enough - unless there is a text coding difference, like 8
    > bit chars to utf, because the pasting (and mailing) does a conversion.
    > In that case the real file would be necessary, I think.


    Yeah, I was thinking about that as well - the output from the 'file'
    command would probably be useful, too.

    Jim



    --
    Jim Henderson
    openSUSE Forums Administrator
    Forum Use Terms & Conditions at http://tinyurl.com/openSUSE-T-C

  9. #9
    Join Date
    May 2010
    Location
    Space Colony Lagrange Point 22° à, 77° Ƅ, 56° ɤ, 99° ɜ
    Posts
    3,166

    Default Re: Libre office works differently

    hextejas wrote:
    >
    > I tried opening a .CSV file on Windows 7 with Open Office and it opens
    > it just fine.
    > However when I try the same file in openSUSE it comes in all scrambled.
    >
    > Who do I talk to about this ?
    >
    > Or I imagine that Open Office is available instead. Let me see.
    >
    >

    When you double click on csv a libreoffice window pops up where you need
    to check/set the correct "character set" and "language". I had a issue
    similar to what you describe and i found that my character set was set
    to Unicode,but when i changed it unicode (UTF-8) it makes massive
    difference.
    screenshots
    wrong character set
    http://paste.opensuse.org/images/42758011.png
    correct character set
    http://paste.opensuse.org/images/88091917.png
    --
    GNOME 3.6.2
    openSUSE Release 12.3 (Dartmouth) 64-bit
    Kernel Linux 3.7.10-1.16-desktop

  10. #10
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: Libre office works differently

    On 2013-08-10 04:23, vazhavandan wrote:
    > When you double click on csv a libreoffice window pops up where you need
    > to check/set the correct "character set" and "language". I had a issue
    > similar to what you describe and i found that my character set was set
    > to Unicode,but when i changed it unicode (UTF-8) it makes massive
    > difference.


    Yes, same here.

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 12.3 x86_64 "Dartmouth" at Telcontar)

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •