Others

This page summarizes other contents.

• How to install and upgrade the CELF runtime environment
• App performance
  • Calculation formulas placed on sheets should be minimal
  • Pay attention to other sheet references and action set calls
  • For registering, updating, and deleting a large number of records, use the 'Batch execution of data updates'
  • Set the Index
  • Use VLOOKUP when searching for specific values
  • Specify the cell range when performing the same process on consecutive cell ranges
  • Take time to aggregate or sort joined multiple tables
  • Format adjacent cells as uniformly as possible
• About automatic conversion of display format and value
• About automatic replacement of values compared to date/time type columns
  • Action to perform automatic replacement
  • Replacement contents
• Differences between CELF and Excel sheet specifications
  • Absolute reference cells after sorting by filter button
  • Numeric (floating point) precision
  • Handling of "February 29" (leap year) in 1900
  • Behavior of numbers with more than 16 significant digits
  • Operation when comparing a "number" with a "numeric string" using the comparison operator
  • Automatic update of cells that reference Cut ＆ Pasted cells
  • Behavior when the cell value specified as the function argument is blank
  • About spill and arrays
  • AVERAGEA function behavior
  • COUNTA function behavior
  • ISBLANK function behavior
  • SUBTOTAL function behavior
  • SUMIF function behavior
  • COUNTIF function behavior
  • MROUND function behavior
  • CEILING function behavior
  • FLOOR function behavior
  • TRIM function behavior
  • VLOOKUP function behavior
  • HLOOKUP function behavior
  • XLOOKUP function behavior
  • MATCH function behavior
  • ADDRESS function behavior