Created attachment 157494 [details] XLSX put in Shared (legacy) mode in Excel 2016 The attached file had been put to "shared workbook" state in Excel 2016. Opening it in Calc, and simply saving (keeping XLSX format) adds a white rectangle (in my testing, WxH ~ 26x50 cm) to the top left of the sheet. Tested with Version: 6.4.0.3 (x64) Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8 CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: CL and with LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 (this is not inherited from OOo, since the latter couldn't save to XLSX).
FTR - documentation on "shared worksheets" feature in later Excel version: https://support.office.com/en-us/article/About-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534 https://support.office.com/en-us/article/what-happened-to-shared-workbooks-150fc205-990a-4763-82f1-6c259303fe05
Confirmed Version: 6.4.0.3 (x64) Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8 CPU threads: 4; OS: Windows 10.0 Build 19551; UI render: GL; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: CL At opening the file has three drawing objects with different names, after save and reopening the three objects has the same name, and the withe box appear.
This is because of the comment in B52, not the shared mode (which is lost on save anyways -> bug #100433). The Excel comments have text contents and a VML shape for positioning, and the broken export of this VML shape was fixed in bug #117274. Excel considered the LO-saved VML broken, and saved it as a separate, but virtually invisible shape (and created a new one for positioning the comment). This is the "Autoshape 2" in the example file. Another save in LO <= 6.3 made this shape visible that's how the huge white rectangle was created. If you double click in the Navigator on the "Autoshape 2" and press Del to delete it, the problem will no longer occur in 6.4 after save & reload. The fix to bug #117274 stopped creating broken VML files, but does not remove the autoshapes stashed away by Excel - you can do that only manually. *** This bug has been marked as a duplicate of bug 117274 ***