TinyButStrong Forum in English http://www.tinybutstrong.com/ http://www.tinybutstrong.com/forum.php?msg_id=15640 Hello, thanks for the answer =D !

I just came here to know if is was a known issue.

Since it is, I've came with this solution for now:

A | B | C | D
1| Number | Value | Quantity | TOTAL
2| [item.number;block=tbs:row] | [item.value;ope=tbs:num] | [item.quantity;ope=tbs:num] | =INDIRECT(CONCAT("B";ROW()))*INDIRECT(CONCAT("C";ROW()))


And voila ! =D
No changes on TBS or OpenTBS, just using excel regular formulas. The functions mentioned are all implemented both on Microsoft Excel and LibreOffice Calc.

It's also possible to use R1C1 style on INDIRECT function. But I prefer to use A1 because the column letter appears in the formula.

Thanks again, hope this post helps someone in the future.



2017-04-14 04:35:26 http://www.tinybutstrong.com/forum.php?msg_id=15575 Hello,

Thanks for the help. It works!
I'll consider the relative syntax (block=tbs:p). Tomorow I'll try something like this:
[code]
1 [myBlock.domaine;strconv=no;enlarge=text:p;block=tbs:p;sub1=(projet)]
1.1 [myBlock_sub1.nom;block=tbs:p;sub1=(ae)]
- [myBlock_sub1_sub1.nom]
[myBlock_sub1_sub1.desc]
[/code] 2017-02-23 22:02:21 http://www.tinybutstrong.com/forum.php?msg_id=15553 Hi Michael and thanks for your reply!

That sounds like you are doing a very comprehensive intervention into the existing class! I am not entirely sure I understand the necessity of each of the explained steps.

I have done the following:
[code]
$TBS = new \clsTinyButStrong('','wlTempl_','wlTempl_'); // new instance of TBS
$TBS->VarRef = [];
$TBS->_UserFctLst = new \TbsNoFunctions;
[/code]

TbsNoFunctions being defined like you explained in you original post. In addition I am customizing the method TbsPicAdd right after it called TbsPicExternalPath with the following code:
[code]
// CHANGE CUSTOMIZATION !!!!
$ExternalPath = str_replace("//","",str_replace("..","",$ExternalPath));
if(!starts_with($ExternalPath,storage_path('app')))
return false;;
[/code]

This ensures that image paths are within the image path and do not navigate out of it.

I am not entirely positive that his is covering all potential to do bad with TBS strong templates. Any input on were this approach is lacking would be appreciated.

Thanks again and all best,
Tobias 2017-02-06 15:44:19 http://www.tinybutstrong.com/forum.php?msg_id=15371 ok 2016-09-01 01:27:08 http://www.tinybutstrong.com/forum.php?msg_id=15277 Hello AAA,

I cannot reproduce your problem.
I guess you've used « demo_ms_excel.php » and not « demo_merge.php » because « demo_merge.php » uses an HTML template.

Can you give more detail about your snippet for merging ? 2016-04-15 00:34:43 http://www.tinybutstrong.com/forum.php?msg_id=14868 Ok, thx, i will try this.

Does it work the same with docx files? 2015-06-12 16:23:24 http://www.tinybutstrong.com/forum.php?msg_id=14825 Hi,

Check that your document is a correct zip archive. You can do this using a zip tool such as 7zip or by checking the binary header of the file.
If the document is protected by a password then it is probably encrypted so it is no longer a common zip archive.

If you still have the problem, you can send the document to me. 2015-04-28 13:19:10 http://www.tinybutstrong.com/forum.php?msg_id=14811 Hi,

What problem do you have ?
Dod you try the classic merge with a table, like in the DOCX example ? 2015-04-14 22:03:16 http://www.tinybutstrong.com/forum.php?msg_id=14806 Thank you Skrol. You are right, it's not a TBS/Open TBS issue, but an html handicap. Some possible solutions found here: http://stackoverflow.com/questions/2339440/download-multiple-files-with-a-single-action 2015-04-10 09:02:35 http://www.tinybutstrong.com/forum.php?msg_id=14674 Oui j'avais tout réalisé en UTF-8. Je vais vérifier ça 2015-01-07 19:18:51 http://www.tinybutstrong.com/forum.php?msg_id=14620 TBS alone can merge any text template, so it can do HTML templates.
OpenTBS is a plug-in for TBS that enables you to merge templates that are LibreOffice and MsOffice documents. 2014-11-20 01:43:29 http://www.tinybutstrong.com/forum.php?msg_id=14598 Worked handsomely ;) 2014-11-13 16:19:21 http://www.tinybutstrong.com/forum.php?msg_id=14570 Hi

Thanks, the "Word.Options.StoreRSIDOnSave = false" seems to make a difference and improve things.

You say "OpenTBS tries to find and delete such elements. But when it seems hazardous to delete an element, OpenTBS let it as it is. So you may sometimes be bothered by TBS tags that seems to not be recognized or be cut."

I understand why it will not delete this but can you make the TBS code write an error into the log or even better via... [code][onshow..error_msg][/code] My main issue is that I cannot easily tell if I have a problem by looking at the template and I have to test every permutation which is a problem for a large template.

Thanks 2014-10-27 18:19:14 http://www.tinybutstrong.com/forum.php?msg_id=14545 fixed 2014-10-21 01:09:19 http://www.tinybutstrong.com/forum.php?msg_id=14447 Hello Walter,

It seems to can easily achieve this using the parameter "onformat".

Simple example:

PHP:[code]
function f_format_div($FieldName,&$CurrVal,&$CurrPrm) {
$CurrVal = $CurrVal / $CurrPrm['value2'];
}
[/code]

Template:[code]
[block1:block=begin]

value=[block1.num] equal to [block1.num;onformat=f_format_div;value2=29]

[block1:block=end]
[/code]

2014-09-08 18:10:52