[Libreoffice-bugs] [Bug 39917] Cells are erroneously marked bad after find/replace

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=39917

--- Comment #2 from James <freedesktop at products.fastmail.fm> 2011-08-08 04:13:58 PDT ---
I don't believe R1C1 syntax is important. However, I see now that R1C1 is what
triggers the problem.

If you're using A1 syntax, and a cell contains the formula "=B1", a Find &
Replace of B1->c1 (note lowercase) doesn't produce a bad formula. LO correctly
treats the replaced formula of "=c1" as if it were newly entered, creating the
formula "=C1".

If you're using R1C1 the formula "=RC[1]" gets the aforementioned error if you
substitute RC->rc (just like the previously reported substitution). Rather than
treating "=rc[1]" as a newly entered formula, LO treats it as a bad cell
reference. If it were treated as A1 syntax is treated that error wouldn't
happen, the formula parser would turn "=rc[1]" into "=RC[1]", which is a good
cell reference.

Bug 39915 is unrelated to this bug.

I didn't see any regular expression hints, so far as I know regular expressions
have nothing to do with this bug (though I do have them turned on).

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.