Axolot Data

Hello,

If I use XLSReadWriteII6 to put a string longer than 32K in length into a cell, then when I open the file in Excel, there is no data.

I can, however, paste the same data directly into Excel.

Is this a bug or is there some other reason for this behavior?

Thanks

John Dorlon

I saw that, but doesn't that command paste clipboard contents INTO the XLS file? That's not what I am trying to do. I want to copy data from a grid/dataset into the clipboard and paste into other MS products like Word or Teams, using the same format that I would have if I copied from Excel into Word...

Hello, This question is not really related to XLSReadWrite, but maybe XLSReadWrite can help. In my application, I have TDataSets and TDBGrids. We have a feature that allows the dataset contents to be exported to clipboard (plain text, tab delimited) and it works fine. However, if I paste into MS Wor...

I just tried again. I have version 6.00.70a and there is no error. Thank you.

Are you sure? I just downloaded a trial of version 6 to test, but I still get the error.

Thank you Lars.

Hello, If I send ascii characters 28 and 29 to a text field in XLSReadWriteII5, then when I open the document in Excel 365, I get an error message and excel asking me if I want to attempt to repair the file. You can test it with this code: var XLS: TXLSReadWriteII5; begin XLS := TXLSReadWriteII5.Cre...

It looks like that is what you are doing in TXLSWorksheet.GetIsDateTime. You check NumFmt.Value, but when I step through this code, the problem is that the NumFmt is blank. I have an old VM that I started up today with an older version of our app that Used XLSReadWriteII4. I tested with the same XLS...

Hello, If I start up Excel (I'm using 2013), type a date value into a cell (For instance 11-Sep-16), then save it as XLSX and look at the cell with XLS.Sheets[FActiveSheet].IsDateTime[FCol, FRow] then it IsDateTime returns true as expected. However, if I save the Excel file as XLS, using the "M...

OK, I sent you the XLS file by email.

Thank you.

John

Hello, I have a customer in Korea (using windows 7 in Korean) who has a problem with Swedish characters appearing correctly. He can reproduce the problem with a small sample app. To reproduce it, drop these components on a form: object es1: TEdit Left = 14 Top = 16 Width = 121 Height = 21 TabOrder =...

More info: This was not a problem with XLSReadWriteII3 and Delphi 7.

Do you have MS Word? You can also reproduce the problem there. In Word, click the "Mailings" Ribbon tab. Click "Start Mail Merge", then "Step by Step mail merge wizard" A toolbar will appear on the right hand side. Click "Next" 2 times at the bottom of it, to ...

Hello,

I can repeat the problem using either format.

-John

HelloHello, I am using version 4.00.15 (according to the changes.txt file) with Delphi 2009 (all updates). I created a file using XLSReadWrite4, and then tried to use MS Access 2007 to import it. MS Access gives an error stating that the file cannot be read. If I then open the file in Excel and save...