Created attachment 173521 [details] sample.xlsx 1) Open sample.xlsx 2) Save as sample2.xlsx Expected: We should see "PUZZLE" button on the first sheet. Actual: "PUZZLE" button is disappeared. Additional info: Document reported in tdf#34941 for another reason that seems as resolved fixed.
I cannot open the attached file in Excel. So there is something wrong with the file.
I can't open it in Excel either. File was saved last from Excel 12 and contains in Calc a VML pushbutton on the first sheet.
please provide a working copy of the OOXML Excel document.
Unfortunately, I didn't produce that document. I'm working on a tool that detects problems of existing files on bugzilla. You can see the tool in feature/ooxml-analyze breach of core repo. That one is one of the output of the tool.
Isn't this actually fixed by this? https://gerrit.libreoffice.org/c/core/+/118219
Kendy, I have that commit my build. It didn't worked for that bug.
It is reproducible with a newly created spreadsheet. The problem in "sample.xlsx" is because of macros. I will attach another spreadsheet from Excel. It is likely duplicate to some bugs listed in bug 133999 or its duplicates.
Created attachment 173557 [details] Spreadsheet with form controls The spreadsheet contains a button, a check box linked to a cell, and a slider linked to a cell. The form controls work after file open and are gone after file save and reopen in LO. Opening the file saved by LO in Excel shows duplicate button and checkbox, and empty frame, where the slider should be.
This got better since: https://git.libreoffice.org/core/+/d50eca2a30bdabdc1735c590d6ec1913c6dd22fd author Justin Luth <justin.luth@collabora.com> Thu Jan 12 11:18:55 2023 -0500 committer Justin Luth <jluth@mail.com> Sun Jan 15 02:09:06 2023 +0000 tree f8d8a738c60fa0c69954a9fbf684a2e7640d8740 parent 37e3455a13ab5741104bf41d05a80e60a4612682 [diff] tdf#117266 sc oox: export vml button with a correct name Now saving and reloading attachment 173557 [details] the button and checkbox are now visible in Calc, the scrollbar is still not.
Created attachment 185034 [details] The original file and its Calc-saved version reloaded Now some small differences also became visible: - Button Font is changed: Courier New -> (Default); Checkbox: Segoe UI 8pt -> (Default) 10 pt - Checkbox background is changed: (Default) -> White - but for the checkbox, it's retained correctly as #ECE9D8 - Push button in the original has the Printable attribute as No -> Yes (see in Print Preview
Dear Gülşah Köse, 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 with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. 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) from https://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: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
(In reply to Gabor Kelemen (allotropia) from comment #9) > > Now saving and reloading attachment 173557 [details] the button and checkbox > are now visible in Calc, the scrollbar is still not. Still in Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7c806a668530f25730717a12e6f97972f69d9c09 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded