Bug 143328

Summary:	FILESAVE: All 3 form controls disappear on reopen in LO, incorrect in MSO
Product:	LibreOffice	Reporter:	Gülşah Köse <gulsah.kose>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	aron.budea, jluth, kelemeng, rb.henschel, vsfoote
Priority:	medium	Keywords:	implementationError
Version:	3.4.0 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=104309
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	133999
Attachments:	sample.xlsx Spreadsheet with form controls The original file and its Calc-saved version reloaded

Description Gülşah Köse 2021-07-13 06:33:56 UTC

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.

Comment 1 Regina Henschel 2021-07-13 09:20:28 UTC Comment hidden (obsolete)

I cannot open the attached file in Excel. So there is something wrong with the file.

Comment 2 NISZ LibreOffice Team 2021-07-13 15:48:04 UTC

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.

Comment 3 V Stuart Foote 2021-07-14 03:27:12 UTC Comment hidden (obsolete)

please provide a working copy of the OOXML Excel document.

Comment 4 Gülşah Köse 2021-07-14 04:38:36 UTC

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.

Comment 5 Jan Holesovsky 2021-07-14 09:05:15 UTC Comment hidden (obsolete)

Isn't this actually fixed by this?

https://gerrit.libreoffice.org/c/core/+/118219

Comment 6 Gülşah Köse 2021-07-14 09:36:10 UTC Comment hidden (obsolete)

Kendy, I have that commit my build. It didn't worked for that bug.

Comment 7 Regina Henschel 2021-07-14 11:39:34 UTC

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.

Comment 8 Regina Henschel 2021-07-14 11:44:59 UTC

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.

Comment 9 Gabor Kelemen (allotropia) 2023-01-31 16:38:03 UTC

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.

Comment 10 Gabor Kelemen (allotropia) 2023-01-31 16:48:14 UTC

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