You can see the web app, but the input cell remain empty? Calculations seem wrong? Here a checklist of common issues that result into malfunctioning apps.
- Remove all #REF, #DIV/O from the spreadsheet
- Check for number as text detection
- Numeric input cells should contain a default value
Why is it so important to pre-fill a numeric value with a default value (usually 0)? First, you have to know a few things:
- By default in Excel, an empty cell is considered to be a string,
- When you type something inside a cell, the spreadsheet software will dynamically update the type of the cell according to what you entered: a number, a date or a string,
- Once converter by Appizy, your web app will lose the capacity to update the input type. It is frozen.
The following mini-calculator is made with Appizy. All the explanations are in the paragraphs below.
The first example does work in Excel but not once converted. It is a basic addition of two cells, but the cells are left empty. In Excel, when you type something in the cell, the Software understands it is a number and get the addition correctly.
"1" + "2" = "12" rather than
1 + 2 = 3. You can also notice that the input is aligned on the left (like a string in Excel) rather than on the right (like a number).
In the second example, we provided a default value in both cells. In this case, Appizy converts the cells as a number and everything works as expected!
If you replay the first example with the SUM function instead of the “+” operator it works! What is the trick? Well, the SUM function as a built-in capacity to parse a string as a number. Knowing that the function is making a sum, it prevents error by converting
1. The output is correct even if the cells are strings (content is left-aligned).
We encourage you to fill all numeric input (displayed or hidden), with a default value. Appizy will understand: “This cell is a number”. If you don’t like all these 0 written everywhere make use of the Clear zero input setting in the panel Content and layout. It will remove the 0 but keep the numeric type. Check the Startup Capital sample for further experimentation.
Commonly used to check if a cell has been filled. Given the formula
=IF(ISBLANK(A1), "Blank", "Not blank") we recommend:
=IF(A1>=0, ..., ...)to check if a numeric value is filled,
=(A1<>", ..., ...)to check if a string value is filled.
The IFERROR function returns a custom value when a formula generates an error. This normally happens when the user input is wrong.