Axolot Data

Dear Larsa, I have tried to load the Excel 97 (xls) open password protected file with the latest version of XSS but failed. The file was created as follows: - Open a blank workbook in MS Excel 2016 (64-bit) under Windows 10 64-bit - Save the file as the Excel 97-2003 workbook with the Password to op...

After trying many attempts, the solution is so simple:

FXSS.Read;

Dear Lars,

I have tried your suggestion but the result still keeps unexpected for backward focus changing.

Call FXSS.InvalidateAndReloadSheet, tests with/without data have the same results.

Please kindly advise.

Hi Lars,

Thank you for your reply but unfortunately, it still does not work.

You can try yourself with the 'XLSSpreadSheetAdvanced.dproj' sample.

App will show properly if moving focus forward, means from cell with low address to higher one, for example A1 -> BC10. However, when going backward the display is not expected: Cursor moves to correct address but screen remains the same. I am thinking of going back to A1 cell, refresh the sheet and...

Solution is:

XSS.SetCursorPos(SheetIndex, 0, 49);

Please kindly advise how to move focus to the selected cell.

E.g. when set the 'A50' in the cell name and Enter, the display will show the A50 cell.

Thank you in advance for your help!