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.