[Libreoffice-bugs] [Bug 72440] Function Wizard Range Selection Resulted in #REF Error

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Nov 22 10:59:30 UTC 2017


https://bugs.documentfoundation.org/show_bug.cgi?id=72440

--- Comment #12 from Kevin Suo <suokunlong at 126.com> ---
Just to clarify, this happens to all functions which allow range parameter.
Copying the steps to reproduce explained in bug 113086.

Steps to Reproduce: 
1.Create a new Spreadsheet 
2.Create a new sheet named "Sheet2" 
3.Switch to sheet "Sheet2" 
4.Select any Cell in Sheet, then click function wizard 
5.Choose any function, for example ABS, then click "Next >>" button. 
6.Click "Select" button right at Number textbox 
7.Choose a range in Sheet1 

Actual Results: 
In select Dialog, show "$Sheet1.A1:A19" 

Expected Results: 
In select Dialog, show "$#REF!.A1:Sheet1.A19"

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171122/80c95696/attachment.html>


More information about the Libreoffice-bugs mailing list