Description: When opening the attached file created in MSO Excel, the pivot table is 1 row longer that it should be and it overwrites the contents of the next row. Steps to Reproduce: 1.Open the attached bugdoc 2.Go to the second sheet 3.Look at row 7 and cell C7 Actual Results: Row 7 is part of he table and cell C7 contains "12". Expected Results: Row 7 is not part of the table and cell C7 contains "under". Reproducible: Always User Profile Reset: Yes Additional Info: Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 437412d79b6b628ab28f15ccdc7aa95fc84cb3c1 CPU threads: 16; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Created attachment 195821 [details] Bugdoc
Jaume Pujantell committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/cd4498d32867af26e95de84836b724b4f85ba1b0 tdf#162466 calc: added handling of firstHeaderRow="0" on xlsx files It will be available in 25.2.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: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1565181908a06dcdb8d97d6be8ff773acd1d05cb CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded @Jaume, thanks for fixing this issue!!
Jaume Pujantell committed a patch related to this issue. It has been pushed to "libreoffice-24-8": https://git.libreoffice.org/core/commit/d54f4a7f5917097e9ac46f95d8122cb2671af9fa tdf#162466 calc: added handling of firstHeaderRow="0" on xlsx files It will be available in 24.8.1. 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.