Hi,
I saw there was a post over 2 years ago, so I'm trying again.
I use template workbook to copy cells into a newly created Excel workbook. If the template is stored with Right to Left direction, I need the newly created workbook to be stored in Right to Left direction as well.
Is this possible? If not, will it be possible in the future?
Is there a workaround for this feature?
Thanks in advance.
<ettigl> wrote in message news:216015@10.0.1.98... Hi, I saw there was a post over 2 years ago, so I'm trying again. I use template workbook to copy cells into a newly created Excel workbook. If the template is stored with Right to Left direction, I need the newly created workbook to be stored in Right to Left direction as well. Is this possible? If not, will it be possible in the future? Is there a workaround for this feature? Thanks in advance. http://helpcentral.componentone.com/cs/forums/p/78707/216015.aspx#216015
James, hi
I'm writing to you after a thoro research of the Microsoft Excel Binary Format, both from Microsoft and from Open Office. I don't know how exactly is the XLS for NET is implemented but if Iunderstand the concept s of Excel (and I think that I understand very well now) you must have worked with Records as defined in the the Microsoft's document or the XLS object would not be read by Excel.
I must say, that I worked extensively with the XLS for NET and it gave me all I needed but with out the need to have Excel on the computer where the application is to be installed. This is very good for me. What I'm missing the the option to mark a sheet to be Right to Left. My clients may open the created Excel files using Microsoft Excel and expect to see the sheet in direction of Right to Left, and although I have tried to implement a different solution only for the Right to Left setting I have failed. I'm writing to you again because I think that for you it will be very easy to implement the change so that a sheet will have the property of RightToLeft along with other properties that are implemented in that specific record.
I'm talking about a record named WINDOW2 which represent UI properties of sheets and I think that XLS for NET is not implementing.
I want to write that I can assit you with this record but I think it is funny to write somehting like this to a company that created the XLS for NET with is a very fine peace of work.
I want to know if there is a chance that this feature will be added soon or do I have to continue look for a solution on this matter by my self.
I'm sorry for the hassle and thank for any reply.
Regards,
Shai Goldberg.