on 2011 Jan 28 2:08 AM
Hello,
I have a combo box that has the following labels: Avg Cost, Total Days, Total Cost.
The labels are in columns in a spreadsheet going across. Not in rows...
So my label range is A1:A3...
When I look at the combo box on the design all the labels are populated in the list.
But when I "preview" the combo box it shows up totally empty...
Can someone please help?
You are correct the exact location of the labels are in columns, I wrote it wrong previously.
It's Sheet1!$G$4:$I$4. And I tried it with the combo box component and the listbox component.
I get the exact same behavior. The list is populated in design mode. But when I preview they disappear.
I tried it with rows to see if they worked with the labels in rows and they both work fine with the labels in rows.
But mine have to be in columns. So that won't work for me.
Is there a fix for this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello DashBoardNewbie,
You have said that the selection for Combo Box is in columns going across, then the range should be from A1:C3. But what you have said is the selection is from A1:A3, which is in rows. So please check whether the range you have selected is the correct range or not.
It doesn't matter whether you have selected the labels for the Combo Box in Columns or in rows. It will always display those labels which you have selected in order. So do check whether you have selected the rest of the properties of Combo Box lile list transparency,or whether you have selected the range for Labels or Title or the Colors have been set properly.
If still you are not able to see then probably it could be a problem with the component. Try the same labels with the filter component and check other components whether they are working properly. If not try reinstalling Xcelsius again since these problems occur sometimes during installation.
Thanks & Regards,
Arjun.C.T
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Your label range you selected wrong .
You mentioned as The label are in columns.
So that you have to select "Sheet1!$A$4:$C$4" ,
Try with this ..
Thanks
Santhu..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.