So you may be interPhilip Goodfellow wrote:
Andreas Saeger wrote:
=shSep --> "!" in Excel, "." (dot) in Calc
=xlEsc --> "~" in Excel, "" (empty string) in Calc
Change your formulae to COUNTIF (range,"A"& xlEsc &"*")
Thank you! Very useful work around which I will use on my own sheets in
future.
Still a pity the import filter doesn't do a suitable conversion though;
not all the sheets I use are actually "mine".
Philip
Just another one:
regexEnabled =ISNUMBER(SEARCH("^A";"ABC"))
xlEsc =IF(shSep="!";"~";IF(regexEnabled;"\";"")
xlAsterisk =IF(shSep="!";"*";IF(regexEnabled;".*";"")
The new xlEsc should work now with and without regexes in Calc.
xlAsterisk should translate wild card "*" to equivalent regex ".*". I
did not test xlAsterisk with Excel, but I think I have used this before
without getting complaints from the Excel user (can't find the old
document now).
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
