FW: open office enquiry

[john allen <hi...@hotmail.com>]

Hi
I sent this email and attachment some time ago but have heard nothing.
I dont know where else to go, who speak to (tried my local computer shop) to get an answer to this issue?
Regards
John 

From: highfly29@hotmail.com
To: users@openoffice.apache.org
Subject: RE: open office enquiry
Date: Mon, 28 Jul 2014 08:21:20 +0100


















JOHN T ALLEN:  20 BLENHEIM COURT:  WOOTTON BASSETT: WILTS SN4 8HQ:

highfly29@hotmail.com  (Preferred means of communication)

Otherwise 01793854479 or
07733609279
Hi
Please see email attachment which I've lost on file.
Regards
John 

 		 	   		   		 	   		  

Re: FW: open office enquiry

[Dave Barton <db...@tasit.net>]

-------- Original Message  -------- From: john allen
<hi...@hotmail.com> To: users@openoffice.apache.org Date: Mon, 25
Aug 2014 08:24:55 +0100

> Hi
> 
> I sent this email and attachment some time ago but have heard nothing.
> 
> I dont know where else to go, who speak to /(tried my local computer
> shop) /to get an answer to this issue?
> 
> Regards
> 
> John

John is not subscribed to the list. The attachment he refers to is a
scanned PDF image document. The following is a plain text conversion of
that document:

<QUOTE>
JOHN T ALLEN: 20 BLENHEIM COURT: WOOTTON BASSETT: WILTS SN4 8HQ:
highfly29@hotmail.com

To: users@openoffice.org
May. 26, 14

I guess there are still some computer dinosaurs around, at 65 with
cognitive & memory issues, I'm one of them.

Hence this what to most may be a simple enquiry email, to me is
desperation to find a non tech answer to my questions on items that are
annoying whilst using computer applications, in this case what short be
a simple action of sorting columns of data in Neooffice.

But when I try that, a message on screen (see attachment) comes up
saying 'ranges containing merged cells can only be sorted without
formats' I may as be an alien visitor, as no understanding what that
means or how to correct it!

The obvious next step was to see if my version was up to date, but not
been able to find that out!

To many people finding the name & version of a programme they have, in
my case, the version I have, for Neooffice (which I also understand is
or part of Openoffce Apache) for my Max OSX 10 6 8 is difficult.

In addition I' no good, get easily confused at all the tech jargin in
forums, in this case, when I googled saw for Neooffice, or is it Openoffice:

http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=4975

All I want is a simple answer to I can use the programme a lot easier.

Regards

John Allen
</QUOTE>




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

RE: open office enquiry

[john allen <hi...@hotmail.com>]

HiI do apologise for not thanking you for your earlier email reply t my enquiry.Not sure how it was missed, but thats for the details of the forum and seeking to 'umerge' cells which I'll try.RegardsJohn allen > Subject: Re: open office enquiry
> From: jimplante@me.com
> Date: Mon, 25 Aug 2014 10:27:47 -0500
> To: users@openoffice.apache.org
> 
> 
> On Aug 25, 2014, at 6:31 AM, Alan B <ab...@gmail.com> wrote:
> 
> >  So the NeoOffice support forum is your next step.
> 
> No, unfortunately it is not--unless you contribute $100/year for tech support. Neo has only one full-time engineer to maintain the program: Patrick Luby. And while he does give good value for the money, you cannot post questions to the support forum unless you maintain that contributor status. There are only two or three part-time coders who contribute.
> 
> (N.B.: I once had a problem with NeoOffice screwing up my inserted pictures, then crashing. I posted the problem and an example file on the support forum, and Patrick issued a patch within 90 minutes. He seldom takes more than a day or two to solve problems, although the knotty ones do take longer. His service is unsurpassed.)
> 
> I use NeoOffice on Mavericks (latest version). To unmerge cells, select the whole data set (not Select All...). From the main menu at the top of the screen, choose Format, then Merge Cells, then uncheck either Merge Cells or Merge and Center cells, whichever is checked. 
> 
> Now you can sort. Then, immediately save the file under a different name. Look carefully at your original data and the data that resulted from the sort. Do the data in the rows make sense? Is anything missing? Are they in proper sort order in all columns? Remember, to sort you must select the entire data set. If you select only a column, then that column is all that will be sorted; the rest of the data will stay as it was. 
> 
> You can get the latest NeoOffice from the App Store for free. It is one of the few programs in the App Store which notifies you of available patches or updates; it does not update automatically, but allows you to selectively eschew updates until you've finished your current project (just in case...).  Tech support must be paid for. Only you can decide whether it's worth it. 
> 
> Jim Plante
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
> 
> 
> 
 		 	   		  

Re: open office enquiry

[James Plante <ji...@me.com>]

On Aug 25, 2014, at 6:31 AM, Alan B <ab...@gmail.com> wrote:

>  So the NeoOffice support forum is your next step.

No, unfortunately it is not--unless you contribute $100/year for tech support. Neo has only one full-time engineer to maintain the program: Patrick Luby. And while he does give good value for the money, you cannot post questions to the support forum unless you maintain that contributor status. There are only two or three part-time coders who contribute.

(N.B.: I once had a problem with NeoOffice screwing up my inserted pictures, then crashing. I posted the problem and an example file on the support forum, and Patrick issued a patch within 90 minutes. He seldom takes more than a day or two to solve problems, although the knotty ones do take longer. His service is unsurpassed.)

I use NeoOffice on Mavericks (latest version). To unmerge cells, select the whole data set (not Select All...). From the main menu at the top of the screen, choose Format, then Merge Cells, then uncheck either Merge Cells or Merge and Center cells, whichever is checked. 

Now you can sort. Then, immediately save the file under a different name. Look carefully at your original data and the data that resulted from the sort. Do the data in the rows make sense? Is anything missing? Are they in proper sort order in all columns? Remember, to sort you must select the entire data set. If you select only a column, then that column is all that will be sorted; the rest of the data will stay as it was. 

You can get the latest NeoOffice from the App Store for free. It is one of the few programs in the App Store which notifies you of available patches or updates; it does not update automatically, but allows you to selectively eschew updates until you've finished your current project (just in case...).  Tech support must be paid for. Only you can decide whether it's worth it. 

Jim Plante
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: FW: open office enquiry

[Alan B <ab...@gmail.com>]

On Mon, Aug 25, 2014 at 3:24 AM, john allen <hi...@hotmail.com> wrote:

> Hi
>
> I sent this email and attachment some time ago but have heard nothing.
>

John, sorry for your difficulties getting information.

First let me recommend you to use the NeoOffice Forums for support. It
doesn't seem you've tried there (I searched your name and email on the
NeoOffice forums and nothing was found). To try the NeoOffice Forums go to
the link below and post your question.
http://trinity.neooffice.org/modules.php?name=Forums&file=search

As to the problem you're having 'ranges containing merged cells can only be
sorted without formats'...

When using a spreadsheet the information that's being operated on, in your
case sorted, is considered to be a "range".

So "ranges containing merged cells..." is the work you're trying to sort.

Spreadsheets are grids of rows and columns. Each intersection of a row and
column is a "cell".

Adjacent cells can be joined together or "merged" creating one larger cell
that occupies more than one column or more than one row.

Sort rearranges the rows based on values in the columns.

Sort doesn't know what to do if all the cells in the range are not the
same, e.g. a 10 x 20, 30 x 15, etc grid.

Your error message is saying that at some point some of your cells have
been joined together. If you created the data then it is something you did.
If you got the data from elsewhere and pasted it into your spreadsheet then
it could have come that way from the source.

To do your sort the cells must be "unmerged". The method to do that will be
specific to NeoOffice. So the NeoOffice support forum is your next step.