XEROF

 

xlsgen 3.0 build #24 : Text-based conditional formattings


Build 3.0.0.24 of xlsgen adds 4 predefined conditional formattings to XLS and XLSX files.

These are text-based conditional formattings, i.e. conditional formattings which highlight cells based on a rule governed by a text condition.

The 4 text conditions are :
- beginningWith
- endingWith
- containing
- notContaining

Internally, the 4 predefined conditional formattings are replaced by Excel formulas and stored in XLS and XLSX files as such.

Here is an example :

xlsgen::IXlsConditionalFormattingPtr cf = wksht->NewRange(L"R2C1:R10C1")->NewConditionalFormatting();
cf->PredefinedCondition->BeginsWith(L"apple");
cf->Style = style2;


Posted on 21-March-2012 10:46 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

 

<-- previous page

< March >
0102030405
0607080910
1112131415
1617181920
2122232425
2627282930
31



Products I distribute :

xlsgen - native Excel generator


xlsgen - business intelligence


Excel formatting style reduction tool


wz - Encrypt/Decrypt tool. Free speech at its best.

 

 

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)

 

Je soutiens :