Zum Hauptinhalt springen

FAQ

Frequently asked questions and answers.

How long can strings be in cell storages?​

Up to 4000 characters.

If my Excel template contains a VBA macro, does it run in Nooxl?​

No. Macros are neither executed in Nooxl Apps nor included in exports — both are disabled because of the security risk. For programmatic logic, use a cell action section instead.

Why are cell borders not displayed as in Excel?​

Nooxl Apps renders cells as an HTML table, where two adjacent cells share a single border. Borders are assigned like this (assuming the visible range/tab starts at A1):

  • A1: all four borders are rendered.
  • Row 1 from column B: all borders except the left.
  • Column A from row 2: all borders except the top.
  • All other cells: only the right and bottom borders.

Borders are rendered even if none was set in Excel — in that case they take the cell's background color.

warning

This does not apply to the right border of merged cells: it is not rendered and always appears white, which can cause "staircase effects" where borders meet.

With what precision are numbers stored?​

Excel's maximum precision is 15 digits in total. Nooxl Apps stores up to 15 digits before the decimal point plus up to 14 digits after it (before November 2019 only 4 after). Values greater than 10^16 − 1 require database adaptations (decimal [29,14]).