My WPF programme fills in data in other sheets using an excel template with preset formulae, and the preset formulas then use the data from the other sheet to display it on the main page.
The issue is that while most formulas pass when I automatically PDF the excel, some others give me a System.
errors such as object or others. However, it operates when I view the excel file containing the dataset.
The formulas with an if() statement to eliminate all non-zero values in a range like this are the ones that work and those without.
", TRUE, TEXT(IF(Details!O:O>0,Details!O:O,""), "HH:MM"))
Functions like this work:
How do I get Spire.xls to PDF the right format?