I’m using LO 5.1.2 on a Windows 7 machine. I have a number of spreadsheets that use wildcards in certain formulas and I am gradually converting old Excel workbooks to LO Calc workbooks as I begin new work and bring an old workbook forward as a foundation.
Two things have to occur each time I open an old Excel workbook and save it to LO Calc. First, I have to make sure Regular Expressions is checked in the Calc options. Second, I have to change formulas using the asterisk wildcard and precede the asterisk with a period – so for instance I have to change “S*” to “S.*” in all affected cells. Otherwise, the formulas containing the wildcards will not yield the correct results.
To me, this seems to be a compatibility issue that could and should be easily fixed – particularly if we want more Excel users to try LO Calc. Comments anyone? Is anyone listening at The Document Foundation?