HTML export into Excel, mso-data-placement: same-cell loses the line break -

-

i'm generating html document i'm serving excel spreadsheet. working fine except in first place, excel reading
line breaks new cell. found workaround that, , that's add <style>br { mso-data-placement:same-cell; }</style> sure enough keeps data in same cell, i'm losing line breaks , keeps in same line.

has else had problem?

i can't figure out life of me why happening. here full code:

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/tr/rec-html40"> <head> <meta http-equiv=content-type content="text/html;charset=windows-1252"> <meta name=progid content=excel.sheet/> <meta name=generator content="microsoft excel 11"> <!--[if gte mso 9]><xml>         <x:excelworkbook><x:excelworksheets><x:excelworksheet>                 <x:name>sheet1</x:name>                 <x:worksheetoptions><x:panes>                 </x:panes></x:worksheetoptions>                 </x:excelworksheet></x:excelworksheets></x:excelworkbook> </xml> <![endif]--> <style> br {mso-data-placement:same-cell;} </style> <body> <table>   <tr>     <td colspan="2" style="font-size:14pt;font-weight:bold;"><?= $user['company_name'] ?> file system listing</th>   </tr>   <tr>     <td>&nbsp;</td>   </tr>   <tr>     <td colspan="2">1. enter or sort</td>   </tr>   <tr>     <td width="45">&nbsp;</td>     <td width="300">to enter</td>   </tr>   <tr>     <td>&nbsp;</td>     <td>to pay</td>   </tr>   <tr>     <td>&nbsp;</td>     <td>to do</td>   </tr>   <tr>     <td>&nbsp;</td>     <td>to file- completed</td>   </tr>   <tr>     <td>&nbsp;</td>     <td><?= $user['business_bank'] ?><br>deposit slips</td>   </tr>   <tr>     <td>&nbsp;</td>     <td>receipt sorting <?= $user['business_bank'] ?><br><?= $user['account1_name'] ?> card x<?= $user['account1_debit'] ?><br><?= $user['account1_name'] ?> x<?= $user['account1_num'] ?></td>   </tr> </table> </body> </html>

you don't have closing "head" tag. if still doesn't work, try placing style inline. instance:

<br style="mso-data-placement:same-cell;" />

as opposed being in style tag. excel should evaluating head styles let's check if there's issue there.


Comments

Post a Comment

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

-
the current version of mozilla firefox 23.0.1, version not support play mp3 shoutcast streams tcp port different 80 (most common 8000 shoutcast 1.9.8). i use flash when mp3 support not available in html5 audio, way detect is: try{ var = document.createelement('audio'); r = !!(a.canplaytype && !!a.canplaytype("audio/mpeg; codecs=mp3").replace(/^no$/,'')) }catch(e){ r = false; } the support mp3 shoutcast streams in firefox added in version 24 . a.canplaytype("audio/mpeg; codecs=mp3") = in chrome , firefox, chrome support, firefox not support, due current code detect not work firefox. the current version of jquery support ie 6 1.10.2, version not has .browser i think "stylized" way testing features , not querying browsers / versions, notwithstanding here see hard not violate "principle". what "stylized" way of detect mp3 icy support without navigator.useragent in firefox? ther...
Read more

web - SVG not rendering properly in Firefox -

-
i have problem svg renderring in firefox. whilst works in safari, chrome or in ie, doesn't work in firefox. inspecting element seems layers there, background visible if it's z-index higher z-index of others. rendered in firefox: svg logo in firefox link original source file: svg file thanks help. ps: used sketch 3 export svg. if helps somehow. you're experiencing bug 995813 . i fixed bug time ago change still making way through release process example display correctly firefox 31 onwards released on 22 july 2014. in meantime if move fill="white" <mask> element child <use> element work around firefox bug.
Read more

java - JavaFX 2 slider labelFormatter not being used -

-
i have following code not label slider "foo50", etc... 1 expect setlabelformatter call, instead seems have no effect (the slider labelled 50, 100, etc , println's dont run). there missing? not implemented in default 2.2 skin? using oracle java 7 package javafxbugtest; import javafx.application.application; import javafx.scene.*; import javafx.scene.control.*; import javafx.stage.*; import javafx.util.stringconverter; public class javafxbugtest extends application { @override public void start(final stage primarystage) { slider cp = new slider(); cp.setlabelformatter(new stringconverter<double>() { @override public string tostring(double t) { system.out.println("nope?"); return "foo" + t.tostring(); } @override public double fromstring(string string) { system.out.println("he...
Read more