Bug on footerpage of 2nd sheet (CALC) How to reproduce the problem: Tested on Windows 7 64b and Windows XP 32b. Tested on LibreOffice Versions: (Portuguese Brazilian) 3.3.3 3.4.1 1) With CALC, build a New SpreadSheet, on the sheet 1 and 2, let the footerpage as # of ## (page number of pages) 2) Save as .xls (office 97 format) 3) Close 4) Reopen and go to 2nd sheet, see the preview... footer must to show p.e. page 1 of 1, but shows page 0 of 1 !? On the 1st sheet the preview is OK, the problem appears on the next sheets ... Roberto Novakosky
Confirmed for LibreOffice 3.4 340m1(Build:103) on OpenSuse Linux. Followed the steps, viewed the sheets on File->Page preview, problem exactly as reporter mentioned.
New Test With the file .xls created on CALC: indicates that the file is correct your data structure, so the problem probably resides on functions from CALC that load the .xls to memory.
New Test With the file .xls created on CALC: If it is opened on MS Office, it works fine, so it indicates that the file is correct your data structure, so the problem probably resides on functions from CALC that load the .xls to memory.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian
New tests on Version 3.6.1.2 of LibreOffice CALC. BUG reconfirmed.
Hello I reproduce with Version 3.6.2.1 (Build ID: ba822cc) & Windows 7 64bits Regards Pierre-Yves
I can confirm this bug on 2nd tab [shhet] of a .xls spreadsheet (saved as Excel 1997-2003) ONLY in preview mode (the print in fact starts correct from number 1) in a Windows 7 Pro 64 bits environment and LibreOffice 3.6.2.2 version for Windows. Beste regards, Leopoldo Saggin aka Topoldo
Version is oldest version not newest. Reverting change. Also requesting confirmation from QA team as that hasn't been done - moving to UNCONFIRMED.
Tested again on Version 4.2.6.3. (on WIN XP 32) Reconfirmed the problem.
Please don't confirm your own bugs .. also don't update the version as version is the oldest version, not newest.
By footerpage, I assume you mean the Page indicator in the Status bar. For me, it shows Page 1 / 0 in the preview even when I've just created the sheets, so no change when saving to .xls. I'd like to see screenshots "ok" and "not ok". Win 7 64-bit Version: 4.4.0.0.alpha2+ Build ID: b021b5983c62e266b82d9f0c5c6d8d8900553827 TinderBox: Win-x86@39, Branch:master, Time: 2014-11-12_01:10:08
Confirmed in 4.3.5.2 Windows and 4.2.7.2 Linux Ubuntu. ONLY in preview, not on printing. Note: AOO 4.1.1 not has this problem.
(In reply to ifanlo from comment #16) > Confirmed in 4.3.5.2 Windows and 4.2.7.2 Linux Ubuntu. > ONLY in preview, not on printing. > > Note: AOO 4.1.1 not has this problem. Can you give screenshots of both LibreOffice & AOO?
Created attachment 113057 [details] screenshot on Excel, LibO and AOO
Created attachment 113058 [details] sample document
(In reply to Beluga from comment #17) > > Can you give screenshots of both LibreOffice & AOO? Attached!
(In reply to ifanlo from comment #18) > Created attachment 113057 [details] > screenshot on Excel, LibO and AOO Thanks. I get the same in LibreOffice as your Excel screenie, 1/1 so no problem for me. Can you test with 4.4? Win 7 Pro 64-bit, LibO Version: 4.4.0.3 Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7 Version: 4.5.0.0.alpha0+ Build ID: 4b9a9ce8a0e5e0716dad9a9ec87d16237e534dc2 TinderBox: Win-x86@39, Branch:master, Time: 2015-01-31_09:49:44 Ubuntu 14.10 64-bit Version: 4.4.0.3 Build ID: 40m0(Build:3)
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 This NEEDINFO message was generated on: 2015-09-03
Roberto: do you confirm this problem with LibO 5.0.x?
Problem confirmed on 5.0.x (Tested on 5.0.1.2) Roberto
I can confirm with Version: 5.1.0.0.alpha1+ Build ID: 83ef294dddf3b1ab5cd5f91a792a7d9413a08f1f TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-09-20_07:00:46 Sheet Hoja1 is correct, sheet Hoja2 is incorrect (0/1) . Works OK in excel2010.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20161108
Confirmed Problem Version Tested: LibreOffice 5.2.3.3 (latest version at the moment) SO: Windows 7 Pro 64b
Roberto, thank you for following your bug but version 5.2.3 is not latest. Not reproducible with: master, 5.3.4, 5.2.7. So I'll close as WFM since fix is not known. There was somewhat related Bug 77111, if you tested you old files. You may get http://tdf.io/siguiexe to easily get and run "parallel" LO in Windows (extract without installation) in order to test newest and still not for production LO versions, like 5.4 and master 6.0+. If you confirm the bug with master or 5.3.4, please note.
Thomas, I don't see the point of all those broad Meta bugs, such as XLS, but if you add it, please test before.
Resolved Task Test OK ON LibreOffice Version: 5.2.7.2