Build 5.0.0.47 of xlsgen fixes a problem related to updating special named ranges, such as the print area of a worksheet, when rows or columns are inserted or added. Before the fix, xlsgen would leave the special named ranges unchanged. Now xlsgen ensures that named ranges are updated accordingly.

Build 5.0.0.46 of xlsgen adds support for a third-party tool generating Excel files that in turn xlsgen is supposed to read. Since Excel can, xlsgen sure must as well !

Build 5.0.0.45 of xlsgen fixes a buffer overrun case that could occur when processing long-format date/time during the loading or writing of XLSX/XLSB files. It would cause xlsgen to crash.

Build 5.0.0.44 of xlsgen improves the compatibility of Excel files generated by xlsgen and consumed by Python-based libraries such as Pandas.

Before this build, reading an XLSX/XLSM Excel files generated by xlsgen with a Pandas script would generate the following kind of error :

TypeError: CellStyle.__init__() got an unexpected keyword argument 'id'

With xlsgen 5.0.0.44 this is no longer the case.

Build 5.0.0.43 of xlsgen is a security update. xlsgen uses an updated version of zlib (1.3.1) to avoid known vulnerabilities existing in prior versions.

Build 5.0.0.42 of xlsgen has a fix for the rendering of pivot tables. Under certain circumstances the rendering may overflow the target area where the pivot table is supposed to live.

Build 5.0.0.41 of xlsgen fixes a problem related to importing large CSV files where the tab character is used as a field separator.

Before this build, xlsgen would filter out tab characters in headers and unintentionally removing actual field separators, causing misalignment in the imported data.

Build 5.0.0.40 of xlsgen improves HTML data import by searching for data within a different HTML markup pattern, in addition to the existing one.

Before this build, xlsgen searches for data in table tr/td markup. Now it tries to search for data in this HTML pattern, and if it can't find anything, tries to search within hierarchical HTML div sections, which are more used nowadays than regular tables.

Build 5.0.0.39 of xlsgen adds a new capability in the CSV data import, where the input data is layed out vertically i.e. in rows, as opposed to columns.

Here is a capture of the input data, i.e. the first actual row of data is made of (A1, B1, C1), then (A2, B2, C2), then ...


Importing transposed CSV data (above), into regular sheet data (below)


And then after instructing the xlsgen CSV import engine that the data is layed out this way :

worksheet.Import.CSV.Options.DataInRows = 3;

Build 5.0.0.38 of xlsgen improves outlines (cell grouping) in a number of ways :

- in worksheet Duplicate scenarios, under certain circumstances, existing outlines were not carried over

- in XLSB files, outline levels were not properly written back to the file

- exposure of outline level in Rows or Columns :

enumOutlineLevel level = worksheet.Rows("12:12").Outline; // returns the outline level of row 12

enumOutlineLevel level = worksheet.Rows("12:15").Outline; // returns the max outline level in rows 12 to 15

Build 5.0.0.37 of xlsgen fixes the support for external references in xlsgen, by loosening how Excel file references with the same short name, stored in different folders, can coexist within the same Excel file.

Build 5.0.0.36 of xlsgen improves the processing speed of fairly large pivot tables using all kinds of sort orderings. The processing time is reduced by an order of magnitude.

Build 5.0.0.35 of xlsgen introduces improved comments. When an author name is specified, it is automatically added to the comment itself, in bold. Before this build, this had to be done by specific code using rich labels (i.e. text with formatting runs).

Here is how it works (C++) :

	xlsgen::IXlsCommentPtr comment11 = worksheet->NewComment(3,2);
        comment11->Author = L"stef";
        comment11->Label = "my comment";
        comment11->Translucid = TRUE;
        comment11->Location(6,5,13,8);

Author name added to comments

Just if you thought the current climate around selling software online was bad, just take a look at this alone, appeared today (july 2024) :

extrait : "Google Chrome will soon throw security warnings at you that you cannot ignore. (...) Whether this new barrier to downloading dangerous files will reduce the number of malicious downloads remains to be seen. It is surely adding complexity to the process and it feels strange that users have to select a reason for wanting to download the file, especially since all lead to the desired result."

extrait : "SAP 2nd quarter 2024 financial results : Software licenses revenue decreased by 28% to €0.2 billion and was down 27% at constant currencies. Cloud and software revenue
was up 10% to €7.17 billion and up 10% at constant currencies. Services revenue was up 6% to €1.11 billion and up 6% at constant
currencies. Total revenue was up 10% to €8.29 billion and up 10% at constant currencies."

Google's chrome is making it harder every year to download software from a website, arbitrarily scoring your software. And SAP, EU's largest software developer, is seeing very deep reduction of software license sales, telling software licensing vendors out there that this is probably time to consider a different career going forward.

It's all written on the wall !! Take notice !!!

And of course, none of this was supposed to happen. It's just the annoyance of a few major companies (Google and Microsoft) making it virtually impossible for a vendor to have their software download and installed by a potential customer.

When it's not Microsoft, it's Google, both are US companies by the way :

extrait : "This link will no longer work in the near future

goo.gl links will no longer function after August 25th, 2025. Visit out blog post for more information about the goo.gl links shutdown."

Google crawler punishes 404 links in websites as long as it's someone other than them. Now Google is going to become the biggest 404 link generator worldwide comes august 2025. Congratulations Google, you've proven that you actually can not be trusted.

extrait : "Major Windows BSOD issue takes banks, airlines, and broadcasters offline / A faulty update from cybersecurity provider CrowdStrike is responsible for the global outage."

Again and again, single point of failure, maximum exposure to crashes.

Why are those guys out there using Windows in the first place ? What is the benefit of using such a bad OS ? Better yet, why are not those guys liable to their customers for using such a crooked OS ? Bring Microsoft to their knees, guys ! it's time !!

extrait : "Google Search will stop its continuous scroll user experience where Google loads more results as you scroll past the first page of the search results. Instead, you will see see the classic and old pagination bar at the footer of the Google Search results."

...and with infinite scrolling everyone could see that Google results were mostly random beyond the third result. These days, Google has a hard time searching for what you are looking for, except if we are talking about finding an entry in directories (think Yahoo 20 years ago). Google has effectively lost its way and no AI will improve it.

The topic of this post is : Fixing hidden Thunderbird emails.

If all of a sudden an entire hive of emails are hidden to you when using Mozilla Thunderbird, perhaps it's because they are internally marked as deleted even though you did no such thing. Fortunately, this is a situation that can be fixed with a proper... text editor !

First of all a little bit of context. In Thunderbird, mails for each account are stored on a per file per folder basis. In other words, your inbox is stored in a single file, whose name is the name of the folder and you can find those folders in your personal Windows files here : c:/users/<username>/AppData/Roaming/Thunderbird/Profiles/<profile_name>/

If your account is served by a POP mail account, it's in the Mail sub-folder. ImapMail for an IMAP-based mail account. There you find an Inbox file, which is the collection of your inbox emails stored as plain-text. This plain-text is called the MBOX file format, and you'll find reference for MBOX with Google, complete with a lot of useless discussions out there. Being plain-text means you can fix a "corrupt" file, as long as you understand the header marking the beginning of an email, and marking further down the stream the end of the current email.

Each email comes with a header such as X-Mozilla-Status: 0009. Number 9 marks a deleted email. So it's easy to guess that the next thing to do, to unhide those emails is to find/replace all such occurence with X-Mozilla-Status: 0001.

Of course, if you've been accumulating emails for a while, chances are your Inbox file will be bigger than 1 GB, in fact possibly bigger than 10 GB. A lot of text editors can't edit this thing because they haven't been properly designed, so you won't open a large Inbox file with say Notepad or something equivalent. First you need a 64-bit version of it, in order to bypass the 2 GB per process limit, and you need a text editor which is designed to edit large files, possibly without loading the file in memory at all. UltraEdit, which comes with a 30-day trial, is such candidate for this. So fire it up off internet and soon you'll be editing large inbox files, only to find that next time Thunderbird is started, all your emails have reappeared and the problem is fixed !!

Build 5.0.0.34 of xlsgen follows the path of the previous build, this time fixing a scenario with defined names.

Build 5.0.0.33 of xlsgen fixes a problem related to undefined names in formulas. The fix updates formulas, when needed, even a part the specifies undefined names, that is defined names without an actual range associated to it. This is for XLSX files. XLS and XLSB formula bytecodes were already covering the scenario properly due to the bytecode nature of it.