TEMA:

Excel Export - formatting issue, very wide columns and Author column 1 año 3 meses antes #264581

  • Autor del tema
  • simun
  • Fuera de línea
  • Navegador Senior
  • Navegador Senior
  • Registered
  • Mensajes: 109
  • Gracias recibidas: 0
Hi there,

Is it possible to modify the format for the exported Excel Sheet in any way?

For our list which is quite big and also has some "textareas" fields, when we export the excel sheets, some fields get created with very wide column due to e.g. long descriptions without any line breaks.
See attached example.

The exported Excel sheet automatically has the "wrap text" on which is nice, so to make the exported Excel sheet more decent, it would be nice to somehow set a max limit the column size of the exported sheet, e.g. 100 (705 pixels). Is this possible?

Also in our ContentBuilder list we also have the Author column shown, but this column does not get exported by the Excel Export feature? How can this be added to the export Excel Sheet?

Additionally some basic formatting would be nice like:
- The field titles being Bold
- The Sort & Filter-> Filter setting "on" for the top row titles
Adjuntos:

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Excel Export - formatting issue, very wide columns and Author column 1 año 3 meses antes #264589

  • Avatar de tihana.krivic
  • tihana.krivic
  • Fuera de línea
  • Moderador
  • Moderador
  • Registered
  • Mensajes: 12079
  • Gracias recibidas: 778
Hi,

basically, template for excel in content builder is in:
/administrator/components/com_contentbuilder/views/export/tmpl/default.php
I will check how to fix this and get back to you

Also in our ContentBuilder list we also have the Author column shown, but this column does not get exported by the Excel Export feature? How can this be added to the export Excel Sheet?

This happends when there are some empty fields into the existing records.

Regards,
Tihana

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

  • Página:
  • 1
Moderadores: ForumSupport
Tiempo de carga de la página: 0.049 segundos

Live Support Chat Opened!

Join our Discord chat here and enter the Crosstec channels to receive live support and talk directly to the team!