Collection with frequently asked questions and answers.
How long can strings be in cell storages?
If my Excel template contains a VBA macro, does this remain in Nooxl?
No, neither in Nooxl itself are macros executed, nor are macros contained in exports from Nooxl.
Both is not possible due to security risks.
The cell borders are not displayed in Nooxl as in Excel - why?
Nooxl renders the cells as a HTML table. A main attribute of those is that there is only one border at the point of contact between two cells.
When rendering, the assignment of borders to the cells is as follows:
These cell addresses are only valid if the visible range (tab) starts in A1!
For example, if it starts in C5, this is the cell with all 4 frames. Those with three borders are located in row 5 from column D, or in column D from row 6.
Borders are also rendered if no border has been set in Excel. It is then automatically rendered in the color which also applies to the background of the cell.
Attention, this does not apply to the right border of connected cells! This border is not rendered at all and therefore ALWAYS appears white.
This circumstance can lead to "staircase effects" at the intersections of borders:
With which precision are numbers stored in Nooxl?
The maximum precision in MS Excel is 15 digits (before and after the decimal point together).
Nooxl can store values with a maximum of 15 places before the decimal point plus a maximum of 14 places after the decimal point (before Nov. 2019 only 4 places after the decimal point).
Values greater than 1016-1 can only be stored in Nooxl with database adaptations (decimal [29,14]).