Description: I received a spreadsheet from an excel user, which when I opened it in Calc did not present same results. Steps to Reproduce: 1.open xlsx 2. 3. Actual Results: see sheet Summary in Calc cp. to Excel I have included screenshots for both Expected Results: should produce same results Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 7c1bad415ae48635dc67041c413bb7b76a530c22 CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-07-05_06:55:03 Calc: threaded
Created attachment 173575 [details] the excel doc
Created attachment 173576 [details] excel result screenshot
Created attachment 173577 [details] calc result screenshot
Note: I a using the Office 365 version of excel
Created attachment 173578 [details] compared to example on internet This is a simple example, but it actually gives the same result as excel. The calculations are rather convoluted, but should still produce the same result?
Your screenshots show different data content, make at least sure you are comparing the same documents.
Created attachment 173579 [details] updated sspreadhseet to include an excample from MS
(In reply to Elmar from comment #7) > Created attachment 173579 [details] > updated sspreadhseet to include an excample from MS That document has regular expressions enabled, which calculates the criterion "=A*" differently. Switch to Excel compatible wildcards instead and you'll get the same 20 result, Tools -> Options -> Calc -> Calculate, Formulas Wildcards, Enable wildcards in formulas.
(In reply to Eike Rathke from comment #6) > Your screenshots show different data content, make at least sure you are > comparing the same documents. So that's actually because the value in B1 is already different, Excel 41831, Calc 41466 (date value of 2013-07-11); which in the Calc case is the value of LifeCycle.K2421 and thus the first date is 2014-03-31 whereas in the Excel case it is 2015-03-31 (unknown origin) and thus one data point less. Where's the 41831 cell content taken from in MIN(LifeCycle.K:K) in Excel?
Fwiw, the results are the same as in Excel if the document is recalculated, hit Shift+Ctrl+F9
The document is not an original Excel document but was stored using a LibreOfficeDev/7.2.0.0.alpha1 version. The stored values don't match the actual calculation, hence the (wrong) cached values are displayed until recalculated. My slightly behind 7.2.0.0.beta1+ calculates as expected. As does 7.3.0.0.alpha0+ and my slightly behind 7.1.5.0.1+ I think there's nothing to fix, the document has stored wrong values and needs to be recalculated.