I have a list view control and I would like to format the alignment for certain columns. I heard that the only way you can do this is by formatting the cells in excel. I tried this with no success. Can someone please give me step by step instructions on how to achieve this. I am currently allowing Xcelsius to handle my formatting for money. Is it possible to have Xcelsius handle the money formatting and have excel handle the alignment formatting. I am open to whatever works at this point. Also I am using Xcelsius 2008 (Build Number 12,2,1,66).
Hi,
In list view control you can format the entire row only, not a certain column.
Go to property-->Appearance-->Text Tab-->select Header-->Format selected text->select the format.
For width change: Property--> Layout Tab-->check custom column width the click the icon and enter width in pixel.
It is possible to format the List View text as explained by Senthil.
Still if you are failing to succeed, please let us know what are you trying and what you are unable to achieve.
Thanks for the response guys. What I am trying to do though is set the alignment for each column individually so for example column 1 is aligned to the left and column 2 is aligned to the right and column 3 is centered. I know this is not possible in Xcelsius, but it is definitely possible in excel. So I guess the real question is how do I have Xcelsius recognize the formating in excel, or is that even possible...or is there another solution for what I am trying to archive.
For your requirement, you could use a speadsheet table instead of a list view. In a spreadsheet table you can format each column and have your xcelsius component map to that spreadsheet table. I don't think this can be achieved using a list view.
Hope this helps!
- Madhuri
Ok, so I switched to a Spreadsheet control and mapped my data. Not sure where to go from here to edit the alignment differently for each column. Any thoughts?
If you go for Spreadsheet control, the alignment of the column is very easy. You can apply the format in the excel sheet only and assign data to the Spreadsheet control. Then got to property panel --> Behavior tab--> Common--> Uncheck the Row Selectability. If you change the data format in the Spreadsheet, you can re-assign the data to the Spreadsheet control then only it will affect.
