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 output

This message has been edited. Last edited by: Kerry,

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

thet dont know how to help me ther...
this is the reason whay im asking your help

Silly question perhaps, but have you checked out MSDN?

T

yes i did
still no answer ther

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
END

T

a very simple template macro

ActiveSheet.DisplayRightToLeft = True

Which is why I asked about MSDN

T

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!!!

Plenty of previous posts about creating Excel templates, also documentation.

Search on "mht"

T

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