Bug 1980800 - convert-to csv is only converting the first tab of xlsx workbooks
Summary: convert-to csv is only converting the first tab of xlsx workbooks
Alias: None
Product: Red Hat Enterprise Linux 8
Classification: Red Hat
Component: libreoffice
Version: 8.4
Hardware: x86_64
OS: Linux
Target Milestone: beta
: ---
Assignee: Caolan McNamara
QA Contact: Martin Krajnak
Depends On:
Blocks: 1980807
TreeView+ depends on / blocked
Reported: 2021-07-09 14:58 UTC by Joe Wright
Modified: 2022-05-10 13:51 UTC (History)
5 users (show)

Fixed In Version: libreoffice-
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1980807 (view as bug list)
Last Closed: 2022-05-10 13:31:48 UTC
Type: Bug
Target Upstream Version:

Attachments (Terms of Use)

System ID Private Priority Status Summary Last Updated
Document Foundation 135762 0 None None None 2021-07-12 13:57:31 UTC
Red Hat Product Errata RHSA-2022:1766 0 None None None 2022-05-10 13:32:07 UTC

Description Joe Wright 2021-07-09 14:58:59 UTC
Description of problem:
- only first tab of workbook is being converted when running 

Version-Release number of selected component (if applicable):

How reproducible:
- verified by support

Steps to Reproduce:
1) Run below command to convert the file to .csv

# soffice --convert-to csv Redhat_Case_02966328.xlsx

2) Run 'cat Redhat_Case_02966328.xlsx' you will see only 1st tab of the original workbook is converted to csv.

Actual results:
- only 1st tab of workbook is converted to csv.

Expected results:
- entire contents of workbook converted

Additional info:

Comment 8 Caolan McNamara 2021-07-14 18:56:19 UTC
our upstream effort is: https://gerrit.libreoffice.org/c/core/+/118850

sample usage:

soffice --convert-to csv:"Text - txt - csv (StarCalc)":44,34,UTF8,1,,0,false,true,false,false,false,-1 sample.ods

where the new (11th!) final token ("-1") enables writing each sheet to a new file based on the suggested target name so output in this example is files
sample-Sheet1.csv and sample-Sheet2.csv

Comment 10 Martin Krajnak 2021-09-15 12:42:20 UTC

$ rpm -q libreoffice 
$ soffice --convert-to csv:"Text - txt - csv (StarCalc)":44,34,UTF8,1,,0,false,true,false,false,false,-1  Redhat_Case_02966328.xlsx 
$ ll
total 24
-rw-r--r--. 1 test test    59 Sep 15 14:10 'Redhat_Case_02966328-Name and Address.csv'
-rw-r--r--. 1 test test    51 Sep 15 14:10 'Redhat_Case_02966328-Name and age.csv'
-rw-r--r--. 1 test test    40 Sep 15 14:10 'Redhat_Case_02966328-Name and ID.csv'
-rw-r--r--. 1 test test 11194 Sep 15 14:02  Redhat_Case_02966328.xlsx

Comment 13 Martin Krajnak 2021-09-29 09:47:25 UTC

Comment 15 errata-xmlrpc 2022-05-10 13:31:48 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Moderate: libreoffice security, bug fix, and enhancement update), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.


Note You need to log in before you can comment on or make changes to this bug.