Bug 89555 - automatic simple quote instead of double quote in conditional format
Summary: automatic simple quote instead of double quote in conditional format
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.7.2 release
Hardware: x86 (IA32) All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-22 09:42 UTC by Yves Duprat
Modified: 2015-03-03 18:34 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
picture to see the problem (48.89 KB, image/png)
2015-02-22 09:42 UTC, Yves Duprat
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yves Duprat 2015-02-22 09:42:57 UTC
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)
Comment 1 A (Andy) 2015-02-22 10:17:12 UTC
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?
Comment 2 Eike Rathke (retired, only occasionally showing up) 2015-03-03 18:33:22 UTC
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".