Created attachment 80938 [details] Screen - Left window: OpenOffice Scaling factor 70%[OK!]; Right window: LibreOffice Scaling factor 100% [BAD!] Problem description: When using PHPExcel class to produce Calc spreadsheets LibreOffice doesn't set scaling factor as expected. I have tested the same document using LibreOffice 4.0.3.3 release and scaling factor was set to 100%. When I opened the same document in OpenOffice Steps to reproduce: 1. $objPHPExcel = new PHPExcel(); 2. Add data 3. Set Breaks $objPHPExcel->getActiveSheet()->setBreak( 'K1' , PHPExcel_Worksheet::BREAK_COLUMN ); $objPHPExcel->getActiveSheet()->getPageSetup()->setFitToWidth(1); $objPHPExcel->getActiveSheet()->getPageSetup()->setScale(70); Current behavior: Scaling factor is set to 100% Expected behavior: Scaling factor should be 70% Operating System: Windows 7 Version: 4.0.3.3 release
Remove comma from whiteboard.
(In reply to comment #0) > Problem description: > When using PHPExcel class to produce Calc spreadsheets LibreOffice doesn't > set scaling factor as expected. > I have tested the same document using LibreOffice 4.0.3.3 release and > scaling factor was set to 100%. When I opened the same document in > OpenOffice Hi katyan, Could you please attach a sample document created by PHPExcel that demonstrates this behavior of LibreOffice? Thanks, --R
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INVALID due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of FDO
Migrating Whiteboard tags to Keywords: (NeedAdvice) [NinjaEdit]
It's not just files created with PHPExcel, it also appears to be happening with files created in Excel itself. The "Scaling Factor" value set by either Excel (Office 365) or PHPExcel (v1.8.1) is not respected in Calc (v5.0.4.2) - see attached images and test file.
Created attachment 122809 [details] File in Excel shows 90%, in Calc shows 100%
Created attachment 122810 [details] test-three (7).xlsx show in comparison image
Setting to NEW as we have confirmation.
Is there any improvement on this? I can confirm that LibreOffice Calc does not follow 'setScale' parameter given in PHPExcel. MS EXcel 78% LibreOffice Calc 100%
I can also reproduce this issue with LibreOffice 5.2.3.3, and would need it fixed.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fef72f9623bac7f9aa50b4f2606e6ec6282cfe1f always import page scaling, tdf#65848 It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=be00e2a73d10483b675a080f4899f8bf85d331db add test for tdf#65848 It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I added Bug 86396 to Seel Also because it was about filesave ever since OO, but it seems also fixed, so I'll mark as a duplicate.
*** Bug 86396 has been marked as a duplicate of this bug. ***
*** Bug 103484 has been marked as a duplicate of this bug. ***
Can we have this in 5.4 as well, please?
(In reply to Gabor Kelemen from comment #17) > Can we have this in 5.4 as well, please? The patch needs review: https://gerrit.libreoffice.org/#/c/39339/ For 5.3: https://gerrit.libreoffice.org/#/c/39340/
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7b1abc47af7a64ab8d3204cb85f173f0023da3ff&h=libreoffice-5-4 always import page scaling, tdf#65848 It will be available in 5.4.0.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ae56c9862222718871b6bf098162c2b8b4c44b82&h=libreoffice-5-3 always import page scaling, tdf#65848 It will be available in 5.3.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 106853 has been marked as a duplicate of this bug. ***