https://bugs.documentfoundation.org/show_bug.cgi?id=113086
Bug ID: 113086
Summary: Function Wizard select range in other sheet get #REF!
Product: LibreOffice
Version: 5.4.2.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: yanjing...@gmail.com
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
--
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