Writing merged cells vertically

Hello,

In Excel I can merge cells of the same column and write a text in those merged cells and put the text vertically.

I try to do the same with Numbers '08 but was not possible.

I know that I can insert a text box but this do not resolve my need, because I need a 4000+-row SS with 200 dates that need to be written vertically _ to save space — maintaining the path.

Is this feature in Numbers '09 or — if you are an Apple insider — in Numbers '11?

Extra: why is Numbers so much slow than AppleWorks SS?

Thanks,

Jorge Lucas (the guy from Rio Grande do Sul)

MacBook 2.16 GHz, Mac OS X (10.6.5), iPhone 3G 8 GB

Posted on Nov 21, 2010 3:59 AM

Reply
9 replies

Nov 21, 2010 5:02 AM in response to Jorge Lucas

Jorge Lucas wrote:
Hello,

In Excel I can merge cells of the same column and write a text in those merged cells and put the text vertically.

I try to do the same with Numbers '08 but was not possible.

I know that I can insert a text box but this do not resolve my need, because I need a 4000+-row SS with 200 dates that need to be written vertically _ to save space — maintaining the path.

Is this feature in Numbers '09 or — if you are an Apple insider — in Numbers '11?


Here, you aren't speaking to Apple representatives but to end users like you.
If some of us are aware of future products, they are under Non Disclosure Agreement so they will not respond.

What is sure is that the wanted feature is unavailable in Numbers '09.

Extra: why is Numbers so much slow than AppleWorks SS?


It seems that Numbers is rebuilding the entire sheet when something is modified in a cell of a table or in a text box or in any other kind of object. From my point of view it's a huge design flaw but it's a job for Apple's engineers, not for end users.

Yvan KOENIG (VALLAURIS, France) dimanche 21 novembre 2010 14:02:03

Nov 21, 2010 5:45 AM in response to KOENIG Yvan

Yvan (the Terrific),

I know about the Non Disclosure Agreement and I should have writing "a friend of a friend of a friend of a friend of..." that could have some info or clue.
The guy should not swear over the bible; just give the guess.

What a shame that Numbers is only visually well designed and it is underpowered.

Like you, I did not understand why Apple abandoned AppleWorks without having a full replacement for it. They should have saved the AppleWorks modular concept, at least.

One simple thing that they should have done is to have the "Open Recent" working.

Thanks Yvan for socialize your knowledge!

Jorge Lucas (the guy from Rio Grande do Sul)

Message was edited by: Jorge Lucas

Message was edited by: Jorge Lucas

Message was edited by: Jorge Lucas

Nov 21, 2010 5:51 AM in response to Jorge Lucas

Jorge Lucas wrote:


Like you, I did not understand why Apple abandoned AppleWorks without having a full replacement for it. They should have saved the AppleWorks modular concept, at least.


iWork is modular too. Alas, the DB module is missing !

One simple thing that they should have done is to have the "Open Recent" working.


What is your problem with "Open Recent" ? Is it with iWork or with AppleWorks ?

Yvan KOENIG (VALLAURIS, France) dimanche 21 novembre 2010 14:51:36

Nov 21, 2010 8:03 AM in response to Jorge Lucas

Jorge Lucas wrote:
Yvan,

The "Open Recent" problem is with AppleWorks; it does not work.


Right. It never did and it will never do.

+And my primary applications is AppleWorks.+


You will be forced to drop it some of these days.

(text, because has Equation Editor included;


Right

databases that iWork does not have


Right

and spreadsheets that are faster


Right

and easier to put formulas than Numbers)


On this point I disagree.

Yvan KOENIG (VALLAURIS, France) dimanche 21 novembre 2010 17:03:14

Nov 21, 2010 9:58 AM in response to KOENIG Yvan

Yvan,


There are some things that make Numbers easy than AppleWorks; like this: if you are going to add numbers of the same row, you do not need to specify the row (you told me this sometime ago).

But, some things that were so natural in AppleWorks are not so in Numbers; take this:
1) write a date in A1
2) write a date in A2
3) in AppleWorks, you just write in a chosen cell, let's say, C2: ' =IF(AND(B1,B2),B2-B1,"")' and the SS calculates the number of days between those 2 dates.

Now, if you try to do this in Numbers, it seems to me that will be a little bit harder.

I know that you have very much more knowledge than I do and could do this very easily even in Numbers; but for an average user like myself, it seems a little bit more difficult in Numbers.

Maybe I just do not know the Mac way of this application and like AppleWorks too much.

If Apple release the future iPad in Brasil — until now, the original iPad did not appear here — and if there is the FileMaker Pro for iPad (complete solution, not the "On the Go" that depends on some other Mac) then I must consider abandoning my AppleWorks DB and bring the iPad to the classroom. The iPad is 1/3 of the MacBook weight and this is an huge difference.

Thanks,

Jorge Lucas (the guy from Rio Grande do Sul)

Nov 21, 2010 12:22 PM in response to Jorge Lucas

In AppleWorks, we have the object date and the object time.
In Numbers we haven't. We have only a date_time object.
The problems are linked to that.

They strike mainly in Numbers '08 because in Numbers '09, engineers introduced a new object : duration.
We may use it as a time value with the huge advantage that it isn't restricted to the range 00:00:00 … 23:59:59. It may use weeks, days, hours, minutes, seconds, milliseconds.

Working with durations is really easy but don't hurry, as we are waiting for it since january 2010, the successor of iWork '09 will be available … one day 😉

I'm not interested by the iPad.
Pages for it is a subset of the true Pages.
Numbers for it is a subset of the true Numbers.
I don't know for Keynote.

I don't understand why FileMaker which is able to create FileMaker Go for the ipad is unable to do the same for the Mac. Bentoy is far from being an alternative to the AppleWorks DB module.

Bye, Now I will switch off.

Yvan KOENIG (VALLAURIS, France) dimanche 21 novembre 2010 21:22:17

Nov 21, 2010 2:55 PM in response to KOENIG Yvan

Yvan,


My interest in the iPad depends on 2 or 3 things:

1) if I am able to build a better and bigger db that the one I already have functioning — for over 10 years — in the db module of AW (the one that you knew some years ago and that is better now, with its 255 fields (it is limited at 255) running fine;
2) if I can get the pdf or e-book version of my text book ( I have the free paper version and I tried — unsuccessfully — to buy the digital copy (the book alone weighs 1 Kg);
3) I need to see which Math apps I can have that substitute the ones I have on the MacBook;
4) I was counting on the full versions of Pages, Numbers and Keynote — you put cold water on my plans.

Apart from the classroom usage that would be something — just imagine, been able to hold it with one hand and write in the board with the other! — it would be nice to use it as an e-book reader and/or internet reader.

But, if the iPad does not do the things I need, I am also considering a MacBook Air 13.3” (1.32 Kg), hoping that I can use AppleWorks in Lion or going to FileMakerPro.
But even this option is hard to implement it because here we have to pay more than double the American price; and our salaries are very much less than the American.

By the way, you said:

I don't understand why FileMaker which is able to create FileMaker Go for the iPad is unable to do the same for the Mac. Bento is far from being an alternative to the AppleWorks DB module.


The last hope I had about the inclusion of a DB module in the iWork suite, was gone after FileMaker made the list organizer Bento: it was very clear that they would not include the Filemaker Pro in the suite because it alone costs more than the all suite; so *+I thought that Apple would ask FileMaker to produce a flat version (not relational) — that could be named “FileMaker” (without the “Pro”)+*.
They could charge for it the same as each of the existing 3 applications.

Bento is very much less than this and because your thoughts on it, I never even tried it.

So, I better wait the release of the new iPad, the iWork ’11, put some money together and find a way to make my teaching easier.

+Thank you for the bad news about iWork for iPad.+

Now, I am closer to the Air.


Jorge Lucas (the guy from Rio Grande do Sul)

Message was edited by: Jorge Lucas

Message was edited by: Jorge Lucas

Nov 22, 2010 5:03 AM in response to Jorge Lucas

Thanks for your feedback but I think that it isn't good practice to trusty me at 100%.

It would be a good idea to download the Bentoy trial and test it. Maybe I'm too severe about it 😉

About Filemaker, we wished the same kind of thing.
You wished a FileMaker deprived of its relational components.
I wished one deprived of its multi-users components.

May you send a mail to my mailbox.
If I remember well, we exchanged some months ago but I made huge cleaning and I find no message from you.

As always, just click my blue name to get my address.

Yvan KOENIG (VALLAURIS, France) lundi 22 novembre 2010 14:03:41

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Writing merged cells vertically

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.