Hi, I'm looking for a way to set grid border line on desired cell range in advanced excel.
CellFormat_ApplyToRange (CellFormat.BorderStyle) did not work. It just draw border line around desired range. Please refer to a screenshot below. (Yellow is desired range)
And here's what I want it to be. I want border lines to be drawn inside the range.
Thanks in advance.
Hi Shinichiro,
I had to customize my version of the extension to achieve this functionality.
You can open your AdvancedExcel extension in your local Visual Studio via the Outsystems Integration Studio, and add all your customizations to it. It is a C# library which allows you to make changes and then build + publish to make your changes uploaded on your environment.
Use below code to customize your Advanced Excel component.
Hi, Ravi.
Thank you for your answer and handy examples!
Unfortunately I don't have enough time to make it by myself now, but I'm sure I will when I have enough time.
Thanks a lot for your help!
and thank you for answering a lot of my questions. You really helped me a lot!
Cheers.
Shin.
Hi @Ravi Punjwani ,
In case we have row/column start/end, we just want to border line (as below), not border inside. What Server Action of Advance Excel should be used in this case?
Please help to support.
Many thanks
Hi Thu,
I haven't tried Advanced Excel, but since it was based .NET EPPlus,
I guess you should call the Merge Range and then put the border on it.
Thanks.
This is a video I found how they did it with .NET EPPlushttps://www.youtube.com/watch?v=n8dZ4CwFAbA&ab_channel=EVERYDAYBECODING
Hi @Kiet Phan ,
Thanks for your info but in this case, we just wanna set border grid without merge cell. :)
I think CellFormat_ApplyToRange (CellFormat.BorderStyle) will do the job for you.
Check out the screenshot below and read through my first post because it seems what you are trying to do is exactly what I did on the first time.
Hope this helps.
And if it doesn't, I think you are supposed to make your own forum as this is already closed question and thus attract less eyes from community.
I've tried. It's not working as my expect.
I'll create my own forum. Sr for bother you.
Brs
Good luck.!
I'm waiting for seeing the solution :)
No worries.
I'm sorry that I couldn't be of help.
I hope you'll get some help out there!