Re: [libreoffice-users] Re: Thank goodness for opening legacy formats
Thanks Stuart. I normally keep my old RPM files, this clears up a lot of disk space :) On 01/06/16 12:14, V Stuart Foote wrote: Well sure. But remember, even if some of the "legacy" deprecated document formats are eventually removed The Document Foundation sponsors an archive of prior LibreOffice project release builds. http://downloadarchive.documentfoundation.org/libreoffice/old/ So you are covered either way :-) -- View this message in context: http://nabble.documentfoundation.org/Thank-goodness-for-opening-legacy-formats-tp4184933p4184935.html Sent from the Users mailing list archive at Nabble.com. -- 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] Thank goodness for opening legacy formats
Quoting Tim---Kracked_P_P---webmaster : Today I downloaded a 2006-ish C++ teacher's guide saved using the .sxw file format. The format shows OpenOffice.org 1.0 text document, in Caja file manager [Ubuntu MATE]. I remember using OOo 1.x and the only issues were not MS Office 97-2003 formats were not supported. I loved it when I was able to read/write .doc files, since I was transitioning from Windows to Linux and MSO 2003 to a free open-source office suite. Today was the first time in 7 or 8 years that I had to open a .sxw file. Thank goodness LO still have support with those file formats. MSO no longer supports their early file formats, so I had to make sure I re-saved all my early Word, WordPerfect, etc. documents to the more "modern" formats [Word 95 floppy era]. I never thought I would find/download .sxw files again. To be honest, I lost a lot of documents because I could not find a working copy of the word processor that I created them with - i.e. before or early Windows software. Hi Tim, I can't remember the name of it right now, but there's a free software project that specifically aims to maintain the ability to read a great whack of legacy formats for cases such as you describe. Libre office and other sw use their work to import. Sounds boring as hell to me but the kind of thing that when you need it you need it bad. Dave -- 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 -- "As long as politics is the shadow cast on society by big business, the attenuation of the shadow will not change the substance." -- John Dewey -- 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] Re: copying down references to other cells turns text to UPPERCASE
I can confirm it also occurs in version 5.2.2, Windows 7, 32 bits, starter edition. --- El software de antivirus Avast ha analizado este correo electrónico en busca de virus. https://www.avast.com/antivirus -- 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] Re: Thank goodness for opening legacy formats
Well sure. But remember, even if some of the "legacy" deprecated document formats are eventually removed The Document Foundation sponsors an archive of prior LibreOffice project release builds. http://downloadarchive.documentfoundation.org/libreoffice/old/ So you are covered either way :-) -- View this message in context: http://nabble.documentfoundation.org/Thank-goodness-for-opening-legacy-formats-tp4184933p4184935.html Sent from the Users mailing list archive at Nabble.com. -- 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] Thank goodness for opening legacy formats
Today I downloaded a 2006-ish C++ teacher's guide saved using the .sxw file format. The format shows OpenOffice.org 1.0 text document, in Caja file manager [Ubuntu MATE]. I remember using OOo 1.x and the only issues were not MS Office 97-2003 formats were not supported. I loved it when I was able to read/write .doc files, since I was transitioning from Windows to Linux and MSO 2003 to a free open-source office suite. Today was the first time in 7 or 8 years that I had to open a .sxw file. Thank goodness LO still have support with those file formats. MSO no longer supports their early file formats, so I had to make sure I re-saved all my early Word, WordPerfect, etc. documents to the more "modern" formats [Word 95 floppy era]. I never thought I would find/download .sxw files again. To be honest, I lost a lot of documents because I could not find a working copy of the word processor that I created them with - i.e. before or early Windows software. -- 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
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
[libreoffice-users] Re: copying down references to other cells turns text to UPPERCASE
Pedro wrote > I can confirm it also occurs in version 5.1.3.2 x64 under Windows 7 Pro > x64 > > (so it's not a Windows > I meant it's not a Linux only problem. Interestingly the problem also does NOT occur with version 5.1.3.2 under Windows 10 Home x64 -- View this message in context: http://nabble.documentfoundation.org/copying-down-references-to-other-cells-turns-text-to-UPPERCASE-tp4184881p4184927.html Sent from the Users mailing list archive at Nabble.com. -- 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
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
Re: [libreoffice-users] Re: copying down references to other cells turns text to UPPERCASE
I can't reproduce this in 5.1.3.2-6.6 on openSUSE. I have interpreted the instructions as; enter text "cat" into sheet1.A1 enter "=Sheet1.A1" into sheet2.A1 copy sheet2.A1 (Ctl c) select sheet2.A1:sheet2.A120 paste (Ctl v) I have also tried entering "cat" into Sheet1.A1:Sheet1.A120 and dragging sheet2.A1 down so that the references increment (=Sheet1.A1 =Sheet1.A2 =Sheet1.A3 etc.) Steve On 2016-06-01 04:48, Rob wrote: Can’t reproduce this in OSX El Capitan (10.11.4) with LO 5.0.4.2 Rob. Op 31 mei 2016, om 18:16 heeft Pedro het volgende geschreven: Hi Thomas Thomas Boehm wrote I found an annoying bug (or is it a feature?) in Calc. When I create a new document in calc and fill column A in Sheet1 with text. Now I add Sheet2 and put "=Sheet1.A1" in cell A1 of Sheet2. Everything behaves as expected so far. If I copy down A1 in Sheet2 up to A99 everything is fine too, but if I copy it down until A100 or more everything turns UPPERCASE and I cannot change it. I'm using LO 5.1.3.2 at the moment, but I observed this behavior in earlier versions too. Am I doing something wrong or is this really a bug? It is indeed a bug! A very similar problem has been reported https://bugs.documentfoundation.org/show_bug.cgi?id=99753 Maybe you can open a new bug report with your description? (it doesn't seem to be exactly the same and developers are very picky) I can confirm it also occurs in version 5.1.3.2 x64 under Windows 7 Pro x64 (so it's not a Windows Hope this helps Pedro -- View this message in context: http://nabble.documentfoundation.org/copying-down-references-to-other-cells-turns-text-to-UPPERCASE-tp4184881p4184887.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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
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] Re: copying down references to other cells turns text to UPPERCASE
Can’t reproduce this in OSX El Capitan (10.11.4) with LO 5.0.4.2 Rob. > Op 31 mei 2016, om 18:16 heeft Pedro het volgende > geschreven: > > Hi Thomas > > > Thomas Boehm wrote >> I found an annoying bug (or is it a feature?) in Calc. When I create a >> new document in calc and fill column A in Sheet1 with text. Now I add >> Sheet2 and put "=Sheet1.A1" in cell A1 of Sheet2. Everything behaves as >> expected so far. >> >> If I copy down A1 in Sheet2 up to A99 everything is fine too, but if I >> copy it down until A100 or more everything turns UPPERCASE and I cannot >> change it. >> >> I'm using LO 5.1.3.2 at the moment, but I observed this behavior in >> earlier versions too. >> >> Am I doing something wrong or is this really a bug? > > It is indeed a bug! > > A very similar problem has been reported > https://bugs.documentfoundation.org/show_bug.cgi?id=99753 > > Maybe you can open a new bug report with your description? (it doesn't seem > to be exactly the same and developers are very picky) > > I can confirm it also occurs in version 5.1.3.2 x64 under Windows 7 Pro x64 > (so it's not a Windows > > Hope this helps > Pedro > > > > -- > View this message in context: > http://nabble.documentfoundation.org/copying-down-references-to-other-cells-turns-text-to-UPPERCASE-tp4184881p4184887.html > Sent from the Users mailing list archive at Nabble.com. > > -- > 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 > -- 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] Re: copying down references to other cells turns text to UPPERCASE
Hi Thomas Thomas Boehm wrote > I found an annoying bug (or is it a feature?) in Calc. When I create a > new document in calc and fill column A in Sheet1 with text. Now I add > Sheet2 and put "=Sheet1.A1" in cell A1 of Sheet2. Everything behaves as > expected so far. > > If I copy down A1 in Sheet2 up to A99 everything is fine too, but if I > copy it down until A100 or more everything turns UPPERCASE and I cannot > change it. > > I'm using LO 5.1.3.2 at the moment, but I observed this behavior in > earlier versions too. > > Am I doing something wrong or is this really a bug? It is indeed a bug! A very similar problem has been reported https://bugs.documentfoundation.org/show_bug.cgi?id=99753 Maybe you can open a new bug report with your description? (it doesn't seem to be exactly the same and developers are very picky) I can confirm it also occurs in version 5.1.3.2 x64 under Windows 7 Pro x64 (so it's not a Windows Hope this helps Pedro -- View this message in context: http://nabble.documentfoundation.org/copying-down-references-to-other-cells-turns-text-to-UPPERCASE-tp4184881p4184887.html Sent from the Users mailing list archive at Nabble.com. -- 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] copying down references to other cells turns text to UPPERCASE
Hi list, I found an annoying bug (or is it a feature?) in Calc. When I create a new document in calc and fill column A in Sheet1 with text. Now I add Sheet2 and put "=Sheet1.A1" in cell A1 of Sheet2. Everything behaves as expected so far. If I copy down A1 in Sheet2 up to A99 everything is fine too, but if I copy it down until A100 or more everything turns UPPERCASE and I cannot change it. I'm using LO 5.1.3.2 at the moment, but I observed this behavior in earlier versions too. Am I doing something wrong or is this really a bug? Thanks Thomas -- 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
