Axolot Data

Lars, I'm afraid this one won't go away. To make things work and avoid going back to version 4, I've modified the library code in a few places. These changes are probably not 100% correct and are workarounds, but seem to fix the problems we've had. What seemed to be happening was that a defined name...

Thanks Lars, Unfortunately the fix hasn't quite worked, and in fact made the problem worse. When the spreadsheet is opened in Excel, I now get a message saying "We found a problem with some content in <filename>. Do you want to recover as much as we can? If you trust the source of this workbook...

Thanks Lars,

The version on the registered download site is still 5.20.39. Is there another page I should be looking at?

Many thanks,
James

Hi Lars,

Yes I'm logged in. The link appears fine in the XLSReadWriteII 5 forum but not the Version History.

Thanks,
James

Hi, In the XLSReadWritwII 5 forum there's a link at the bottom that says "Subscribe Forum" so I can be notified of all new posts. I'd like to use this in the XLSReadWriteII version history forum so I can be notified when new versions are available, but I can't see the link. Is this somethi...

Thanks Lars, I'll keep an eye out for it.

Hello, I've now done some further investigation on this as we have customers refusing to use the new version, and I've found a solution, but I'm unsure how (or indeed, if) I can fix it in code using XLSReadWrite. I opened newly created XLSX file in Excel and turned off the Autofilter, then turned it...

Hello, I've recently upgraded to XLSReadWriteII 5.20.36 from version 4, and I'm having some problems with autofilters. I'm producing an xlsx file with a single tab, and have a header row where I'm applying an autofilter using the code below. When the file is opened in Excel 2013 it displays fine and...

Hi Lars, Thanks for your offer to help, but I've finally figured this out - I was applying a background colour to the cell after the font set (I have separate functions for setting font, background colour etc.), and even though I wasn't explicitly setting the font name when setting the background co...

OK I've got a bit further with this and now have a spreadsheet where the default font is working on subsequent tabs - almost. I've modified the code so it reads as follows: On create: oXLS.CmdFormat.BeginEdit(nil); oXLS.CmdFormat.Font.Name := 'Arial'; oXLS.CmdFormat.Font.Size := 10; FDefaultFormat :...

Hello, I'm trying to upgrade our XLS library to XLSReadWriteII5 and have hit problems with the default formats. Previously (with .xls files) the default was Arial and size 10, but after the upgrade the default seems to be Calibri and size 11. I'm trying to prevent this change to avoid users complain...