Axolot Data

I'd like to revisit this post of mine, for clarity: As mentioned, the last change (CompileFormulas+CalculateAndVerify) makes sure that the EU service accepts the calculated cells. But as it turns out that change also makes Excel complain that the file is corrupt. The problem was probably something r...

Thanks, Lars, for replying to my email.

It all turned out to be about formula calculation.
The following 2 lines before saving the file, fixed it:
::tor

These are the error message from the EU service, all very application specifi: 'Title of the project' - Compulsory field. Maximum length is 500 characters. 'Objectives of the project' - Compulsory field. Maximum length is 2500 characters. 'Potential benefits likely to derive from this project' - Com...

I'm producing an xlsx file that will be imported into an EU service. The problem is that the receiving service outputs a number of error messages about missing values. The values are not missing, and after I open the xlsx in Excel, and then save it again from there, it is imported without problems. ...

The worst is that after installation the Src\obj folder is missing it subfolder x64, for compiling Win64. I see that the Win32 obj files are binary identical to the ones in v5. Can I just copy over the x64 subfolder from v5 into v6? Besides, when installing I get an error saying the installer cannot...

Thanks a lot! Worked like a charm.

When I try to import a csv file with the following line in it (anonymised), the second cell is picked up as a date. That happens in ImportCSVInt, in the last check before defaulting to a text field. SysUtils.TryStrToDateTime is used to check if we have a datetime cell, but TryStrToDateTime skips any...

The code in the for loop stretches beyond the length of the string: for i := 1 to Length(Result) - 1 do begin if (Result[i] = '&') and (Result[i + 1] = '#') and ((Length(Result) - i) >= 3) then begin I changed it to the following, and got rid of an error that occurred when importing mhtml xls fi...

In XLSRow5 there is a comment to check for the IDE accidentally adding an FXF field to the TXLSRow class.

In my copy of 5.10.17 it looks like that has happened to the TXLSColumn object, causing an AV in TXLSFormattedObj.IsFormatted.
Is that right, or did I misunderstand?

Yes, it looked like it would be hard. So I took a more manual approach, and ended up with two routines that gave the desired result. EDIT: Or, actually I'm having AV trouble in the real app (not the test app). Looks like BeginEdit/EndEdit does not function like the usual BeginUpdate/EndUpdate, so I ...

In XLSReadWriteII v4 I used TXLSColumn.Assign() to copy column formatting from a format sheet to the target sheet. In v5 the TXLSColumn doesn't have any Assign method. What is the best way to copy column formatting? Can I do it using TXc12Column and TXLSColumns.CopyHitList somehow? Looks like some o...