Bug ID: 115721
           Summary: Calc function wizard cell reference problem
           Product: LibreOffice
           Version: release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc

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

Actual Results:  
$#REF!.A1 appear in formula instead of $Sheet1.A1 when using formula wizard

Expected Results:

Reproducible: Always

User Profile Reset: Yes

Additional Info:
i can reproduce this on LO / windows 10 and LO / windows 10

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101

You are receiving this mail because:
You are the assignee for the bug.
Libreoffice-bugs mailing list

Reply via email to