RE: [sqr-users] Using SYLK.sqc - writing currency toaspreadsheetsothat the cu rrency symbol appears on the left

["Jim Womeldorf" <jwomeldo@fastenal.com>]

Hi folks,
I always get a bit excited when I see someone using SYLK.SQC :)  I only deal I 
English so I have not run into this.  

Do a 'save as type' of SYLK to an Excel spreadsheet that is behaving the way 
you want it to behave.  (Excel will try to talk you out of it, but be 
persistent and save it that way anyhow.)

Close Excel and open the file you just saved.  If it appears with the 
formatting as you wish then I must have missed something in coding the SQC.  
Perhaps one of you can figure it out.  

If the formatting is the same as it is with the SQC-created files then it is 
probably a 'feature' of either SYLK or Excel.

Jim

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org 
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org] On Behalf Of 
Sengupta, Rajib (Contractor)
Sent: Wednesday, May 24, 2006 2:49 PM
To: This list is for discussion about the SQR database reportinglanguage from 
Hyperion Solutions.
Subject: RE: [sqr-users] Using SYLK.sqc - writing currency to 
aspreadsheetsothat the cu rrency symbol appears on the left

But in excel you can format as French currency in which $ will appear at right. 
There is some problem in the program

Rajib Sengupta
Project Manager
Peoplesoft Consultant - ConagraFoods Inc
402-952-2144 

-----Original Message-----
From: sqr-users-bounces+rajib.sengupta=conagrafoods.com@sqrug.org 
[mailto:sqr-users-bounces+rajib.sengupta=conagrafoods.com@sqrug.org] On Behalf 
Of Knapp, Richard
Sent: Wednesday, May 24, 2006 2:16 PM
To: This list is for discussion about the SQR database reportinglanguage 
fromHyperion Solutions.
Subject: RE: [sqr-users] Using SYLK.sqc - writing currency to a 
spreadsheetsothat the cu rrency symbol appears on the left


Talk to Bill (Gates, that is).  This is an Excel problem, not something you can 
control from SQR especially since the feature is not present in the destination 
application, no?

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org 
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of 
SandlerA@DFO-MPO.GC.CA
Sent: Wednesday, May 24, 2006 1:27 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Using SYLK.sqc - writing currency to a spreadsheet sothat 
the cu rrency symbol appears on the left

Hi All,
 
I have many reports where I am writing both an SQR output and writing to a 
spreadsheet.  I write to the spreadsheet using SYLK.SQC.  I need to produce the 
output in both French and English (i.e. if and English user runs the report the 
headings and formatting are in English while if a French user runs the report, 
the headings and formatting are in French).
 
On many of the reports, I need to write dollar figures to the spreadsheet.
In English, the format should be $999,999.99.  This works without any problem.  
In French, the format should look like 999 999,99$.  On the SQR output this 
works fine.  However, in writing to Excel, the dollar sign always appears on 
the left side of the number not the right.  The spacing and the commas on the 
spreadsheet do appear where they are supposed; just the dollar sign does not.  
The position of the currency symbol should be a function of the Windows 
regional settings; no matter how I set these, the currency symbol always 
appears on the left.
 
I do need to write these values to the spreadsheet as numbers (not as 
characters, so I cannot set the format that way).  While the users know that 
they can change the format on the spreadsheet, they would rather that it appear 
from the report output as they want to see it.
 
We are in a Windows environment.  The reports are generated on a Metaframe 
server running Windows 2000.  The users view the spreadsheet on their own 
desktops.  Most of these are running Windows XP and the regional settings are 
either English or French depending on the users preference.
 
The reports are created in SQR version 6.2 and are run as compiled reports from 
Maximo 4.1.1.
 
Does anyone know how I can write to the spreadsheet so that the currency symbol 
will appear to the right of the number on French reports?
 
Thank you.
Aaron Sandler
(613) 991-4862 |facsimile/télécopieur (613) 993-4811

SandlerA@dfo-mpo.gc.ca <mailto:SandlerA@dfo-mpo.gc.ca>  

MIMS Technical Team |Équipe technique SGIE

Canadian Coast Guard|Garde côtière canadienne

437 - 360 Laurier, Ottawa, ON  K1P 1C8

Government of Canada| Gouvernement du Canada

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users