https://bugs.documentfoundation.org/show_bug.cgi?id=162303
--- Comment #4 from [email protected] --- (In reply to Werner Tietz from comment #2) > Hallo > > you need to escape the braces in Q1 like "Gain \(Loss\) > > OR > > you need to choose one of the optiona **without** »regular Expession …« > > ⇒ Tools ⇒ Options ⇒ LO-Calc ⇒ calculate ⇒⇒ »Placeholders in Formulas«: …… > > > I would say »works as expected ⇒ not a bug« ?? Yes, that corrects the problem. Per my example, I would expect that a cell reference would be treated as a literal, not a regular expression. Alternatively, there should be some feedback warning the user that the function is being processed as a regular expression, as I had no way of knowing that the regular expression setting was causing the issue. I'm grateful that you intuitively knew that was it. -- You are receiving this mail because: You are the assignee for the bug.
