xou/elixlsx

Formula FILTERXML could not be evaluated without an acceptance

adjivas opened this issue · 0 comments

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.
1

Graphically, it's can be regulated like a valid name with a manual acceptance of the formula.
2
3