https://bugs.documentfoundation.org/show_bug.cgi?id=123922
Oliver Brinzing <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
Resolution|--- |NOTABUG
Status|NEEDINFO |RESOLVED
--- Comment #3 from Oliver Brinzing <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
