Bug 116691 - Assistant does not reference properly the sheet
Summary: Assistant does not reference properly the sheet
Status: RESOLVED DUPLICATE of bug 72440
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.1.1 rc
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-29 13:27 UTC by hug.charlotte@gmail.com
Modified: 2018-03-29 14:56 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 hug.charlotte@gmail.com 2018-03-29 13:27:33 UTC 
Description:
When using the functions assistant, NB.SI (in french, NB.IF ?), I want to reference columns in another sheet, instead of generating name.column:column, it generates #ref!.colum:name.column

Steps to Reproduce:
1. functions assistant
2.nb.si function (nb.if ?)
3.select colum in another sheet
4.#ref! appears instead of sheet name

Actual Results:  
1. functions assistant
2.nb.si function (nb.if ?)
3.select colum in another sheet
4.#ref! appears instead of sheet name

Expected Results:
#ref! appears instead of sheet name


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: fr
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes


User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:59.0) Gecko/20100101 Firefox/59.0
Comment 1 raal 2018-03-29 14:56:30 UTC 
Should be fixed. Please upgrade to actual version.

http://www.libreoffice.org/download/libreoffice-fresh/

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