xou/elixlsx

Formula different sheet cell

Opened this issue · 1 comments

Hello,

When I try to use a cell of another sheet:

{:formula, "$Deductions.I1"}

The result on the excel cell is the following: =$deductions.i1 and due to the lowercase is not working.

The Workbook seems fine ([formula: "$Deductions.I1", ...]), might be the write_to_memory.

Thank you!

I reproduce a #NAME? for formula sheet cell, it looks independent of the downcase or capitalize's name of the sheet.