RecalcForced

[Franc_BURDIAN]

Hello,



In the version 6.7.1 property TXlsFile.RecalcForced no longer exists. What is alternative for RecalcForced = False ?



TIA and best regards

Branko

[adrian]

Hi,

The reason we removed Recalcforced is that was doing nothing for some years already, as explained in http://www.tmssoftware.biz/flexcel/docs/vcl/whatsnew.htm

Here is the text:

Breaking Change: XlsFile.RecalcForced and FlexCelReport.RecalcForced properties have been removed. RecalcForced used a way to make files recalculate on open which has been deprecated in newer versions of Excel, and will cause validation errors with the generated files. For this reason, RecalcForced wasn't doing anything in the last couple of years.
Look at the new RecalcVersion property if you were using RecalcForced and want new not deprecated way to create files which Excel will recalculate on open.

So it depends in why you were using it. If you are not sure, just remove the line, it is very likely it was doing nothing anyway.
If you were using RecalcForced to avoid the dialog "Do you want to save changes?" when you open and close a file in Excel without changing anything, use RecalcVersion ( http://www.tmssoftware.biz/flexcel/hlp/vcl/index.htm?FlexCel.Core.TExcelFile.RecalcVersion.htm ) instead:

xls.RecalcVersion := TRecalcVersion.Excel2016;

This will of course prevent the files from being saved up to Excel 2016, when a new version comes up the dialog will too. This is just how Excel works.

[Franc_BURDIAN]

Thank you, Branko