AnsweredAssumed Answered

vrf VXL (excel) problem

Question asked by VRFuser on Jan 11, 2006
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><TITLE>Message</TITLE><META http-equiv=Content-Type content="text/html; charset=iso-8859-1"><META content="MSHTML 6.00.2800.1522" name=GENERATOR><STYLE>@font-face {     font-family: MS Mincho;}@font-face {     font-family: Tahoma;}@font-face {     font-family: @MS Mincho;}@page Section1 {size: 595.3pt 841.9pt; margin: 70.85pt 70.85pt 2.0cm 70.85pt; }P.MsoNormal {     FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"}LI.MsoNormal {     FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"}DIV.MsoNormal {     FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"}A:link {     COLOR: blue; TEXT-DECORATION: underline}SPAN.MsoHyperlink {     COLOR: blue; TEXT-DECORATION: underline}A:visited {     COLOR: purple; TEXT-DECORATION: underline}SPAN.MsoHyperlinkFollowed {     COLOR: purple; TEXT-DECORATION: underline}SPAN.emailformatvorlage17 {     COLOR: navy; FONT-FAMILY: Arial}SPAN.EmailFormatvorlage18 {     COLOR: navy; FONT-FAMILY: Arial}DIV.Section1 {     page: Section1}</STYLE></HEAD><BODY lang=DE vLink=purple link=blue><DIV><SPAN class=457283316-11012006><FONT face=Arial color=#0000ff size=2>Hi</FONT></SPAN></DIV><DIV><SPAN class=457283316-11012006><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV><DIV><SPAN class=457283316-11012006><FONT face=Arial color=#0000ff size=2>In VEE I select the format 0.00 there is no slection for 0,00. </FONT></SPAN></DIV><DIV><SPAN class=457283316-11012006><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV><DIV><SPAN class=457283316-11012006><FONT face=Arial color=#0000ff size=2>Also I am in the UK so the default format we use in excel is 0.00</FONT></SPAN></DIV><DIV><SPAN class=457283316-11012006><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV><DIV><SPAN class=457283316-11012006><FONT face=Arial color=#0000ff size=2>Simon</FONT></SPAN></DIV><BLOCKQUOTE style="MARGIN-RIGHT: 0px">  <DIV></DIV>  <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT   face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Baranski, Detlef   [mailto:Detlef.Baranski@pilkington.de] <BR><B>Sent:</B> 11 January 2006   16:16<BR><B>To:</B> VRF<BR><B>Subject:</B> AW: [vrf] VXL (excel)   problem<BR><BR></FONT></DIV>  <DIV class=Section1>  <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN lang=EN-GB   style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Just to make   sure:</SPAN></FONT></P>  <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN lang=EN-GB   style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Are you using 10.23   format or 10,23 format like a different Version form english to german    or someoneelse localisation ?</SPAN></FONT></P>  <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN lang=EN-GB   style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">In your example I can   not change the text to numbers until  search and replace  . to   ,   ( point to comma ). Then it works.</SPAN></FONT></P>  <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN lang=EN-GB   style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face=Tahoma size=2><SPAN   style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Ursprngliche   Nachricht-----<BR><B><SPAN style="FONT-WEIGHT: bold">Von:</SPAN></B> Simon   Parfitt [mailto:Simon.Parfitt@renesas.com] <BR><B><SPAN   style="FONT-WEIGHT: bold">Gesendet:</SPAN></B> Mittwoch, 11. Januar 2006   17:08<BR><B><SPAN style="FONT-WEIGHT: bold">An:</SPAN></B> VRF<BR><B><SPAN   style="FONT-WEIGHT: bold">Betreff:</SPAN></B> FW: [vrf] VXL (excel)   problem</SPAN></FONT></P>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face="Times New Roman"   size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>  <DIV>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face="Times New Roman"   size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>  <P class=MsoNormal   style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 35.4pt; MARGIN-RIGHT: 0cm"><FONT   face=Tahoma size=2><SPAN lang=EN-US   style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original   Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Simon   Parfitt <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> 11 January   2006 16:07<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> 'Baranski,   Detlef'<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [vrf]   VXL (excel) problem</SPAN></FONT></P>  <DIV>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face=Arial color=blue   size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Hi   </SPAN></FONT></P></DIV>  <DIV>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face="Times New Roman"   size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>  <DIV>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face=Arial color=blue   size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">If I try   to set the cell/cells via the format menu it shows the cells set to number two   dec place ie as VEE set them. But the cells are still set to   text.</SPAN></FONT></P></DIV>  <DIV>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face="Times New Roman"   size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>  <DIV>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face=Arial color=blue   size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">If i   double click on the cell and then select the green tice the cell is   correct.</SPAN></FONT></P></DIV>  <DIV>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face="Times New Roman"   size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>  <DIV>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face=Arial color=blue   size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">find excel   workbook attached</SPAN></FONT></P></DIV>  <DIV>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face="Times New Roman"   size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>  <DIV>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face=Arial color=blue   size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Simon</SPAN></FONT></P></DIV>  <DIV>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face="Times New Roman"   size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>  <BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0cm">    <P class=MsoNormal     style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 35.4pt; MARGIN-RIGHT: 0cm"><FONT     face=Tahoma size=2><SPAN lang=EN-US     style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original     Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>     Baranski, Detlef [mailto:Detlef.Baranski@pilkington.de] <BR><B><SPAN     style="FONT-WEIGHT: bold">Sent:</SPAN></B> 11 January 2006 15:54<BR><B><SPAN     style="FONT-WEIGHT: bold">To:</SPAN></B> Simon Parfitt; VRF<BR><B><SPAN     style="FONT-WEIGHT: bold">Subject:</SPAN></B> AW: [vrf] VXL (excel)     problem</SPAN></FONT></P>    <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face=Arial color=navy     size=2><SPAN lang=EN-GB     style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Can you use the     Format Data  Menue in Excel directly without problems     ?</SPAN></FONT></P>    <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face=Tahoma     size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Ursprngliche     Nachricht-----<BR><B><SPAN style="FONT-WEIGHT: bold">Von:</SPAN></B> Simon     Parfitt [mailto:Simon.Parfitt@renesas.com] <BR><B><SPAN     style="FONT-WEIGHT: bold">Gesendet:</SPAN></B> Mittwoch, 11. Januar 2006     15:49<BR><B><SPAN style="FONT-WEIGHT: bold">An:</SPAN></B> VRF<BR><B><SPAN     style="FONT-WEIGHT: bold">Betreff:</SPAN></B> [vrf] VXL (excel)     problem</SPAN></FONT></P>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face=Arial size=2><SPAN     style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi again</SPAN></FONT></P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face=Arial size=2><SPAN     style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Quick question/problem about     VXL.</SPAN></FONT></P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face=Arial size=2><SPAN     style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am writing a 2d array to excel     using vxl (attached) Now this works just fine. But when I try to format to     data to a number type to two dec places it fails to     work.</SPAN></FONT></P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face=Arial size=2><SPAN     style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The array I am writing is text     because it might contain text!! ie things like NAN fail...... But the     numbers are in format 123.456E+12 etc.</SPAN></FONT></P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face=Arial size=2><SPAN     style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">When I the excel the numbers are     all in text format or apper to be. If I try to format the cell from within     excel the cell is already set to number two dec     places.</SPAN></FONT></P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face=Arial size=2><SPAN     style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Now if i double click on a cell     and then click on the green tick box the cell formats to number two dec     places!!</SPAN></FONT></P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face=Arial size=2><SPAN     style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Can someone explain why all this     happens and how to format the cells from vee.</SPAN></FONT></P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face=Arial size=2><SPAN     style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks in     advance</SPAN></FONT></P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face=Arial size=2><SPAN     style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Simon     Parfitt</SPAN></FONT></P></DIV>    <DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>    <P class=MsoNormal style="MARGIN-LEFT: 70.8pt"><FONT face="Times New Roman"     size=3><SPAN style="FONT-SIZE: 12pt"><BR>--- <BR>You are currently     subscribed to vrf as: Detlef.Baranski@pilkington.de <BR>To subscribe send a     blank email to "join-vrf@it.lists.it.agilent.com". <BR>To unsubscribe send a     blank email to "leave-vrf@it.lists.it.agilent.com". <BR>To send messages to     this mailing list, email "vrf@agilent.com". <BR>If you need help with the     mailing list send a message to "owner-vrf@it.lists.it.agilent.com".     <BR>Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".     </SPAN></FONT></P></BLOCKQUOTE>  <P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face="Times New Roman"   size=3><SPAN style="FONT-SIZE: 12pt"><BR>--- <BR>You are currently subscribed   to vrf as: Detlef.Baranski@pilkington.de <BR>To subscribe send a blank email   to "join-vrf@it.lists.it.agilent.com". <BR>To unsubscribe send a blank email   to "leave-vrf@it.lists.it.agilent.com". <BR>To send messages to this mailing   list, email "vrf@agilent.com". <BR>If you need help with the mailing list send   a message to "owner-vrf@it.lists.it.agilent.com". <BR>Search the "unofficial   vrf archive" at "www.oswegosw.com/vrf_archive/".   </SPAN></FONT></P></DIV><BR>--- <BR>You are currently subscribed to vrf as:   simon.parfitt@renesas.com <BR>To subscribe send a blank email to   "join-vrf@it.lists.it.agilent.com". <BR>To unsubscribe send a blank email to   "leave-vrf@it.lists.it.agilent.com". <BR>To send messages to this mailing   list, email "vrf@agilent.com". <BR>If you need help with the mailing list send   a message to "owner-vrf@it.lists.it.agilent.com". <BR>Search the "unofficial   vrf archive" at "www.oswegosw.com/vrf_archive/". </BLOCKQUOTE><BR>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list,  email "vrf@agilent.com".  <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".<BR>Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".</BODY></HTML>  

Outcomes