Hello.

I have a table, with various values and see correctly, for example:

Love,

Dark,

Other

In the sql data, I have 

Love,<br />Dark,<br />Other<br />

But, when i charge the report, with ${themes}, the data are:

Love,Dark,Other.

I need that te report respect the </br> and put a /n in the line, the result should be:

Love,

Dark,

Other

Is possible?

Hello.

The table is in a local server.

The problem is these:

In phpmyadmin, I have a table with data, with values separates by <br/>.

For example, the field, her name is "themes conversation", from the table "themes people"

Love,<br />Dark,<br />Other,<br />Because,<br />Philp,<br />Valentin,<br />Data,<br />Remove,<br />Back order<br />

When I put these field in wpdatatablets, are put correctly, and see each word in a phrase, these is the result:

Love,

Dark,

Other,

Because,

Philp,

Valentin,

Data,

Remove,

Back order

The problem are in the report builder, when i created the .doc with the report, the values from these field that are named ${theme_conversation), but the result in the report in .doc are these:

Love,Dark,Other,,Because,Philp,Valentin,Data,Remove,,Back order

I need that the result on the report are the same how the wpdatatable, the result that need are:

Love,

Dark,

Other,

Because,

Philp,

Valentin,

Data,

Remove,

Back order

do you know how to resolve these problem?

Thanks

I have this same request, please post a public solution if you find one.

Column D specifically in the .xlsx, my goal is to get the <br>'s to either disappear or actually break the lines.

Hello Milos

I send the data the next monday, because i have the data in the office.

Thanks for all!

Hello Milos.

I send and email to [email protected] with the data that you need, thanks for all

Hi Milos.

My code is a bit different:

    protected function getCellOutput( $columnKey, $cellValue ){
        $return_val = $this->_wpDataTable
                            ->getColumn( $columnKey )
                            ->getTextBefore();
        switch( $this->_wpDataTable->getColumn( $columnKey )->getType() ){
            case 'link':
            case 'image':
            case 'string':
            case 'email':
                $return_val .=
                    stripslashes(
                        strip_tags(
                            $this->_wpDataTable
                            ->getColumn( $columnKey )
                            ->returnCellValue( $cellValue )
                        )
                    );
                break;
            case 'int':
            case 'float':
            case 'formula':
                // Remove thousands separator for data pulled from front-end
                if( $this->_filteredData != null && is_string( $cellValue ) ){
                    $cellValue = self::unformatNumber( $cellValue );
                }
            default:
                $return_val .= $this->_wpDataTable
                    ->getColumn( $columnKey )
                    ->returnCellValue( $cellValue );
        }
        $return_val .= $this->_wpDataTable
                            ->getColumn( $columnKey )
                            ->getTextAfter();
        if( $return_val === '' ){ $return_val = ' '; }
        return apply_filters( 'reportbuilder_before_render_cell_output', $return_val, $this->_wpDataTable->getColumn( $columnKey )->getType() );

    }

That need to change, i dont want remove the br, i need that in the zone that exist a br, i put a jum line (how if you put a /n).

How the example that i send in the email

Hello.

I put the data, but dont work.

$cellValue = str_replace("<br>"," \n ", $cellValue); 

The replace is correct, for example if i put:

$cellValue = str_replace("<br>"," test ", $cellValue); 

The result are 

Love, test Dark, test Other, test Because,

But when i put 

$cellValue = str_replace("<br>"," \n ", $cellValue); 

The result are the same, no put a new line.

Hi Milos

I replace, but dont working, put a blank space , but not a new line:

case 'link':
            case 'image':
            case 'string':
            case 'email':
                $cellValue = str_replace("<br>"," \n ", $cellValue);
$return_val .=
$this->_wpDataTable
->getColumn( $columnKey )
->returnCellValue( $cellValue );
break;

The result before the modify:

Casa,Mar,Palacio

The result after the modify:

Casa,    Mar,    Palacio

In the table from wpdatable, the data from the field when inspect with control+u, is :

<td style class =" Marcos">

"Casa, "

<br>

"Mar, "

<br>

"Palacio"

</td>

In the field from wpdatable are fine, but in the reportbuilder dont

Thanks

Hello.

I dont understand, it is not my data...my data send you in a email.

These data are from the person weihs5  that asked in the same thread that me......my data are that i send in the email, with field "personajes", etc

I see that the different are that her BR are text, not a html tag, in my data are html tag.

Its not and error from word, my version from report are 1.0.1

Please, see the data that i send to an email, not the data from weihs5 , that is not my error, and not mixing problems

Thanks

Thanks!!

I have a update the version 1.0.1 and 1.0.2 and work!.

I have another problem, that in the version 1.0.1 dont have...

In the text, The report cut the text, for example in the <td> from wpdatatable:

These are the result in the report

Thanks!!!

Hi

Thanks for all, if you see the data, in these zone:

"These is the data from the person that work in these data"

In the report the data is cut, and the data are:

"These is the data from the pe"

In the 1.0.1 was work fine, i updated the report builder to 1.0.2 and the br work fine, but these are and new error, and the error is that the reportbuilder cut long phrases.

Thanks

Thanks.

I send you tomorrow the data.

Other problem that in the new version, there are 2 options that need and is dissapear in the new version:

Version 1.0.1 wpdatatables have "limit table layout" and "word wrap", and in the 1.0.2 not have these options.

thanks

Hello.

Thanks for all, the problem are fixed with your indications!

I fixed all the problems, one of the problem was in the sentence:

$cellValue = str_replace("<br>"," \n ", $cellValue); 

The sentence not working in microsoft office, but i se that the plugin work to phpworld.

If change the sentence for these:

$cellValue = str_replace("<br>","\n<w:br/>", $cellValue);

Work in microsoft office and open office ;)

Thanks for all!

Thanks Milos.

If i can ask a final question, is possible to the plugin convert to .doc to pdf.

For example, in my table when download the reports, i have a .zip with 3 .doc.

Is possible that the plugin give me a zip with 3 .pdf?

Thanks for all, is a great plugin and a better people that work in these plugin!

I give a great review in CodeCanyon ;)

Thanks for all, for me is all OK in these ticket ;)

Hello again.

A question, i have a problem, in the report are data are ok when use these:

$cellValue = str_replace("<br>","\n<w:br/>", $cellValue);

But, in the export options from wpdatatable (excell, csv,pdf), i have the same problem that i had in the report, that dont put a line in the BR, and all the data are in the same line.

In that line of code and archive, I have to replace the code from the plugin to put these correct code?

$cellValue = str_replace("<br>","\n<w:br/>", $cellValue);

Thanks!

Hello.

The problem that in the wpdatatable is visible correctly, but in the excel, pdf and csv dont.

Put two images, I need only that the result are the same in the wpdatatable and the excell/pdf/csv.

Thanks

Yes, just when the export, the problem exist in the report, but its solved with these replace, that change in the .doc the br from a line:

$cellValue = str_replace("<br>","\n<w:br/>", $cellValue);

But in the Excel, CSV or PDF, I dont know in these line of code i can change put before convert the table in Excel, CSV or PDF, change the valures <br> from other values, from example \n<w:br/> or other character, for example ","

Thanks!

I fully complete the application, a last question.

is possible to change the orientation from the pdf export?

Change the portrait to landscape.

Thanks!

Thanks Milos

Its correct, i have the orientation changed!