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
+44- 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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+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
+52- Celebrity
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