XEROF

 

xlsgen 4.5.0.80 : Try parse formula


Build 4.5.0.80 of xlsgen adds support for testing the parsing of formulas. Typically, writing a formula in a cell or to an object returns an exception if there is a problem, but it does not tell what the problem is. This parsing error is specifically the purpose of the introduced TryParseFormula method available at the workbook level.


typedef enum
{
[helpstring("Formula parsing error, no error")] parseformula_noerror = 0,
[helpstring("Formula parsing error, syntax error")] parseformula_syntaxerror = 1,
[helpstring("Formula parsing error, out of memory")] parseformula_outofmemory = 2,
[helpstring("Formula parsing error, not enough parameters")] parseformula_notenoughparams = 3,
[helpstring("Formula parsing error, too many parameters")] parseformula_toomanyparams = 4,
[helpstring("Formula parsing error, impaired parenthesis")] parseformula_impairedparenthesis = 5,
[helpstring("Formula parsing error, impaired brace")] parseformula_impairedbrace = 6,
[helpstring("Formula parsing error, division by zero")] parseformula_divisionbyzero = 7,
[helpstring("Formula parsing error, function does not exist")] parseformula_functionnotexist = 8,
[helpstring("Formula parsing error, wrong argument separator")] parseformula_wrongargumentseparator = 9

} enumParseFormulaError;


It works like this :

C/C++ code

xlsgen::enumParseFormulaError error = workbook->TryParseFormula(L"=SUMXYZ(5;3;A2)"); // returns parseformula_functionnotexist because SUMXYZ() does not exist



Posted on 05-December-2019 23:19 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

xlsgen 4.5.0.79 : Fix pack


Build 4.5.0.79 of xlsgen is a fix pack. It has the following :

- pivot tables now use localized strings. For instance, "Grand Total" is no longer hardcoded. It follows the current formula language (which you can set from the corresponding property in the workbook object, and which is one of EN/FR/DE/IT/PO/ES).

- fixed an edge case in rendering cells when the content has multiple lines separated by carriage returns, but no room vertically to show everything and the wrap flag set to off. Excel in this case ignores carriage returns. This is what xlsgen does now.

Posted on 03-December-2019 14:41 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

xlsgen 4.5.0.78 : UI-related pivot table settings (II)


Build 4.5.0.78 xlsgen follows previous build (4.5.0.77) related to pivot table UI settings in Excel.

This build writes back the UI settings listed below, including existing pivot tables, i.e. pivot tables that were not created using xlsgen.

Also the automatic source code generator now generates the corresponding source code for those.

Pivot table UI settings (in Excel) :
- EnablePivotTableUI (yes/no) : when set to no, the entire user interface for manipulating pivot tables is hidden
- ShowDetails (yes/no) : when set to no, non-aggregate values do not appear
- EnableFieldListUI (yes/no) : when set to no, the field list view is hidden
- EnableFieldPropertiesUI (yes/no) : when set to no, field properties dialog does not appear (looks like a bug for the end user because Excel does not gray out the menu)
- ShowFieldHeaders (yes/no) : when set to no, hides field elements

And also, in pivot table data source options,
- RefreshEnabled (yes/no)

Posted on 02-December-2019 12:06 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

xlsgen 4.5.0.77 : UI-related pivot table settings


Build 4.5.0.77 of xlsgen adds a number of user interface properties to the object model, for pivot tables. Those properties affect the experience of viewing or working with pivot tables in Excel.

They are :

in pivot table options
- EnablePivotTableUI (yes/no) : when set to no, the entire user interface for manipulating pivot tables is hidden
- ShowDetails (yes/no) : when set to no, non-aggregate values do not appear
- EnableFieldListUI (yes/no) : when set to no, the field list view is hidden
- EnableFieldPropertiesUI (yes/no) : when set to no, field properties dialog does not appear (looks like a bug for the end user because Excel does not gray out the menu)
- ShowFieldHeaders (yes/no) : when set to no, hides field elements

And also, in pivot table data source options,
- RefreshEnabled (yes/no) : when set to no, makes it impossible for the user to refresh the data source associated to the pivot table

Posted on 28-November-2019 16:11 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

xlsgen 4.5.0.76 : Edit table ranges (II)


Build 4.5.0.76 of xlsgen follows previous build 4.5.0.75 and adds another table property, DataRange, in order to differentiate :

- data rows : DataRange property
- header + data + totals : Range property

Both are read and write properties.

Posted on 28-November-2019 16:04 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

xlsgen 4.5.0.75 : Edit table ranges


Build 4.5.0.75 of xlsgen allows to edit ranges of existing tables. This applies to XLSX (and their variants) and XLSB files.


To obtain the cell range,

C++ code


_bstr_t range = worksheet->Tables->ItemByName[L"Table1"]->DataSource->Range; // returns a cell range of the form RxCx:RyCy




To change it,

C++ code


worksheet->Tables->ItemByName[L"Table1"]->DataSource->Range = L"R1C1:R15C10";




Alternatively, if the scenario knows in advance that all it needs is to add a new row to the table,

C++ code


worksheet->Tables->ItemByName[L"Table1"]->DataSource->AddRow();



Posted on 28-November-2019 09:10 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

xlsgen 4.5.0.74 : Support for XMATCH/XLOOKUP functions



Build 4.5.0.74 of xlsgen adds read, write and calculation support for XMATCH() and XLOOKUP() functions.

Those functions have been recently introduced by Microsoft as part of Office 365 insider preview and they'll be made available with an Office 365 subscription in 2020. They will never be supported in any existing Excel version (2007/2010/2013/2016/2019).

xlsgen supports them right now.

XMATCH() and XLOOKUP() are, according to Microsoft, more powerful versions of MATCH() and LOOKUP() functions.

They are indeed more powerful in the sense that MATCH() has several lookup algorithms, it does not go only top to bottom. And XLOOKUP() is more powerful than traditional LOOKUP()/HLOOKUP()/VLOOKUP() functions in the sense that the same function supports looking up in all directions, also it has a "if not found" fallback parameter which can be set optionally, and finally the return range is arbitrarily set. In other words, XMATCH() and XLOOKUP() can replace complex combinations of simpler functions sometimes.

Syntax : (optional arguments are square braced)

XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])


match_mode is {0 = exact, 1 = lesser approximation, -1 = higher approximation, 2 = exact with wildcard characters}

search_mode is {1 = top-to-bottom search, -1 = bottom-to-top, 2 = half split top to bottom, -2 = half split bottom to top}

Posted on 17-November-2019 13:00 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

xlsgen 4.5.0.73 : Fix pack (III)


Build 4.5.0.73 of xlsgen fixes two problems related to rendering :

1) correct page margin inclusion (right edge)

2) in header/footer, any content in the center portion can span along the entire width of the page, excluding margins, not just the third of the width of the page, excluding margins.

Posted on 14-October-2019 12:02 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

PDF vulnerability : how amateur


According to Zdnet,

extrait : "New PDFex attack can exfiltrate data from encrypted PDF files. All the 27 desktop and web PDF viewer apps that were tested were found to be vulnerable in a way or another."


And here is the culprit, from my point of view (emphasis mine) :

extrait : "The research team says that an attacker can tamper with these unencrypted fields and create a booby-trapped PDF file that when decrypted and opened will attempt to send the file's content back to an attacker. (...) by adding a PDF form that auto-submits the PDF's content to an attacker's server when the victim decrypts and opens an encrypted PDF;"


A form control that auto-submits itself, how does that even pass through review in all PDF viewers out there? And how on earth is it possible that auto-submitting a form isn't disabled by default ?

Just overnight, all those PDF viewers have become a liability to every (corporate or no) user on the planet. I hope someone sues their ass off because such an auto-submit behavior was and is irresponsible.

Posted on 08-October-2019 11:16 | Category: News | comment[0] | trackback[0]

 

xlsgen 4.5.0.72 : Fix pack (II)


Build 4.5.0.72 of xlsgen includes a number of fixes :

1) better handle fitToWidth and fitToTall page setup settings from XLSX files

2) improved fit-to-page algorithm when either fitToWidth or fitToTall is unspecified

3) localize PDF bookmarks in the PDF bookmarks bar by taking into account the current formula language

4) improved position of pictures when rendering pages with repeat columns or rows

5) avoid picture duplicates in XLSX and XLSB files (and their variants, XLSM, XLST, ...)

6) merged cells pre-write for rendering needs

Posted on 08-October-2019 00:10 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

xlsgen 4.5.0.71 : Fix pack


Build 4.5.0.71 of xlsgen is a pack of 2 fixes.

1) Support for the variant of =CEILING(number, significance) function introduced by Microsoft in Excel 2013. A silent behavorial change was introduced which allows the number to be negative while the significative to remain positive in order to ask for the rounding be the smallest integer instead of highest integer.

2) More fixing of internal shared formulas in cell manipulation scenarios.

Posted on 02-October-2019 00:49 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

xlsgen 4.5.0.70 : Querying objects by name


Build 4.5.0.70 of xlsgen adds object name setting and querying. This applies to shapes, pictures, text boxes, vector shapes and charts.

In Excel, object names appear in the same list than defined named, even though technically speaking they are not because they have no formula attached to it. Some of those names can be edited using the corresponding ribbon name field.

Querying a known name is a convenient method for getting an object and doing something with it, such as calculating depending formulas, rendering it and so on. Querying a known name in xlsgen is achieved by first getting the objects collection in question (for instance the charts collection for the current worksheet) and then use the ItemByName property to obtain the object by just passing the name as argument.

In xlsgen, when new objects such as shapes, pictures, text boxes, vector shapes and charts are created, they have no name by default. You can add one by just using the Name property which is a read/write property.

This works with all Excel file types.

Posted on 29-September-2019 10:22 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

Unexcusable YouTube submission to power


When you know that YouTube makes a statement like this,

extrait : "YouTube will remove content from politicians using its platform if their content violates the company’s guidelines, but some exceptions can be made if the videos have enough educational, news, scientific or artistic value."


you know that something is wrong, very wrong.

That YouTube does not bring a despicable video in their top search results or even in the automatically played or recommended videos, I see no problem with it, because the video is still there for anyone to find and see.

But that YouTube removes any video, on what grounds are they judiciary parts ? Of course YouTube, by behaving like this, will represent the bad will of political and religious militants, not the interest of the general public. This has profound implications for freedom of expression. Remember, video is not like text. You can put up a computer online and a blog, and put your text there. It's all yours period. But video is hard to host because of the bandwidth it demands to cast over more than one person at a time. So YouTube is always one of the defacto destinations for hosting videos due to technical difficulties of doing it yourself. This is the reason why YouTube should not have a say, especially made worse because this say is on behalf of militants most of the time, and just host the video and that's it.

If that isn't the case, then YouTube should make that clear in every page of the site that the videos they host are videos they enfully endorsed. Again, this has deep judicial implications and also questions the freedom of expression. Perhaps, after all, YouTube isn't the place you are looking for.

Posted on 27-September-2019 12:11 | Category: anti-Google | comment[0] | trackback[0]

 

xlsgen 4.5.0.69 : Improved page order print/rendering


Build 4.5.0.69 of xlsgen improves the page order algorithm in print/preview/PDF/XPS scenarios.

Prior to this build, pages would be rendered by xlsgen in a top-down then left-right algorithm with no API available to change that.

The page setup object has a new property, PageNumberLeftToRight, which when set to TRUE does the opposite, i.e. pages are rendered in a left-right then top-down algorithm.

Posted on 24-September-2019 20:37 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

xlsgen 4.5.0.68 : Fix pack (III)


Build 4.5.0.68 of xlsgen has 6 fixes :

1) fix picture duplication for XLS files (mso drawing solver container records correctly placed)

2) migrate form controls from XLS files to XLSX/XLSB files

3) migrate shape arrows properly from XLS files to XLSB/XLSB files

4) automatic source code generator exposes more accurate column width (floating point values)

5) sparkline rendering of "same min and max property for all sparklines" in XLSX/XLSB files

6) translation of formula error codes such as #VALUE! in the 6 formula languages (english, french, german, spanish, italian and portuguese). So #NAME? appears as #¿NOMBRE? in spanish, #VALUE! appears as #WERT! in german, and so on. Don't forget to set the formula language before processing a formula (reading or writing) with the workbook FormulaLanguage property.

Posted on 24-September-2019 20:33 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

xlsgen 4.5.0.67 : Fix pack (II)


Build 4.5.0.67 of xlsgen has two fixes :

1) case of formula corruption on row manipulation (insertion/deletion)

2) range selection allows max column and max row of current worksheet

Posted on 20-September-2019 10:36 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

AI is crap and then...


extrait : "But first they had to rebuild it, and their design, for reasons unknown, was falling short of its promised results. Until, that is, the students tried some “creative manipulations” that didn’t appear in the other lab’s paper."


So-called AI is entirely empirical. It's not hard and demonstrative science (like maths for instance). In other words, just crap. If you hear the word "A.I.", just move on.

Posted on 17-September-2019 22:52 | Category: News | comment[0] | trackback[0]

 

xlsgen 4.5.0.66 : Fix pack


Build 4.5.0.66 of xlsgen is a fix pack.

1) incorrect sparklines minimum and maximum axis options handling for XLSX files

2) incorrect picture migration from XLS to XLSX or XLSB files, related to changing the sign of internal offsets

Posted on 14-September-2019 11:03 | Category: xlsgen, Excel generator | comment[0] | trackback[0]

 

Keynote Apple : un gros gag quand même


Keynote Apple : un gros gag quand même. Peu ou pas d'annonce invention qui justifie de changer d'appareil. A quoi bon faire un keynote quand il n'y a pas de substance ?

Posted on 11-September-2019 13:44 | Category: France | comment[0] | trackback[0]

 

L'iPhone et son absence de zoom optique


L'iPhone, 12 ans après sa sortie, Apple s'apprète à annoncer un upgrade de la fonction caméra avec un (petit) zoom optique. 12 ans d'attente pour une fonction qui aurait pu être mise d'emblée pour éviter que tous ces gens qui font des photos avec soient ridicules.

Posted on 09-September-2019 09:07 | Category: France | comment[0] | trackback[0]

 

 

<-- previous page

< November >
0102030405
0607080910
1112131415
1617181920
2122232425
2627282930



 

 

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)