Bug 1980800

Summary:	convert-to csv is only converting the first tab of xlsx workbooks
Product:	Red Hat Enterprise Linux 8	Reporter:	Joe Wright <jwright>
Component:	libreoffice	Assignee:	Caolan McNamara <caolanm>
Status:	CLOSED ERRATA	QA Contact:	Martin Krajnak <mkrajnak>
Severity:	medium	Docs Contact:
Priority:	low
Version:	8.4	CC:	alanm, erack, sbarcomb, tpelka, vikpatil
Target Milestone:	beta	Keywords:	FutureFeature, Triaged
Target Release:	---
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:	libreoffice-6.4.7.2-6.el8	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:
Clones:	1980807 (view as bug list)		Environment:
Last Closed:	2022-05-10 13:31:48 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1980807

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):
- 6.4.7.2-5.el8.x86_64

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 
libreoffice-6.4.7.2-6.el8.x86_64
$ 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

csv_convert

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.

https://access.redhat.com/errata/RHSA-2022:1766