TinyButStrong Forum

Re: [fr] Garder sa mise en page sous tbs:row

2017-03-16 09:14:00

Bonjour Skrol,

Aie, ça m'arrange pas du tout tout ça.
Il faut que je trouve une solution de contournement, je pensais à PHPExcel pour ajouter des lignes avant peut-être, il faut voir comment ça interagit.
En tout cas, merci beaucoup pour ta réponse très rapide

Re: how to do sub1 + row in xlsx

2017-03-15 22:08:13

You have do to a $TBS->MergeBlock(...) at the PHP side.

In your snipped, block "clienti" has no bounds, so only first record will be merged.

Re: Excel could not open file - unreadable content

2017-03-13 22:21:51

Thanks,

The "Merged.xlsx" file is corrupted because they are some extra data after the end of the zip file.

This is probably because your PHP script does send some content after the file is merged.

You extra data is: "File [xxxxxxx.xlsx] has been created."

Re: only one row displayed instead of 42 rows

2017-02-17 08:49:37

You should replace
[rec.p_id;block:table:table-row]
with
[rec.p_id;block=Row]
because in Excel-XML file format the row entity is .

I suggest that you use the OpenTBS plug-in instead of the TBS_EXCEL plug-in, that will enables you to have true XLSX template.

Re: Set xlsx cell to text format

2017-01-13 11:49:36

I figured out the problem.
If a cell is styled, the format has to be defined in the cell.

Problem with tbs:date, tbs:time and xlsxDate

2017-01-11 13:40:59

Hello

After chaning the locale in our project we found a problem with a column with tbs:date. The generated excel contained now 42725,744849537 instead of 42725.744849537. With that excel fails to open correctly (shows error and can not repair the problem). The Problem is the same as discussed in http://www.tinybutstrong.com/forum.php?thr=3463. Just different place.

What worked for me was to change in the function MsExcel_ChangeCellValue on line 3796 "$Value = ($t/86400.00)+25569;" to "$Value = var_export((float) ($t/86400.00)+25569, true);".

With that the implicit converion from float to string does not lead to a wrong decimal separator and it works again.

Best Regards,
Christoph

Re: How to create Hyper Link to excel?

2016-12-17 16:21:23

Thank you for the reply, I hope see it in future version.
OpenTBS is the best! Loved it

File creation progress

2016-12-12 15:13:43

Hello,

how cai i implement a creation progress of an xlsx file.

thank you

Re: Insert XML in a cell

2016-10-06 09:38:48

Re: Insert image on XLSX

2016-09-15 17:50:19

> Someone has an xlsx file example?

The demo given in the OpenTBS package has such an example.

Can you precise your code that does the merging ?

Re: adjust cell height of xlsx

2016-06-09 07:07:50

Hi there. I am struggling with the same issue too. I did the suggestions mentioned above but was unable to solve it.

Thanks,
Hameed

Re: OpenTBS tbs:date modification propose

2016-05-11 01:16:33

Hi Alexey,

Thank for your submitting.
This will be taken for the next version.

Regards,

Re: How to attach xlsx to email

2016-04-14 08:32:11

Never mind - I figured out it by myself :)
It should be OPENTBS_STRING as a parameter for Show():

[code]
$TBS->Show(OPENTBS_STRING);
$xls_content = $TBS->Source;

$mail->addAttachment(new stringAttachment($xls_content, "test.xlsx", 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'));
[/code]

That way it generates the right XLSX attachment.
Thank you anyway. OpenTBS is awesome!

Re: tbs:date and block=tbs:row

2016-03-24 23:06:10

Re: Acces all worksheets dynamically

2016-03-08 12:59:43

No, its not that urgent. As I already found a solution for my original problem (forced re-calculation of formulas) this feature is more like a "nice-to-have" - but thanks anyways!