123Macmini.com
FAQFAQ   SearchSearch   MemberlistMemberlist   GalleryPhoto Gallery   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

NeoOffice spreadsheet

 
Post new topic   Reply to topic    123Macmini.com - Forums Forum Index -> General Software
View previous topic :: View next topic  
Author Message
fiat
Senior Member
Senior Member


Joined: 20 Apr 2009
Posts: 449

PostPosted: Wed Mar 16, 2011 6:10 pm    Post subject: NeoOffice spreadsheet Reply with quote

Hi,

I use NeoOffice to replace MS Office for all sort of office works. I think there is a big missing from NO spreadsheet compared with MSO: can't have 2 or more lines of text in a cell (remember in MSO, you can hit return and go to next line and ... without leaving the cell, of course the cell (row) height will increase accordingly).

I could miss the different way of accomplishing this in NO. Does anyone know how or confirm the dead issue? Thanks for sharing.
Back to top
View user's profile Send private message
Bandit Bill
Veteran Member
Veteran Member


Joined: 07 Jun 2005
Posts: 5968
Location: Edmonton, AB, Canada

PostPosted: Wed Mar 16, 2011 7:08 pm    Post subject: Reply with quote

Did you try <shift> return?

My Mac mini is in a box right now Sad so I can't test it for you.
Back to top
View user's profile Send private message
fiat
Senior Member
Senior Member


Joined: 20 Apr 2009
Posts: 449

PostPosted: Wed Mar 16, 2011 7:27 pm    Post subject: Reply with quote

Bandit Bill wrote:
Did you try <shift> return?

This is what I got:
I type "let me try" in a cell and it reaches the right edge of the cell; so I hit "return" and the highlighted cell moves to the cell below (leave the text-filled cell); if I hit <shift> "return", the highlighted cell moves to the one above (also leave the original one). So no good?
Back to top
View user's profile Send private message
Cypher
Veteran Member
Veteran Member


Joined: 24 Jan 2007
Posts: 3067
Location: North West - UK

PostPosted: Thu Mar 17, 2011 6:36 pm    Post subject: Reply with quote

I haven't got NeoOffice installed anymore but I'm sure it did work. Try doing it with ALT Return or CTRL Return
_________________
Phil

Mac Mini 2.53GHz - iMac 2.0Ghz - Macbook Pro 2.4GHz - iPad 1 32GB 3G
6TB Netgear Ready NAS NV+ - 6TB Drobo S
Back to top
View user's profile Send private message
Cypher
Veteran Member
Veteran Member


Joined: 24 Jan 2007
Posts: 3067
Location: North West - UK

PostPosted: Thu Mar 17, 2011 6:37 pm    Post subject: Reply with quote

I've just checked it in Numbers and it works with ALT Return. so give that a try first
_________________
Phil

Mac Mini 2.53GHz - iMac 2.0Ghz - Macbook Pro 2.4GHz - iPad 1 32GB 3G
6TB Netgear Ready NAS NV+ - 6TB Drobo S
Back to top
View user's profile Send private message
fiat
Senior Member
Senior Member


Joined: 20 Apr 2009
Posts: 449

PostPosted: Thu Mar 17, 2011 6:51 pm    Post subject: Reply with quote

Cypher wrote:
I've just checked it in Numbers and it works with ALT Return. so give that a try first

Thanks, Cypher. Yeah, it (ALT Return) works with Numbers, but doesn't with NO Calc... Maybe I miss something set in NO? Can't figure out! (I do have the most updated NO version though.)
Back to top
View user's profile Send private message
papercut
Junior Member
Junior Member


Joined: 24 Aug 2007
Posts: 30

PostPosted: Sun Mar 20, 2011 7:55 am    Post subject: Reply with quote

from the HELP screen in NeoOffice:

Writing Multi-line Text
1.Pressing the Command+Enter keys inserts a manual line break. This shortcut only works directly in the cell, not in the input line.
If you want the text to automatically break at the right border of the cell, proceed as follows:
1.Select all the cells where you want the text to break at the right border.
2.In Format - Cells - Alignment, mark the Wrap text automatically option and click OK.
Back to top
View user's profile Send private message
fiat
Senior Member
Senior Member


Joined: 20 Apr 2009
Posts: 449

PostPosted: Sun Mar 20, 2011 3:06 pm    Post subject: Reply with quote

Papercut,

Thank you so much for educating/helping me with the clear, precise solution. Now since line breaking in a spreadsheet cell is supposed a single function (no sense for non-line breaking) and there are already arrow keys for moving cell highlight, let wonder why NO has to make it a special way to implement as different from MS office's natural way of hitting "return"? (by hitting return in NO spreadsheet, the cell highlight is moved and no linebreak is done)
Back to top
View user's profile Send private message
Smithcraft
Veteran Member
Veteran Member


Joined: 09 Nov 2008
Posts: 3219
Location: Seattle

PostPosted: Sun Mar 20, 2011 6:11 pm    Post subject: Reply with quote

Then I would be confused, when I hit return and expect to go to the next cell, instead of entering another line in the current cell?

SC
_________________
Grumpy old man of computing.

[Desktop] Intel mini - 2.16Ghz 2GB 60GB HDD - Newer miniStack v2 500GB - 10.5.8

[Media System] Intel i5 mini - 2.33Ghz 8GB 500GB HDD - 4 x Hitachi 2TB HDD in a qBOX-SF - 10.7.5 (Thanks Phil!)

Make sure it has pins!
Back to top
View user's profile Send private message Visit poster's website
fiat
Senior Member
Senior Member


Joined: 20 Apr 2009
Posts: 449

PostPosted: Sun Mar 20, 2011 6:28 pm    Post subject: Reply with quote

Smithcraft wrote:
Then I would be confused, when I hit return and expect to go to the next cell, instead of entering another line in the current cell?

Are you using NeoOffice? Very strange! My try: either from inside the cell or input line, hit return all goes to the next (below) cell, no line break. (I did check the NO Help and confirmed that line break has to be done by special way other than just hit return.)
Back to top
View user's profile Send private message
graceangela9
New Member
New Member


Joined: 21 Mar 2011
Posts: 16
Location: newyork

PostPosted: Tue Apr 05, 2011 7:10 am    Post subject: Re: NeoOffice spreadsheet Reply with quote

fiat wrote:
Hi,

I use NeoOffice to replace MS Office for all sort of office works. I think there is a big missing from NO spreadsheet compared with MSO: can't have 2 or more lines of text in a cell (remember in MSO, you can hit return and go to next line and ... without leaving the cell, of course the cell (row) height will increase accordingly).

I could miss the different way of accomplishing this in NO. Does anyone know how or confirm the dead issue? Thanks for sharing.



Neooffice is a good software and you can have two or more lines of text what you have to do is click alt return simultaneously then it will definitely work.
_________________
Thanks & Regards
Angela Grace
Writing Software
Back to top
View user's profile Send private message Visit poster's website
Ranter
Member
Member


Joined: 07 Jun 2005
Posts: 223
Location: Palm Springs, CA USA

PostPosted: Tue Apr 05, 2011 8:25 am    Post subject: Reply with quote

Recently I discovered yet another OpenOffice clone for Mac called LibreOffice. I prefer their user interface over NeoOffice. Perhaps it might be useful for you.

http://www.libreoffice.org/
_________________
http://skeptichosting.com/

Weapons are the tools of violence; all decent men detest them.
Lao Tzu, Tao Te Ching
Back to top
View user's profile Send private message Visit poster's website
fiat
Senior Member
Senior Member


Joined: 20 Apr 2009
Posts: 449

PostPosted: Tue Apr 05, 2011 11:23 pm    Post subject: Reply with quote

Ranter, Thanks for referring LO. I found it very same to NO except it has stand-alone "drawing", "formula" etc. I see no significant difference in user interface between LO and NO though. I am not sure, but aren't OO and NO for Mac only? Anyway I am keeping NO ...
Back to top
View user's profile Send private message
Ranter
Member
Member


Joined: 07 Jun 2005
Posts: 223
Location: Palm Springs, CA USA

PostPosted: Wed Apr 06, 2011 9:05 am    Post subject: Reply with quote

fiat wrote:
I see no significant difference in user interface between LO and NO though.


I sometimes work with spreadsheets that have very large cells, and I stretch them across two 24" displays. In that situation NeoOffice behaves very badly while LibreOffice lets me scroll gracefully through the contents of a cell.

fiat wrote:
I am not sure, but aren't OO and NO for Mac only? Anyway I am keeping NO ...


OpenOffice is designed to run on nearly all current day operating systems. Back in the day when Sun Microsystems still existed it was a shot across the bow of their then arch rival Microsoft.

NeoOffice is a Mac specific rendering of OO designed to offer a more typical Mac UI.
_________________
http://skeptichosting.com/

Weapons are the tools of violence; all decent men detest them.
Lao Tzu, Tao Te Ching
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    123Macmini.com - Forums Forum Index -> General Software All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



      

Shop:  Apple Store  |  Refurbished Macs  |  Refurbished iPads  |  MacConnection  |  Mac Mini Vault  |  Other World Computing

MK 1 Studio Mac mini Racks  |  Crucial Mac Memory  |  Top Free Mac Apps  |  Top Paid Mac Apps



123Macmini.com is an independent publication and has not been authorized, sponsored, or approved by Apple Computer, Inc.
All logos and trademarks in this site are property of their respective owners.
Copyright © 2011 123Macmini.com. All Rights Reserved.