Hello.
I have a very simple Excel file, which cannot be correctly displayed in UltraSpreadsheet. It looks like cells get wrong formatting with white font color. You can see the example on the screenshot.
On the left hand side is a screenshot from the simple application, which do nothing, but simply load workbook from the file.
var workbook = Workbook.Load(openFileDlg.FileName); ultraSpreadsheet1.Workbook = workbook;
On the right side, the screenshot from MS Excel.
I've also attached the Excel file itself_Invisible_Values.xlsx
Is this kind of bug, or I have to do some additional "magic" to make data visible in UltraSpreadsheet?
Best regards,
Oleg
P.S.: I also have experienced some appearing/disappearing values in the cells for some Excel files, during ZoomLevel adjustments. Is this some known issue?
Hello Oleg,
Thank you for contacting Infragistics. Which version of Infragistics assemblies are you using? What are the exact steps to cause the behavior? Was your excel file originally created in Excel and then loaded into the Spreadsheet? Or was the Excel file created, loaded in the Spreadsheet, modified, then loaded back in resulting in the issue?
I tried both of these and only reproduce the behavior with your original file. My next step is to cause the behavior and debug the steps taken necessary in reproducing the behavior. Thanks.
Michael
Hello, Michael.
Thanks for reply.
I use latest version of WinForms components (19.2.20192.302).The steps are very simple, just try to load specified file:
var workbook = Workbook.Load(fileName); ultraSpreadsheet1.Workbook = workbook;
The file was originally created in MS Excel.
The background of the problem is that we have Excel files, coming from different sources, and our application has to be able to show them all. The format of the cells can be very different there, and I start to notice that there are differences between the appearance in standard Excel and in UltraSpreadsheet. Most of them are not so critical, like:* same font might look a bit different,
* changing zoom level might made data in the cell to become invisible or stretch it too wide, when there is custom cell format applied.
* column autosizing do not work well for columns with dates, if date format is specified like dd.mm.yyyy; it left column a couple units smaller, than required.But of course, the one with completely invisible data is more critical for us. (There is a chance to get data visible, if you specify new cells format trough UltraSpeadsheet.)Regards, Oleg.