Data validation lists not showing

Post your questions, bug reports and suggestions here for PlanMaker 2010 for Windows Mobile.

Moderator: SoftMaker Team

CRP
Posts: 3
Joined: Fri Sep 10, 2010 11:28 pm

Data validation lists not showing

Postby CRP » Fri Sep 10, 2010 11:35 pm

Hello,
I'm new to Softmaker and the forum.
I have installed Planmaker on my PDA and I was really hoping that I could use custom choice lists (validation). And from what I've seen this is possible.
I have copied an Excel07 .xlsx spreadsheet onto the PDA and it loads fine, but I don't see my drop down lists that I created in Excel. Is there something I'm missing?
I do have the choice lists on a separate worksheet from the drop-down cells in named groups.

Thanks for your help.

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7065
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Data validation lists not showing

Postby sven-l » Mon Sep 13, 2010 9:38 am

Hello,

can you please attach an example file or send it to forum(at)softmaker.de? Thank you!
Sven Leßmann
SoftMaker Software GmbH

CRP
Posts: 3
Joined: Fri Sep 10, 2010 11:28 pm

Re: Data validation lists not showing

Postby CRP » Thu Sep 16, 2010 2:12 am

Thanks for the reply.

I figured out that you have to have the list(s) on the same worksheet. That's how I got them to work anyway.

Can you tell me how I can have a list on a separate worksheet (same file)? The lists are named, which is how they work in Excel.

Thanks.

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7065
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Data validation lists not showing

Postby sven-l » Thu Sep 16, 2010 8:58 am

Hello,

it should work if you create a new worksheet and create a listbox via Object=>New Forms Object=>Listbox. In the properties of that box, in "Forms Object" you can enter the list area. For example, if your data is in Worksheet 1 in the cells A5:A8, type in "=Sheet1!$A$5:$A$8" into the field "List area".
Sven Leßmann
SoftMaker Software GmbH

CRP
Posts: 3
Joined: Fri Sep 10, 2010 11:28 pm

Re: Data validation lists not showing

Postby CRP » Sun Sep 19, 2010 5:49 am

Thanks!
I'll give that a try.


Return to “PlanMaker 2010 for Windows Mobile”

Who is online

Users browsing this forum: No registered users and 2 guests