Actually that's something else I wanted to ask about but wasn't going to do so until I'd done a little bit of study. This spreadsheet has some pulldown arrows that pop up a list of choices. The list is located elsewhere in the spreadsheet and the control points at the start of the list. It's great for one aspect of what I'm doing - a function that takes a sort of strange text input with these 5 choices as user input: D, DG, V, DV, DGV. In the Excel version (I'm using Excel because that's the sample file I was given) this pull down chooses which ever one of these that I want. However when I try building this myself the associated cell doesn't get these text values but rather the numbers 1-5. I can change the table that has what shows up in the pull down, changing DGV to the word 'really' and I see 'really' in the pull down. However the associated cell always gets the numbers and never the text.
So, first question, does OOCalc even HAVE a 'Designer' area like Excel where I can instantiate these pulldowns? - Mark On Thu, Aug 21, 2008 at 1:05 PM, Dave Craven <[EMAIL PROTECTED]> wrote: > Another option (in M$ Excel) is "Data Validation" which forces the user > to leave a cell blank or select from a drop down list (which is held in > a hidden column). > Haven't done this in OOo. > > >> -----Original Message----- >> From: Mark Knecht [mailto:[EMAIL PROTECTED] >> Sent: Thursday, August 21, 2008 11:41 AM >> To: [email protected]; [EMAIL PROTECTED] >> Subject: Re: [users] Cell formatting question >> >> Anthony, >> Thanks. That does seem to be what he did. In his spreadsheet the >> cell evaluates to 'Option 0'. In another cell elsewhere ($B$99) he >> wrote out 'Option 0' and on this cell he has conditional formatting >> such that if this cell has the same text as $B$99 then the font is >> written in the background color. This way the cell displays when some >> value comes up other than 0 but is clean when 0 is the number. Nice. >> >> Thanks again for your help. You seem to be around a lot when I have >> these questions. I appreciate it! >> >> Cheers, >> Mark >> >> On Thu, Aug 21, 2008 at 9:08 AM, Anthony Chilco >> <[EMAIL PROTECTED]> wrote: >> > Hi Mark, >> > The author of the original spreadsheet probably used conditional >> formatting. >> > The cell is hidden if M33 is zero. >> > tc >> > >> > Mark Knecht wrote: >> >> >> >> Hi, >> >> I'm looking at a prebuilt spreadsheet in Excel and trying to >> >> duplicate some of its functionality in OOCalc. I'm having trouble >> with >> >> one formatting issue. In Excel there is a cell that has the >> following >> >> contents: >> >> >> >> ="Option "&M33 >> >> >> >> M33 is a cell that contains a number from 0-160. In Excel when M33 >> is >> >> 1 or greater Excel displays >> >> >> >> Option 1 >> >> >> >> or whatever number is in cell M33. However when M33 is 0 Excel >> >> displays nothing. The cell is completely blank. It does not say >> Option >> >> 0. >> >> >> >> When I try to build this myself, in Excel or OOCalc I see Option > 0 >> >> in my version. How did the guy who created this spreadsheet get >> Excel >> >> to do this? >> >> >> >> I've checked all the formatting for the cell and I just don't see >> it. >> >> >> >> Thanks, >> >> Mark >> >> >> >> > -------------------------------------------------------------------- >> - >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> >> >> >> > >> > >> > > --------------------------------------------------------------------- >> > To unsubscribe, e-mail: [EMAIL PROTECTED] >> > For additional commands, e-mail: [EMAIL PROTECTED] >> > >> > >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
