Excel Preview Issue.zip (12.7 KB)
Hello,
We have encountered issue where doconut has not generated preview for whole excel sheet.
For the above document it shows only 19 rows, however it has 100+ rows. And also it doesn’t show table at the right (L2:P-R7)
I’m able to replicate it on https://netcore-mvc.doconut.com/
@egormarkov
Thank you for sharing the sample Excel file and the details of the issue.
Our development team is currently reviewing your case to investigate why the preview is not displaying all the rows and the table on the right side. We’ll provide you with an update as soon as we have more information from our analysis.
We appreciate your patience while we look into this.
@egormarkov
Thank you again for sharing the sample Excel file and for your patience while our team investigated the issue.
I’m glad to let you know that this problem has been addressed in the latest Doconut release. We’ve added a new property PrintArea
in ExcelConfig
:
- The Excel Viewer now supports user-defined print areas (for example:
"A1:C99"
).
- Setting
PrintArea
to an empty string clears any predefined area in the document, ensuring that the entire sheet is displayed.
In your specific case, the original document had a print area defined, which limited the rows and the table being shown. To display the full sheet, you can set the PrintArea
to empty, like this:
var excelConfig = new ExcelConfig();
excelConfig.PrintArea = "";
This will render the complete worksheet instead of the restricted print area.