When using Manual Attribute Definition in the XLSX Writer or FeatureWriter, is there a way to copy the Column Formatting between attributes? I have noticed that if I manually add a new attribute beneath one already formatted it copies the Formatting of the one above. But I was hoping there would be an easy way to set one, and then have it applied to all attributes.
Solved
Excel Column Formatting
+34- Influencer
Best answer by rahulsharma
Hi
In FeatureType properties dialog, Under User Attribute → Switch to “ Manual”
Create a customize row, specify Font, Color, Border etc
Right click → Copy Row
Add a new row if required , Right-Click and Paste
This operation should copy the formatting and you can copy and paste as many times as you want.
You can also use the ExcelStyler transformer to format rows or cells
+10- Safer
- Best Answer
Hi
In FeatureType properties dialog, Under User Attribute → Switch to “ Manual”
Create a customize row, specify Font, Color, Border etc
Right click → Copy Row
Add a new row if required , Right-Click and Paste
This operation should copy the formatting and you can copy and paste as many times as you want.
You can also use the ExcelStyler transformer to format rows or cells
1 person upvoted this
+44- Evangelist
rahulsharma wrote:
Hi
In FeatureType properties dialog, Under User Attribute → Switch to “ Manual”
Create a customize row, specify Font, Color, Border etc
Right click → Copy Row
Add a new row if required , Right-Click and Paste
This operation should copy the formatting and you can copy and paste as many times as you want.
You can also use the ExcelStyler transformer to format rows or cells
Very nice
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.