Public API Changes in Aspose.Cells 8.7.1
Added LookInType.ORIGINAL_VALUES Property
Aspose.Cells APIs already support the Find or Search Data feature for spreadsheets in order to find some particular piece of contents in cell value & formula. However, this feature was lacking the aspect of formatting applied onto the cell that may change the appearance as well as the value of the contents, consequently make the text unsearchable using the original value. With this release of Aspose.Cells APIs, another constant by the name LookInType.ORIGINAL_VALUES has been exposed to the public API which allows to overcome the situation as discussed above.
Following is the simple usage scenario.
//Create workbook object Workbook workbook = new Workbook(); //Access first worksheet Worksheet worksheet = workbook.getWorksheets().get(0); //Add 10 in cell A1 and A2 worksheet.getCells().get("A1").putValue(10); worksheet.getCells().get("A2").putValue(10); //Add Sum formula in cell D4 but customize it as --- Cell cell = worksheet.getCells().get("D4"); Style style = cell.getStyle(); style.setCustom("---"); cell.setStyle(style); //The result of formula will be 20 //but 20 will not be visible because //the cell is formated as --- cell.setFormula("=Sum(A1:A2)"); //Calculate the workbook workbook.calculateFormula(); //Create find options FindOptions options = new FindOptions(); options.setLookInType(LookInType.ORIGINAL_VALUES); options.setLookAtType(LookAtType.ENTIRE_CONTENT); Cell foundCell = null; Object obj = 20; //Find 20 which is Sum(A1:A2) and formatted as --- foundCell = worksheet.getCells().find(obj, foundCell, options); //Print the found cell System.out.println(foundCell);