Defect in Engine with Custom Properties

[steve_randomno]

Hi,

I think there may be a defect in the FormulaEngine. The defect occurs when a custom property is assigned to a GridStyleInfo object, the CellType is set to either "FormulaCell" or some derrived type (as in example), and the FormulaCopyFlags of the cell type's engine is set to the "GridFormulaCopyFlags.ClipBoardReferencesAdjusted".

In this situation, formulas that are copied and pasted between cells are not adjusted as the should be given the value of the FormulaCopyFlags property.

Please see the attached sample project for a realistic example (we are using a cell type that is derived).

Many thanks,
Steve

FormulaEngineDefect.zip

[steve_randomno]

IS this a defect or is there another way of doing this?

[Rajagopal]

Hi Steve,

Thanks for your patience.

Please refer the below sample that shows this working as intended in copying and pasting the cell refrences adjusted to thier new location.
http://www.syncfusion.com/Support/user/uploads/GridFormulaCells_1786a6a5.zip

We are currently analyzing your sample on the mentioned problem and will get back to you with the results on this soon.

Regards,
Rajagopal

[steve_randomno]

Thanks.

The problem only seems to occur when you have custom properties.

This is very important to us as we have Excel Power users who expect as much excel like functionality as possible. Relative formula copy/paste is one of the most basic of excel features that would be very obvious if missing in our ap.

We are running on Windows 2000.

Please keep us updated with your investigations.

[steve_randomno]

Any update?

[steve_randomno]

Is this a defect?