Description: After making some changes (doesn't matter how many} to a Spreadsheet (format is .xlsx), I place the cursor in a cell (doesn't matter what cell) and display the page on the screen. I save the Spreadsheet and close it. When I open the Spreadsheet again, the page with the cursor is not displayed, but another page from a save many times ago is displayed. This happens in version 6.3.0.4. I have completely removed version 6.3.0.4 and reinstalled 6.2.5.2 and the problem is gone. Note that all my Spreadsheets are in .xlsx format because my wife's laptop has Office 2007 and she doesn't want to learn LibreOffice at the moment. I don't think the .xlsx format is the problem. Actual Results: no comment Expected Results: no comment Reproducible: Always User Profile Reset: No Additional Info:
Thank you for reporting the bug. To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? If the issue still exists, please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(In reply to Wally from comment #0) Can you please attach your description and sample documents to the issue? -> [Add an attachment]
Created attachment 153634 [details] copy of file after problem
Created attachment 153635 [details] copy of file before problem
I reset the profile per the instructions and ran in safe mode and the problem is still there. Since I have already reinstalled version 6.2.5.2 and reinstalled my latest backup profile, I have just reinstalled 6.3.0.4 over top of 6.2.5.2. The profile is in perfect shape as I used a backup profile from August 1, 2019. I have attached a before and after version of a file. The before version has not been modified by 6.3.0.4. The after version has had the following done to it. I added some lines of code, placed the cursor in cell A46, saved the file with cell A46 displayed on the screen, closed the file, opened the file, and it displayed cell A46 as it should, put the cursor in cell A9, saved the file with cell A9 displayed on the screen, closed the file, opened the file, the cursor is still in cell A9 but cell A9 is not displayed on the screen, cell A46 is displayed. Cell A9 should be displayed. Hope this helps. Brian Waldron
Oliver, please be aware that this is my first sojurn through Bugzilla so I have no idead how it works.
reproducible with: Version: 6.3.1.1 (x64) Build ID: e979878b49a48dab15ebe528f238b88125e32c65 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: steps to reproduce: - open "Great Lakes Freighters after.xlsx" - cell cursor selects cell A9, but first visible row is 39 (same happens if opened with ms excel 2016) - scroll to row 1 and select cell A1 - save - reload -> cell cursor now selects cell A1, but first visible row is still 39 but *not* reproducible with: Version: 6.2.6.2 (x64) Build-ID: 684e730861356e74889dfe6dbddd3562aae2e6ad CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc:
Adding keywords regression and filter:xlsx
This seems to have begun at the below commit. Adding Cc: to László Németh ; Could you possibly take a look at this one? Thanks 3fe34c889435e5361493124492e03854d589fc47 is the first bad commit commit 3fe34c889435e5361493124492e03854d589fc47 Author: Jenkins Build User <tdf@pollux.tdf> Date: Tue Feb 19 01:23:00 2019 +0100 source 3707e2a7b8b05617b0afb75374f866c967593861 author László Németh <nemeth@numbertext.org> 2019-02-18 18:29:51 +0100 committer László Németh <nemeth@numbertext.org> 2019-02-19 01:14:12 +0100 commit 3707e2a7b8b05617b0afb75374f866c967593861 (patch) tree abd4602d22bdb518c648aadefa2395f1759eaf65 parent 6fb9ef15aa67b91dec016873ad8224db2323291c (diff) tdf#122624 XLSX OLE in DOCX: export view positions
(In reply to raal from comment #9) > Adding Cc: to László Németh ; Could you possibly take a look at this one? > Thanks Yes, I started to check it, thanks for your report.
László Németh committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/47aa9324e3d15fcc9d1195b9b0822b5568e6d96e%5E%21 tdf#127110 XLSX export: fix bad view position It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 6.4.0.0.alpha0+ Build ID: bb9c07b82f4921941112de7e545af13a24b37f5d CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded @László Németh, thanks for fixing this issue!!
László Németh committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/09afdc89572202f100e5ab5112ae0878ae032fc1%5E%21 tdf#127110 XLSX export: fix bad view position It will be available in 6.3.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I have tested with 6.3.2.2 and all works OK.