XEROF

 

xlsgen 4.0.0.60 : Wildcards in database functions


Build 4.0.0.60 of xlsgen adds support for wildcards (*, ? and ~) in the following database functions in the calculation engine : DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP.

In other words, if you are using for instance a database function such as DSUM(A6:C10;"Sales";B1:B3), the criterias referenced in B1:B3 may use strings of the form Daliv*o which in turn will match strings in A6:C10 such as Dalivpo or Dalivio.

Posted on 05-December-2016 22:39 | 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)