Hide Forgot
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:
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
$ 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
csv_convert
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