Build 3.5.0.11 of xlsgen introduces several fixes to the formula parser.
- more strict validation of defined names being inserted to an Excel file. The names are checked against additional invalid characters. Invalid characters include spaces and colons, to name a few.
- insertion of unknown names whenever applicable in formulas. Before this, the parsing of unknown names would abort and the entire formula would be lost. But Excel does not behave this way when it reads an existing file. So xlsgen mimics just that. If xlsgen encounters an unknown name, it creates a special entry for it internally (marked as for deletion, as in Excel), and the parsing carries on, meaning that such formulas are preserved as is. Before this build, a lost formula would have caused, as a result, the loss of the object attached to it, such as a data validation object, only because the missing formula would make it not valid. This is now a thing of the past.
- support for literal expressions such as #REF!:#REF!
- performance improvements : no longer detection of error tokens in the main parsing phase.