I just tried importing an XLS file (converted from an ODS I had been working on in IBM Lotus Symphony and LibreOffice), and I've run into two major limitations.
First, I have a bunch of SUMPRODUCT formulas, which had worked great, but here they all return 0. In the manual it says "Empty cells, text strings, and logical values evaluate as zero". All of my SUMPRODUCT formulas begin with two comparisons, for example:
The idea is to sum all the expenses (from another sheet) which are within a range of dates. But I suppose that PlanMaker takes the first two arguments as zero, so that this function fails to work as intended.
Does this interpretation seem accurate, and if so: 1. Is there an easy workaround; 2. Will logical values be supported in the future?
(I had previously used DSUM to accomplish a similar task, but I found that the SUMPRODUCT formulas were much simpler and more flexible, and they didn't require maintaining and referring to a sheet full of criteria.)
Second, I had simplified my spreadsheet by combining all expense categories and subcategories into one sheet, rather than having a sheet for each category. So my Expense sheet has a Category column and a Subcategory column. The first column uses Input Validation, with a static list of Categories. The second column uses Input Validation, with the list determined by a formula, which looks at which Category is selected, and based on that, selects the appropriate list of Subcategories. This formula looks something like this:
Unfortunately, in PlanMaker, the Subcategory dropdown doesn't work: clicking on the arrow does nothing. I suppose it doesn't understand the formula, but why not?