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)
Version:
(earliest affected)
5.4.2.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
function wizard (36.42 KB, image/png)
2017-10-13 01:23 UTC, yanjingtao 		Details
Spreadsheet name get #REF (127.54 KB, image/png)
2017-10-13 03:30 UTC, Aschalew 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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 
Description:
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:
版本：5.4.2.2 (x64)
Build ID：22b09f6418e8c2d508a9eaf86b2399209b0990f4
CPU 线程：8; 操作系统：Windows 6.19; UI 渲染：默认; 
区域语言：zh-CN (zh_CN); Calc: single

Version: 5.4.2.2
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

Reproduce;

Windows 10(x64)

LibreOffice:
    Version: 5.4.2.2 (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
Version: 6.0.0.0.alpha0+
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 ***