Bug 136148 - Headless converting XLSX to XLS doesn't take hide grid checkbox
Summary: Headless converting XLSX to XLS doesn't take hide grid checkbox
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Commandline XLS
  Show dependency treegraph
 
Reported: 2020-08-26 13:46 UTC by kirill
Modified: 2024-02-25 05:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
TestCase (9.28 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-08-27 06:47 UTC, kirill
Details

Note You need to log in before you can comment on or make changes to this bug.
Description kirill 2020-08-26 13:46:46 UTC
console comand like C ""C:\Program Files (x86)\LibreOffice\program\soffice.bin" --norestore --nofirststartwizard --headless --convert-to xls "C:\AlphaStorage\mpt\mptStorage\File.ConvertedFile\1d9a404b-a859-41cc-b7c3-8658532e8458\Паспорт государственной программы 26.08.2020 15.31.xlsx" --outdir "C:\AlphaStorage\mpt\mptStorage\File.ConvertedFile\1d9a404b-a859-41cc-b7c3-8658532e8458""
doen't take value of hide grid checkmark.
Comment 1 Roman Kuznetsov 2020-08-26 17:54:00 UTC Comment hidden (obsolete)
Comment 2 kirill 2020-08-27 06:47:08 UTC
Created attachment 164732 [details]
TestCase
Comment 3 QA Administrators 2020-08-28 04:04:59 UTC Comment hidden (obsolete)
Comment 4 Roman Kuznetsov 2020-09-01 14:37:42 UTC
Kirill, you shouldn't confirm your own bug reports, it should be someone another
Comment 5 buba 2020-09-16 14:11:32 UTC
using cli conversion does not take into account the hide grid checkbox.
Comment 6 Timur 2021-06-14 14:59:21 UTC
44max oldest is OK, 44max master is NOK, so regression.
I couln't bibisect in Linux. Someone else may try, or Windows.
Comment 7 QA Administrators 2023-06-15 03:15:06 UTC Comment hidden (obsolete)
Comment 8 raal 2023-12-22 14:28:31 UTC
Still reproducible Version: 24.2.0.0.beta1+ (X86_64) / LibreOffice Community
Build ID: 0034d2ab9382da86340738137218791a4ccc9c90
CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
Comment 9 Aron Budea 2024-02-25 05:40:58 UTC
This was all good, until the following commit. After this commit, headless conversion started failing.

https://cgit.freedesktop.org/libreoffice/core/commit/?id=bfb978334cea775b8ae5c40ceea050ea0660d80a
author		Michael Meeks <michael.meeks@collabora.com>	2014-06-28 20:10:33 +0100
committer	Michael Meeks <michael.meeks@collabora.com>	2014-06-30 15:36:26 +0100

"configmgr: faster / simpler compare for keys."

The failing lasted until this commit, after which the output was already buggy.

https://cgit.freedesktop.org/libreoffice/core/commit/?id=24d20bce789063f6dba2df1c5d2c5a8948d24370
author		David Tardon <dtardon@redhat.com>	2014-07-07 16:34:18 +0200
committer	David Tardon <dtardon@redhat.com>	2014-07-07 16:34:59 +0200

"fdo#80955 make calc_MS_Excel_97 filter default for xls ext."

However, the "XLS" exported before the first commit isn't actually XLS, it's an ODS (you can rename it to ZIP, and unzip it). So this isn't a regression.


I also tried performing the conversion specifying the filter: "xls:calc_MS_Excel_97"

Strangely, that always resulted in an error:
"Error: Please reverify input parameters..."

In recent 24.8 builds:
"Error: Please verify input parameters... (SfxBaseModel::impl_store <file:///home/valaki/bibisect/bibisect-linux-64-24.8/instdir/program/DDND.xls> failed: 0x81a(Error Area:Io Class:Parameter Code:26) at /home/tdf/lode/bibisect/core248/sfx2/source/doc/sfxbasemodel.cxx:3304 at /home/tdf/lode/bibisect/core248/sfx2/source/doc/sfxbasemodel.cxx:1822)"