Formula FILTERXML could not be evaluated without an acceptance
adjivas opened this issue · 0 comments
adjivas commented
Hello,
For a code like:
alias Elixlsx.Sheet
alias Elixlsx.Workbook
sheet1 = Sheet.with_name("First")
|> Sheet.set_cell("A1", {:formula, "FILTERXML(A2,\"//price\")"})
|> Sheet.set_cell("A2",
"<?xml version=\"1.0\" encoding=\"UTF-8\"?><pricing><price>0.9</price></pricing>"
)
%Workbook{sheets: [sheet1]}
|> Elixlsx.write_to("example.xlsx")
The formula FILTERXML
is considered as an invalid name.
Graphically, it's can be regulated like a valid name with a manual acceptance of the formula.