date:20170424

Re: [libreoffice-users] Pop Up Notifications

2017-04-24 Thread Ian Whitfield

If you use Thunderbird for your eMail add the extension "ReminderFox" - 
It does this kind of thing perfectly!!



On 04/24/2017 07:13 PM, charles meyer wrote:

My esteemed listmates,


I’m wondering if in Libre Writer or Calc  a user can set up a sound or
pop-up notification of an approaching deadline which sounds or pop-sup when
you power on the PC or while Windows is open even though Word or Excel is
*not* open?


Ex. Due date for auto tire rotation – You don’t have Libre Writer or Calc
open but Windows 7 is open.  A sound  (e.g. .mp3) launches or a box pops-up
alerting you that in one week you need to rotate your tires.


This is just an example so please don’t explore the issue of rotating
tires! :)


I was reading/watching these Excel suggestions (below)  but they don’t seem
  to  answer my questions about alerting sounds or pops-ups  if the program
is not open.


https://excel.tips.net/T003179_Alerts_About_Approaching_Due_Dates.html

https://www.youtube.com/watch?v=BiDfI4-kngw


Has anyone set these kinds of notification?


Thanks so much.


Charles.



--

--
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] Automated table row numbering in Writer?

2017-04-24 Thread Mauricio Baeza

21. Apr 2017 22:53 by c...@almostconnecticut.net:


> I am making tables in LibreWriter. The structure is one short column
> with a couple of numbers, followed by one long column with information
> that I type in. The individual rows are eventually cut out and put into stamp 
> albums.
>
>  I've looked around for a "table row" field and I can't find one. One
>  of the numbers in the first column is sequential and will serve as a
>  page number after I stick that row into the album. It would be
>  wonderful if I could insert a field and have the rows number
>  themselves - especially for those times I go back and discover that I
>  left something out 50 rows before.
>
> If there is a way of doing that...is there then a way of assigning a
> specific number to the first instance and letting it increment from
> there?
>
> I could almost certainly do this in Calc, but Calc lacks a few
> formatting niceties, and I'd prefer to keep it in Writer if I can.
>
> Thanks!
>
>




ok... 





select column and press F12




Best regards




Mauricio Baeza














 


-- 
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] Libre Writer or Excel - File Name List - Pritning

2017-04-24 Thread Paul D. Mirowsky

Have you added the metadata from C:\Music\Sinatra\CapitolYears\MyWay to 
your files?




On 4/24/2017 1:10 PM, charles meyer wrote:

My learned and esteemed listmates,

I wish to print the names of every artist with their respective album names
and with each respective song tile (file named as such – e.g. My Way) under
that album name (sub-folder).

I’ve saved these files as such:

Artist name (mostly in alphabetical descending order – A – Z) each a
separate folder.

Ex. Frank Sinatra (the folder)

Under that artist’s name (folder) is often (but not always) a sub-folder
with an album name

Ex. The Capitol Years

Under each album (or artist alone if an album had not been created for
that artist) are all the songs.

Ex. My Way
  Love and Marriage
  New York New York
 Etc.

In many instances there will be no album listed as there may be only one
song under that artist.

Ex. Elvis
   Return to Sender

Summary: This is how it looks on my hard drive?

C:\Music\Sinatra\CapitolYears\MyWay
…along with other songs (as .mp3 or .wav files) listed in the Folder
(Capitol Years) under the Folder (Sinatra).

I’ve already had one external hard drive die suddenly with music on it. I
want to, at the very least, have a list of all my music on this external
hard drive so when it dies I’ll have all the music list printed.

Is there an *easy* way to do this in Windows 7 (32 bit)?


I downloaded the ptdirprn-setupexe from KAREN’S Directory Printer (
https://karenware.com/ - to a flash drive and then copied and pasted it
into C:\Download folder on my desktop hard drive.

It’s 1,266 kb but when I tried to open it under my Admin user (it prompted
that for an install) I get the error message - ”Installer integrity check
has failed. Common causes include an incomplete download and damaged media.
Contact the installer’s author to a obtain a new copy. More info at
http:/nsis.sf.nsis_error.

I downloaded that same file three times and each time got the same error
message.

I then downloaded -
https://www.pendriveapps.com/create-a-list-of-songs-album-printer - and it
only displays some of the artists (less then 1/3) and not alphabetically
and not their albums – just a very haphazard list.

I’d very much appreciate your suggestions about any freeware which could
generate a full music list of artists, albums and song tittles for
printing.

Thank you!

Charles.




--
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] Pop Up Notifications

2017-04-24 Thread James Knott

Google calendar has notifications or can send an email, so you'll know
when to rotate your tires.  ;)


On 04/24/2017 01:13 PM, charles meyer wrote:
> My esteemed listmates,
>
>
> I’m wondering if in Libre Writer or Calc  a user can set up a sound or
> pop-up notification of an approaching deadline which sounds or pop-sup when
> you power on the PC or while Windows is open even though Word or Excel is
> *not* open?
>
>
> Ex. Due date for auto tire rotation – You don’t have Libre Writer or Calc
> open but Windows 7 is open.  A sound  (e.g. .mp3) launches or a box pops-up
> alerting you that in one week you need to rotate your tires.
>
>
> This is just an example so please don’t explore the issue of rotating
> tires! :)
>
>
> I was reading/watching these Excel suggestions (below)  but they don’t seem
>  to  answer my questions about alerting sounds or pops-ups  if the program
> is not open.
>
>
> https://excel.tips.net/T003179_Alerts_About_Approaching_Due_Dates.html
>
> https://www.youtube.com/watch?v=BiDfI4-kngw
>
>
> Has anyone set these kinds of notification?
>
>
> Thanks so much.
>
>
> Charles.
>


-- 
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] Pop Up Notifications

2017-04-24 Thread charles meyer

My esteemed listmates,


I’m wondering if in Libre Writer or Calc  a user can set up a sound or
pop-up notification of an approaching deadline which sounds or pop-sup when
you power on the PC or while Windows is open even though Word or Excel is
*not* open?


Ex. Due date for auto tire rotation – You don’t have Libre Writer or Calc
open but Windows 7 is open.  A sound  (e.g. .mp3) launches or a box pops-up
alerting you that in one week you need to rotate your tires.


This is just an example so please don’t explore the issue of rotating
tires! :)


I was reading/watching these Excel suggestions (below)  but they don’t seem
 to  answer my questions about alerting sounds or pops-ups  if the program
is not open.


https://excel.tips.net/T003179_Alerts_About_Approaching_Due_Dates.html

https://www.youtube.com/watch?v=BiDfI4-kngw


Has anyone set these kinds of notification?


Thanks so much.


Charles.

-- 
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] Libre Writer or Excel - File Name List - Pritning

2017-04-24 Thread charles meyer

My learned and esteemed listmates,

I wish to print the names of every artist with their respective album names
and with each respective song tile (file named as such – e.g. My Way) under
that album name (sub-folder).

I’ve saved these files as such:

Artist name (mostly in alphabetical descending order – A – Z) each a
separate folder.

Ex. Frank Sinatra (the folder)

Under that artist’s name (folder) is often (but not always) a sub-folder
with an album name

Ex. The Capitol Years

Under each album (or artist alone if an album had not been created for
that artist) are all the songs.

Ex. My Way
 Love and Marriage
 New York New York
Etc.

In many instances there will be no album listed as there may be only one
song under that artist.

Ex. Elvis
  Return to Sender

Summary: This is how it looks on my hard drive?

C:\Music\Sinatra\CapitolYears\MyWay
…along with other songs (as .mp3 or .wav files) listed in the Folder
(Capitol Years) under the Folder (Sinatra).

I’ve already had one external hard drive die suddenly with music on it. I
want to, at the very least, have a list of all my music on this external
hard drive so when it dies I’ll have all the music list printed.

Is there an *easy* way to do this in Windows 7 (32 bit)?


I downloaded the ptdirprn-setupexe from KAREN’S Directory Printer (
https://karenware.com/ - to a flash drive and then copied and pasted it
into C:\Download folder on my desktop hard drive.

It’s 1,266 kb but when I tried to open it under my Admin user (it prompted
that for an install) I get the error message - ”Installer integrity check
has failed. Common causes include an incomplete download and damaged media.
Contact the installer’s author to a obtain a new copy. More info at
http:/nsis.sf.nsis_error.

I downloaded that same file three times and each time got the same error
message.

I then downloaded -
https://www.pendriveapps.com/create-a-list-of-songs-album-printer - and it
only displays some of the artists (less then 1/3) and not alphabetically
and not their albums – just a very haphazard list.

I’d very much appreciate your suggestions about any freeware which could
generate a full music list of artists, albums and song tittles for
printing.

Thank you!

Charles.

-- 
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] Enhancements to Calc functions

2017-04-24 Thread toki

On 04/23/2017 02:12 PM, David Lynch wrote:

> SUBSTITUTE("Text"; "SearchText"; "NewText"; Occurrence)
> REPLACE("Text"; Position; Length; "NewText")

What is the use case for those functions?

> MATCH(SearchCriterion; LookupArray; Type)

Why use this, rather than VLookUp or HLookUp?

jonathon

-- 
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: Libreoffice Base

2017-04-24 Thread toki

On 04/24/2017 02:40 PM, Robert Großkopf wrote:

> I won't change to Firebird with any version of LO at this moment.

I haven't been following the FireBird migration.  (I'd rather use
SQLite. But SQLite is only for those who like to live dangerously.)

> There is no problem to use the internal HSQLDB. It will work much
> better than the internal Firebird-database at this moment. 

My concern is/was HSqlDb gets dropped from LibO. OTOH, even after being
dropped, it can be used as an external database. And, on the gripping
hand, it looks like in LibO 5.3.2.1 dBase 3 support is still alive. So
maybe a decade from now, both HSqlDB and FireBird support will be built
into LibO.

jonathon

-- 
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: Libreoffice Base

2017-04-24 Thread Robert Großkopf

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi John,

> Thank you for your reply. I am using Libreoffice on Microsoft
> Windows 10 and always update Libreoffice when one becomes
> available. I have seen comments that say Java can be a problem, if
> you moved over to Firebird does this remove Java. These are
> questions being raised by someone who loves to experiment but does
> not have a clue when it comes to programming, I leave that to the
> experts. If I continue to develop my database(s) and a change from
> HSQLdb to Firebird takes place what effect might that have?

I won't change to Firebird with any version of LO at this moment.
Firebird is experimental since LO 4.2. Internal Firebird-DB has been
changed with LO 5.3 to a new version and those people, who have used
the experimental version for all LO-versions before have problems to
get the data from the old FB 2.5 to the new FB 3.0.

There is no problem to use the internal HSQLDB. It will work much
better than the internal Firebird-database at this moment. Many
databases have been designed with the internal HSQLDB. So it wouldn't
be moved away suddenly. There is no problem to switch from the
internal HSQLDB to a external HSQLDB.

I you need a more stable database: Switch to a external database. If
you need a database with more functions than the old HSQLDB you could
use MySQL/MariaDB or PostgreSQL or something else.

Java will also be nedded when using the internal Firebir-Database. It
isn't only the connection to the internal HSQLDB, which will need Java.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJY/g5FAAoJELDKYwaoS9AISI8P/1WE/MlIX7zcAn5Ww/bE7R+4
5G4lSr26i7Frt4IoT2w2tj1Q5YGb/XFUnBQmtNFaMEb+InkSOX1pV4SiyVeG0Qqg
Xiv3xH3tHh5bWGqSymN4ni+xNXkqFDcTm9XtcBp39L1zHEcVpGmiIeEadMZj0dcw
uzSwwKWe06vHynAEX43LAuNjYu1NLLbxejtbSz7OR5/5nS/LYXMBjleRIib7rv8F
qcC/HAWfWd6cupYeZkUt0aHW9kyEFvXIoNm4A3gwAmsKyLOsHfjFAsSBBBZ4h+US
J+lzdNqwyZ7F1r7q5dmHEzfiRPMlA4MHmOfpcodc8H/qgY5uJfpRYO6u/w0ClTFz
8BvX5PRZaHK08f3dMWfCx0ZtnFGsg7SKBz9UCtuJ299xpZ3TfitWHXiS00NAZ3Ch
wXJyo9sEdLGYHBQEBlY/bq37jOhkGYW6dtnZiQkO3Sh07RkRVoWBmgx0ES11vw66
IorgP0ydzSYVDm/AqR+A+9OyVa1x9zo4awM72M/M06hn+8IKpl4aJg93DrMJDUqo
tYalR+PuYzSxccVsZiPxa04+j/nFGPriDanG7OJl8SPQD4/mPBsT2EH+GxlEIwsJ
OzSXtOaiD6NTT6gZgf4BhEF1JymA+NUplWvP62bbAFrUSkZtsT+JK4dSyx8MH3ib
UFtlS0dDLTOh4nY/7CK2
=VZrY
-END PGP SIGNATURE-

-- 
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: Libreoffice Base

2017-04-24 Thread lismurn

Hi Jonathan,
Thank you for your reply. I am using Libreoffice on Microsoft Windows 10
and always update Libreoffice when one becomes available. I have seen
comments that say Java can be a problem, if you moved over to Firebird does
this remove Java. These are questions being raised by someone who loves to
experiment but does not have a clue when it comes to programming, I leave
that to the experts.
If I continue to develop my database(s) and a change from HSQLdb to
Firebird takes place what effect might that have?

John

On 22 April 2017 at 06:50, toki [via Document Foundation Mail Archive] <
ml-node+s969070n4213006...@n3.nabble.com> wrote:

> On 04/21/2017 07:00 AM, lismurn wrote:
>
> > 1.  Is Base being supported or is it dead in the water.
>
> Base is, and will continue to be supported.
>
> The embedded database engine is in the process of changing from HSQLdb
> to FireBird. This change has caused some users to be confused, and think
> that the Base component is going away.
>
> > I am trying to assemble a small database but wonder should I continue if
> it is not being supported.
>
> Spend some time thinking about which database engine you want to use.
>
> Base can be used both as a database front end, or as combined front
> end/database engine.
>
> I don't know Base well enough to answer the rest of your questions. :(
>
> jonathon
>
> --
> To unsubscribe e-mail to: [hidden email]
> 
> 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
>
>
>
> --
> If you reply to this email, your message will be added to the discussion
> below:
> http://nabble.documentfoundation.org/Libreoffice-Base-
> tp4212918p4213006.html
> To unsubscribe from Libreoffice Base, click here
> 
> .
> NAML
> 
>




--
View this message in context: 
http://nabble.documentfoundation.org/Libreoffice-Base-tp4212918p4213010.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] Setting Defaults [SOLVED]

2017-04-24 Thread Ian Whitfield


*Thanks Cley*

That did it for me - It was not the 'Local' or the 'User Profile' that 
was out - but thanks to others for the suggestions!!


It was just the convoluted (IMHO) way that LO works to achieve this.
I my World I would suggest that a better way to do this is to have a 
"Default" set of settings, (that you change in Preferences), and these 
are how the Program _always_ starts up. Then if you need special 
Templates you select this after the Program is started and they over 
ride the Default.


Just my Penny/Cent's worth!! But at least I've solved this problem that 
has bugged me for a long time!!


So thanks to all

IanW
Pretoria RSA




--
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] Pop Up Notifications

Re: [libreoffice-users] Automated table row numbering in Writer?

Re: [libreoffice-users] Libre Writer or Excel - File Name List - Pritning

Re: [libreoffice-users] Pop Up Notifications

[libreoffice-users] Pop Up Notifications

[libreoffice-users] Libre Writer or Excel - File Name List - Pritning

Re: [libreoffice-users] Enhancements to Calc functions

Re: [libreoffice-users] Re: Libreoffice Base

Re: [libreoffice-users] Re: Libreoffice Base

[libreoffice-users] Re: Libreoffice Base

Re: [libreoffice-users] Setting Defaults [SOLVED]

11 matches

Site Navigation

Mail list logo

Footer information