https://bugs.documentfoundation.org/show_bug.cgi?id=152014
Bug ID: 152014
Summary: Wrong result with match function when multiple
spreadsheets are opened
Product: LibreOffice
Version: 7.2.7.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Wrong result with match function when multiple spreadsheets are opened
Steps to Reproduce:
1. New spreadsheet
2. Type =MATCH(1,A2,0) in Sheet1.A1
3. Type 1 in Sheet1.A2
4. Create another spreadsheet (Ctrl+N)
5. Type =MATCH(1,A2,0) in Sheet1.A1
Actual Results:
Sheet1.A1=1 in both spreadsheets
Expected Results:
Sheet1.A1=#N/A in the 2nd spreadsheet
Reproducible: Always
User Profile Reset: Yes
Additional Info:
This bug happens also in 7.3.7 and 7.4.2
Version: 7.2.7.2 (x64) / LibreOffice Community
Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
Version: 7.3.7.2 (x64) / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
Version: 7.4.2.3 (x64) / LibreOffice Community
Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
