Summary: | compatibility options for older spreadsheets ... | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Michael Meeks <michael.meeks> |
Component: | Calc | Assignee: | Kohei Yoshida <kohei> |
Status: | RESOLVED FIXED | ||
Severity: | major | CC: | james, LibreOffice, michael.meeks, ml.freedesktopbugzilla, nerd, phiphi, whisperteresa |
Priority: | medium | ||
Version: | unspecified | ||
Hardware: | Other | ||
OS: | All | ||
Whiteboard: | target:4.0 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 37860, 50345 | ||
Attachments: | new configuration option to toggle this behavior. |
Description
Michael Meeks
2012-01-12 06:18:55 UTC
Please do not add non-development related comments to this bug that are not based on the coding interactions :-) *** Bug 37860 has been marked as a duplicate of this bug. *** Removed EASYHACK from summary I'll look into this for 3.7. No longer an easy hack. Created attachment 64581 [details]
new configuration option to toggle this behavior.
This is now implemented on master (for 3.7). *** Bug 50345 has been marked as a duplicate of this bug. *** @Kohei Yoshida: Can you please tell me where the configuration option shown in screenshot can be found? It seems that most spreadsheet sw is missing a proper way to condtionally set an empty cell. Why not create an empty() function to be used like: if(cond,result,empty()) I guess traditionally we use if(cond,result,"") to do this today, but the use of an empty string as empty cell has unexplored consequences. Of course any function with empty() as argument, should return as if the argument cell was deleted/untouched. (In reply to comment #9) > @Kohei Yoshida: > Can you please tell me where the configuration option shown in screenshot > can be found? It's in Tools-Options-Calc-Formula, and set the detailed calculation settings to 'Custom', then click on Details (or similar). I may not be totally accurate as I don't have a build I can use at the moment... FYI, the OpenFormula specification already has ISBLANK(), which tells you if a given cell is blank or not (and empty strings do NOT count as a blank). LibreOffice 3.5.6.2 (at least) already implements ISBLANK(), too. So I think what some commenters wanted is already available. (In reply to comment #12) > FYI, the OpenFormula specification already has ISBLANK(), which tells you if > a given cell is blank or not (and empty strings do NOT count as a blank). > LibreOffice 3.5.6.2 (at least) already implements ISBLANK(), too. So I > think what some commenters wanted is already available. I'm aware of that, but that is not what I asked for. My request is a function to return the equivalent of an empty cell. Now we are forced to use "" to set [conditional] empty cell and that causes issues, because its not really an empty cell, but an empty string. |