[Libreoffice-bugs] [Bug 123922] a cell with function is not evaluate properly

[bugzilla-daemon at bugs.documentfoundation.org]

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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de
         Resolution|---                         |NOTABUG
             Status|NEEDINFO                    |RESOLVED

--- Comment #3 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
it seems to work if you change the sheetname in the functions from
"calendar!D" to LO syntax "calendar.D"

D13:  =INDIRECT("calendar.D"&(C13+1))

E15:  =SUMIF(B18:B48;">0";C18:C48)+(SUMIF(B18:B48;">0";D18:D48))&"
      ("&INDIRECT("calendar.E"&(C13+1))&" jours ouvrés dans le mois)"

according to

https://help.libreoffice.org/6.1/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153181

> If you open an Excel spreadsheet that uses indirect addresses calculated from 
> string functions, the sheet addresses will not be translated automatically.
> For example, the Excel address in INDIRECT("filename!sheetname"&B1) is not
> converted into the Calc address in INDIRECT("filename.sheetname"&B1).

this is not a bug

-- 
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/20190308/eaab3053/attachment.html>