The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
Hi,
I''m currently implementing some report generation code for our company extranet, and hit a snag with a certain formula.
dataCell.Formula = "IF(B4=0;0;C4/B4)";
I''m actually building the formula programmatically but even this literal form causes the following exception:
System.ArgumentOutOfRangeException
IF(B4=0;0;C4/B4)
Parameter name: Argument count must be 2 or 3"
I''m no Excel expert really, but it looks like there are three arguments. Also, if I paste the formula in Excel, it works fine.
I''ve been using simple formulas like "C4/B4" without problem. Is this an issue with the formula validation in ExcelRW, or am I missing something?