You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Is this normal, or is there a setting I'm getting wrong?
It's very irritating - there are two or three words at least underneath the header column, and increasing the offset from the cell edge doesn't help
thanks
iMac (21.5-inch, Late 2012), OS X Yosemite (10.10.2)
Hi demonkiwi,
This happens sometimes when the table has gotten dragged somehow to the left. Grab the bullseye and drag it to the right.
quinn
Hi demonkiwi,
This happens sometimes when the table has gotten dragged somehow to the left. Grab the bullseye and drag it to the right.
quinn
If you want you can turn off Freeze Header Columns by going to the Table menu and unchecking it:
When you have Freeze Header Columns checked, that means Numbers tries to keep them scrolling out of view (until you scroll too far and then it gives up and lets them go).
SG
Hi demonkiwi,
There are my settings on my Mac. Numbers > Preferences >Rulers (tick every box)
I am not sure how that works on an iDevice.
The Alignment Guides help me by showing when I drag an object to the Page margins, and also to align objects on the canvas. I use these settings all the time.
Regards,
Ian.
On my machine, this occurs not when the table has "gotten dragged" to the left, but when the canvas is scrolled. If I drag the table to the right to "correct", then the overlapping does go away. But then I might drag it too close to another table on the right. Plus when I scroll the canvas again, either on purpose or inadvertently, the behavior comes right back.
So instead of dragging the table to the right, I would think the better way would be to just scroll the canvas back a little.
Or turn off the behavior entirely by unchecking Freeze Header Columns.
SG
Taking both suggestions in to account I have done a bit of fiddling - and established that if I drag the table by its little round handle to the far left of the application window I can continue to drag on for some or all of the first non-frozen column - even though the table itself has stopped at the edge. Thus the first column slides under the frozen one.
The act of dragging the table to the right first slides the partly hidden column into full view and then starts moving the whole table object.
Curious!
Hi SG,
I see both happening on my machine. The canvas scroll is an expected behavior- it is why I freeze header columns. On my machine, numbers throws up some guides as I drag the table to the edge of the canvas but can flash by unnoticed.
quinn
But my header columns (and rows) are frozen - hence the curiosity.
I've tried locking the table on the canvas, but that doesn't seem to make any difference.
I have now also check the effect on the header row, and the same thing happens. In fact once the table hits the top of the app window the scrolling motion will keep the rows winding up and under the frozen hearer row quite happily!
I can continue to drag on for some or all of the first non-frozen column - even though the table itself has stopped at the edge. Thus the first column slides under the frozen one.
The act of dragging the table to the right first slides the partly hidden column into full view and then starts moving the whole table object.
Curious!
Yes, a bit curious! With such an easily scrolled canvas I tend to prefer an obvious visual cue when I'm "living too close to the edge." Unchecking Freeze Header Columns is better for me because it's so obvious. I like Freeze Header Rows, though.
In a touch interface on the iPad this scrolling canvas behavior seems more natural to me. I'm guessing that's where the idea of Freeze Header Columns originated. A quick swipe of the finger and you're right back where you need to be. With the trackpad it doesn't seem as obvious what to do.
SG
Hi quinn,
Just had a look at a table in on the iPad that has a Header Column. There, with the limited screen real estate, the overlap behavior seems natural and useful. But on the Mac, a bit odd, unless turned off ... in which case not sure if it will be turned off on the iPad too... which I don't think I'd want.
SG
Hah!
Glad it was something simple.
I see that there is no shadow on the side of the header row now: so I'll take that as a telltale in the future.
Many thanks
Hi demonkiwi,
I do think it is a bug. I can't think of a useful function for it.
quinn
Hi SG,
iOS will remember the setting from OSX. You can turn it off and on in the paintbrush menu.
I have a couple of tables that are a bit wide on my Mac. Glad I can freeze header columns.
quinn
header column obscures part of first column next to it
