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.
I will log this issue with our development team today. The only remaining information that would be useful would be to provide me with a working excel file to start with, provide the steps to change the excel file before loading it in our workbook/spreadsheet. Thanks
Hello, Michael.I have attached the file, which can be used to reproduce weird behavior, I described before.
Values on first sheet are invisible.
On the second sheet, there are dates in column C, which autosize fails a bit.
The values in column M might be displayed weird on some zoom levels (for me it is 119%) after column has been autosized.
As example of different font appearances there is "Calibri" font. "Arial" looks more or less the same as in Excel.
7462._Invisible_Values.xlsx
Oleg.
Thank you for following up. I've logged the development issue 269161 for the missing values and opened a support ticket CAS-206776-C4N1X8 that you can now visit on your support activity page at your account.
Attached below is a screenshot comparing your previous worksheet with Excel. I don't see any autosizing differences in column C.
Column C
Column MI do see a difference, we are putting an extra # because there are 9 pound signs and Excel is excluding one of them leaving space on the left side of the cell. I don't know if this is intentional or not but I will bring this to our development team's attention.
I made a couple of screenshots as a proof of autosize issues I face. Hope it might help.
It might make sense that date format is different for me:
Presentation very at different zoom factors for custom numbers format:
Best regards,Oleg