https://bugs.documentfoundation.org/show_bug.cgi?id=161271
--- Comment #8 from Robert Lacroix <[email protected]> --- In the meantime, if someone is keen to do it, ask MS Copilot to write a macro for Calc which converts these functions into REGEX, to allow you at least to load and run the Excel workbook in LO-Calc. You must be very specific about the syntax of REGEX, as Copilot will cheerily give you incorrect code. Depending on your skill, it can take frustratingly many iterations to goad Copilot into creating 100% correct code. However, you can just take what Copilot gives you after a couple of iterations as a pretty solid outline and fix up the details yourself in a fraction of the time. The result hopefully is a macro which converts these unrecognized functions after loading an Excel workbook into LO-Calc. The trip, however, is one-way. If you want to save this workbook and give it back to Excel you will need to convert REGEX back to Excel syntax, which won't be so easy. There can't be very much demand for the reverse trip, otherwise we would be seeing requests to convert LO-Calc workbooks into Excel. -- You are receiving this mail because: You are the assignee for the bug.
