Cell with text formated in HTML #2742

Open
opened 2022-07-13 12:13:42 +00:00 by Seykotron · 0 comments
Seykotron commented 2022-07-13 12:13:42 +00:00 (Migrated from github.com)

We are trying to export an excel that comes from an array of objects, in example:

{ "success": true, "hojas": { "Imputaciones": { "columnas": [ [ "Id", "Email", "Nombre Completo", "Puesto", "Equipos", "Áreas de Práctica", "Socio Referencia", "Manager Referencia", "Fecha Grabación", "Fecha Imputacion", "Centro de Facturación", "Cliente", "Exp. Referencia Antigua", "Exp. Referencia Actual", "Expediente", "Asunto", "Descripcion", "Tiempo", "Horas", "Minutos", "Estado" ] ], "columnas_con_fechas": [ [ "Fecha Grabación", "Fecha Imputacion" ] ], "columnas_con_html": [ [ "Descripcion" ] ], "valores": [ [ 292195, "xxxxx@xxxxx", "xxxxxxx", "xxxxxxx", "xxxxxxx", "xxxxxxx", null, null, "2022-07-13T07:17:40.173", "2022-07-13", "xxxxxxx", "xxxxxxx", "xxxxxxx", "xxxxxxx", "xxxxxxx", null, "<p>Reporte trimestral de los casos en FinRep.&nbsp;</p>\r\n\r\n<p>FPCE. Revisi&oacute;n de los m&oacute;dulos mandatory con sus responsables. Redacci&oacute;n de las respuestas y recopilaci&oacute;n de evidencias.&nbsp;</p>", 7, 7, 0, "Pendiente de revisar" ], ], "total": 8, "title": "Imputaciones" } }, "sheet": "Imputaciones", "title": "imputaciones_todas", "filas_por_pagina": 1000, "pagina": 1 }

The thing is that in excel the colum "Descripcion" its not showing as html but showing the html tags, etc.

I tried to fill the "h" property of the cell but it does not change the output.

I've search a lot and didnt see any issue like this,

can you help me please?

We are trying to export an excel that comes from an array of objects, in example: `{ "success": true, "hojas": { "Imputaciones": { "columnas": [ [ "Id", "Email", "Nombre Completo", "Puesto", "Equipos", "Áreas de Práctica", "Socio Referencia", "Manager Referencia", "Fecha Grabación", "Fecha Imputacion", "Centro de Facturación", "Cliente", "Exp. Referencia Antigua", "Exp. Referencia Actual", "Expediente", "Asunto", "Descripcion", "Tiempo", "Horas", "Minutos", "Estado" ] ], "columnas_con_fechas": [ [ "Fecha Grabación", "Fecha Imputacion" ] ], "columnas_con_html": [ [ "Descripcion" ] ], "valores": [ [ 292195, "xxxxx@xxxxx", "xxxxxxx", "xxxxxxx", "xxxxxxx", "xxxxxxx", null, null, "2022-07-13T07:17:40.173", "2022-07-13", "xxxxxxx", "xxxxxxx", "xxxxxxx", "xxxxxxx", "xxxxxxx", null, "<p>Reporte trimestral de los casos en FinRep.&nbsp;</p>\r\n\r\n<p>FPCE. Revisi&oacute;n de los m&oacute;dulos mandatory con sus responsables. Redacci&oacute;n de las respuestas y recopilaci&oacute;n de evidencias.&nbsp;</p>", 7, 7, 0, "Pendiente de revisar" ], ], "total": 8, "title": "Imputaciones" } }, "sheet": "Imputaciones", "title": "imputaciones_todas", "filas_por_pagina": 1000, "pagina": 1 }` The thing is that in excel the colum "Descripcion" its not showing as html but showing the html tags, etc. I tried to fill the "h" property of the cell but it does not change the output. I've search a lot and didnt see any issue like this, can you help me please?
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#2742
No description provided.