I cant open a file saved in libreoffice as XLSX. I have: - created and worked with the file in my comoyter. It works fine. - saved the file in my Dropbox fólder. - tried to open the file in my mobile phone (android) using the oficial ms Excel app. It returns an error. Like the file is corrupt and is not able to open It. However the file is fully operational in my PC like nothing happened. I have experienced this with only few of many of my files, the only thing i can imagine are the pívot tables causing some issue... Because when files are very basic and simplistic this error doesnt show.
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon. Please don't set up your own reports as new, someone else must confirm it.
Created attachment 203390 [details] sample file Attached the file that is presenting the gap between libreoffice/dropbox/excel. Please find below the info from Menu/Help/About LibreOffice Version: 25.8.1.1 (X86_64) Build ID: 54047653041915e595ad4e45cccea684809c77b5 CPU threads: 12; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
Created attachment 203392 [details] for test This is the xml for pivot table: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <pivotTableDefinition xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" name="DataPilot1" cacheId="1" applyNumberFormats="0" applyBorderFormats="0" applyFontFormats="0" applyPatternFormats="0" applyAlignmentFormats="0" applyWidthHeightFormats="0" dataCaption="Values" showDrill="0" useAutoFormatting="0" itemPrintTitles="1" indent="0" outline="0" outlineData="0" compact="0" compactData="0"><location ref="L3:M8" firstHeaderRow="1" firstDataRow="1" firstDataCol="1"/><pivotFields count="9"><pivotField compact="0" showAll="0"/><pivotField compact="0" showAll="0"/><pivotField axis="axisRow" compact="0" showAll="0" defaultSubtotal="0" outline="0"><items count="4"><item x="0"/><item x="1"/><item x="2"/><item x="3"/></items></pivotField><pivotField dataField="1" compact="0" showAll="0" outline="0"/><pivotField compact="0" showAll="0"/><pivotField compact="0" showAll="0"/><pivotField compact="0" showAll="0"/><pivotField compact="0" showAll="0"/><pivotField compact="0" showAll="0"/></pivotFields><rowFields count="1"><field x="2"/></rowFields><rowItems count="5"><i><x v="0"/></i><i><x v="1"/></i><i><x v="2"/></i><i><x v="3"/></i><i t="grand"><x v="4"/></i></rowItems><colItems count="1"><i t="grand"><x v="0"/></i></colItems><dataFields count="1"><dataField name="Suma - % Sobre Total" fld="3" subtotal="sum" numFmtId="165"/></dataFields><pivotTableStyleInfo name="PivotStyleLight16" showRowHeaders="1" showColHeaders="1" showRowStripes="0" showColStripes="0" showLastColumn="1"/></pivotTableDefinition> I made some changes here, please try the file I upload, see if it is better.
Hi Bogdan. This new file doesnt work either. I download It to my phone (instead of putting in Dropbox) Same behaviour. bR.
Reproducible Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 94993b477d0db1b8572233ba96a60cbcf7523b79 CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win Locale: en-US (es_ES); UI: en-US Calc: threaded This is the file generated by Excel at opening an repair the file. The pivot table does not survive the reparation. <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error333280_01.xml</logFileName><summary>Se han detectado errores en el archivo "C:\Users\mario\Downloads\_Test\SAMPLE BUG Miguel oct2025.xlsx"</summary><removedFeatures><removedFeature>Característica quitada: Informe de tabla dinámica de /xl/pivotTables/pivotTable1.xml parte (Vista Tabla Dinámica)</removedFeature></removedFeatures></recoveryLog>
I reproduce with attached sample, but not if I resave in LO 25.8 or 26.2+ And bug only makes sense with saving in new versions. Not clear how Miguel testeed So this seems fixed. If someone tests differently, please explain. Would be better to reverse bibisect to know the fix.