You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Vincent Juliano <vj...@optonline.net> on 2013/09/23 21:15:05 UTC
Alphabetizing when using a spread sheet as an index for parts storage.
In using a spreadsheet , using two columns where the first column contains the part description and the second column indicates where the part is to be found alphabetizaation was tried..
This feature hasn't been used in quite some time. When activated the alphabetizing is done using the SECOND column. This puts all the part descriptions in chaos but the placement in alphabetical order.
To accomplish the alphabetization properly the parts list was cut and placed in the second column behind the position the part is to be found.
It works and then the columns are then changed into proper placement and all is well.
It's necessary to upgrade the spreadsheet because of constant additions and removals.
What is the necessary procedure to get the alphabetization of the spreadsheet based on the first column?
Thank you
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Link edits will not "stick" after closing spreadsheet
Posted by David L Babcock <ol...@rochester.rr.com>.
Win XP.
I have several spreadsheets, linked.
I copied these to my Dropbox directory and gave access to my soon
replacement. -Dropbox worked as expected. She could work in the files
(but the links were broken, I'm pretty sure).
I opened the files from my end and used Edit>Links to change the links,
which made them work, for me. Except that the DDE code in the affected
cells did not change, and so when I closed and then opened the files the
changes were lost. (Do I have to say this is nutty behavior? Just
where does a link /live ?/)
On a whim I just repeated the edit thing on the original files and got
the same result: the edit does not stick. (Never mind Dropbox, that was
apparently a red herring.)
Okay, whats the workaround?
Secondly -back to Dropbox, and assuming a solution- I would like to use
relative addressing in the links, so that when we take turns on the
spreadsheets we don't have to change the links each and every time.
When she is working the path includes (if XP) something like "Donna\My
Documents\Dropbox\" etc, while I need to have "\Ol' Bab\My
Documents\Dropbox". Is this possible?
To make it perhaps harder the several files are in several directories,
down two levels in Dropbox.
Give example, I don't remember back that far...
Thanking you for any help,
Ol' Bab
Re: Alphabetizing when using a spread sheet as an index for parts
storage.
Posted by Vincent Juliano <vj...@optonline.net>.
Regina,
It was a great help. thank you
Vince
On Sep 23, 2013, at 4:09 PM, Regina Henschel wrote:
> Hi Vincent,
>
> Vincent Juliano schrieb:
>> In using a spreadsheet , using two columns where the first column
>> contains the part description and the second column indicates where
>> the part is to be found alphabetizaation was tried..
>>
>> This feature hasn't been used in quite some time. When activated the
>> alphabetizing is done using the SECOND column. This puts all the
>> part descriptions in chaos but the placement in alphabetical order.
>
> Then you have only sort the second column and not the whole data range.
>
>>
>> To accomplish the alphabetization properly the parts list was cut and
>> placed in the second column behind the position the part is to be
>> found.
>>
>> It works and then the columns are then changed into proper placement
>> and all is well.
>>
>> It's necessary to upgrade the spreadsheet because of constant
>> additions and removals.
>>
>> What is the necessary procedure to get the alphabetization of the
>> spreadsheet based on the first column?
>
> "first column"?
>
> For to get sorting based on the second column, and for to be able to insert and delete records, do this:
>
> Mark the whole data range including column labels (=field headers) and an additional empty row at the end of the date. The empty row is needed, because you can only insert a row above the current row, not after the current row.
> Name this data range via menu Data > Define Range. Click the "More" button and check the options "Contains column labels" and "Insert or delete cells". The later provides, that the address of this data range is adapted automatically, so that you always get the correct range, when you use its name.
>
> If the data range is no longer selected, select it via menu Data > Select Range. Then use menu Data > Sort. In that dialog choose the label of the second column. Then set the other needed sorting options in that dialog.
>
> After you have insert a record (=row) in the data range, set cursor into the data range and use menu Data > Refresh Range. Now your data range is sorted again with the same initial settings.
>
> Kind regards
> Regina
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Alphabetizing when using a spread sheet as an index for parts
storage.
Posted by Regina Henschel <rb...@t-online.de>.
Hi Vincent,
Vincent Juliano schrieb:
> In using a spreadsheet , using two columns where the first column
> contains the part description and the second column indicates where
> the part is to be found alphabetizaation was tried..
>
> This feature hasn't been used in quite some time. When activated the
> alphabetizing is done using the SECOND column. This puts all the
> part descriptions in chaos but the placement in alphabetical order.
Then you have only sort the second column and not the whole data range.
>
> To accomplish the alphabetization properly the parts list was cut and
> placed in the second column behind the position the part is to be
> found.
>
> It works and then the columns are then changed into proper placement
> and all is well.
>
> It's necessary to upgrade the spreadsheet because of constant
> additions and removals.
>
> What is the necessary procedure to get the alphabetization of the
> spreadsheet based on the first column?
"first column"?
For to get sorting based on the second column, and for to be able to
insert and delete records, do this:
Mark the whole data range including column labels (=field headers) and
an additional empty row at the end of the date. The empty row is needed,
because you can only insert a row above the current row, not after the
current row.
Name this data range via menu Data > Define Range. Click the "More"
button and check the options "Contains column labels" and "Insert or
delete cells". The later provides, that the address of this data range
is adapted automatically, so that you always get the correct range, when
you use its name.
If the data range is no longer selected, select it via menu Data >
Select Range. Then use menu Data > Sort. In that dialog choose the label
of the second column. Then set the other needed sorting options in that
dialog.
After you have insert a record (=row) in the data range, set cursor into
the data range and use menu Data > Refresh Range. Now your data range is
sorted again with the same initial settings.
Kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Alphabetizing when using a spread sheet as an index for parts
storage.
Posted by Vincent Juliano <vj...@optonline.net>.
Maurice.
Thank you. Data-sort-column A --OK
It is so easy I'm embarrassed.
Thank you
> I think all (most?) spreadsheet programs require that you select [highlight]
> the entire range of data to be sorted (which may or may not be the whole
> spreadsheet), then click DATA, then SORT, then tell it which major/
> intermediate/ minor columns to use, then press ENTER. If you simply select
> a column and do SORT, it will sort THAT column only, leaving the rest of the
> data as was. (Why? Because that might actually be what you wanted to do.
> In most cases, including yours, it isn't.) The same logic applies to
> sorting TABLEs when using the TEXT part of OpenOffice.
>
> Yes, you can give the range a name but it's so simple to do the above.
>
> Maurice Howe
>
>
> -----Original Message-----
> From: Vincent Juliano [mailto:vjuliano@optonline.net]
> Sent: Monday, September 23, 2013 3:15 PM
> To: users@openoffice.apache.org
> Subject: Alphabetizing when using a spread sheet as an index for parts
> storage.
>
> In using a spreadsheet , using two columns where the first column contains
> the part description and the second column indicates where the part is to be
> found alphabetizaation was tried..
>
> This feature hasn't been used in quite some time. When activated the
> alphabetizing is done using the SECOND column. This puts all the part
> descriptions in chaos but the placement in alphabetical order.
>
> To accomplish the alphabetization properly the parts list was cut and placed
> in the second column behind the position the part is to be found.
>
> It works and then the columns are then changed into proper placement and all
> is well.
>
> It's necessary to upgrade the spreadsheet because of constant additions and
> removals.
>
> What is the necessary procedure to get the alphabetization of the
> spreadsheet based on the first column?
>
> Thank you
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3408 / Virus Database: 3222/6691 - Release Date: 09/22/13
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
RE: Alphabetizing when using a spread sheet as an index for parts storage.
Posted by Maurice Howe <ma...@stny.rr.com>.
I think all (most?) spreadsheet programs require that you select [highlight]
the entire range of data to be sorted (which may or may not be the whole
spreadsheet), then click DATA, then SORT, then tell it which major/
intermediate/ minor columns to use, then press ENTER. If you simply select
a column and do SORT, it will sort THAT column only, leaving the rest of the
data as was. (Why? Because that might actually be what you wanted to do.
In most cases, including yours, it isn't.) The same logic applies to
sorting TABLEs when using the TEXT part of OpenOffice.
Yes, you can give the range a name but it's so simple to do the above.
Maurice Howe
-----Original Message-----
From: Vincent Juliano [mailto:vjuliano@optonline.net]
Sent: Monday, September 23, 2013 3:15 PM
To: users@openoffice.apache.org
Subject: Alphabetizing when using a spread sheet as an index for parts
storage.
In using a spreadsheet , using two columns where the first column contains
the part description and the second column indicates where the part is to be
found alphabetizaation was tried..
This feature hasn't been used in quite some time. When activated the
alphabetizing is done using the SECOND column. This puts all the part
descriptions in chaos but the placement in alphabetical order.
To accomplish the alphabetization properly the parts list was cut and placed
in the second column behind the position the part is to be found.
It works and then the columns are then changed into proper placement and all
is well.
It's necessary to upgrade the spreadsheet because of constant additions and
removals.
What is the necessary procedure to get the alphabetization of the
spreadsheet based on the first column?
Thank you
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3408 / Virus Database: 3222/6691 - Release Date: 09/22/13
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org