<!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>
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".