Bug 113086 - Function Wizard select range in other sheet get #REF!
Summary: Function Wizard select range in other sheet get #REF!
Status: RESOLVED DUPLICATE of bug 72440
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2017-10-13 01:21 UTC by yanjingtao
Modified: 2017-10-14 14:01 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

function wizard (36.42 KB, image/png)
2017-10-13 01:23 UTC, yanjingtao
Spreadsheet name get #REF (127.54 KB, image/png)
2017-10-13 03:30 UTC, Aschalew

Note You need to log in before you can comment on or make changes to this bug.
Description yanjingtao 2017-10-13 01:21:16 UTC
Sheet name get #REF! if I select other sheet range in function wizard

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"

Reproducible: Always

User Profile Reset: Yes

Additional Info:
I have tested in:
版本: (x64)
Build ID:22b09f6418e8c2d508a9eaf86b2399209b0990f4
CPU 线程:8; 操作系统:Windows 6.19; UI 渲染:默认; 
区域语言:zh-CN (zh_CN); Calc: single

Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4
CPU threads: 4; OS: Linux 3.10; UI render: default; VCL: gtk2; 
Locale: zh-CN (zh_CN.utf8); Calc: group

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:56.0) Gecko/20100101 Firefox/56.0
Comment 1 yanjingtao 2017-10-13 01:23:24 UTC
Created attachment 136941 [details]
function wizard
Comment 2 Aschalew 2017-10-13 03:30:54 UTC
Created attachment 136943 [details]
Spreadsheet name get #REF


Windows 10(x64)

    Version: (x64)
    Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4
    CPU threads: 8; OS: Windows 6.19; UI render: default; 
    Locale: en-US (en_US); Calc: group

I have tried according the steps mentioned above, but it reproduce the same thing for me too!
Comment 3 Xavier Van Wijmeersch 2017-10-13 07:21:07 UTC
Can this be the same as bug72440 ??? anyone
Comment 4 Xavier Van Wijmeersch 2017-10-13 07:22:18 UTC
I have this seen to  with
Build ID: fbfe55e58c4b14f86cbb2c7b822f727e5b2e4a66
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 5 Jacques Guilleron 2017-10-14 14:01:31 UTC
Hi all,

I Confirm this report is a duplicate of
Bug 72440 - Vlookup issues with wizard
Thank you very much for the report.

*** This bug has been marked as a duplicate of bug 72440 ***