cell overlapping other cell when typing

Hi Steve,

Is your "cost calculator' a separate table?

If so, that table will be pushed downward when the data table expands to fill the space between the two. If not, that portion of the single table will be pushed down as rows above it expand.

The cost calculators cells appear to be overlapping a text box, not a cell on another table.

You can keep the 'item name' cell(s) from expanding by unchecking the "wrap text in cell" box in the Text section of the Table format Inspector. But that would mean you would see only the first line of text in the item name cell.

Otherwise, your only solutions are to delete rows from the bottom of the data table to keep space available for the cost calculator, or to change the page size from US Letter to US Legal, or to narrow the top and bottom margins in the Document Inspector.

Regards,

Barry

Hi Steve,

I can't tell from your screen shot how the invoice template was constructed.

Just trying to recreate the problem, does a blank document created when you open the invoice template look something like this?

Invoice table, Cost Calculator table, and the text "PAYMENT REQUIRED IMMEDIATELY etc." in a text box.

When I add lots of text to a cell in the Invoice table (with Text Wrap) the cell expands to accommodate the text. The Cost Calculator table and the text box politely move down.

Is that text box locked (and therefore won't move)?

Click on the text box. Small x marks will show if it is locked.

Menu > Arrange > Unlock.

Regards,

Ian.

Hi Steve,

in the original file, there are five tables on the Invoice sheet, plus three text boxes.

Clicking on one of the objects, then pressing command-A produces the result seen in the image below.

A screen shot of the same area as displayed on your computer may help in determining what is causing the difference in your case.

Steps:

Set Zoom to 100% (or to largest value that will show the whole page on your screen).

Click any object, then press command A to Select All.

Place the mouse pointer at the top left corner of the screen area to be captured.

(include the column and row reference tabs as shown above)

Press shift-command-4 (the pointer will change to a crosshair)

Click and hold and drag the crosshair to the lower right corner of the area to be captured.

Release the mouse button to capture the image as a file.

Look for differences between your image and the one above.

Regards,

Barry

Hi Ian,

I'm also stymied.

I agree with your suggestion of starting again from the template (and if that fails, with a freshly downloaded copy). When I downloaded the template and opened a new document from it, the behaviour was as expected—as the main table took up more space, it pushed the tables and text box beneath it downward.

The only obvious differences I can see between the document fresh from the template and the most recent screen shot from Steve are the repositioning of the text box containing the logo and of the single row table near the bottom showing the payment due date and time. (I did change this one to a single cell table, as the only content is in cell A1.)

Sharing a copy of the misbehaving file via Dropbox or other depository site could be useful as well.

Regards,

Barry

it looks like you moved the table accidentally.

select the table, then Use the move control to reposition that table to clear the conflict:

Hi Steve,

"…here is the screenshot"

But it isn't. I asked for a screenshot taken while ALL objects were selected.

The only object selected in that screen shot is the box containing your City Handyman logo.

With that selected, press command-A to add all the other objects to the selection. Then take the screen shot showing ALL the row and column reference tabs for the various tables and the selection handles for ALL the rest of the objects.

See my post above for an example with all five tables and all three text boxes selected.

(After taking the screen shot, click on the space below Handyman to release all objects from the selection.)

Regards,

Barry

Hi Steve,

Thanks for the screen shot. I can't see anything obvious that is causing the tables to overlap instead of moving down.

As I see it, you could try:

1. Start again with a new document opened from that template (you may need to download again to start afresh);
2. Place the misbehaving document on Dropbox or some other public website so that we can do some testing.

Regards,

Ian.

Hi Steve,

The request above regarding a full page screenshot with ALL objects selected is for the purpose state: an attempt to obtain some clues regarding the cause of this behaviour, which could lead to a correction of the behaviour.

Without the details specified in the request, those clues are not available in the screen shot.

Regards,

Barry

Hi Steve,

when i send to customer all the sheets which includes customer database, data generator, receipt, packing slip, License and products all attach themselves to the email

Numbers for Mac (which I assumed from your original question) works that way. Menu > Share > Send a Copy > Mail (or the button Send a Copy > Mail) allows you to export the whole document as an email attachment.

To export only the invoice, go to the invoice sheet and Menu > File > Print (command p) to see Print Setup. Make sure that you choose Print > This Sheet, not All Sheets.

Click on the Print... button (bottom right) and choose PDF > Open PDF in Preview to check that your customer will see only the invoice:

In Preview, Save that PDF to a convenient Invoices folder. Attach it to an email to your customer.

All is good!

Regards,

Ian.