html - white-space: pre; ignored/inconsistent inside <td> in export to (save as) .xls -

-

consider following, in browser: 

<tr>    <td><pre>my  ex       tra   whitespace    preserved</pre></td> </tr> <tr>    <td style="white-space: pre;">my  ex       tra   whitespace    preserved</td> </tr>

but in excel, when open above .html file, whitespaces removed unless use <pre>

this problem because 1 table i'm exporting has 50 columns , ~2000 rows. not balloons size of file (which fine), causes excel crash.

inconsistency

i used pre tags wrap tds this:

<tr>     <pre>     <td>my  ex       tra   whitespace    preserved</td>     <td>my  ex       tra   whitespace    preserved</td>     <td>my  ex       tra   whitespace    preserved</td>     </pre> </tr>

it worked fine. used on 2000 line html table 6 columns.


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more