RE: Conditional cells in a straddled table row
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
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
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
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
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
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
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.