You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a Excel 2007 file(xlsx) , C2 formula value=A2 * B2/100 ,if I select C2,drag From C2 to C4,then C3 to C4 Cell Value as follows:
C3=A3 * B3/100
C4=A4 * B4/100
at last i want clear C3 formula , I run follows code,but have error;
In a strange way, I Manual input C3 to C4 formula ,run follows code,but No error;
I found that the set-null code in SetCellFormula doesn't call XSSFSheet.OnDeleteFormula. It only calls XSSFWorkbook.OnDeleteFormula, which is not enough.
I have a Excel 2007 file(xlsx) , C2 formula value=A2 * B2/100 ,if I select C2,drag From C2 to C4,then C3 to C4 Cell Value as follows:
C3=A3 * B3/100
C4=A4 * B4/100
at last i want clear C3 formula , I run follows code,but have error;
In a strange way, I Manual input C3 to C4 formula ,run follows code,but No error;
The Code is very sample,as follows:
errors,as follows:
test file:
TEST2.xlsx
ref infors:
NPOI Version : V2.5.6
.Net framework Version : 4.5
The text was updated successfully, but these errors were encountered: