 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] How to Set Excel To Be From Right To left Report
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] How to Set Excel To Be From Right To left Report Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] How to Set Excel To Be From Right To left Report | Login/Join |
| Member |
Hello All, Im Using 7.1.6 Version Of WF And i have a big problem i mad a reoprt that genret an excel 2003 and the report start from the left side of the excel becuse im using a hebrew leng i need the report to start form the right side of the excel the A column need to be on the right side of the excel when im genret the report. Hope i explained clear enought. version 7.1.6 Windows, excel outputThis message has been edited. Last edited by: Kerry, WebFOCUS 7.1.6 Windows Excel | ||
|
| Expert |
I think that your best bet would be to hope that Danny of SRL will be along to assist you. Alternatively look them up (SRL in Israel). If your company is new to WF they may be able to provide some consultancy (I believe they are IB affilates or similar?) to ease you through your initial learning process. T
| |||||||||
|
| Member |
thet dont know how to help me ther... this is the reason whay im asking your help WebFOCUS 7.1.6 Windows Excel | |||
|
| Expert |
Silly question perhaps, but have you checked out MSDN? T
| |||||||||
|
| Member |
yes i did  still no answer ther  WebFOCUS 7.1.6 Windows Excel | |||
|
| Expert |
As I do not know what hebrew output should look like, is the following anything like your requirement? This one has BYDISPLAY turned OFF and is the equivalent of the code below, however BYDISPLAY = ON would be easier to achieve.  TABLE FILE CAR
SUM RCOST
DCOST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET BYDISPLAY OFF
ENDT
| |||||||||
|
| <JG> |
a very simple template macro ActiveSheet.DisplayRightToLeft = True | ||
|
| Expert |
Which is why I asked about MSDN T
| |||||||||
|
| Member |
sorryyyy my bad!!!!! i did not look for template macro how can i insert macro to my wf report TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL ON TABLE PCHOLD FORMAT EXL2K END tnxxxxxx alott!!! WebFOCUS 7.1.6 Windows Excel | |||
|
| Expert |
Plenty of previous posts about creating Excel templates, also documentation. Search on "mht" T
| |||||||||
|
| Platinum Member |
Hi just to clarify: 1.SRL is IBI's agent in Israel. 2. Its highly recommended to attend webfocus training for new developers 3. WF 7.6.10 introduced a new SET for EXL2K, HTML,AHTML and PDF SET LAYOUTRTL=ON creates an automatic right to left report 4. In previous versions, HTML: using htmlcss with dir=rtl or div align=right with SEQUENCE EXL2K,PDF: using the SEQUENCE attribute in the WF stylesheet to re-arrange the order of the columns from right to left Yours Eran | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] How to Set Excel To Be From Right To left Report
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] How to Set Excel To Be From Right To left ReportCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |