we are preparing the release as i am writing this, should be up this week
BORIS MATOS MORILLO
@bjrmatos
Posts made by bjrmatos
-
RE: error when using pptxSlides helper with only one array element
-
RE: error when using pptxSlides helper with only one array element
hi!
yes, this is already fixed on our development branch, the fix will be part of the next release, which we are not sure when it will come, we are still preparing other changes and fixes to do that.
-
RE: long expressions and style conditions in docxTable templating
I'm rendering docxTable and I need to display a tight column with displayIndex value. Also as first cell it should contain beginning of docxTable handlebar so as a result it becomes unreadable
i think this is only a problem for the dev working on the template, right? i mean that it is not affecting the final output somehow, because the long expression for {{#docxTable ...}} is replaced when producing final output.
i've never been bothered by this, and there is no workaround at the moment. i make no promises but i will try to check if there is something we can do
Also wanted to ask about conditional styling. I want to set background color of a cell depending on incoming data. What is the best way to do it? And is it possible already?
it is not possible to do it right now, the only way i know about is to use the MS Word table styles editor, which let you configure the background and other styles for the table itself with some conditions in mind (like a background for odd rows and another for even rows). however if it is supported with docxStyle it will be more dynamic, letting you customize each cell on its own, anyway we have that in our backlog, i am currently working on another docx related tasks and after it i will check this task.
-
RE: @ added to formula in html-to-xlsx recipe
What does the error message (at the exclamation triangle) say?
i think that is translated to "Error: The value is not available"
-
RE: @ added to formula in html-to-xlsx recipe
i am checking the xlsx you sent me, but even after changing my language to German i still can not see the
@
character.any other step you do that reveals such character?
-
RE: Problem of not being able to use Autofit in xlsx or html-to-xlsx format
hi!
for the template "test2" which uses html-to-xlsx recipe the issue is the inline style you use for the table,
letter-spacing: -4px
any reason why are you doing this? if you remove this negative spacing it works as expected, in html-to-xlsx recipe the autofit is done automatically, no need to do anything elsethis piece of code you have there can be removed (anyway it is not doing anything valid/supported)
Object.assign(options, { xlsx: { addOptions: { xlsxColAutofit: true } } });
for the template "test" which uses xlsx recipe, you are using the
xlsxColAutofit
helper wrong, the xlsx recipe has two phases, the generation and transformation phase,xlsxColAutofit
is a helper designed to be used in the generation phase (so inside the xlsx template edited by MS Excel), however you are using it in the transformation phase which is wrong. an updated example can be found here: https://playground.jsreport.net/w/anon/u4O~fYYffor the autofit to work correctly you need to generate the cells in the generation phase, because if you create new cells in the transformation phase then the
xlsxColAutofit
won't be able to catch them because it runs first. -
RE: @ added to formula in html-to-xlsx recipe
maybe, but it would be weird that MS Excel changes something just because the locale, can you email me your generated xlsx file? (bjrmatos@gmail.com) i just want to double-check if what is stored internally for your output matches the same for what i see in the output of playground.
-
RE: @ added to formula in html-to-xlsx recipe
i have checked the template but we are not doing nothing on our side to change your formula, the output for me looks like this:
=LOOKUP(2,1/(INDIRECT(CONCATENATE("'",INDIRECT(CONCATENATE("Z",ROW(),"S1"),FALSE),"'!D:D"))<>""),INDIRECT(CONCATENATE("'",INDIRECT(CONCATENATE("Z",ROW(),"S1"),FALSE),"'!D:D")))
and in MS excel (which it displays according to my local, in Spanish)
=BUSCAR(2;1/(INDIRECTO(CONCATENAR("'";INDIRECTO(CONCATENAR("Z";FILA();"S1");FALSO);"'!D:D"))<>"");INDIRECTO(CONCATENAR("'";INDIRECTO(CONCATENAR("Z";FILA();"S1");FALSO);"'!D:D")))
i don't see the
@
being addedhowever what i've noticed is that internally the formulas are being html escaped, this is likely caused by your custom
formula
formula helper, i recommend you to change the formula helper call to use triple{{{
, update your calls to{{{formula ....}}}
maybe this fix the way your MS Excel parse the formula -
RE: @ added to formula in html-to-xlsx recipe
hi! generally, i don't know what can be causing that extra
@
character in the formula, there is a lot of logic around formulas so this needs to be debugged, can you share a playground demo replicating the issue? -
RE: jsrender - how to use tailwind
hi @arthuriques seems that the tailwind asset does not exists on the playground