Comments (3)
"1.1" does not work. But seems there is another solution - HTML ...
Copying excel fragment with styles and viewing it with Free Clipboard Viewer gives a hint
<table>
<tr><td>H1</td><td>H2</td><td>H3</td></tr>
<tr><td>abc</td><td style='mso-number-format:"\@"'>1.1</td><td>123,45</td></tr>
</table>
This seems to paste correctly
from text2tab.
Version:1.0
StartHTML:0000000105
EndHTML:0000002495
StartFragment:0000001914
EndFragment:0000002443
<html xmlns:v="urn:schemas-microsoft-com:vml"
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=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 15">
<style>
<!--table
{mso-displayed-decimal-separator:"\,";
mso-displayed-thousand-separator:" ";}
@page
{margin:.75in .7in .75in .7in;
mso-header-margin:.3in;
mso-footer-margin:.3in;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
td
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:204;
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;}
.xl65
{font-size:10.0pt;
font-family:Calibri, sans-serif;
mso-font-charset:0;
vertical-align:middle;
white-space:normal;}
.xl66
{font-size:10.0pt;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:"\@";
vertical-align:middle;
white-space:normal;}
-->
</style>
</head>
<body link="#0563C1" vlink="#954F72">
<table border=0 cellpadding=0 cellspacing=0 width=192 style='border-collapse:
collapse;width:144pt'>
<!--StartFragment-->
<col width=64 span=3 style='width:48pt'>
<tr height=19 style='height:14.4pt'>
<td height=19 class=xl65 width=64 style='height:14.4pt;width:48pt'>H1</td>
<td class=xl65 width=64 style='width:48pt'>H2</td>
<td class=xl65 width=64 style='width:48pt'>H3</td>
</tr>
<tr height=21 style='height:15.6pt'>
<td height=21 class=xl65 width=64 style='height:15.6pt;width:48pt'>abc</td>
<td class=xl66 width=64 style='width:48pt'>1.1</td>
<td class=xl65 align=right width=64 style='width:48pt'>123,45</td>
</tr>
<!--EndFragment-->
</table>
</body>
</html>
Complete fragment, might be useful, e.g. for decimal separator styles
from text2tab.
done in v2.3.4
from text2tab.
Related Issues (12)
- Double quoted values
- parse_float doesn't work with dot as thousand separator HOT 5
- Load corresponding HOT 2
- not_strict by default (breaking) ?
- DO and DElem veri_c08 not in latest S/4 Hana 1709.
- Breaking ideas for next version
- stvarv should be used as default format settings
- Serialization performance improvement
- CUINT conv exit fails if no UoM exists in the system HOT 2
- Need to allow '/' character in field names to support customer namespaces HOT 3
- abaplint config HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from text2tab.