ReplaceText doesn't work on Numbers?

GemBox.Spreadsheet
1

Just want to make sure I’m not missing something, but ReplaceText doesn’t appear to work on Numbers. Is that correct? If so, is there a workaround?

Thanks!

2

Hi! Can you please give an example?

3

Hi Byron,

Is it possible you’re searching for the formatted value, not the actual cell value itself?
In other words, try this:

var workbook = new ExcelFile();
var worksheet = workbook.Worksheets.Add("Sheet1");
var cell = worksheet.Cells["A1"];

cell.Value = 1234.56;
cell.Style.NumberFormat = "$ #,##0.00";

Console.WriteLine($"CELL VALUE: {cell.Value.ToString()}");
Console.WriteLine($"CELL FORMATTED VALUE: {cell.GetFormattedValue()}");
Console.WriteLine();
Console.WriteLine($"FIND '1234.56': {worksheet.Cells.FindText("1234.56", out _, out _)}");
Console.WriteLine($"FIND '$ 1,234.56': {worksheet.Cells.FindText("1,234.56", out _, out _)}");

I hope this helps.

Regards,
Mario