We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Formula Issues

I am generating a dynamic varying length item list for customers to order from.

I want to use the following formula in cell F6:

=IF(OR(E6<>0)(E6<D6),“Some Message”,"")

but when I save and view the excel document the formula is:

=IF(Print_Area(E6<>0)
(E6<D6),“Some Message”,"")

Can you please explain what your component is trying to do here?

Is the OR syntax not supported or is there a bug in your component.

Why does your component parse the formulas?
Is there a way to stop the component caring what formula has been set?


The OR function in MS Excel is not support yet. It will be available in the next week.

We have to parse the formulas because formulas in Excel file is not saved as string but as parsed records.

Excelent!

Thanks…

Now Aspose.Excel supports OR function. You can download the latest hotfix and have a try.

Most Excelent!

Works great!

Looking forward to trying the Conditional Formatting Cell copy option.

Thank you!

@ojo,
Aspose.Excel is discontinued now and no more development is done for it. A new product Aspose.Cells has replaced it which contains all the features provided by Aspose.Excel and supports the latest fatures of recent MS Excel too. Aspose.Cells allows developers to copy conditional format settings from one cell to another in the worksheet by calling the Range.Copy() method. You may try the following sample code to achieve this fucntioanlity.

// Creating a file stream containing the Excel file to be opened
FileStream fstream = new FileStream(dataDir + "Book1.xlsx", FileMode.Open);

// Opening the Excel file through the file stream
Workbook workbook = new Workbook(fstream);

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Copying conditional format settings from cell "A1" to cell "B1"
//worksheet.CopyConditionalFormatting(0, 0, 0, 1);

int TotalRowCount = 0;

for (int i = 0; i < workbook.Worksheets.Count; i++)
{
    Worksheet sourceSheet = workbook.Worksheets[i];

    Range sourceRange = sourceSheet.Cells.MaxDisplayRange;

    Range destRange = worksheet.Cells.CreateRange(sourceRange.FirstRow + TotalRowCount, sourceRange.FirstColumn,
          sourceRange.RowCount, sourceRange.ColumnCount);

    destRange.Copy(sourceRange);

    TotalRowCount = sourceRange.RowCount + TotalRowCount;
}
            

// Saving the modified Excel file
workbook.Save(dataDir + "output.xls");

// Closing the file stream to free all resources
fstream.Close();

Following article contains more information about conditional formatting:
Conditional Formatting

For trial purpose, you can download the free version here:
Aspose.Cells for .NET (Latest Version)

A ready to run solution is available here which can be used to test the product features easily.