Keep xls style

[gdo]

Hi,

When I use an excel template with XlsIO the borders that where in the template always disappear in the final file.

Is there an option to keep them ? Or to keep style when putting variable value in cells ? (I just know insert:copystyles but I don't want to insert cells, I only want something like keepstyle or something that provides an equivalent behavior).

Thanks,
Greg

[Melba Winshia]

Hi Greg,

Currently by using insert:copystyles option only we can keep the style. Here is the sample using insert:copystyles:

http://websamples.syncfusion.com/samples/XlsIO.Web/4.4.0.51/61236/main.htm

We do not have any other option to keep style alone. Sorry for the inconvenience caused.

Kindly let me know if you have any other questions.

Thanks,
Melba

[Anonymous]

Also you can try to use jump argument
jump:R[1]C:copystyles;
or something like that. This will update position and copy style but will not insert any new row or column

[gdo]

Thanks ami !

You saved my life ^^

[Melba Winshia]

Hi Ami,

Thanks for the information.

Thanks,
Melba

[gdo]

Hi,

I've got another problem. Borders in cells that are not modified just disappear too. Is there a way to fix the borders in the template ?

Thanks,
Greg

[Melba Winshia]

Hi Greg,

Could you please provide us a sample that you have used to reproduce this issue or please modify the below sample to reproduce the issue?

http://websamples.syncfusion.com/samples/XlsIO.Windows/F61236/main.htm

This would help us in investigating this issue further.

Thanks,
Melba

[gdo]

I'm going to try it. But I had a virus alert when unpacking the sample, here the detail :

Detection : W32/HLLP.Philis.ini (Virus)
File : C:\cvset\TestColumnCount\_desktop.ini

Greg

[gdo]

I have reproduced the problem based on your sample's code.

To test it, change code to open file "template.xls" for the clean result, and change code to open file "template_bug.xls" to see the template causing problems.

Greg

TestColumnCount.zip

[Anonymous]

I'm not sure whether you will fill better after my words, but simple open-save (without applying any marker) of that template_bug.xls makes that mess with your template (at least in my version).

[Melba Winshia]

Hi Greg,

Could you please create a Direct-Trac incident with the subject as " Keep xls style_61236"? So that it would be possible for us to provide more details regarding this issue.

Thanks,
Melba

[gdo]

>I'm not sure whether you will fill better after my words, but simple open-save (without applying any marker) of that template_bug.xls makes that mess with your template (at least in my version).

Ouch !

[Melba Winshia]

Hi Greg,

Kindly let me know if you have any other questions.

Thanks,
Melba