You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/12/18 12:19:49 UTC

[Bug 123876] New: Conversion ODS => XLS make wrong column width when is made in -headless mode

https://issues.apache.org/ooo/show_bug.cgi?id=123876

            Bug ID: 123876
        Issue Type: DEFECT
           Summary: Conversion ODS => XLS make wrong column width when is
                    made in -headless mode
           Product: Calc
           Version: 4.0.1
          Hardware: All
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: save-export
          Assignee: issues@openoffice.apache.org
          Reporter: samborsky_d@yahoo.com
                CC: issues@openoffice.apache.org

Created attachment 82132
  --> https://issues.apache.org/ooo/attachment.cgi?id=82132&action=edit
this is a test script and all the files needed to reproduce the issue

I observe an erroneous ODS => XLS (MS Excel 97) format conversion:
column sizes are increased for some ODS files.

It only happens when:

1. ODS file contains styles with 'Times New Roman Cyr' or 'Arial Cyr' fonts
(Linux *does* have Microsoft 'Times New Roman' & 'Arial' TTF fonts, but not the
legacy cyrillic fonts with 'Cyr' suffix)

2. Conversion is made in a headless mode (i.e. executed with a command like
'DISPLAY="" soffice -headles ...')

See the attached ZIP file for the sample file.ods test file, test scipt,
Module1.xba and the resulted file.xls which has wrong size of its first column
(4.04", not 3.53").

My test environment is following:

$ uname -a
Linux ... 2.6.32-358.18.1.el6.x86_64 #1 SMP Wed Aug 28 17:19:38 UTC 2013 x86_64
x86_64 x86_64 GNU/Linux

OpenOffice version: Apache OpenOffice 4.0.1, AOO401m5(Build:9714)  -  Rev.
1524958 2013-09-20 11:54 - Linux x86_64

There were a couple related issues (#50210, #59234) reported earlier, but now I
think I have 100% reproducable behaviour which is tested in OO v.3.1.1, v.3.3,
and v.4.01.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123876] Conversion ODS => XLS make wrong column width when is made in -headless mode

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123876

--- Comment #2 from Dmitriy Samborskiy <sa...@yahoo.com> ---
> What is Module1.xba?

Module1.xba is a file with user's standard macro library which is located in 

~/.openoffice/3/user/basic/Standard

folder.

The conversion commands call macro function SaveAsMSO which is defined in this
file (AFAIK there is no other way to call a macro function from a command line
than to use user's macro library defined in this file).

> ./test.sh gives:
> No protocol specified
> No protocol specified
> /opt/openoffice4/program/soffice.bin X11 error: Can't open display: 
>   Set DISPLAY environment variable, use -display option
>   or check permissions of your X-Server
>   (See "man X" resp. "man xhost" for details)

Perhaps you are running it without X display.
It's necessary for the first command

soffice macro:///Standard.Module1.SaveAsMSO\($FILE\)

to have access to graphic display. It shows OO logo window for a second
and then the resulted file.xls is made (the correct one).

Only the second command gives the wrong file.xls (with wrong column1 size):

DISPLAY="" soffice -headless macro:///Standard.Module1.SaveAsMSO\($FILE\)

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123876] Conversion ODS => XLS make wrong column width when is made in -headless mode

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123876

--- Comment #3 from Edwin Sharp <el...@apache.org> ---
Thank you. 
The first command in test.sh was commented.
./test.sh now has no effect.
Apologies for not being a Linux expert.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123876] Conversion ODS => XLS make wrong column width when is made in -headless mode

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123876

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needmoreinfo
                 CC|                            |elish@apache.org

--- Comment #1 from Edwin Sharp <el...@apache.org> ---
./test.sh gives:
No protocol specified
No protocol specified
/opt/openoffice4/program/soffice.bin X11 error: Can't open display: 
   Set DISPLAY environment variable, use -display option
   or check permissions of your X-Server
   (See "man X" resp. "man xhost" for details)

What is Module1.xba?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123876] Conversion ODS => XLS make wrong column width when is made in -headless mode

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123876

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |IRREPRODUCIBLE

--- Comment #4 from Edwin Sharp <el...@apache.org> ---
No info from author.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.