| Summary: | automatic simple quote instead of double quote in conditional format | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Yves Duprat <yvesduprat> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | CLOSED NOTABUG | ||
| Severity: | minor | CC: | ilmari.lauhakangas, markus.mohrhard, stgohi-lobugs |
| Priority: | medium | ||
| Version: | 4.2.7.2 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | picture to see the problem | ||
Reproducible with LO 4.4.0.3, Win 8.1. But I am not sure whether this is a real bug. Unfortunately, there is no help existing yet for this dialog, which could tell you how to use it. @Markus: Do you think that this quotation mark issue is a bug and if yes, could this maybe be something for you? It's not a bug, it's a feature ;-) The conditional value actually is a formula expression, in fact any valid expression can be entered, so entering oui there is the same as if =oui was entered, which does an automatic column/row label lookup (if not disabled and no named expression of the same name exists), which also ends up as ='oui'. To force a string you'll have to enter it with double quotes, "oui". |
Created attachment 113593 [details] picture to see the problem Hello ! i'm french so i try to explain but look at the attach pictures when i use the conditional format singles quotes are inserted on both sides of the value and it doesn't work, i must replace the single quote by double quote to see it work correctly (two hours to find it)