Skip to main content
Completed

Excel export does not contain group labels

Related products:Software Factory
Marius Korff
rbiram
  • Marius Korff
    Marius Korff
  • rbiram
    rbiram

Mark Leunissen
Captain

When exporting an excel file, the group labels are not included in the excel file. As you can see in the image, the labels ‘kostprijs’ and ‘bruto verkoopprijs’ will not show up in the excel doc. 

 

The problem occurs when I translate the columns ‘huidige kostprijs’ and ‘nieuwe kostprijs’ to ‘huidige’ and ‘nieuwe’ (in order to make the screen readable). Then, the excel only shows columns named ‘huidige’ and ‘nieuwe’, which would make the excel unreadable. Is there a way to work around this problem? And otherwise, could it be possible to include group labels in an excel export?

 

Kind regards,

 

Mark

Did this topic help you find an answer to your question?

4 replies

Renée Evertzen
Moderator
Forum|alt.badge.img+4

Hi Mark,

As far as I know group headers are never included in the export to Excel. I will convert this topic into an idea for you so we may take it into consideration for implementation in the future.


Jeroen van den Belt
Administrator
Forum|alt.badge.img+9

Hi @Mark Leunissen,

Perhaps there is no need to export the group headers.

When exporting, the regular translation for columns is exported, not the grid translation. So you should get the extensive name in your export when you fill it in the ‘Translation’ field. 

When you divert from this in the ‘Translation grid’ field with the shortened name, the grid should also stay clean.

Can you try if this works for you? And if so, do you still require the idea to export group headers?


Mark Leunissen
Captain
Forum|alt.badge.img+4

Good idea! This would solve my problem.


Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
Needs feedbackCompleted

Reply


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