https://bugs.documentfoundation.org/show_bug.cgi?id=115721
Bug ID: 115721
Summary: Calc function wizard cell reference problem
Product: LibreOffice
Version: 6.0.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: zoom322...@yahoo.fr
Description:
a problem appears when using function wizard. When i type = then click on the
cell on another spreadsheet, reference is ok (=$Sheet1.B4)
but with function wizard, result is $#REF!.A1
Steps to Reproduce:
open calc
create a new sheet, sheet2
on first cell of Sheet2 (A1), clic on function wizard.
select a function (example : upper)
argument : clic on sheet1, cell A1
$#REF!.A1 appear in formula, instead of Sheet1.A1
- when using vlookup function , for the matrix array, it displays
$#REF.A1:Sheet1.C3
Actual Results:
$#REF!.A1 appear in formula instead of $Sheet1.A1 when using formula wizard
Expected Results:
$Sheet1.A1
Reproducible: Always
User Profile Reset: Yes
Additional Info:
i can reproduce this on LO 5.4.0.3 / windows 10 and LO 6.0.0.3 / windows 10
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101
Firefox/58.0
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs