a bug? #NAME? when "Use English function names" is enabled

goosepirate / lox365

⚗️ Lox365: XLOOKUP for LibreOffice

GNU General Public License v3.0

87 stars 5 forks source link

a bug? #NAME? when "Use English function names" is enabled #7

Closed githubuser181226 closed 1 year ago

githubuser181226 commented 1 year ago

Hi.

I've found a bug.

I've installed this wonderful extension today, but when I enable "Use English function names" in Calc settings (which I really need) every lox365 function stops working and gives out #NAME? error.

Please, advise.

Edit. Found a bypass but suboptimal: added COM.GOOSEPIRATE.LOX365.OXT. before every function name ie. COM.GOOSEPIRATE.LOX365.OXT.XLOOKUP and all is well even if "Use English function names" is activated. it is suboptimal, though.

goosepirate commented 1 year ago

Lox365 already uses English function names, so this sounds like it could be an issue with Calc. Let me know if you figure out a better way to fix this.