Apache OpenOffice (AOO) Bugzilla – Issue 97639
RPT: More flexible output for Boolean values
Last modified: 2015-07-02 06:59:06 UTC
As well as TRUE/FALSE, users (well, I) need other forms of output: YES/NO, Y/N, T/F, Tick/Cross (symbols) and even filled-in check boxes would be very useful. If I could get formulae to work I could manage the text ones, but the automatic choice would be good.
I may have put the wrong version number into the heading - I'm using SRB 1.0.5 but that's not an option in the drop-down box.
send further to ocke (representing rpt i-team)
As from DEV300_m39 it is possible to you use the same AutoPilot which can be used from Calc. So it possible to do such things directly. Remember that parameter separator is semi colon. IF(booleanField ; "Yes" ; "NO" )
Feel free to reopen it again, if this doesn't fit to your idea. Thanks.
Thanks for this. It fits my idea and is fine for the moment. But I'd still suggest providing the standard defaults (will need internationalisation - I expect you'd prefer "J" und "N") automatically rather than asking us to learn how to write functions, and also provide a checkbox option. But I ran into another problem! The function syntax is very odd. It likes your syntax, but not IF(booleanField ;"Yes" ;"NO" ) - note the lack of a space before the parameters. And the field also has to be surrounded with [], which you forgot to remind me (I'm only a newbie here!). I can't say I'm happy with having to use semi-colons rather than commas as parameter separators - very rare in programming languages. I hope there's a good reason for it rather than a bad design choice.
So if you want to have a checkbox option. The parameter are defined in the ODF Formula specification http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula And here is the wiki entry: http://wiki.services.openoffice.org/wiki/Calc/ODFF_Implementation PS: I often use comas as well and wondering why it didn't work :-)
Thanks for the pointers. I'm not sure how the average Joe User (like me) is expected to know about these... But it does explain why the semi-colon is used as a parameter separator, which is useful and totally logical. I think that the wiki pages could be expanded here. I'd volunteer to help here, but I don't think I know enough about the subject to be suitably authoritative. (there are also a few places I've found in the wiki where the English could be slightly improved - I think the team are mostly German?)
Yes, you are right. The most developers from Sun are from Germany, Hamburg. And yes to expand the wiki pages would be of great help.
Ocke, I'm 100% occupied on another project at the moment and don't have time for my own work. But when things clear up (probably another month) I may be able to help. But, as I said, I don't think I know enough detail to write effective wiki pages, so in the end I may prove counter-productive.
*** Issue 105204 has been marked as a duplicate of this issue. ***