XEROF

 

xlsgen 4.0.0.61 : Trigonometric functions


Build 4.0.0.61 adds support for a number of math trigonometry functions in the calculation engine. The functions were already supported for read and write purposes. The list goes as follows :

ACOSHReturns the inverse hyperbolic cosine of a number
ACOTReturns the arccotangent of a number
ACOTHReturns the hyperbolic arccotangent of a number
ASINHReturns the inverse hyperbolic sine of a number
ATAN2Returns the arctangent from x- and y-coordinates
ATANHReturns the inverse hyperbolic tangent of a number
COSHReturns the hyperbolic cosine of a number
COTReturns the cotangent of an angle
COTHReturns the hyperbolic cotangent of a number
SINHReturns the hyperbolic sine of a number
TANHReturns the hyperbolic tangent of a number
PIReturns the value of PI


Posted on 05-December-2016 22:42 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

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

< December >
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)