Axolot Data

Hi! I have a similar problem with excel 2013 when i add a string like "test_xflat_test.txt" to an excel file (leads to a corrupt excel file) and solved the problem with a simple regex. The main problem is that excel encodes strings with "_x + Hex value + _" (and only these string...

Thank you!

Thank you! But the fix seems not to be correct. I think % must be treated like this: %': begin if (StrToIntDef('$'+Copy(ALink,i + 1,2),MAXINT) = MAXINT) and not (Copy(ALink,i + 1,2)= '25') then Result := Result + '%25' else Result := Result + ALink[i]; end; You need '$' because the values are stored...

Hi! I am sorry, that I have to open this ticket again but there is still a problem with the hyperlinks. The function TXLSHyperlink.EncodeFileHLink, which obviously handles the hyperlink addresses, is called each time I create a hyperlink. But it is also called if I read the file which corrupts some ...

Hi!

Are there any plans to support Delphi XE7?

Best regards
d3nton.

Okay. I found the property :-) xlsfile.Manager.StyleSheet.NumFmts.Count can be used to check if a new format can be added: if (xlsfile.Manager.StyleSheet.NumFmts.Count < 256) then begin xlsfile.CmdFormat.BeginEdit(psheet); xlsfile.CmdFormat.Number.Format := pNumberFormat; xlsfile.CmdFormat.Apply(pCo...

Hi! To apply a specific formatting to an excel cell i use e.g self.CmdFormat.BeginEdit(psheet); self.CmdFormat.Number.Format := pNumberFormat; self.CmdFormat.Apply(pColumn, pRow); It seems that there is a limitation of different formats for an excel file (or maybe a single excel sheet, i'm not sure)...

In the current release 5.20.17 the xlsx files are corrupted in Excel2007 for UNC path hyperlinks with empty spaces. In XLSHyperlinks5.pas TXLSHyperlink.SetAddress the hyperlink is not encoded for UNC paths: line 265: else if BeginWith('\\') then begin FHyperlinkType := xhltUNC; end ... FAddress := S...

There are 66 Noncharacters (some in the unicode basic plane, some in the supplementary plane): http://www.unicode.org/faq/private_use.html#noncharacters http://en.wikipedia.org/wiki/Unicode#Character_General_Category These characters corrupt the xlsx files. Nocharacters in delphi are represented e.g...

Microsoft is really inconsistent in saving date values in the docprops such as 'created' and 'modified' dates. I found out that the 'modified' date is saved in UTC whereas other time values like 'created' are saved as local time. A fix can be implemented in XC12Manager5.pas. You can use the SystemTi...

Hello.

I seems that there is still a small bug in V5.20.18
In my timezone (UTC +1:00) the 'Date last saved' is currently 1 hour ahead.
E.g. instead of 9:00 (the current time) it is 10:00. Other Dates like creation date or modified date are correct.

Hi! Okay. I moved the characters via copy paste to excel and saved the file as xlsx (->the file contains the invalid character buit is not corrupted). Aftgerwards I extracted the xlsx file (created in excel). Compared to the xml created by XLSReadWrite there is a small difference.: Excel appended a ...

Thank you. I guess you mean 5.20.13?! It works now. But it seems that the changes in TXLSHyperlink.SetAddress: if IsURL(Value) or BeginWith('www.') then begin // if BeginWith('http://') or BeginWith('https://') or BeginWith('www.') or BeginWith('ftp://') then begin FHyperlinkType := xhltURL; S := En...

Hi! I got a floating point error on hyperlink creation (xls and xlsx) for the following hyperlink (XLSReadWrite 5.20.12): I know that the hyperlink is not valid in windows but we use these kind of hyperlinks in another context, so it would be nice if the the file would be created correctly. Issue se...

Yes, thanks. Works for me now.