If the attached XLSX file is opened and then press CTRL+END, it goes to column XFD. When I open the same spreadsheet in Excel it goes to column G (because column G has wrap text turned on)
Loading a spreadsheet with customized default format settings creates cell objects for all columns and rows
Answers approved by DevExpress Support
We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.
Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.
Hello Stephen, this issue has been fixed. But, we cannot provide you a hot fix because it was quite complex. I suggest you wait for the next version of our VCL controls - VCL 14.2.3, that we are going to release in a week.
Hello Stephen,
I've reproduced this behavior and forwarded this thread to our developers for further research.
Hello Stephen,
The problem was that loading a spreadsheet with customized default format settings creates cell objects for all columns and rows. So, we've changed the subject of this thread according to the cause.