Excel spreadsheets that use structured reference tables are now corrupted on round trip with a 'Err:507'. Steps to reproduce: 1. With a recent build of LibreOffice open attachment 114686 [details] 2. Save as XLSX 3. Open in Excel or Calc The first sheet, Per Participant has a 'Err:507' (#REF! in Excel). On the 'Data' sheet, the Total Medals column also has an 'Err:507'. Fortunately, the relevant tinderbox builds had not yet faded into the ether( why is TDF so stingy here?), and I was able to quickly bibisect this regression to: https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=215cbfb460326010737433c2020638e9388a88a4..0ab8a27244e74e1c0916b3737f15c6c949aead78
Confirmed in Version: 5.4.0.0.alpha0+ Build ID: 9a30cb2161506e003f14592d83075ab9d30516c1 CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk2; Locale: ca-ES (ca_ES.UTF-8); Calc: group but not in Version: 5.3.0.0.beta2+ Build ID: 6238f71ddbdc766e733b1c808a4fa7d66f7bde87 CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk2; Layout Engine: new; Locale: ca-ES (ca_ES.UTF-8); Calc: group
thank you, could reproduce on master with your steps regression of https://cgit.freedesktop.org/libreoffice/core/commit/?id=f1dcb8b3e2e01848d44dd1beb82cd4e6e68a2acd > replace hard-coded namespace URL strings with function calls... > Follow-up for https://gerrit.libreoffice.org/#/c/32425/
I can confirm, reverting: https://cgit.freedesktop.org/libreoffice/core/commit/?id=f1dcb8b3e2e01848d44dd1beb82cd4e6e68a2acd replace hard-coded namespace URL strings with function calls... Resolves this issue.
I will take care of it.
Ok. Just replace xls14Lst in sc/source/filter/excel/xedbdata.cxx with xls. I made a mistake while replacing the strings.
(In reply to auchi31 from comment #5) > Ok. Just replace xls14Lst in sc/source/filter/excel/xedbdata.cxx with xls. > I made a mistake while replacing the strings. Ah. Perfect. Used your change and pushed it.
Rosemary Sebastian committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=95cf7fa25d3b950e0cb576a1e864b54f1a43bc7a tdf#105272: fix wrong namespace URL It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified FIXED in Version: 5.4.0.0.alpha0+ (x64) Build ID: efce216ca5d2b852c9fccc52ee68d1e27279d900 Thanks Rosemary!
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b0e1592bbbe5d25d65b834e7202b4e6cdee435a6 tdf#105272: Add unittest It will be available in 7.0.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.