Re: [U2] Export to Excel using XML

2013-10-25 Thread John Castilletti
Funny how you have had success with this product when 
I have tried for what seems a year now with no success!
 


 From: George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org 
Sent: Thursday, October 17, 2013 9:28 AM
Subject: Re: [U2] Export to Excel using XML
  

Tony,

Great link - thanks.

Thanks for expressing the pain that my clients do not. You are my new, best 
marketing resource.

No problemwhen I first read that, I thought it was going to say I wrote a 
new blog entry over this..

It's not so much the cost of implementing a product, but the time involved to 
integrate it.

I was just looking for a quick conversion type utility (which I will post in a 
followup)

Thanks
George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Wednesday, October 16, 2013 6:53 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Export to Excel using XML

Correct. It makes more sense if you know that the ss:Format attribute is really 
a complex field that describes what to do with positive numbers, negative 
numbers, zero, and then finally with text. Using @ you're saying you don't 
want any formatting for numbers, only for text, and further, that you don't 
want to change the text that's there. If you wanted to include specific text 
for every cell, you would put it before the @. For examples of these formatting 
codes, right click a cell, go to Format Cells, Number, Custom, then scroll down 
through the list to the bottom.

For details on that topic:
http://office.microsoft.com/en-us/excel-help/create-or-delete-a-custom-number-format-HP001216503.aspx

To keep this in context with MV, NebulaXLite includes named formats so that you 
don't need to know this stuff, but it also allows you to enter custom codes 
when you want to take it to the next level. The product documentation helps 
with this.

Thanks for expressing the pain that my clients do not. You are my new, best 
marketing resource.

BTW, (duh) I forgot to mention that NebulaXLite is free for developers. All you 
need to do is to download the account for your platform, 
generate an activation request from TCL, and we'll return a key for a 
couple months. That gets renewed for as long as you want. No charge and no 
grief. The cost of only $200 (with free support) is only for end-users, and 
only after you have completed your development and they're running production. 
How tough is that?  ;)

Regards,
T



On Wednesday, October 16, 2013 1:52 PM, George Gallen wrote:

After saving the XML2003 from Excel, looks like NumberFormat ss:Format=@ is 
for Text???
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Export to Excel using XML

2013-10-25 Thread George Gallen
With which product?

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Castilletti
Sent: Friday, October 25, 2013 6:54 AM
To: U2 Users List
Subject: Re: [U2] Export to Excel using XML

Funny how you have had success with this product when 
I have tried for what seems a year now with no success!
 


 From: George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org 
Sent: Thursday, October 17, 2013 9:28 AM
Subject: Re: [U2] Export to Excel using XML
  

Tony,

Great link - thanks.

Thanks for expressing the pain that my clients do not. You are my new, best 
marketing resource.

No problemwhen I first read that, I thought it was going to say I wrote a 
new blog entry over this..

It's not so much the cost of implementing a product, but the time involved to 
integrate it.

I was just looking for a quick conversion type utility (which I will post in a 
followup)

Thanks
George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Wednesday, October 16, 2013 6:53 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Export to Excel using XML

Correct. It makes more sense if you know that the ss:Format attribute is really 
a complex field that describes what to do with positive numbers, negative 
numbers, zero, and then finally with text. Using @ you're saying you don't 
want any formatting for numbers, only for text, and further, that you don't 
want to change the text that's there. If you wanted to include specific text 
for every cell, you would put it before the @. For examples of these formatting 
codes, right click a cell, go to Format Cells, Number, Custom, then scroll down 
through the list to the bottom.

For details on that topic:
http://office.microsoft.com/en-us/excel-help/create-or-delete-a-custom-number-format-HP001216503.aspx

To keep this in context with MV, NebulaXLite includes named formats so that you 
don't need to know this stuff, but it also allows you to enter custom codes 
when you want to take it to the next level. The product documentation helps 
with this.

Thanks for expressing the pain that my clients do not. You are my new, best 
marketing resource.

BTW, (duh) I forgot to mention that NebulaXLite is free for developers. All you 
need to do is to download the account for your platform, 
generate an activation request from TCL, and we'll return a key for a 
couple months. That gets renewed for as long as you want. No charge and no 
grief. The cost of only $200 (with free support) is only for end-users, and 
only after you have completed your development and they're running production. 
How tough is that?  ;)

Regards,
T



On Wednesday, October 16, 2013 1:52 PM, George Gallen wrote:

After saving the XML2003 from Excel, looks like NumberFormat ss:Format=@ is 
for Text???
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users