Bug 1980807

Summary:	convert-to csv is only converting the first tab of xlsx workbooks
Product:	Red Hat Enterprise Linux 7	Reporter:	Joe Wright <jwright>
Component:	libreoffice	Assignee:	Caolan McNamara <caolanm>
Status:	CLOSED WONTFIX	QA Contact:	Desktop QE <desktop-qa-list>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	7.9	CC:	alanm, caolanm, mkrajnak, sbarcomb, tpelka, vikpatil
Target Milestone:	rc
Target Release:	---
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:	1980800	Environment:
Last Closed:	2021-07-13 10:20:39 UTC	Type:	---
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:	1980800
Bug Blocks:

Description Joe Wright 2021-07-09 15:12:08 UTC

Description of problem:
- only first tab of workbook is being converted when running 

Version-Release number of selected component (if applicable):
- 5.3.6.1-25.el7_9.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 4 Caolan McNamara 2021-07-13 10:20:29 UTC

This is more a feature request to provide some way to save each sheet of a spreadsheet to a different csv than a simple bug. An implementation of that doesn't fit the criteria of comment #1.

There is guidance in https://bugzilla.redhat.com/show_bug.cgi?id=1980800#c7 as to how conversion of a csv to multiple files per sheet could be scripted via a macro callable from the command line as a workaround.

Comment 5 RHEL Program Management 2021-07-13 10:20:39 UTC

Development Management has reviewed and declined this request. You may appeal this decision by reopening this request.