[Libreoffice-commits] calc/html-import
Kohei Yoshida
kohei at kemper.freedesktop.org
Fri Jul 22 10:33:36 PDT 2011
calc/html-import/css-mso-number-format.html | 166 ++++++++++++++++++++++++++++
1 file changed, 166 insertions(+)
New commits:
commit b060d1fabc652986c5dde806eabb6f474d56f5b4
Author: Kohei Yoshida <kyoshida at novell.com>
Date: Fri Jul 22 13:32:43 2011 -0400
HTML file generated by Excel that includes number formats for cells.
Number formats are specified by the custom mso-number-format CSS
properties.
diff --git a/calc/html-import/css-mso-number-format.html b/calc/html-import/css-mso-number-format.html
new file mode 100644
index 0000000..93c6537
--- /dev/null
+++ b/calc/html-import/css-mso-number-format.html
@@ -0,0 +1,166 @@
+<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 10">
+<link rel=File-List href="css-mso-number-format_files/filelist.xml">
+<link rel=Edit-Time-Data href="css-mso-number-format_files/editdata.mso">
+<link rel=OLE-Object-Data href="css-mso-number-format_files/oledata.mso">
+<!--[if gte mso 9]><xml>
+ <o:DocumentProperties>
+ <o:Author>Kohei Yoshida</o:Author>
+ <o:LastAuthor>Kohei Yoshida</o:LastAuthor>
+ <o:Created>2011-07-22T17:24:43Z</o:Created>
+ <o:LastSaved>2011-07-22T17:28:34Z</o:LastSaved>
+ <o:Company>Novell, Inc.</o:Company>
+ <o:Version>10.2625</o:Version>
+ </o:DocumentProperties>
+ <o:OfficeDocumentSettings>
+ <o:DownloadComponents/>
+ <o:LocationOfComponents HRef="file:///D:\"/>
+ </o:OfficeDocumentSettings>
+</xml><![endif]-->
+<style>
+<!--table
+ {mso-displayed-decimal-separator:"\.";
+ mso-displayed-thousand-separator:"\,";}
+ at page
+ {margin:1.0in .75in 1.0in .75in;
+ mso-header-margin:.5in;
+ mso-footer-margin:.5in;}
+tr
+ {mso-height-source:auto;}
+col
+ {mso-width-source:auto;}
+br
+ {mso-data-placement:same-cell;}
+.style0
+ {mso-number-format:General;
+ text-align:general;
+ vertical-align:bottom;
+ white-space:nowrap;
+ mso-rotate:0;
+ mso-background-source:auto;
+ mso-pattern:auto;
+ color:windowtext;
+ font-size:10.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:Arial;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ border:none;
+ mso-protection:locked visible;
+ mso-style-name:Normal;
+ mso-style-id:0;}
+td
+ {mso-style-parent:style0;
+ padding-top:1px;
+ padding-right:1px;
+ padding-left:1px;
+ mso-ignore:padding;
+ color:windowtext;
+ font-size:10.0pt;
+ font-weight:400;
+ font-style:normal;
+ text-decoration:none;
+ font-family:Arial;
+ mso-generic-font-family:auto;
+ mso-font-charset:0;
+ mso-number-format:General;
+ text-align:general;
+ vertical-align:bottom;
+ border:none;
+ mso-background-source:auto;
+ mso-pattern:auto;
+ mso-protection:locked visible;
+ white-space:nowrap;
+ mso-rotate:0;}
+.xl24
+ {mso-style-parent:style0;
+ mso-number-format:"\0022$\0022\#\,\#\#0\.00";}
+.xl25
+ {mso-style-parent:style0;
+ mso-number-format:"\@";
+ text-align:center;}
+-->
+</style>
+<!--[if gte mso 9]><xml>
+ <x:ExcelWorkbook>
+ <x:ExcelWorksheets>
+ <x:ExcelWorksheet>
+ <x:Name>Sheet1</x:Name>
+ <x:WorksheetOptions>
+ <x:Selected/>
+ <x:Panes>
+ <x:Pane>
+ <x:Number>3</x:Number>
+ <x:ActiveRow>2</x:ActiveRow>
+ <x:ActiveCol>1</x:ActiveCol>
+ </x:Pane>
+ </x:Panes>
+ <x:ProtectContents>False</x:ProtectContents>
+ <x:ProtectObjects>False</x:ProtectObjects>
+ <x:ProtectScenarios>False</x:ProtectScenarios>
+ </x:WorksheetOptions>
+ </x:ExcelWorksheet>
+ <x:ExcelWorksheet>
+ <x:Name>Sheet2</x:Name>
+ <x:WorksheetOptions>
+ <x:ProtectContents>False</x:ProtectContents>
+ <x:ProtectObjects>False</x:ProtectObjects>
+ <x:ProtectScenarios>False</x:ProtectScenarios>
+ </x:WorksheetOptions>
+ </x:ExcelWorksheet>
+ <x:ExcelWorksheet>
+ <x:Name>Sheet3</x:Name>
+ <x:WorksheetOptions>
+ <x:ProtectContents>False</x:ProtectContents>
+ <x:ProtectObjects>False</x:ProtectObjects>
+ <x:ProtectScenarios>False</x:ProtectScenarios>
+ </x:WorksheetOptions>
+ </x:ExcelWorksheet>
+ </x:ExcelWorksheets>
+ <x:WindowHeight>14445</x:WindowHeight>
+ <x:WindowWidth>19980</x:WindowWidth>
+ <x:WindowTopX>360</x:WindowTopX>
+ <x:WindowTopY>75</x:WindowTopY>
+ <x:ProtectStructure>False</x:ProtectStructure>
+ <x:ProtectWindows>False</x:ProtectWindows>
+ </x:ExcelWorkbook>
+</xml><![endif]-->
+</head>
+
+<body link=blue vlink=purple>
+
+<table x:str border=0 cellpadding=0 cellspacing=0 width=307 style='border-collapse:
+ collapse;table-layout:fixed;width:230pt'>
+ <col width=95 style='mso-width-source:userset;mso-width-alt:3474;width:71pt'>
+ <col width=212 style='mso-width-source:userset;mso-width-alt:7753;width:159pt'>
+ <tr height=17 style='height:12.75pt'>
+ <td height=17 width=95 style='height:12.75pt;width:71pt'>Member ID</td>
+ <td class=xl25 width=212 style='width:159pt'>32426439034221343269802</td>
+ </tr>
+ <tr height=17 style='height:12.75pt'>
+ <td height=17 style='height:12.75pt'>Income</td>
+ <td class=xl24 align=right x:num="123030.34">$123,030.34</td>
+ </tr>
+ <tr height=17 style='height:12.75pt'>
+ <td height=17 style='height:12.75pt'>Expense</td>
+ <td class=xl24 align=right x:num="93223.23">$93,223.23</td>
+ </tr>
+ <![if supportMisalignedColumns]>
+ <tr height=0 style='display:none'>
+ <td width=95 style='width:71pt'></td>
+ <td width=212 style='width:159pt'></td>
+ </tr>
+ <![endif]>
+</table>
+
+</body>
+
+</html>
More information about the Libreoffice-commits
mailing list