Smart marker syntax for column index

Aspose.Cells Product Family
1

Hi,


I know &=={r} shows current row index,
&=={-1} above current row, &=={1} below current row
and &=={c} shows current column index.

what’s the syntax to get column index offset (left or right) to current column?
&=={c-1} or &=={c+1} doesn’t work.

2

Hi,

It seems to be a new feature to me.

Could you post your sample smart marker file and the sample output file that you want to get after it has been populated with the data.

You can create both of them manually using Ms-Excel 2010.

We will look into your files and help you asap.

3

Hi,


I have logged a ticket for it with an id: CELLSNET-40659. We will investigate and look into it if we can support according to your needs regarding Smart Markers. Once we have any update, we will let you know here.

By the way, you may use Column Name e.g A, B, C, … etc. to specify your columns in the dynamic formulas in Smart Markers, e.g … if you need to specify the Column A.
&=&=A{r}, &==A{r} etc.

4

Hi Shakeel Faiz,


Sample excel file is attached with two worksheets - marker and expected output.
Such feature would be useful to further construct any excel formula though it looks simple and straight forward.


Hi Amjad Sahi,

Thanks for your reply. However I afraid hard coding column name would not be a choice for me in this case. The column position changes in run time.


Regards,
hylin


5

Hi,


Thanks for the sample file to demonstrate your requirements or feature.

As we already logged a ticket for your feature, your example will help us to analyze your requirement precisely. We will look into it soon.

Thank you.
6

Hi,

Please download and use the latest fix: Aspose.Cells for .NET v7.2.0.8

Please try this fix with the following code.

C#


WorkbookDesigner designer = new WorkbookDesigner();

designer.Workbook = new Workbook();

designer.Workbook.Worksheets[0].Cells[“B2”].PutValue(“&=={-1}{1}”);

designer.Workbook.Worksheets[0].Cells[“B3”].PutValue(“&=={-1}1”);

designer.Workbook.Worksheets[0].Cells[“B4”].PutValue(“&==C{-1}+10”);

designer.Process();


.
7

The issues you have found earlier (filed as CELLSNET-40659) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.