Re: [libreoffice-users] Sorting in Writer

[Luuk]

Unable to reproduce in LO 7.1.1

In which version of LO are you doing this?

On 23-4-2021 23:14, Pat Brown wrote:

Hi,
 I have a number of rows of text that I want to sort by row. My problem
is that some of the rows are also hyperlinks and when I run the sort it
puts all the hyperlink rows sorted and then the non-hyperlink rows. Is
there any way to get the sort to ignore the hyperlink code?

Thanks,

Paddy



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Sorting in Writer

[Pat Brown]

Hi,
I have a number of rows of text that I want to sort by row. My problem
is that some of the rows are also hyperlinks and when I run the sort it
puts all the hyperlink rows sorted and then the non-hyperlink rows. Is
there any way to get the sort to ignore the hyperlink code?

Thanks,

Paddy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Sorting in Writer

[anne-ology]

   So glad you found what will work for you; thanks for letting me know.



From: Pat Brown <mistyha...@gmail.com>
Date: Thu, Jun 2, 2016 at 7:57 PM
Subject: Re: [libreoffice-users] Sorting in Writer
To: anne-ology <lagin...@gmail.com>


Thanks for this. What Piet showed me was like running a macro but manually,
step by step. It worked fine for what I wanted but I think I will write and
save a macro to automate the process in the future. What he suggested was
really logical once I started to think it through



On 3 June 2016 at 02:33, anne-ology <lagin...@gmail.com> wrote:

   Well, I've done this for any number of lists; sorted in various ways
> ...
>   once it's done, it's much easier to locate what you have & much
> easier to maintain the list.
>
>The manual method is somewhat quicker if you use (1) the 'find' to
> sort;
>   (2) maybe doing a section at a time.
>
>There are numerous programs that supposedly will do this for you;
>how they operate or how they would know where to place what, I
> haven't the foggiest ...
>   some can be located through Gizmo's
> http://www.techsupportalert.com/
>
>Hoping this helps,
>
>
>
> From: Pat Brown <mistyha...@gmail.com>
> Date: Tue, May 31, 2016 at 3:12 PM
> Subject: [libreoffice-users] Sorting in Writer
> To: Libre Office <users@global.libreoffice.org>
>
>
> I received a document which, essentially is a document of song lyrics.
> However, they were typed in at random, as they were received. I now want to
> sort the songs by song title and can't figure a way to do this. The format
> is the following:
>  The song title, the artist, the lyrics. Each line is essentially a new
> paragraph so I cannot sort by paragraph. I need some way of marking the
> beginning and the ending of each song, having the contents between these
> two marks recognised as a unit, and then sorting these units. Does anyone
> have any ideas, without having to select each song, cutting it and then
> pasting it in its correct position alphabetically
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sorting in Writer

[anne-ology]

   Well, I've done this for any number of lists; sorted in various ways
...
  once it's done, it's much easier to locate what you have & much
easier to maintain the list.

   The manual method is somewhat quicker if you use (1) the 'find' to
sort;
  (2) maybe doing a section at a time.

   There are numerous programs that supposedly will do this for you;
   how they operate or how they would know where to place what, I
haven't the foggiest ...
  some can be located through Gizmo's
http://www.techsupportalert.com/

   Hoping this helps,



From: Pat Brown <mistyha...@gmail.com>
Date: Tue, May 31, 2016 at 3:12 PM
Subject: [libreoffice-users] Sorting in Writer
To: Libre Office <users@global.libreoffice.org>


I received a document which, essentially is a document of song lyrics.
However, they were typed in at random, as they were received. I now want to
sort the songs by song title and can't figure a way to do this. The format
is the following:
 The song title, the artist, the lyrics. Each line is essentially a new
paragraph so I cannot sort by paragraph. I need some way of marking the
beginning and the ending of each song, having the contents between these
two marks recognised as a unit, and then sorting these units. Does anyone
have any ideas, without having to select each song, cutting it and then
pasting it in its correct position alphabetically

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sorting in Writer

[Piet van Oostrum]

Piet van Oostrum wrote:

 > As far as I know, steps 4 and 6 cannot be done with the regular find and 
 > replace as you can't specify a paragraph mark in the replace. At least i 
 > don't know how to.

Well, in the meantime I found that \n in the Replace field with the regular 
Find and Replace represents a paragraph break. In the Search For field $ should 
be used. The recipe with the regular Find and Replace then becomes:
(all Find/replace with "Regular expressions"" ticked):

1. Choose two characters that do not appear in your text. I chose # an §.
2. Mark every song title, except the first one, with # at the beginning of the 
line.
3. Find & replace:
   Search For: $
   Replace With: §
   Replace all
4. Find & Replace:
   Search for: §#
   Replace With: \n
5. Select all text and then Tools > Sort.
6. Find & Replace:
   Search for: §
   Replace with: \n
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sorting in Writer

[Piet van Oostrum]

Pat Brown wrote:

 > I received a document which, essentially is a document of song lyrics.
 > However, they were typed in at random, as they were received. I now want to
 > sort the songs by song title and can't figure a way to do this. The format
 > is the following:
 >  The song title, the artist, the lyrics. Each line is essentially a new
 > paragraph so I cannot sort by paragraph. I need some way of marking the
 > beginning and the ending of each song, having the contents between these
 > two marks recognised as a unit, and then sorting these units. Does anyone
 > have any ideas, without having to select each song, cutting it and then
 > pasting it in its correct position alphabetically
 > 
Here is a recipe that could help you, but it requires the Alternative Searching 
extension (aka Alternative Find & Replace)

1. Choose two characters that do not appear in your text. I chose # an §.
2. Mark every song title, except the first one, with # at the beginning of the 
line.
3. With Alt. Find & replace:
   Search For: \p
   Replace: §
   Check "regular expressions" box
   Replace all
4. With Alt. Find & Replace:
   Search for: §#
   Replace \p
   ("regular expressions" box still checked)
5. Select all text and then Tools > Sort.
6. With Alt. Find & Replace:
   Search for: §
   Replace \p
   ("regular expressions" box still checked)

As far as I know, steps 4 and 6 cannot be done with the regular find and 
replace as you can't specify a paragraph mark in the replace. At least i don't 
know how to.

-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sorting in Writer

[Steve Edmonds]

How many songs?
Steve

On 2016-06-01 08:12, Pat Brown wrote:

I received a document which, essentially is a document of song lyrics.
However, they were typed in at random, as they were received. I now want to
sort the songs by song title and can't figure a way to do this. The format
is the following:
  The song title, the artist, the lyrics. Each line is essentially a new
paragraph so I cannot sort by paragraph. I need some way of marking the
beginning and the ending of each song, having the contents between these
two marks recognised as a unit, and then sorting these units. Does anyone
have any ideas, without having to select each song, cutting it and then
pasting it in its correct position alphabetically




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Sorting in Writer

[Pat Brown]

I received a document which, essentially is a document of song lyrics.
However, they were typed in at random, as they were received. I now want to
sort the songs by song title and can't figure a way to do this. The format
is the following:
 The song title, the artist, the lyrics. Each line is essentially a new
paragraph so I cannot sort by paragraph. I need some way of marking the
beginning and the ending of each song, having the contents between these
two marks recognised as a unit, and then sorting these units. Does anyone
have any ideas, without having to select each song, cutting it and then
pasting it in its correct position alphabetically

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sorting table (Writer) with months or days

[Brian Barker]

At 00:35 28/12/2015 -0500, Dave Boland wrote:
How do I get Writer to sort a table using a column with months 
(January, February, March, etc).) or days (Monday, Tuesday, 
Wednesday, etc.)?  I know that if I change them to a numeric 
representation it will work, but that is not what I want to do.


Sorry, but we don't know that you don't want to do this unless you 
tell us exactly why - so I'm permitted to ignore that.


There lots of ways to do this:

o Go to Tools | Options... | LibreOffice Writer | Table | Input in 
tables, and ensure "Number recognition" is ticked.

o Enter your data as genuine dates.
o Format your data using Table | Number Format...; choose Date under 
Category and December under Format (or Format code  for days). 
Note that the appearance of your table is now exactly as you wanted it.

o Sort your values normally, using Numeric for "Key type".

o Copy your table (text) data (or parts of it) to a spreadsheet.
o Sort the material in the spreadsheet. On the Options tab of the 
Sort dialogue, tick "Custom sort order" and select 
"January,February,March...". (Days are also available.)

o Copy the sorted material back to your table in Writer.

o Copy your table (text) data (or parts of it) to a spreadsheet.
o Convert values there to genuine dates, using available functions.
o Sort the material in the spreadsheet (using normal numeric sort).
o Either freeze the date values back to text, using TEXT(), and copy 
the results back into your Writer table,

o Or copy the date values back and format them appropriately there.

There are probably more ...

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Sorting table (Writer) with months or days

[dave boland]

Thanks Brian - very helpful!

Dave,

On Mon, Dec 28, 2015, at 10:23 AM, Brian Barker wrote:
> At 00:35 28/12/2015 -0500, Dave Boland wrote:
> >How do I get Writer to sort a table using a column with months 
> >(January, February, March, etc).) or days (Monday, Tuesday, 
> >Wednesday, etc.)?  I know that if I change them to a numeric 
> >representation it will work, but that is not what I want to do.
> 
> Sorry, but we don't know that you don't want to do this unless you 
> tell us exactly why - so I'm permitted to ignore that.
> 
> There lots of ways to do this:
> 
> o Go to Tools | Options... | LibreOffice Writer | Table | Input in 
> tables, and ensure "Number recognition" is ticked.
> o Enter your data as genuine dates.
> o Format your data using Table | Number Format...; choose Date under 
> Category and December under Format (or Format code  for days). 
> Note that the appearance of your table is now exactly as you wanted it.
> o Sort your values normally, using Numeric for "Key type".
> 
> o Copy your table (text) data (or parts of it) to a spreadsheet.
> o Sort the material in the spreadsheet. On the Options tab of the 
> Sort dialogue, tick "Custom sort order" and select 
> "January,February,March...". (Days are also available.)
> o Copy the sorted material back to your table in Writer.
> 
> o Copy your table (text) data (or parts of it) to a spreadsheet.
> o Convert values there to genuine dates, using available functions.
> o Sort the material in the spreadsheet (using normal numeric sort).
> o Either freeze the date values back to text, using TEXT(), and copy 
> the results back into your Writer table,
> o Or copy the date values back and format them appropriately there.
> 
> There are probably more ...
> 
> I trust this helps.
> 
> Brian Barker
> 
> 
> -- 
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
> 
-- 
  dave boland
  dbola...@fastmail.fm

-- 
http://www.fastmail.com - Same, same, but different...


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Sorting table (Writer) with months or days

[dave boland]

How do I get Writer to sort a table using a column with months (January,
February, March, etc).) or days (Monday, Tuesday, Wednesday, etc.)?  I
know that if I change them to a numeric representation it will work, but
that is not what I want to do.

Thanks,
Dave
-- 
  dave boland
  dbola...@fastmail.fm

-- 
http://www.fastmail.com - Access your email from home and the web


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted