[Libreoffice-bugs] [Bug 116691] New: Assistant does not reference properly the sheet

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Mar 29 13:27:33 UTC 2018


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

            Bug ID: 116691
           Summary: Assistant does not reference properly the sheet
           Product: LibreOffice
           Version: 5.4.1.1 rc
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: hug.charlotte at gmail.com

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

-- 
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/20180329/44d2d0b7/attachment.html>


More information about the Libreoffice-bugs mailing list