RE: Conditional cells in a straddled table row

2014-07-01 Thread Zimmerman, Gary
Have you tried unstraddling the rows, then applying the conditions you want, 
then re-straddling?

A workaround trick could be to unstraddle everything then tweak the table cell 
borders to make the table appear as the straddled table you intend.

-- garyZ


From: framers-boun...@lists.frameusers.com 
[mailto:framers-boun...@lists.frameusers.com] On Behalf Of Samantha Nair
Sent: Monday, June 30, 2014 7:51 AM
To: framers@lists.frameusers.com
Subject: Conditional cells in a straddled table row

Hi all,

I wonder if any of you could help me.

I have a table with 3 columns and 5 rows. Columns 1 and 2 have all 5 rows 
straddled. Column 3 contains all 5 rows separately. The last entry in column 3 
contains conditional text:

   | Column 1 | Column 2 | Column 3
Row A | Cell 1A | Cell 2A | Cell 3A
Row B ||| Cell 3B
Row C ||| Cell 3C
Row D | ​   || Cell 3D
Row E ||| Cell 3E​

​I am unable to make all of Row E conditional as I've straddled Cell 1A, and 
Cell 2A over it respectively. This means when I hide my conditional text, Cell 
3E, my table is left with an blank row.

Is there a way of getting around this?? I experimented with having Row E 
unstraddled but I was unable to change the borders for that row. I may have 
been looking in the wrong places!

In reality, this is a large table and I have this scenario repeated at various 
points, so I would like to avoid changing the layout where possible, but am 
resigned to the fact that I may have to.

Any help you can give would be appreciated.

Thanks,
Sam.
___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.


Conditional cells in a straddled table row

2014-06-30 Thread Samantha Nair
Hi all,

I wonder if any of you could help me.

I have a table with 3 columns and 5 rows. Columns 1 and 2 have all 5 rows
straddled. Column 3 contains all 5 rows separately. The last entry in
column 3 contains conditional text:

   *| Column 1 | Column 2 | Column 3*
Row A | Cell 1A | Cell 2A |* Cell 3A*
Row B |||* Cell 3B*
Row C |||
* Cell 3C*
Row D | ​   ||* Cell 3D*
Row E *||| Cell 3E*​

​I am unable to make all of Row E conditional as I've straddled Cell 1A,
and Cell 2A over it respectively. This means when I hide my conditional
text, Cell 3E, my table is left with an blank row.

Is there a way of getting around this?? I experimented with having Row E
unstraddled but I was unable to change the borders for that row. I may have
been looking in the wrong places!

In reality, this is a large table and I have this scenario repeated at
various points, so I would like to avoid changing the layout where
possible, but am resigned to the fact that I may have to.

Any help you can give would be appreciated.

Thanks,
Sam.
___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.


Re: Conditional cells in a straddled table row

2014-06-30 Thread David Spreadbury
Samantha,
Have you tried making separate tables and applying the appropriate condition to 
each table?
Dave



On Monday, June 30, 2014 9:54 AM, Samantha Nair samantha.n...@smoothwall.net 
wrote:
 


Hi all,

I wonder if any of you could help me.

I have a table with 3 columns and 5 rows. Columns 1 and 2 have all 5 rows 
straddled. Column 3 contains all 5 rows separately. The last entry in column 3 
contains conditional text:

           | Column 1 | Column 2 | Column 3
Row A | Cell 1A     | Cell 2A     |Cell 3A
Row B |                |                |Cell 3B
Row C |                |                |Cell 3C

Row D | ​               |                |Cell 3D
Row E |                |                | Cell 3E​

​I am unable to make all of Row E conditional as I've straddled Cell 1A, and 
Cell 2A over it respectively. This means when I hide my conditional text, Cell 
3E, my table is left with an blank row. 

Is there a way of getting around this?? I experimented with having Row E 
unstraddled but I was unable to change the borders for that row. I may have 
been looking in the wrong places!

In reality, this is a large table and I have this scenario repeated at various 
points, so I would like to avoid changing the layout where possible, but am 
resigned to the fact that I may have to.

Any help you can give would be appreciated.

Thanks,
Sam.
___


You are currently subscribed to framers as dspre...@yahoo.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/dspreadb%40yahoo.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.


Re: Conditional cells in a straddled table row

2014-06-30 Thread Steve Rickaby
At 15:51 +0100 30/6/14, Samantha Nair wrote:

In reality, this is a large table and I have this scenario repeated at various 
points, so I would like to avoid changing the layout where possible, but am 
resigned to the fact that I may have to.

It sounds like a nightmare. If only have one condition applies to the table 
(and if no-one suggests some appropriate magic), would it work for you to 
maintain two versions of the entire table, conditionalised as appropriate?

Clearly if multiple conditions apply to the table(s), this workaround would 
become unwieldy.

-- 
Steve
___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.


Re: Conditional cells in a straddled table row

2014-06-30 Thread Böðvar Björgvinsson
Hi Samantha,

I fought with this several years ago and found that the only way to get the
results you want is to make the whole row conditional.

This could probably be done through a script if making the row conditional
is not a practical option.

For what it's worth,

Bodvar






On Mon, Jun 30, 2014 at 2:51 PM, Samantha Nair samantha.n...@smoothwall.net
 wrote:

 Hi all,

 I wonder if any of you could help me.

 I have a table with 3 columns and 5 rows. Columns 1 and 2 have all 5 rows
 straddled. Column 3 contains all 5 rows separately. The last entry in
 column 3 contains conditional text:

*| Column 1 | Column 2 | Column 3*
 Row A | Cell 1A | Cell 2A |* Cell 3A*
 Row B |||* Cell 3B*
 Row C |||
 * Cell 3C*
 Row D | ​   ||* Cell 3D*
 Row E *||| Cell 3E*​

 ​I am unable to make all of Row E conditional as I've straddled Cell 1A,
 and Cell 2A over it respectively. This means when I hide my conditional
 text, Cell 3E, my table is left with an blank row.

 Is there a way of getting around this?? I experimented with having Row E
 unstraddled but I was unable to change the borders for that row. I may have
 been looking in the wrong places!

 In reality, this is a large table and I have this scenario repeated at
 various points, so I would like to avoid changing the layout where
 possible, but am resigned to the fact that I may have to.

 Any help you can give would be appreciated.

 Thanks,
 Sam.


 ___


 You are currently subscribed to framers as bod...@gmail.com.

 Send list messages to framers@lists.frameusers.com.

 To unsubscribe send a blank email to
 framers-unsubscr...@lists.frameusers.com
 or visit
 http://lists.frameusers.com/mailman/options/framers/bodvar%40gmail.com

 Send administrative questions to listad...@frameusers.com. Visit
 http://www.frameusers.com/ for more resources and info.


___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.


Re: Conditional cells in a straddled table row

2014-06-30 Thread Samantha Nair
Hi Dave,

I'd rather not duplicate the whole table as it is rather large ... but you
have given me the idea of just duplicating the affected, straddled rows and
conditioning them. Hopefully, that should keep it easier to maintain than 2
separate tables.

Thanks,
Sam.​


On 30 June 2014 16:02, David Spreadbury dspre...@yahoo.com wrote:

 Samantha,
 Have you tried making separate tables and applying the appropriate
 condition to each table?
 Dave


   On Monday, June 30, 2014 9:54 AM, Samantha Nair 
 samantha.n...@smoothwall.net wrote:


 Hi all,

 I wonder if any of you could help me.

 I have a table with 3 columns and 5 rows. Columns 1 and 2 have all 5 rows
 straddled. Column 3 contains all 5 rows separately. The last entry in
 column 3 contains conditional text:

*| Column 1 | Column 2 | Column 3*
 Row A | Cell 1A | Cell 2A |* Cell 3A*
 Row B |||* Cell 3B*
 Row C |||
 * Cell 3C*
 Row D | ​   ||* Cell 3D*
 Row E *||| Cell 3E*​

 ​I am unable to make all of Row E conditional as I've straddled Cell 1A,
 and Cell 2A over it respectively. This means when I hide my conditional
 text, Cell 3E, my table is left with an blank row.

 Is there a way of getting around this?? I experimented with having Row E
 unstraddled but I was unable to change the borders for that row. I may have
 been looking in the wrong places!

 In reality, this is a large table and I have this scenario repeated at
 various points, so I would like to avoid changing the layout where
 possible, but am resigned to the fact that I may have to.

 Any help you can give would be appreciated.

 Thanks,
 Sam.

 ___


 You are currently subscribed to framers as dspre...@yahoo.com.

 Send list messages to framers@lists.frameusers.com.

 To unsubscribe send a blank email to
 framers-unsubscr...@lists.frameusers.com
 or visit
 http://lists.frameusers.com/mailman/options/framers/dspreadb%40yahoo.com

 Send administrative questions to listad...@frameusers.com. Visit
 http://www.frameusers.com/ for more resources and info.


___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.


Re: Conditional cells in a straddled table row

2014-06-30 Thread Shmuel Wolfson

  
  
I would repeat all these five rows for
  each condition, and conditionalize each set of row for one of the
  conditions.
  Shmuel Wolfson
052-763-7133

  On 30-Jun-14 5:51 PM, Samantha Nair wrote:


  
Hi
  all,



  I wonder if any of you could help me.



  I have a table with 3 columns and 5 rows. Columns 1 and 2 have
  all 5 rows straddled. Column 3 contains all 5 rows separately.
  The last entry in column 3 contains conditional text:

  


  | Column 1 | Column 2 | Column 3

  Row A | Cell 1A   | Cell 2A   | Cell 3A
Row
  B ||| Cell 3B

  Row C ||| Cell 3C
  

  Row
D ||| Cell 3D
  Row
E ||| Cell 3E
  


  
I am unable to make all of Row E conditional as I've
straddled Cell 1A, and Cell 2A over it respectively. This
means when I hide my conditional text, Cell 3E, my table is
left with an blank row.
  

  
  Is
there a way of getting around this?? I experimented with
having Row E unstraddled but I was unable to change the
borders for that row. I may have been looking in the wrong
places!
  
  
  In
reality, this is a large table and I have this scenario
repeated at various points, so I would like to avoid
changing the layout where possible, but am resigned to the
fact that I may have to.
  
  
  Any
help you can give would be appreciated.
  
  
  Thanks,
  
Sam.


  

  
  
  
  
  ___


You are currently subscribed to framers as shmue...@gmail.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit http://lists.frameusers.com/mailman/options/framers/shmuelw1%40gmail.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.



  

___


You are currently subscribed to framers as arch...@mail-archive.com.

Send list messages to framers@lists.frameusers.com.

To unsubscribe send a blank email to
framers-unsubscr...@lists.frameusers.com
or visit 
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com

Send administrative questions to listad...@frameusers.com. Visit
http://www.frameusers.com/ for more resources and info.