Cannot get the correct output using LineByLine = false with smartmarkers

Aspose.Cells Product Family
1

LineByLine.zip (65.6 KB)

I’ve created a small sample project to illustrate my problem.
It contains an Excel file with the desired output, and an Excel file with the current output which is incorrect.

It seems like creating the range has no effect and the smartmarkers are still processed line by line. What am i doing wrong.

2

@tom.procureur,

Thanks for the samples with template files.

I did test your scenario/case a bit using your template file. Currently, Smart Markers are processed line by line. We have logged an investigation ticket with an id “CELLSNET-50748” for your issue/requirements. The ticket is logged as following:
CELLSNET-50748 - Process Smart Markers not LineByLine.

We will look into it soon.

Once we have an update on it, we will let you know.

3

Any update yet?

4

@tom.procureur,

The investigation or analysis phase is not completed yet. Please spare us little time. Once we have an update on it, we will let you know.

5

I think i found out why my code is not working…

The name of the range has to be ‘_CellsSmartMarkers’.
If you give this range another name then this does no longer work.

6

@tom.procureur,

Yes, by changing the line of code:
worksheet.Cells.CreateRange("1:7").Name = "_dossierSmartMarkers";
to:
worksheet.Cells.CreateRange("1:7").Name = "_CellsSmartMarkers";
it works fine.

So, you may use it to accomplish your task for your requirements.