Topic Options
#24361 - 06/14/10 05:02 PM Blank columns in Excel and Formatting
mittens Offline
Junior Member

Registered: 07/30/10
Posts: 0
Aloha, I have just been assigned to a project taht uses this product. The file being fed in has alot of manual manipulation due to the print template being static. The template does not handle blank cells in the excel file well for example. We have a list of items that a customer may or may not have. They could have procuct 1 not 2 or 3 but 4 and 5. If we do not push everything over in the xcel file then we get spacing between products like this
1


4
5

We want it like this
1
4
5
basically a shift up if there is no value only spaces. Is this possible? mahalo for your assistance :-)

Top
#24362 - 06/14/10 07:39 PM Re: Blank columns in Excel and Formatting
mittens Offline
Junior Member

Registered: 07/30/10
Posts: 0
One more issue with this. They have built a text box for each field. Is there a way to rid of a textobject and move the one below it up? If not how would you approach this? Much mahalo, Mark

Top
#24363 - 06/15/10 09:20 AM Re: Blank columns in Excel and Formatting
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4953
Loc: Objectif Lune Montreal
kaiserguy,

For the first issue, you can click on your text box, and in the Properties panel, you should have an option called "Remove Empty Lines". Turn it on, and it will skip the blank lines. If you don't see the Properties panel, you can make it appear by going to Window->Properties.

For the second, I'm not sure what you mean. Do you mean that you want the text box to disappear if there's no text in it? If so, then this isn't possible, objects cannot be turned ON or OFF in PrintShop Mail. If you just mean deleting the text box manually, then just click on it and press the delete key on your keyboard, or do Edit->Delete. You can then move the other text boxes using the mouse.

Regards,
Rapha

Top