XEROF

 

xlsgen 3.5 build #11 : Fixes for the formula parser


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.

Posted on 16-January-2014 13:00 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

 

<-- previous page

< July >
0102030405
0607080910
1112131415
1617181920
2122232425
2627282930
31



 

 

This site
Home
Articles

DevTools
CPU-Z
EditPlus
ExplorerXP
Kill.exe
OllyDbg
DependencyWalker
Process Explorer
autoruns.exe
Araxis
COM Trace injection
CodeStats
NetBrute
FileMon/Regmon
BoundsChecker
AQTime profiler
Source monitor
GDI leaks tracking
Rootkit revealer
Rootkit removal
RunAsLimitedUser(1)
RunAsLimitedUser(2)

 

 

Liens
Le Plan B
Un jour à Paris
Meneame
Rezo.net (aggr)
Reseau voltaire
Cuba solidarity project
Le grand soir
L'autre journal
Le courrier suisse
L'Orient, le jour
Agoravox (aggr)