Ask Your Question
0

Calc wildcards not compatible with Excel

asked 2016-06-23 23:34:40 +0200

LKeithJordan gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-06-24 00:01:21 +0200

Lupp gravatar image

Please refer to the 5.2 release notes.

(I personally am not so happy with the inflation of options. In addition regular expressions are a well introduced concept, by far not only concerning office software, for decades now. They should be preferred over a competing construct conceived in stubbornness and ...)

edit flag offensive delete link more

Comments

I agree about regular expressions, perhaps the option guides to a source of mistakes depending of the option used, but I think remember wildcards in 123 since 80's beginning.

m.a.riosv gravatar imagem.a.riosv ( 2016-06-25 15:26:38 +0200 )edit

Hi Lupp:

I had recently discovered that LO 5.2 fixed the wildcard problem. As I opened this post to update, I saw your advice. I am therefore giving you the point. Thanks for taking time to respond.

If anyone is listening at The Document Foundation, I would like to believe you read my post and responded by fixing the problem. That said, I hope you are now reading this update and will accept my thanks. As a long-time M$O power user, I now prefer LO to M$O and recommend it when appropriate.

LKeithJordan gravatar imageLKeithJordan ( 2017-03-15 19:24:15 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-06-23 23:34:40 +0200

Seen: 239 times

Last updated: Jun 24 '16