AnsweredAssumed Answered

vrf VXL (excel) problem

Question asked by VRFuser on Jan 11, 2006

Like • Show 0 Likes0
Comment • 9

<!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>Hi</DIV><DIV> </DIV><DIV>In VEE I select the format 0.00 there is no slection for 0,00. </DIV><DIV> </DIV><DIV>Also I am in the UK so the default format we use in excel is 0.00</DIV><DIV> </DIV><DIV>Simon</DIV><BLOCKQUOTE style="MARGIN-RIGHT: 0px"> <DIV></DIV> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>-----Original Message----- From: Baranski, Detlef [mailto:Detlef.Baranski@pilkington.de] Sent: 11 January 2006 16:16 To: VRF Subject: AW: [vrf] VXL (excel) problem </DIV> <DIV class=Section1> Just to make sure: Are you using 10.23 format or 10,23 format like a different Version form english to german or someoneelse localisation ? In your example I can not change the text to numbers until search and replace . to , ( point to comma ). Then it works. -----Ursprngliche Nachricht----- Von: Simon Parfitt [mailto:Simon.Parfitt@renesas.com] Gesendet: Mittwoch, 11. Januar 2006 17:08 An: VRF Betreff: FW: [vrf] VXL (excel) problem <DIV> </DIV> -----Original Message----- From: Simon Parfitt Sent: 11 January 2006 16:07 To: 'Baranski, Detlef' Subject: RE: [vrf] VXL (excel) problem <DIV> Hi </DIV> <DIV> </DIV> <DIV> 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.</DIV> <DIV> </DIV> <DIV> If i double click on the cell and then select the green tice the cell is correct.</DIV> <DIV> </DIV> <DIV> find excel workbook attached</DIV> <DIV> </DIV> <DIV> Simon</DIV> <DIV> </DIV> <BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0cm"> -----Original Message----- From: Baranski, Detlef [mailto:Detlef.Baranski@pilkington.de] Sent: 11 January 2006 15:54 To: Simon Parfitt; VRF Subject: AW: [vrf] VXL (excel) problem Can you use the Format Data Menue in Excel directly without problems ? -----Ursprngliche Nachricht----- Von: Simon Parfitt [mailto:Simon.Parfitt@renesas.com] Gesendet: Mittwoch, 11. Januar 2006 15:49 An: VRF Betreff: [vrf] VXL (excel) problem <DIV> Hi again</DIV> <DIV> </DIV> <DIV> Quick question/problem about VXL.</DIV> <DIV> </DIV> <DIV> 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.</DIV> <DIV> </DIV> <DIV> 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.</DIV> <DIV> </DIV> <DIV> 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.</DIV> <DIV> </DIV> <DIV> Now if i double click on a cell and then click on the green tick box the cell formats to number two dec places!!</DIV> <DIV> </DIV> <DIV> Can someone explain why all this happens and how to format the cells from vee.</DIV> <DIV> </DIV> <DIV> Thanks in advance</DIV> <DIV> </DIV> <DIV> Simon Parfitt</DIV> <DIV> </DIV> --- You are currently subscribed to vrf as: Detlef.Baranski@pilkington.de To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/". </BLOCKQUOTE> --- You are currently subscribed to vrf as: Detlef.Baranski@pilkington.de To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/". </DIV> --- You are currently subscribed to vrf as: simon.parfitt@renesas.com To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/". </BLOCKQUOTE> --- You are currently subscribed to vrf as: rsb@soco.agilent.com To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".</BODY></HTML>

No one else has this question

Outcomes

9 Replies

VRFuser Jan 10, 2006 5:39 PM
Mark Correct
Correct Answer

Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Like • Show 0 Likes0
Actions
VRFuser Jan 10, 2006 6:29 PM
Mark Correct
Correct Answer

Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Like • Show 0 Likes0
Actions
VRFuser Jan 10, 2006 6:41 PM
Mark Correct
Correct Answer

Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Like • Show 0 Likes0
Actions
VRFuser Jan 10, 2006 7:29 PM
Mark Correct
Correct Answer

Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Like • Show 0 Likes0
Actions
VRFuser Jan 10, 2006 7:39 PM
Mark Correct
Correct Answer

Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Like • Show 0 Likes0
Actions
VRFuser Jan 10, 2006 8:12 PM
Mark Correct
Correct Answer
</BODY></HTML>
Like • Show 0 Likes0
Actions
VRFuser Jan 10, 2006 10:48 PM
Mark Correct
Correct Answer
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><html><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 10 (filtered)"><title>LAN (TCP/IP) instrument</title><style></style></head><body lang=DE link=blue vlink=purple><div class=Section1><spanlang=EN-GB style='font-size:12.0pt;color:navy'>There is a new nice proggi from Bratbaecker for free download available. It shows how to use menue like windows.<spanlang=EN-GB style='font-size:12.0pt;color:navy'>It is a very nice applicationwhich can be easily adapted for your needs. Size is 385 kB so you can see thatit includes a lot !<spanlang=EN-GB style='font-size:12.0pt;color:navy'>Some additionial information isavailable on german, but I think the pictures do expain themselves...<spanlang=EN-GB style='font-size:12.0pt;color:navy'>Have a look at <spanlang=EN-GB style='font-size:12.0pt;color:navy'><a href="http://www.my-vee.de/">http://www.my-vee.de</a><spanlang=EN-GB style='font-size:12.0pt;color:navy'> <spanlang=EN-GB style='font-size:12.0pt;color:navy'>under downloads.<spanlang=EN-GB style='font-size:12.0pt;color:navy'> <spanlang=EN-GB style='font-size:12.0pt;color:navy'>It is free under own risk;-)<spanlang=EN-GB style='font-size:12.0pt;color:navy'>detlef </div> --- You are currently subscribed to vrf as: rsb@soco.agilent.com To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com". To send messages to this mailing list, email "vrf@agilent.com". If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".</BODY></html>
Like • Show 0 Likes0
Actions
VRFuser Jan 11, 2006 12:02 AM
Mark Correct
Correct Answer
Hi Shawn

Yes it is correct

Simon

-----Original Message-----
From: Shawn Fessenden [mailto:shawn@testech-ltd.com]
Sent: 11 January 2006 15:39
To: VRF
Subject: RE: [vrf] VXL (excel) problem

> But when I try to format to data to a
> number type to two dec places it fails
> to work.

I'd be curious about the Range parameter. Is it really a Range and is it
equal to what the Range actually is.
-SHAWN-

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Like • Show 0 Likes0
Actions
VRFuser Jan 11, 2006 12:32 AM
Mark Correct
Correct Answer
Yes Shawn,

But I could have text values within my array!! I do not know in advance what
is in the array. I could write each cell one at a time by going through
every element of the array, but then I lose the speed advantage of just
writing an array.

Simon

-----Original Message-----
From: Shawn Fessenden [mailto:shawn@testech-ltd.com]
Sent: 11 January 2006 16:29
To: Simon Parfitt; 'VRF'
Subject: RE: [vrf] VXL (excel) problem

> Yes it is correct

Mkay. I'm beginning to understand. It doesn't work here either. My theory so
far is because data are entered as text number formats have no effect, so
the problem is converting the values to numbers before formatting.
-SHAWN-

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Like • Show 0 Likes0
Actions

vrf VXL (excel) problem

Outcomes

Related Content

Recommended Content