I am using Aspose Cells version 8.3.0. The Cell.StringValue does not seem to respect conditional formatting that applies to the cell. Is there a way to get the displayed text according applied conditional formatting?
The below code creates a worksheet with two cells with the same “0” Custom number format and applies a “0.00” conditional formatting to one of those cells. It places 0.5 in both cells. Then it copies those two cells’ StringValues to another column and saves the workbook. When I open the workbook, I see the conditional formatting displays the text “0.50” correctly on the second cell, but the StringValue still reflected only the Custom number format. I would expect both the StringValues in the second column to look like the displayed text from the first column.
Dim BOOK = New Aspose.Cells.Workbook
Dim SHEET = BOOK.Worksheets(0)
Dim CELL_1 = SHEET.Cells(0, 0)
Dim CELL_2 = SHEET.Cells(1, 0)
Dim CELL_3 = SHEET.Cells(0, 1)
Dim CELL_4 = SHEET.Cells(1, 1)
Dim AREA = New Aspose.Cells.CellArea
Dim CELL_STYLE = CELL_1.GetStyle
Dim intFORMATTING = SHEET.ConditionalFormattings.Add
Dim FORMATTING = SHEET.ConditionalFormattings.Item(intFORMATTING)
CELL_STYLE.Custom = "0"
CELL_1.SetStyle(CELL_STYLE)
CELL_2.SetStyle(CELL_STYLE)
AREA.StartRow = CELL_2.Row
AREA.EndRow = CELL_2.Row
AREA.StartColumn = CELL_2.Column
AREA.EndColumn = CELL_2.Column
Dim int_arr_FORMATTING_STYLE = FORMATTING.Add(AREA, Aspose.Cells.FormatConditionType.NotContainsBlanks, Aspose.Cells.OperatorType.None, Nothing, Nothing)
Dim FORMATTING_STYLE = FORMATTING.Item(int_arr_FORMATTING_STYLE(0))
FORMATTING_STYLE.Style.Custom = "0.00"
CELL_1.PutValue(0.5)
CELL_2.PutValue(0.5)
CELL_3.PutValue(CELL_1.StringValue)
CELL_4.PutValue(CELL_2.StringValue)
BOOK.Save(“C:\TEMP\Test.xlsx”)