Skip to main content
Question

Apply border style only on bottom with ExelStyler

  • September 9, 2021
  • 2 replies
  • 24 views

jelle
Contributor
Forum|alt.badge.img+16
  • Contributor

In the ExcelStyler, it is possible to add a border style to a row.  It gets a value like:

version<semicolon>1<semicolon>cell_border_style<semicolon>BORDERSTYLE_THICK<semicolon>cell_border_color<semicolon>0<comma>0<comma>0

However, I only want to apply it to the bottom of that row, which is not available in the interface. Does anyone know whether it is a possibility to extend the current formatting value and apply the border style to the bottom only?

 

Maybe something similar to:

cell_border_type<semicolon>BOTTOM<semicolon>

but then with the right values

2 replies

danminneyatsaf
Safer
Forum|alt.badge.img+12

Hi @Jelle De Zwaef​, unfortunately as far as I know there is no way to force the ExcelStyler to only apply a border style to only one side of a cell/row. 

 

This functionality could be something that other users may also be looking for in FME. If you haven’t yet, I recommend checking out the FME Community Ideas where you could submit an idea that other users can vote for & comment on. If it gets popular, it might even be reviewed by Safers and considered for development! 


jelle
Contributor
Forum|alt.badge.img+16
  • Author
  • Contributor
  • September 14, 2021
danminneyatsaf wrote:

Hi @Jelle De Zwaef​, unfortunately as far as I know there is no way to force the ExcelStyler to only apply a border style to only one side of a cell/row. 

 

This functionality could be something that other users may also be looking for in FME. If you haven’t yet, I recommend checking out the FME Community Ideas where you could submit an idea that other users can vote for & comment on. If it gets popular, it might even be reviewed by Safers and considered for development! 

Hi @danminneyatsaf​ , thank you for your answer. I'll post the idea on the forum


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings