Description: try to convert xlsx document to pdf like libreoffice --convert-to pdf 1.xlsx --headless or libreoffice --print-to-file 1.xlsx --headless on an output the file constructed without the scale parameter Steps to Reproduce: 1. create new xlsx file by libreoffice calc insert some data 2. set prit options: File->Print Preview -> Format Page-> Sheet -> Scale : Scale mode: Reduce/enlarge printout Scaling factor: 50% 3. Save file to "xlsx" fromat 4. convert with "libreoffice --convert-to pdf/print-to-file " 5. open output file to be convinced that scale parameter don't use Actual Results: scale parameter don't use Expected Results: slace parameter influences to output file by -convert-to pdf/print-to-file Reproducible: Always User Profile Reset: No Additional Info: if itself I generate xlsx file xl/worksheets/sheet1.xml <worksheet> <sheetPr filterMode="false"> <pageSetUpPr fitToPage="false"/> </sheetPr> ... ... <pageSetup paperSize="9" scale="50" firstPageNumber="0" fitToWidth="1" fitToHeight="1" pageOrder="downThenOver" orientation="portrait" usePrinterDefaults="false" blackAndWhite="false" draft="false" cellComments="none" useFirstPageNumber="false" horizontalDpi="300" verticalDpi="300" copies="1"/> ... </worksheet> this problem reproduce User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.59 Safari/537.36
Hello Alexander, it seems you're using an old version of LibreOffice. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
update libreoffice from https://www.libreoffice.org/download/libreoffice-fresh/ to LibreOffice 5.3.1.2 e80a0e0fd1875e1696614d24c32df0f95f03deb2 problem reproduce OS Distributor ID: Ubuntu Description: Ubuntu 16.04.2 LTS Release: 16.04 Codename: xenial Linux 4.4.0-62-generic x86_64 x86_64 x86_64 GNU/Linux
also still I noted the bug connected to it: 1. open libreoffice calc 2. set prit options: File->Print Preview -> Format Page-> Sheet -> Scale : Scale mode: Reduce/enlarge printout Scaling factor: 50% 3. save in the "xlsx" format 4. close libreoffice calc 5. open just saved file 6. go to File->Print Preview -> Format Page-> Sheet -> Scale : Scale mode: Reduce/enlarge printout Scaling factor: 100% !
(In reply to Alexander from comment #3) > also still I noted the bug connected to it: > 1. open libreoffice calc > > 2. set prit options: > File->Print Preview -> Format Page-> Sheet -> Scale : > Scale mode: Reduce/enlarge printout > Scaling factor: 50% > > 3. save in the "xlsx" format > 4. close libreoffice calc > 5. open just saved file > 6. go to File->Print Preview -> Format Page-> Sheet -> Scale : > > Scale mode: Reduce/enlarge printout > Scaling factor: 100% ! if use fromat Microsof Excel (2007-2013) (.xlsx) or Office Open XML Spreadsheet (.xlsx) - problem reproduce if use fromat ODF Spreadsheet (.ods) to save, problem not reproduce
(In reply to Alexander from comment #3) > also still I noted the bug connected to it: > 1. open libreoffice calc > > 2. set prit options: > File->Print Preview -> Format Page-> Sheet -> Scale : > Scale mode: Reduce/enlarge printout > Scaling factor: 50% > > 3. save in the "xlsx" format > 4. close libreoffice calc > 5. open just saved file > 6. go to File->Print Preview -> Format Page-> Sheet -> Scale : > > Scale mode: Reduce/enlarge printout > Scaling factor: 100% ! This is the real problem. ..and I found an existing report. *** This bug has been marked as a duplicate of bug 86396 ***
(In reply to Alexander from comment #0) > Description: > try to convert xlsx document to pdf like > > libreoffice --convert-to pdf 1.xlsx --headless > or > > libreoffice --print-to-file 1.xlsx --headless > > on an output the file constructed without the scale parameter > > Steps to Reproduce: > 1. > create new xlsx file by libreoffice calc > insert some data > 2. > set prit options: > File->Print Preview -> Format Page-> Sheet -> Scale : > Scale mode: Reduce/enlarge printout > Scaling factor: 50% > 3. > Save file to "xlsx" fromat > 4. > convert with "libreoffice --convert-to pdf/print-to-file " > 5. open output file to be convinced that scale parameter don't use > > Actual Results: > scale parameter don't use > > Expected Results: > slace parameter influences to output file by -convert-to pdf/print-to-file > > > Reproducible: Always > > User Profile Reset: No > > Additional Info: > if itself I generate xlsx file > > xl/worksheets/sheet1.xml > > <worksheet> > <sheetPr filterMode="false"> > <pageSetUpPr fitToPage="false"/> > </sheetPr> > ... > ... > <pageSetup > paperSize="9" > scale="50" > firstPageNumber="0" > fitToWidth="1" > fitToHeight="1" > pageOrder="downThenOver" > orientation="portrait" > usePrinterDefaults="false" > blackAndWhite="false" > draft="false" > cellComments="none" > useFirstPageNumber="false" > horizontalDpi="300" > verticalDpi="300" > copies="1"/> > ... > > </worksheet> > > this problem reproduce > > > User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like > Gecko) Chrome/54.0.2840.59 Safari/537.36 But how about this bug ??
(In reply to Alexander from comment #6) > But how about this bug ?? LibreOffice is resetting the scaling to 100% always when opening xlsx, so it's the same bug all the time. *** This bug has been marked as a duplicate of bug 86396 ***
When this bug will be fixed ?
(In reply to Alexander from comment #8) > When this bug will be fixed ? Nobody knows. You are free to find a developer to fix it. https://wiki.documentfoundation.org/Development/GetInvolved
*** This bug has been marked as a duplicate of bug 65848 ***