En Grèce, la télévision publique a été coupée du jour au lendemain.

Vue l'absence totale d'information et d'émissions de qualité sur les chaînes publiques de la télévision française, je ne serais pas contre que France Televisions cesse d'emettre du jour au lendemain.

Bonus : fin du rackett de la redevance.

Build 3.0.0.98 of xlsgen makes it possible to create scenarios in Excel. This works with XLS and XLSX files.


Scenarios in Excel (and now in xlsgen)

Scenarios differ significantly over what-if tables in the sense that what-if tables are designed to test changes in formula values when one or more of its parameter are tested against other values expressed in a table, whereas scenarios input values are cells, and resulting values are not expressed in a table.

(VB code follows)

worksheet.Number(2,3) = 1
worksheet.Number(3,3) = 10
worksheet.Number(4,3) = 100

worksheet.Formula(8,3) = "=SUM(C2:C4)"

' one scenario
Dim s1 As IXlsScenario
Set s1 = worksheet.NewScenario
s1.ScenarioName = "scenario 1"
s1.ScenarioComment = "my scenario!"
s1.ScenarioResultCellsRange = "C8:E8"

' one input value to be tested
Dim sv1 As IXlsScenarioValue
Set sv1 = s1.ScenarioAddValue()
sv1.ScenarioValueRow = 3
sv1.ScenarioValueColumn = 3
sv1.ScenarioValueAsFloat = 20 ' replace 10 with 20 (in the scenario only)

Build 3.0.0.97 of xlsgen adds another improvement to the formatting of floating-point values (formatting occurs when you are doing a rendering, or calling the FormattedLabel() method). Thousands separators were systematically padded, for instance a value such as 24256,8 would be formatted as "24 256,8" (or "24,256.8" depending on your locale) even in cases when the number format associated to the cell would not specify thousands separators.

Beginning with this build, only number formats which explicitely specify thousands separators will cause formatting such as "24 256,8". Otherwise the formatting will be "24256,8".

Build 3.0.0.96 of xlsgen does not create PDF or XPS pages for hidden sheets. The scenario is PDF and XPS workbook-level generation where all the sheets are exported in the same output file (and presented in the table of contents as such). Beginning with this build, xlsgen won't export sheets that are marked hidden (or very hidden which is a special value in the Excel file format).