Created attachment 168380 [details] Comparison 7.1 vs 7.2 Steps to reproduce: 1. Open attachment 168180 [details] from bug 138925 -> faulty expressions cells show 179769313486232000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.0 value Reproduced in Version: 7.2.0.0.alpha0+ Build ID: ad8485ebe11396aaac68095ef9eec819de6af26c CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Regression introduced by: https://cgit.freedesktop.org/libreoffice/core/commit/?id=ee2cc952eeb5385ee37485c822d7ad7abd8fb989 author Eike Rathke <erack@redhat.com> 2020-11-25 13:54:31 +0100 committer Eike Rathke <erack@redhat.com> 2020-11-25 15:47:34 +0100 commit ee2cc952eeb5385ee37485c822d7ad7abd8fb989 (patch) tree e8e12b7af73ddc3a39025b09ffecc56a42ed55c7 parent 708a8b7f1d869580741787e71a9248757bb1541e (diff) Related: tdf#136272 accept 1.79769313486232e+308 as DBL_MAX Bisected with: bibisect-linux64-7.2 Adding Cc: to Eike Rathke
Sigh.. that uncovered bugs in Writer. Writer wrongly uses the *valid* DBL_MAX value to flag error (which is the real underlying bug) and then fails to check it after import. In content.xml there is <table:table-cell table:style-name="Table33.E3" table:formula="ooow:<?>+<D5>" office:value-type="float" office:value="1.79769313486232E+308"> <text:p text:style-name="P12">** Expression is faulty **</text:p> </table:table-cell> which has a faulty formula with a valid numeric result and a different display string.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0e37ded8d4aea25e5d9f7325fba0597f509147bc Resolves: tdf#139126 DBL_MAX is a valid value, just not for Writer It will be available in 7.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.
Pending review https://gerrit.libreoffice.org/c/core/+/108916 for 7-1 https://gerrit.libreoffice.org/c/core/+/108900 for 7-0
Verified in Version: 7.2.0.0.alpha0+ Build ID: 6bb6eb1692d7dd432103d0e7278534390084caf6 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded @Eike, thanks for fixing this issue!!
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/2569211290f460b4401a85f0540e965807bc5a34 Resolves: tdf#139126 DBL_MAX is a valid value, just not for Writer It will be available in 7.1.0.2. 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.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/428244a88ab01c68a8dec4d39eff3c0ece69b784 Resolves: tdf#139126 DBL_MAX is a valid value, just not for Writer It will be available in 7.0.5. 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.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/90cc24d4728dc94a30865d3b3af9409d5967b45a tdf#139126: sw_odfexport: Add unittest It will be available in 7.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.