An Excel add-in is introduced in order to make it possible to search within Excel, by that is meant to use search features that are much more useful than the regular search in Excel. Most notably it includes search as you type and search with incorrectly worded keywords (i.e. missing letters, too many letters, swapped letters). The experience is immersive since results appear in the right hand pane within Excel. You can double-click a search result in order to navigate towards it. The navigation pane can be hidden and can reappear to avoid taking too much screen space all the time. There is a ribbon button to switch it.
Depending on the Excel version that you are using, the add-in may have to be enabled as a COM add-in. In our tests, it appear this is needed beginning with Excel 2013.



Search tool Excel add-in

Search as you type is introduced in the search tool as a feature. Searching as you type means that you see the search results before hitting enter and you can decide if more letters need to be entered in order to refine further those results. It's the equivalent of Google's search box drop down.

Of course the search tool does not perform such search before hitting enter if the file in question is too large, because it would imply a processing time deemed too long to make the user interface useable.

Search tool now includes a google-like search in that it can find words whether or not a couple of letters are missing, added or in the opposite order. This is very interesting because it reduces the time to actually find the content that matters to you, the content that matches your keywords.

search tool for Excel is released. It works on Windows.

This tool has unique features that are meant to accelerate your productivity for looking up things in Excel files :

- search in a single file or an entire folder with the same ease
- case sensitivity and wildcards (? and *)
- search in cells as well as other objects such as charts and shapes



Search tool for Excel

Build 4.5.0.57 of xlsgen has fix for XLSX files and their variants (XLSB, ...) related to better handling locally defined names. xlsgen makes sure, when it looks up an existing defined name, to take a preference for the local name, as opposed to either the global name or local names from different worksheets.

Build 4.5.0.56 of xlsgen has a fix for calculating TODAY() and NOW() functions. Beginning with this build, xlsgen uses the local time instead of the system time. The local time accounts for the timezone of the interactive user and is therefore what is expected most often in calculations.

Build 4.5.0.55 of xlsgen improves the import from CSV, XML, JSON and HTML files, by adding the ability to split columns.

Let's take an example of a data table including a person's name. This name often differentiates the first and last name in different columns, ie :


Data with first and last names in separate columns

But sometimes both are in the same column, separated by a special character, here a comma :


Data with both first and last names in the same column

In the latter case, xlsgen can import the data in separate columns. The mechanism is available for all import file formats, ie CSV, XML, JSON and HTML.

VB code

' import a CSV file, split Name column in two First name and Last name columns Dim wbk As xlsgen.IXlsWorkbook Set wbk = engine.New("ResultingFile.xlsx") Dim wksht As xlsgen.IXlsWorksheet Set wksht = wbk.AddWorksheet("Sheet1") Dim cs As xlsgen.IXlsImportColumnSplitter Set cs = wksht.Import.CSV.Options.ColumnSplitByName("Name") cs.SplitBySeparator = "," cs.AddColumn("First name") cs.AddColumn("Last name") wksht.Import.CSV.ImportFile ("datasource.csv")

Other than splitting based on a special character, the split can be based on a string length. For instance, if you know the data is made of 3 pieces of 10 characters each, you can set SplitByLength to 10.

Each split column can have its own style and number format. This is specified in the IXlsImportColumnSplit interface.

Les gros opérateurs annoncent les uns après les autres des services de cloud gaming, entendez par là un service permettant de jouer à distance en haute résolution avec des ordinateurs modestes, à la limite avec juste un navigateur web.

C'est une énorme supercherie.

Officiellement, la cible ce sont les gens qui n'ont pas les moyens d'avoir un ordinateur puissant capable de faire le rendu graphique haute résolution des jeux tout en préservant un niveau élevé de fréquence d'affichage (60 images par secondes minimum pour ne pas ressentir de freinage visible). La cible est donc les gens modestes.

De l'autre, pour pouvoir non pas faire du rendu haute résolution, mais le diffuser à l'utilisateur, il faut que l'utilisateur possède une connection type fibre. Hors, pour la plupart des gens sur la planète, la fibre n'est qu'un rêve, et par ailleurs ceux qui vivent au coeur des grandes métropoles et qui disposent éventuellement de la fibre optique sont ceux qui ont les moyens de s'acheter le fameux ordinateur puissant. Donc, précisément, pas la cible.

Par ailleurs, il y a un décalage dans l'évolution des prix des configurations PC chères car il est désormais possible de s'offrir pour moins de 300 euros une carte graphique surpuissante, pour équiper un PC modeste. Le cloud gaming se fait donc couper l'herbe sous le pied par les configs gaming pas chères.

Alors pourquoi ? pour deux raisons. La première, c'est que les gros opérateurs veulent s'insérer comme intermédiaire dans le plus de marchés possibles, en particulier dans ceux qui rapportent du fric, comme celui du jeu vidéo. Etre intermédiaire, quand on a les reins solides, ça veut dire à terme pouvoir dicter ses règles et son prix. Quand on s'appelle Google ou Amazon, ce n'est pas rien. On a vu ce que ça donne dans le e-commerce.

Et pour des gens comme Facebook, être intermédiaire de ce genre de choses, c'est pouvoir créer du data mining supplémentaire.

En réalité, au delà de la supercherie, au delà de l'aspect non genuine de ces annonces, il faut comprendre que ce dont ont besoin les joueurs aujourd'hui, ce sont de plus gros serveurs de match making notamment pour les battle royale qui est une niche multi-joueurs en devenir.
Et la dernière chose dont ont besoin les éditeurs de jeux vidéos, c'est d'avoir un intermédiaire qui se mette entre eux et les joueurs. Intermédiaire qui a des chances de rapidement venir prendre sa part de rémunération, alors que rien n'est plus intéressant et légitime qu'une relation la plus directe possible entre les éditeurs et les joueurs.

Sur le fond comme sur la forme, le cloud gaming est un non-sujet. Passez votre chemin.

Build 4.5.0.54 of xlsgen fixes a problem that was introduced by the previous build 4.5.0.53 related to the isolated server (xlsgen.exe). Late-binding programming languages (VBScript and JScript) were not working anymore because the type libraries used to marshall calls were not loaded prior or during the first call.

Il y a le business de facebook, que tout le monde connait. Et il y a l'autre, moins public.

Voilà en deux temps comment ça s'articule.

Une startup nommée SendBird crée un moyen d'intégrer un module de discussion en temps réel dans des applications. On se dit ce truc soit on le développe en interne, et ça prend 48 heures, ou alors on intègre quelque chose fait ailleurs pour un montant dérisoire.

La startup en question, qui devrait être dans l'incapacité de vivre tant ce bout de code a peu de valeur sur le plan technique, annonce néanmoins une énorme levée de fond, de pas moins de 52 millions de dollars.

Et là on se dit forcément, il y a anguille sous roche. Pourquoi des investisseurs mettent autant de fric dans un truc purement technique à la base, et qu'on pourrait trouver gratuitement d'ailleurs dans un projet open source quelconque ?

C'est que, on comprend par l'énormité de la somme, que ce n'est pas la technique qui est valorisée là. Evidemment que c'est les eye balls comme on dit pour ne pas dire l'historique des communications de tous les gens qui utilisent ce module de discussion sans rien suspecter sur ce qui en est fait derrière.

Et pour être bien sûr que les choses sont claires, qui trouve-t'on dans les investisseurs ? Un certain mark zuckerberg... Au moins les choses sont dites, mais je réprouve dans ces conditions la légitimité même de cette startup.

Ainsi, dans sa page "About", cette startup indique :

extrait : "As a company whose origin is in messaging solutions, we are beginning with messaging in text. But our mission is to bring the freedom, accessibility, and value that digitizing human interactions can offer to all people."

La liberté ? La liberté de se faire méthodiquement pister, oui c'est sûr...

Build 4.5.0.53 of xlsgen introduces a special mode, the keep mode, for the isolated server (xlsgen.exe).

When used, the keep mode avoids that the working process kills itself after the running engine instance is out of scope (the scope is under the control of the client application). This mode also enforces strict apartment related to COM object method call marshalling.

How to activate this mode ?

Just register the isolated server as a COM object using a command-line script, adding the /K option to it, as in :

<path>\xlsgen.exe /K /REGSERVER

Put this in a .BAT file, then right-click on it and choose Run as Administrator.

Upon registration, a message box appears to confirm completion.

Build 4.5.0.52 of xlsgen improves the import of all 4 input file formats namely CSV, XML, HTML and JSON.

When custom data mapping was introduced in build 4.5.0.4, meaning that you can pass a number format for any given column of data being imported, we said that chances are that we would, in the long run, end up having some kind of AI or intelligent automatic inference that would figure it the data it is importing, and would therefore infer the number format itself. That's what build 4.5.0.52 brings to the table. Not a single line of code is needed.

Let's say in the data you import, there is a "length" column with a number of kilometers to it, ie :

12 kms
15 kms
50 kms
75 kms
...

Since build 4.5.0.4, if you want this data to be imported as numbers and retain this "kms" suffix, you would pass it like this to the import engine : options.ColumnDataMappingFormatByName[L"length"] = "0 \"kms\"";

With build 4.5.0.52, this line of code is not needed anymore. It is magically inferred. And it works the same for all CSV, XML, HTML and JSON files.

Build 4.5.0.51 of xlsgen brings a number of improvements to all of the 4 input file formats, i.e. CSV, XML, HTML and JSON.

The improvements are :

- improved usage of # and 0 when automatically inferring the type and number format of data that appear to be numbers (integer or float)

- improved currency detection when automatically inferring the type and number format of data that appear to be currencies, that is, numbers with an accompanying currency symbol

- improved disambiguation of date, time and date+time when automatically inferring the type and number format of data that appear to be date or time related

- better import of different data types inside the same column


Overall, when you are importing a CSV file, an XML file, an HTML file or a JSON file, the automatic import engine works better at finding the actual data types and tries a lot inferring an appropriate number format, resulting in data that are imported correctly and are therefore ready for calculations and charting. Of course, any custom option that may be set before the Import statement takes precedence over what is automatically inferred, letting a client application really control how data is imported.

Ca ne trouble personne manifestement que les start-ups ont pour objectif de disrupter des business établis, des monopoles et qu'aucune start-up ne s'est réellement attaqué à ce marché vicié qu'est l'immobilier.

Ainsi l'excellent titre de l'article du New york times :

extrait : "A lot of tech startups have promising ideas to fix the housing crisis, but the fundamental problem of affordability seems beyond their reach"

J'ai ma petite idée sur la question. Et en tout cas, je pense que 99% des start-ups sont en réalité des pussy lorsqu'elles ne s'attaquent pas aux citadelles imprenables. Peut-être est-ce d'ailleurs une conséquence de la féminisation de la société. Qu'on ne me parle plus de start-ups, c'est pathétique.

Remember Google's motto, "index the world's information" ?

You can forget it now, Google is just censoring or deferencing, both equivalent to deleting, content it indexes based on undisclosed rules.

In fact, you can see quite clearly that someone owns Google. I am sure that will come as a surprise when so many (un)informed journalists out there tell you that Google owns you.

Someone informs Google, and Google isn't transparent about it.

More accurately, Google says so but you've got to read between the lines.

Take a look at their latest announcement regarding the censoring and deferencing of so-called questionable Youtube videos :

extrait : "Title : Continuing our work to improve recommendations

(...) We’ll begin reducing recommendations of borderline content and content that could misinform users in harmful ways—such as videos promoting a phony miracle cure for a serious illness, claiming the earth is flat, or making blatantly false claims about historic events like 9/11. (...) We think this change strikes a balance between maintaining a platform for free speech and living up to our responsibility to users. (...) This change relies on a combination of machine learning and real people. We work with human evaluators and experts from all over the United States

"

So, in a nutshell, responsability implies censoring and dereferencing content produced by others, content that is not illegal at all, and this is controlled by human evaluators. Oh and by the way, those people are from the United states only, just to be sure this makes sense...

If Google were transparent, as they claim they are, all censored and deferenced videos would 1) get listed on a page where everyone can see them listed with details to know why they were flagged 2) who flagged them and in particular who is the person behind the censorship and deferencing.

Of course Google will never do transparency on the subject. Why is because it is obvious everyone with a functioning brain would immediately understand who owns Google. And there would be a blood bath right after that.

Only respectable way out of this : a Googler stockpiles this list and makes it available publicly aftger a year or two, openly so that researchers can extract active censors, on what political/religious grounds properly owned content is censored and deferenced. In other words, why freedom of expression is so blatantly violated by a (possibly) small group of people with enormous power (none of these are Googlers by the way).

Build 4.5.0.50 of xlsgen adds support for calculating table formulas, that is, formula expressions including one or more table structured references, such as :

- Table1[Sales] // Sales column
- Table1[[Sales]:[Income]] // Column range : Sales, ..., Income
- Table1[[#Headers];[Sales]] // Header rows from the Sales column

Table formulas can appear anywhere : in cells, in objects (conditional formattings, ...), in defined names, ...

Build 4.5.0.49 of xlsgen takes into account the "hide zero cells" option which is supposed to show empty cells every time a cell stores a 0, entered as a zero or the result of a function. This impacts print, preview and PDF output.

Build 4.5.0.48 of xlsgen adds calculation support for Excel 365 functions related to the recently announced (by Microsoft) dynamic array functions, namely :

• =RANDARRAY([rows],[columns]) : returns an array of random numbers between 0 and 1.
• =SEQUENCE(rows,[columns],[start],[step]) : generates a list of sequential numbers in an array, such as 1, 2, 3, 4.
• =FILTER(array,include,[if_empty]) : filters a range of data based on criteria you define.
• =UNIQUE(array,[by_col],[occurs_once]) : returns a list of unique values in a list or range.
• =SORT(array,[sort_index],[sort_order],[by_col]) : sorts the contents of a range or array.
• =SORTBY(array, by_array1, [sort_order1], [[by_array2], [sort_order2]],…) : sorts the contents of a range or array based on the values in a corresponding range or array.
• =SINGLE(value) : returns a single value using logic known as implicit intersection.

This build follows build 4.5.0.44 in which read and write support for those functions was added.

Ventes privées : je le soupçonnais, c'est factuel désormais. Se méfier du concept de ventes privées, qui veut vous faire croire à un accès privilégié. Voici ce que dit la DGCCRF de cet accès privilégié :

extrait : "Il est reproché à l’entreprise d’avoir cherché à donner à ses clients l’illusion de faire une bonne affaire en mettant en place différentes stratégies frauduleuses visant à construire un 'prix de référence' fictif. En l’occurrence, des 'prix de référence' qui ne correspondaient dans les faits à aucune réalité économique étaient utilisés pour afficher des taux de promotion particulièrement attractifs"

C'est facile d'afficher des soldes à 40% et plus, lorsque le prix d'origine est fabriqué. Méfiance, les autres sites de e-commerce, l'étau se resserre...

Build 4.5.0.47 of xlsgen fixes a design problem in the calculation engine, namely the recursive calls to function calculations by reverse finding formula dependencies, reverse calculating them and putting them in the cache in order to avoid any additional recursion.