Spire marker in horizontal style overwrite text

[LauraNM]

Hello!
I have the next problem:
When I use marker in rows, Spire add new rows and then, The rest of the content of the file remains the same but below.

spire marker horizontal overwrite 1.PNG (28.71 KiB) Viewed 2068 times

But, when I use marker in columns (horizontal), Spire overwrite the content the rest of the content of the file.

spire marker horizontal overwrite 2.PNG (149.33 KiB) Viewed 2068 times

It is possible avoid that? And, It is possible use two modiffiers: add:style and horizontal in the same cell?

Thank you very much for your help!

[Betsy.jiang]

Hi,

Thanks for your inquiry.
Based on your information, I guess you want to insert data into the left column. If so, I am afraid it is impossible at present, since using horizontal the data will be inserted to right side one by one.
Besides, you could use add:style and horizontal in one cell, please refer to following sample:

Code: Select all

&=Country.Capital(horizontal, add:styles)

If I misunderstood, please provide detailed information.
1. Input and output Excel file, rather than image since it is not clear
2. The test code which includes the data you want to insert in Excel
3. The desired Excel file

Sincerely,
Betsy
E-iceblue support team

[LauraNM]

Hello,

The code and the sample is your MarkerDesigner project in the VS2015 Samples.

But, the answer is clear to me. In rows, spire inserts new rows and respects the rest of the content on the same sheet, but, in columns, spire overwrites the contents of the sheet to the right.
Currently it is not possible to have anything to the right of the cell in the horizontal case. Do you know if it is planned to modify this behavior in the future?

Thank you very much for your help!

[Betsy.jiang]

Hi,

Thanks for your response.
The sample in MarkerDesigner project doesn't include horizontal setting like your image shows. Anyway, we will consider adding the new feature in our future upgrade. If there is any update, we will let you know.

Thanks,
Betsy
E-iceblue support team

[Betsy.jiang]

Hi,

Hope you are doing well.
The new feature has been implemented, please download the Spire.Office Platinum (DLL Only) Version:4.10.0 and have a try.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
NuGet link:https://www.nuget.org/packages/Spire.Office/

Sample for your kind reference:

Code: Select all

//add in original file, the data will be inserted from the bottom to the top in vertical orientation.
&=Country.Capital(vertical:bottom_to_top,add:styles)
// add in original file, the data will be inserted from the right to the left in horizontal orientation.
&=Country.Capital(horizontal:right_to_left,add:styles)

Sincerely,
Betsy
E-iceblue support team

[LauraNM]

Hello!
I'm going to try it!
Thank you very much for your help!

[Betsy.jiang]

Hi,

I am waiting for your feedback after trying.
If there is any question, welcome to get it back to us.

Sincerely,
Betsy
E-iceblue support team