Attachment #34953 for bug #61033

View | Details | Raw Unified | Return to bug 61033
Collapse All | Expand All

Lines 561-569 public final class XSSFCell implements Cell { Link Here

(-)a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java (-3 / +5 lines)
561	return;	561	return;
562	}	562	}
563		563
564	XSSFEvaluationWorkbook fpb = XSSFEvaluationWorkbook.create(wb);	564	if(wb.getCellFormulaValidation()) {
565	//validate through the FormulaParser	565	XSSFEvaluationWorkbook fpb = XSSFEvaluationWorkbook.create(wb);
566	FormulaParser.parse(formula, fpb, formulaType, wb.getSheetIndex(getSheet()), getRowIndex());	566	//validate through the FormulaParser
		567	FormulaParser.parse(formula, fpb, formulaType, wb.getSheetIndex(getSheet()), getRowIndex());
		568	}
567		569
568	CTCellFormula f = CTCellFormula.Factory.newInstance();	570	CTCellFormula f = CTCellFormula.Factory.newInstance();
569	f.setStringValue(formula);	571	f.setStringValue(formula);

Lines 209-214 public class XSSFWorkbook extends POIXMLDocument implements Workbook { Link Here

(-)a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFWorkbook.java (-1 / +24 lines)
209	private MissingCellPolicy _missingCellPolicy = MissingCellPolicy.RETURN_NULL_AND_BLANK;	209	private MissingCellPolicy _missingCellPolicy = MissingCellPolicy.RETURN_NULL_AND_BLANK;
210		210
211	/**	211	/**
		212	* Whether a call to {@link XSSFCell#setCellFormula(String)} will validate the formula or not.
		213	*/
		214	private boolean cellFormulaValidation = true;
		215
		216	/**
212	* array of pictures for this workbook	217	* array of pictures for this workbook
213	*/	218	*/
214	private List<XSSFPictureData> pictures;	219	private List<XSSFPictureData> pictures;
Lines 2470-2473 public class XSSFWorkbook extends POIXMLDocument implements Workbook { Link Here
2470		2475
2471	return oleId;	2476	return oleId;
2472	}	2477	}
		2478
		2479	/**
		2480	* Whether a call to {@link XSSFCell#setCellFormula(String)} will validate the formula or not.
		2481	*
		2482	* @param value true if the application will validate the formula is correct
		2483	* @since 3.17
		2484	*/
		2485	public void setCellFormulaValidation(final boolean value) {
		2486	this.cellFormulaValidation = value;
		2487	}
		2488
		2489	/**
		2490	* Whether a call to {@link XSSFCell#setCellFormula(String)} will validate the formula or not.
		2491	*
		2492	* @since 3.17
		2493	*/
		2494	public boolean getCellFormulaValidation() {
		2495	return this.cellFormulaValidation;
		2496	}
2473	}	2497	}
2474	-

Return to bug 61033