[libreoffice-users] Re: LibreOffice Base and MySQL

[Andreas Säger]

Am 21.01.2016 um 13:20 schrieb Heinrich Stoellinger:
> Of course these are valid values as for as CSV is concerned, but not ALL
> are
> valid as far as MySQL goes. I have no problem restoring MySQL-DATE COLUMN
> values, but represent them as "2014-12-22", the same as character strings.
> Forget Base at the moment and deal with the stipulations of SQL, in
> particular
> MySQL.
> 
> On Thu, 21 Jan 2016 11:37:51 +0100, Jaroslaw Staniek 
> wrote:
> 

Of course, ISO dates are the one and only unambiguous standard for date
strings. It is not too difficult to convert other date strings with 3
numbers and 2 separators into ISO strings which can be converted to real
date values.


-- 
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: question about the best version of libreoffice:

[Philip Jackson]

On 21/01/16 12:43, Pedro wrote:
> Returning to the subject I believe it would be useful to find out what is
> making people stick to older (and in particular discontinued) versions. If
> it is because the new features in new versions are not useful to them but
> the version they use fulfills all their needs, then it is fine. But if the
> cause are regressions then it is something to worry about.

I wouldn't think this anything peculiar to LO nor is it anything to
worry about.  It is a reflection of what is happening every where in the
tech world.

Any established product (hardware or software) reaches a point in its
development where a large number of users are entirely satisfied with
the offer.  The devs keep working on new versions with some, although
increasingly fewer, new features because that is what devs do.

These newer versions with extra features are accepted as part of the
background by newcomers to the product but the extra features are
considered as uninteresting bells and whistles by large numbers of the
existing users, the old-timers who stick to what they've already got.

It is becoming increasingly more difficult to invent a new 'wheel' and
in circles where users have to buy the product, this is causing
producers to turn away from selling to renting.

Philip

-- 
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: question about the best version of libreoffice:

[V Stuart Foote]

Virgil Arrington wrote
> On 01/21/2016 06:43 AM, Pedro wrote:
>> Returning to the subject I believe it would be useful to find out what 
>> is making people stick to older (and in particular discontinued) 
>> versions. If it is because the new features in new versions are not 
>> useful to them but the version they use fulfills all their needs, then 
>> it is fine. But if the cause are regressions then it is something to 
>> worry about. Just my 2 cents.
> 
> ...
> 
> All this to say that I'll continue to use LO 4 until it no longer 
> performs my work. Then I'll upgrade to the most stable of the "still" 
> versions available at that time. Who knows, by then it could be LO 
> 6.x.5. But, my days of trying a newer version simply because it's 
> available are over.

And that is absolutely fine!  In fact for those with similar inclinations,
here is a link to our archived releases:

/librreoffice/old
  

Of course even from these users we (the LibreOffice project) really need
folks to install the developmental and pre-releases, in parallel of course
[1], both to see emerging features (or regressions) but more importantly to
provide feed back to the design, development and QA process. That is an
aspect of care and feeding a FOSS project that users should not abdicate.
LibreOffice is a great project, please participate.

Stuart

=-ref-=
1. https://wiki.documentfoundation.org/Installing_in_parallel





--
View this message in context: 
http://nabble.documentfoundation.org/question-about-the-best-version-of-libreoffice-tp4172346p4172585.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] footnotes numbering problem

[Wojciech Górnaś]

Thank you Brian, thank you Piet!
Worked just fine (in the original large file too). I do appreciate your 
help, it saved me a lot of time and work.
If applied carefully, your method is a simple and useful tool to convert 
footnotes.


Best regards
Wojciech

W dniu 21.01.2016 o 12:21, Piet van Oostrum pisze:

Brian Barker wrote:

  > You could unzip the .odt file, extract
  > content.xml, examine this to determine how
  > Automatic and Character footnote anchors are
  > differently represented, edit it as necessary,
  > rezip the .odt file using the edited content.xml
  > - and hope it works! But I don't recommend this.
  >
I tried this out and it appears to be easy:

The text is in the content.xml file in the zip file.
The footnotes are of the form

6
followed by a 
(For some reason all the footnote numbers are equal to the last one:6)

In an automatic footnote, the text:label="6" part is missing. So removing this, 
changes them to automatic. Then, they will be numbered A, B, C, ... If you want to change this 
to numbers, do it with Tools > Footnotes > Numbering as has been mentioned by Brian in an 
earlier message.

Of course you should do this on a copy of your file, not on the original (or 
have a copy saved).


--
I’ve seen the other side of rainbow, and it was black and white.

ʞǝʇɾoʍ


--
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 and MySQL

[Heinrich Stoellinger]

Of course these are valid values as for as CSV is concerned, but not ALL are
valid as far as MySQL goes. I have no problem restoring MySQL-DATE COLUMN
values, but represent them as "2014-12-22", the same as character strings.
Forget Base at the moment and deal with the stipulations of SQL, in particular
MySQL.

On Thu, 21 Jan 2016 11:37:51 +0100, Jaroslaw Staniek  wrote:


On 20 January 2016 at 21:34, Andreas Säger  wrote:


How can anybody solve any csv related problem without knowing anything
about
the actual content?

4 different lines of perfectly valid and commonly used csv data:

1234.98;2014-12-22
1.234,98;22 Dez 2014
1234.98;12/22/14
1234.98;22/12/14

Each line carries the exact same information. I could add a thousand more
different lines with the exact same values without leaving the conventions
of valid csv.



​Exactly, this is why I have invested in pretty a intelligent
auto-detection of data types​
​ and representation of values in Kexi​

​CSV importer.​ Yes, dates values are the most tricky.

Sure, the auto-detection has limits, importing has to be _interactive_ at
times, at least until we "know" all the options user wants to use, then the
user would be able to save and re-use an 'import specification'.
For complicated import cases it's not a matter of a custom SQL statement,
it's sometimes a trial-and-error process.

The only thing I would regret is that we have no organized FOSS effort to
share such routines and every app has own. Not yet at least.

(Ian has sent me a rich feedback off the list, work in progress)





--
View this message in context:
http://nabble.documentfoundation.org/LibreOffice-Base-and-MySQL-tp4172396p4172475.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








--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

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

[nasrin khaksar]

we also believe all prophets, there prophethood and there holy books.
all religions have commen views and ideas, but the religion of islam
is the last divine religion that all prophets, gave good news to there
followers about its comming and prophet mohammad peace be upon him and
his progeny.
the desire of all divine prophets is guidance of mankind.
but all people are born according to divine mettle and nature and the
people  are not sinful from there birthday.
all people are good when they are born and they should try to maintain
there morality, virtues and divine nature.

-- 
O people! there has come to you indeed an admonition from your Lord
and a healing for what is in the breasts and a guidance and a mercy
for the believers.
Say: In the grace of Allah and in His mercy-- in that they should
rejoice; it is better than that which they gather.
holy quran, chapter 10.

please visit al-islam.org


On 1/21/16, nasrin khaksar  wrote:
> and i pray for you and thank your greeting and peace.
> i pray that you study holy quran and the life and sayings of prophet
> mohammad peace be upon him and his progeny.
> as i mentioned, we believe all divine prophets and also there holy
> books and prophethood including prophet jesus peace be upon him.
>
>
> On 1/21/16, nasrin khaksar  wrote:
>> and also we and all belivers of divine religions convince monotheism
>> and eternity of god.
>> also we believe that prophet jesus is alive and appeare with emam
>> mahdi peace be upon him. who is rescue for all mankind.
>>
>> On 1/21/16, James E. Lang  wrote:
>>> -Original Message-
>>> From: nasrin khaksar < >
>>> To: jim+...@lang.hm
>>> Sent: Thu, 21 Jan 2016 1:39
>>> Subject:
>>>
>>> hi jim.
>>> thanks for your answer.
>>>
>>> [You are very welcome. You were entitled the respect of the best answer
>>> I
>>> could give. My primary usage of LibreOffice is its spreadsheet
>>> functionality. -- jl]
>>>
>>> -->8=
>>>
>>> we believe that prophet jesus is divine messenger and servant of god.
>>>
>>> [We believe much more. We believe that there is one God, the creator of
>>> everything including time itself, who exists eternally (with neither
>>> beginning nor end) in three persons (Father, Son, and Holy Spirit).
>>> Jesus
>>> of
>>> Nazareth (Christ, the Anointed One, Messiah) is God the Son himself who
>>> lived on earth in human form and who died a physical death on a Roman
>>> cross
>>> in our place as the only final and perfect sacrifice for our sins. He
>>> rose
>>> from the grave on the third day. See Philippians chapter 2 verses 1
>>> through
>>> 11 in the Holy Bible. We believe there is no other way to reconcile with
>>> God
>>> (Jehovah) than to accept His sacrifice in our place for our sin. I am
>>> aware
>>> that Islamic theology teaches differently but I pray that you will
>>> receive
>>> the teachings in the Holy Bible with an open mind and a joyful heart.
>>> Jesus
>>> said, "I am the way, the truth, and the life. No man comes to the Father
>>> but
>>> by Me." He also said, speaking of Jehovah, "I and my Father are one." He
>>> is
>>> who He says He is or He is a false prophet being either a blatant
>>> blasphemer
>>> or a lunatic. You cannot simply classify Him as a "divine messenger and
>>> servant of god (sic)." -- jl]
>>>
>>> -->8=
>>>
>>> --
>>> Jim
>>
>>
>> --
>> O people! there has come to you indeed an admonition from your Lord
>> and a healing for what is in the breasts and a guidance and a mercy
>> for the believers.
>> Say: In the grace of Allah and in His mercy-- in that they should
>> rejoice; it is better than that which they gather.
>> holy quran, chapter 10.
>>
>> please visit al-islam.org
>>
>
>
> --
> O people! there has come to you indeed an admonition from your Lord
> and a healing for what is in the breasts and a guidance and a mercy
> for the believers.
> Say: In the grace of Allah and in His mercy-- in that they should
> rejoice; it is better than that which they gather.
> holy quran, chapter 10.
>
> please visit al-islam.org
>


-- 
O people! there has come to you indeed an admonition from your Lord
and a healing for what is in the breasts and a guidance and a mercy
for the believers.
Say: In the grace of Allah and in His mercy-- in that they should
rejoice; it is better than that which they gather.
holy quran, chapter 10.

please visit al-islam.org

-- 
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: question about the best version of libreoffice:

[Virgil Arrington]

On 01/21/2016 06:43 AM, Pedro wrote:
Returning to the subject I believe it would be useful to find out what 
is making people stick to older (and in particular discontinued) 
versions. If it is because the new features in new versions are not 
useful to them but the version they use fulfills all their needs, then 
it is fine. But if the cause are regressions then it is something to 
worry about. Just my 2 cents.


I'm currently using LO 4.4.7.2. I recently tried LO 5.0.x (can't 
remember the third digit). I suffered daily crashes with it, usually 
when trying to open or save documents. I went back to 4.


I was recently thinking that my old OOo 3.2 did everything I ever needed 
in an office suite. (I use writer 95% of the time, Calc 4%, and Base 
once a year when I create a mailing list for my Christmas cards). I have 
upgraded through the LO chain of versions mostly because they were 
available. However, aside from better support for Graphite fonts like 
Linux Libertine G, my LO 4 does little (for me at least) that my OOo 3.2 
didn't do. For my work, OOo 3.2 was just as stable, if not more so, than 
LO 4 (and *much* more stable than LO 5). I long ago gave up trying to 
get OOo, or LO, or AOO to properly read and write MS Word documents, or 
to have Word properly read and write .odt documents. Something is 
*always* lost in translation and I only ever expect a close 
approximation, which LO 4 gives me.


And there have been some changes along the way that I have definitely 
not liked, such as the changes to the Templates dialog boxes (totally 
unnecessary in my opinion) and the new multi-functional sidebar. At 
least on my machine, (Ubuntu 14.04 LTS) the sidebar defaults to a 
Properties box, which I *never* use, and I have to manually switch to my 
Styles box. I have tried everything to change the default box in the 
sidebar to Styles but no avail.


All this to say that I'll continue to use LO 4 until it no longer 
performs my work. Then I'll upgrade to the most stable of the "still" 
versions available at that time. Who knows, by then it could be LO 
6.x.5. But, my days of trying a newer version simply because it's 
available are over.


Virgil

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

[nasrin khaksar]

and i pray for you and thank your greeting and peace.
i pray that you study holy quran and the life and sayings of prophet
mohammad peace be upon him and his progeny.
as i mentioned, we believe all divine prophets and also there holy
books and prophethood including prophet jesus peace be upon him.


On 1/21/16, nasrin khaksar  wrote:
> and also we and all belivers of divine religions convince monotheism
> and eternity of god.
> also we believe that prophet jesus is alive and appeare with emam
> mahdi peace be upon him. who is rescue for all mankind.
>
> On 1/21/16, James E. Lang  wrote:
>> -Original Message-
>> From: nasrin khaksar < >
>> To: jim+...@lang.hm
>> Sent: Thu, 21 Jan 2016 1:39
>> Subject:
>>
>> hi jim.
>> thanks for your answer.
>>
>> [You are very welcome. You were entitled the respect of the best answer I
>> could give. My primary usage of LibreOffice is its spreadsheet
>> functionality. -- jl]
>>
>> -->8=
>>
>> we believe that prophet jesus is divine messenger and servant of god.
>>
>> [We believe much more. We believe that there is one God, the creator of
>> everything including time itself, who exists eternally (with neither
>> beginning nor end) in three persons (Father, Son, and Holy Spirit). Jesus
>> of
>> Nazareth (Christ, the Anointed One, Messiah) is God the Son himself who
>> lived on earth in human form and who died a physical death on a Roman
>> cross
>> in our place as the only final and perfect sacrifice for our sins. He
>> rose
>> from the grave on the third day. See Philippians chapter 2 verses 1
>> through
>> 11 in the Holy Bible. We believe there is no other way to reconcile with
>> God
>> (Jehovah) than to accept His sacrifice in our place for our sin. I am
>> aware
>> that Islamic theology teaches differently but I pray that you will
>> receive
>> the teachings in the Holy Bible with an open mind and a joyful heart.
>> Jesus
>> said, "I am the way, the truth, and the life. No man comes to the Father
>> but
>> by Me." He also said, speaking of Jehovah, "I and my Father are one." He
>> is
>> who He says He is or He is a false prophet being either a blatant
>> blasphemer
>> or a lunatic. You cannot simply classify Him as a "divine messenger and
>> servant of god (sic)." -- jl]
>>
>> -->8=
>>
>> --
>> Jim
>
>
> --
> O people! there has come to you indeed an admonition from your Lord
> and a healing for what is in the breasts and a guidance and a mercy
> for the believers.
> Say: In the grace of Allah and in His mercy-- in that they should
> rejoice; it is better than that which they gather.
> holy quran, chapter 10.
>
> please visit al-islam.org
>


-- 
O people! there has come to you indeed an admonition from your Lord
and a healing for what is in the breasts and a guidance and a mercy
for the believers.
Say: In the grace of Allah and in His mercy-- in that they should
rejoice; it is better than that which they gather.
holy quran, chapter 10.

please visit al-islam.org

-- 
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: question about the best version of libreoffice:

[Pedro]

Hi Andreas, all


Andreas Säger wrote
> I'm still convinced that the poster is not interested in the answer to
> his technical question. And like so often we will not see any feedback
> regarding the answers to his on topic question. Therefore I call him a
> troll.

I believe you are wrong. She has contributed with bug reports on the
tracker.

If LibreOffice wants to be universally used then it needs users from other
countries and cultures. 
This is particularly important if LibreOffice wants to handle other
characters and Right To Left (RTL) writing such as Persian or Farsi (used by
around 100 million human beings)

The fact that she adds a link to a site explaining her religion doesn't
shock me. In fact I think it follows the same logic of Open Source projects
(such as LibreOffice). If you find a good project you want to share it with
others so that they join the community and that advantage of this good thing
you found.

I do not believe in any religion but I am sure that insulting people or
their religion does not help in any way and am also sure that religion is
not a subject for this forum.

Returning to the subject I believe it would be useful to find out what is
making people stick to older (and in particular discontinued) versions. If
it is because the new features in new versions are not useful to them but
the version they use fulfills all their needs, then it is fine. But if the
cause are regressions then it is something to worry about.

Just my 2 cents.

All the best,
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/question-about-the-best-version-of-libreoffice-tp4172346p4172556.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] footnotes numbering problem

[Piet van Oostrum]

Brian Barker wrote:

 > You could unzip the .odt file, extract 
 > content.xml, examine this to determine how 
 > Automatic and Character footnote anchors are 
 > differently represented, edit it as necessary, 
 > rezip the .odt file using the edited content.xml 
 > - and hope it works! But I don't recommend this.
 > 
I tried this out and it appears to be easy:

The text is in the content.xml file in the zip file.
The footnotes are of the form

6
followed by a 
(For some reason all the footnote numbers are equal to the last one:6)

In an automatic footnote, the text:label="6" part is missing. So removing this, 
changes them to automatic. Then, they will be numbered A, B, C, ... If you want 
to change this to numbers, do it with Tools > Footnotes > Numbering as has been 
mentioned by Brian in an earlier message.

Of course you should do this on a copy of your file, not on the original (or 
have a copy saved).
-- 
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:

[nasrin khaksar]

and also we and all belivers of divine religions convince monotheism
and eternity of god.
also we believe that prophet jesus is alive and appeare with emam
mahdi peace be upon him. who is rescue for all mankind.

On 1/21/16, James E. Lang  wrote:
> -Original Message-
> From: nasrin khaksar < >
> To: jim+...@lang.hm
> Sent: Thu, 21 Jan 2016 1:39
> Subject:
>
> hi jim.
> thanks for your answer.
>
> [You are very welcome. You were entitled the respect of the best answer I
> could give. My primary usage of LibreOffice is its spreadsheet
> functionality. -- jl]
>
> -->8=
>
> we believe that prophet jesus is divine messenger and servant of god.
>
> [We believe much more. We believe that there is one God, the creator of
> everything including time itself, who exists eternally (with neither
> beginning nor end) in three persons (Father, Son, and Holy Spirit). Jesus of
> Nazareth (Christ, the Anointed One, Messiah) is God the Son himself who
> lived on earth in human form and who died a physical death on a Roman cross
> in our place as the only final and perfect sacrifice for our sins. He rose
> from the grave on the third day. See Philippians chapter 2 verses 1 through
> 11 in the Holy Bible. We believe there is no other way to reconcile with God
> (Jehovah) than to accept His sacrifice in our place for our sin. I am aware
> that Islamic theology teaches differently but I pray that you will receive
> the teachings in the Holy Bible with an open mind and a joyful heart. Jesus
> said, "I am the way, the truth, and the life. No man comes to the Father but
> by Me." He also said, speaking of Jehovah, "I and my Father are one." He is
> who He says He is or He is a false prophet being either a blatant blasphemer
> or a lunatic. You cannot simply classify Him as a "divine messenger and
> servant of god (sic)." -- jl]
>
> -->8=
>
> --
> Jim


-- 
O people! there has come to you indeed an admonition from your Lord
and a healing for what is in the breasts and a guidance and a mercy
for the believers.
Say: In the grace of Allah and in His mercy-- in that they should
rejoice; it is better than that which they gather.
holy quran, chapter 10.

please visit al-islam.org

-- 
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] use Calc rows as footer

[Brian Barker]

At 08:06 21/01/2016 +1100, Keith Bainbridge wrote:
I am trying to use 4 rows on a calc sheet as a footer, in addition 
to a header row. Can only see how to use rows as a header. Any hints please?


I don't think you can use spreadsheet rows in a header or a footer: 
strictly, what you describe here is a heading rather than a header.


A couple of workarounds:

o Repeat the necessary rows in your spreadsheet, so that they appear 
in all the correct places. If desired, insert manual page breaks to 
control what happens. Don't enter the data or formulae for your 
repeated rows multiple times; instead, insert references to a first 
instance. This will maintain reliability as you edit the spreadsheet.


o Maintain your spreadsheet as before. Copy and paste material from 
it into a header and a footer as well as the main text of a text 
(Writer) document. In each case, use Paste Special and choose "DDE 
link". Your spreadsheet material will become a table in the text 
document and it will be updated as you edit the source spreadsheet.


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

[libreoffice-users] Re: use calc rows as fooier

[Andreas Säger]

Am 20.01.2016 um 22:06 schrieb Keith Bainbridge:
> Good morning All
> 
> 
> 
> It's been a while.
> 
> 
> 
> I am trying to use 4 rows on a calc sheet as a footer, in addition to a
> header row. Can only see how to use rows as a header.
> 
> 
> Any hints please?
> 
> 
> Thanks
> 
> 
> 


If I recall correctly, the following macro writes cell contents into
page headers and footers:
> http://sourceforge.net/projects/ooomacros/files/Calc%20Header_Footer/




-- 
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: question about the best version of libreoffice:

[Andreas Säger]

Am 21.01.2016 um 01:42 schrieb Tom Davies:
> Hi :)
> Many people on this mailing list have had signatures that include
> Bible quotes or such-like without anyone grumbling or anything.  I
> thought it was nice to see something similar from a different religion
> for a change.
> 
> Regards from
> Tom :)
> 
> 
> 
> 

And I tend to ignore all of them instinctively. I would not have
answered this topic if I had noticed that sermon.
Interesting how the least relevant null topics trigger the most
extensive discussions on this list. Trolls at work.


-- 
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: question about the best version of libreoffice:

[nasrin khaksar]

hi every one.
i thank you for your time and answering my question.
i was waiting to see all comments and after that reply them.
i recieved my answer from tom and also i i appreciate him specially.

On 1/21/16, Andreas Säger  wrote:
> Am 21.01.2016 um 01:42 schrieb Tom Davies:
>> Hi :)
>> Many people on this mailing list have had signatures that include
>> Bible quotes or such-like without anyone grumbling or anything.  I
>> thought it was nice to see something similar from a different religion
>> for a change.
>>
>> Regards from
>> Tom :)
>>
>>
>>
>>
>
> And I tend to ignore all of them instinctively. I would not have
> answered this topic if I had noticed that sermon.
> Interesting how the least relevant null topics trigger the most
> extensive discussions on this list. Trolls at work.
>
>
> --
> 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
>


-- 
O people! there has come to you indeed an admonition from your Lord
and a healing for what is in the breasts and a guidance and a mercy
for the believers.
Say: In the grace of Allah and in His mercy-- in that they should
rejoice; it is better than that which they gather.
holy quran, chapter 10.

please visit al-islam.org

-- 
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 and MySQL

[Jaroslaw Staniek]

On 20 January 2016 at 21:34, Andreas Säger  wrote:

> How can anybody solve any csv related problem without knowing anything
> about
> the actual content?
>
> 4 different lines of perfectly valid and commonly used csv data:
>
> 1234.98;2014-12-22
> 1.234,98;22 Dez 2014
> 1234.98;12/22/14
> 1234.98;22/12/14
>
> Each line carries the exact same information. I could add a thousand more
> different lines with the exact same values without leaving the conventions
> of valid csv.
>

​Exactly, this is why I have invested in pretty a intelligent
auto-detection of data types​
​ and representation of values in Kexi​

​CSV importer.​ Yes, dates values are the most tricky.

Sure, the auto-detection has limits, importing has to be _interactive_ at
times, at least until we "know" all the options user wants to use, then the
user would be able to save and re-use an 'import specification'.
For complicated import cases it's not a matter of a custom SQL statement,
it's sometimes a trial-and-error process.

The only thing I would regret is that we have no organized FOSS effort to
share such routines and every app has own. Not yet at least.

(Ian has sent me a rich feedback off the list, work in progress)


>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/LibreOffice-Base-and-MySQL-tp4172396p4172475.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
>
>


-- 
regards, Jaroslaw Staniek

KDE:
: A world-wide network of software engineers, artists, writers, translators
: and facilitators committed to Free Software development - http://kde.org
Calligra Suite:
: A graphic art and office suite - http://calligra.org
Kexi:
: A visual database apps builder - http://calligra.org/kexi
Qt Certified Specialist:
: http://www.linkedin.com/in/jstaniek

-- 
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] footnotes numbering problem

[Wojciech Górnaś]

Hello, thank you both for your answers. A new link to the same document, 
saved as ODT: https://copy.com/t38Z7xRx9CrSjiNI – hope this one will 
open flawlessly.



I don't see an automatic method, but there is a manual techniques that 
is quite straightforward.


I know the manual way of doing it – although I had a good reason to ask 
about an automatic method: the original file contains 1000+ footnotes :)
This should have been written it at the very beginning: I am quite 
familiar with LO Writer and really have tried out different options. I 
decided ask my question because I really don't know what to do now.

Wojciech

o Either: place the cursor on the first footnote anchor, so that it 
changes from I-beam to a hand, and go to right-click | 
Footnote/Endnote... .
o Or: place the cursor immediately to the left of the first footnote 
anchor and go to Edit | Footnote/Endnote... .
o In the Edit Footnote/Endnote dialogue, the Numbering type is shown 
as Character; change this to Automatic.
o *Don't* click OK, but instead click the right-arrow at bottom right 
to move to the next footnote anchor.

o Repeat the process, clicking Automatic and the right-arrow each time.
o When the right-arrow becomes greyed out, you have come to the end of 
the footnote anchors; click OK.


o The label in the footnote now labelled "D" has different format from 
the others, as it has a different paragraph style. Open the Styles and 
Formatting window and correct this.


o The footnotes are now labelled A, B, C, etc. If you want to change 
this - perhaps to the conventional 1, 2, 3, etc. - go to Tools | 
Footnotes/Endnotes... | Footnotes | AutoNumbering | Numbering and make 
your choice.


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

[libreoffice-users] Re: question about the best version of libreoffice:

[Andreas Säger]

Am 21.01.2016 um 06:54 schrieb James E. Lang:
> Hi Andreas and Tom,
> 
> It was good to see that someone actually responded to the question that was 
> asked about LO. I don't make much use of Writer so I have little but civility 
> to contribute. I have *reflowed* your messages as quoted below my signature.
> 
> I would think that for the casual user of Writer who mostly uses it as a text 
> document reader like the original poster said describes his usage of LO, it 
> makes little difference which version of LO one uses. 
> 
> The diatribe that occurred against the original poster's signature block is 
> regrettable and in my opinion unwarranted. While I'm convinced that Islam is 
> in error and Christianity is true, I can pray for the followers of Islam and 
> for the peace of Jerusalem.
> 

I'm still convinced that the poster is not interested in the answer to
his technical question. And like so often we will not see any feedback
regarding the answers to his on topic question. Therefore I call him a
troll.


-- 
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] footnotes numbering problem

[Brian Barker]

At 10:01 21/01/2016 +0100, Wojciech Górnas wrote:
I know the manual way of doing it - although I 
had a good reason to ask about an automatic 
method: the original file contains 1000+ 
footnotes :) This should have been written it at 
the very beginning: I am quite familiar with LO 
Writer and really have tried out different options.


Indeed it should: this would have saved me wasted effort.


I decided ask my question because I really don't know what to do now.


You could unzip the .odt file, extract 
content.xml, examine this to determine how 
Automatic and Character footnote anchors are 
differently represented, edit it as necessary, 
rezip the .odt file using the edited content.xml 
- and hope it works! But I don't recommend this.


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] Re: question about the best version of libreoffice:

[Virgil Arrington]

On 01/21/2016 09:12 AM, V Stuart Foote wrote:
Of course even from these users we (the LibreOffice project) really 
need folks to install the developmental and pre-releases, in parallel 
of course [1], both to see emerging features (or regressions) but more 
importantly to provide feed back to the design, development and QA 
process. That is an aspect of care and feeding a FOSS project that 
users should not abdicate. LibreOffice is a great project, please 
participate. 



At the risk of sounding like a whiner, I recently tried to participate 
by reporting a bug in LO's outline numbering system (bug 96733). The 
triage volunteer didn't think much of my bug report and first offered a 
solution. When I suggested that the proffered solution didn't work, he 
responded that I shouldn't confuse my desires with what is correct (both 
of which are accomplished with LaTeX). As a result, for certain 
outlining work, I'm forced to use LaTeX when I would prefer to use LO, 
which unfortunately doesn't work either correctly or as desired. When 
attempts to participate are rebuffed, it doesn't encourage further 
participation.


Again, I apologize for my whining. I realize not everyone shares my 
priorities.


Virgil

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

[Dave Stevens]

Quoting nasrin khaksar :


we also believe all prophets, there prophethood and there holy books.
all religions have commen views and ideas, but the religion of islam
is the last divine religion that all prophets, gave good news to there
followers about its comming and prophet mohammad peace be upon him and
his progeny.
the desire of all divine prophets is guidance of mankind.
but all people are born according to divine mettle and nature and the
people  are not sinful from there birthday.
all people are good when they are born and they should try to maintain
there morality, virtues and divine nature.


Nasrin,

I don't object to your views but this is a technical support list,  
your post is off-topic. I know you aren't the only one.


Dave



--
"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] LibreOffice Base - music cataloging

[charles meyer]

Hi Libre Folks,

Happy New Year to you all.

I have many music files which appear as thus after creating a list of
file names using DOS command and saving in a word processor file:

12/31/2015  10:40 PMFile Size in MBs  1-25-2016 Bryan Ferry - Dont
Stop The Dance Art.mp3
01/09/2016  07:31 PMFile Size in MBs  1-9-2016 Talking Heads
Puzzlin Evidence.mp3
07/30/2015  10:11 PM   File Size in MBs  7-26-2015 David Bowie - Cat
People - Putting Out Fire.mp3

That’s just a short example of all the music to be cataloged.

It was suggested to me, so I could eventually sort alphabetically by
artist, that I search for a music cataloging application.

Then, I read Jack Wallen’s article
(http://www.techrepublic.com/blog/five-apps/five-free-cataloging-applications/)
where he suggested one might consider LibreOffice Base for cataloging.

For those who’ve played around with LibreOffice Base (which I have not
yet) would it be labor intensive to use Base for this purpose?

It’s complicated to take this info and import it into Excel’s cells
and columns to then sort.

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] Re:

[James Knott]

And it's all nonsense.  The bible is provably fiction.


On 01/21/2016 06:32 AM, nasrin khaksar wrote:
> and also we and all belivers of divine religions convince monotheism
> and eternity of god.
> also we believe that prophet jesus is alive and appeare with emam
> mahdi peace be upon him. who is rescue for all mankind.
>
> On 1/21/16, James E. Lang  wrote:
>> -Original Message-
>> From: nasrin khaksar < >
>> To: jim+...@lang.hm
>> Sent: Thu, 21 Jan 2016 1:39
>> Subject:
>>
>> hi jim.
>> thanks for your answer.
>>
>> [You are very welcome. You were entitled the respect of the best answer I
>> could give. My primary usage of LibreOffice is its spreadsheet
>> functionality. -- jl]
>>
>> -->8=
>>
>> we believe that prophet jesus is divine messenger and servant of god.
>>
>> [We believe much more. We believe that there is one God, the creator of
>> everything including time itself, who exists eternally (with neither
>> beginning nor end) in three persons (Father, Son, and Holy Spirit). Jesus of
>> Nazareth (Christ, the Anointed One, Messiah) is God the Son himself who
>> lived on earth in human form and who died a physical death on a Roman cross
>> in our place as the only final and perfect sacrifice for our sins. He rose
>> from the grave on the third day. See Philippians chapter 2 verses 1 through
>> 11 in the Holy Bible. We believe there is no other way to reconcile with God
>> (Jehovah) than to accept His sacrifice in our place for our sin. I am aware
>> that Islamic theology teaches differently but I pray that you will receive
>> the teachings in the Holy Bible with an open mind and a joyful heart. Jesus
>> said, "I am the way, the truth, and the life. No man comes to the Father but
>> by Me." He also said, speaking of Jehovah, "I and my Father are one." He is
>> who He says He is or He is a false prophet being either a blatant blasphemer
>> or a lunatic. You cannot simply classify Him as a "divine messenger and
>> servant of god (sic)." -- jl]
>>
>> -->8=
>>
>> --
>> Jim
>


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

[James Knott]

On 01/21/2016 08:12 AM, nasrin khaksar wrote:
> but the religion of islam
> is the last divine religion that all prophets

That is until the next one comes along.  Before Islam, Jews and then
Christians both claimed they had the last word.  No doubt there will be
some other "prophet" coming along claiming to know the "truth".

Bottom line, it's all nonsense that ignores reality.


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

[Dave Stevens]

Quoting James Knott :


And it's all nonsense.  The bible is provably fiction.


is it possible to park this thread or take it off-list?

Dave




On 01/21/2016 06:32 AM, nasrin khaksar wrote:

and also we and all belivers of divine religions convince monotheism
and eternity of god.
also we believe that prophet jesus is alive and appeare with emam
mahdi peace be upon him. who is rescue for all mankind.

On 1/21/16, James E. Lang  wrote:

-Original Message-
From: nasrin khaksar < >
To: jim+...@lang.hm
Sent: Thu, 21 Jan 2016 1:39
Subject:

hi jim.
thanks for your answer.

[You are very welcome. You were entitled the respect of the best answer I
could give. My primary usage of LibreOffice is its spreadsheet
functionality. -- jl]

-->8=

we believe that prophet jesus is divine messenger and servant of god.

[We believe much more. We believe that there is one God, the creator of
everything including time itself, who exists eternally (with neither
beginning nor end) in three persons (Father, Son, and Holy  
Spirit). Jesus of

Nazareth (Christ, the Anointed One, Messiah) is God the Son himself who
lived on earth in human form and who died a physical death on a Roman cross
in our place as the only final and perfect sacrifice for our sins. He rose
from the grave on the third day. See Philippians chapter 2 verses 1 through
11 in the Holy Bible. We believe there is no other way to  
reconcile with God

(Jehovah) than to accept His sacrifice in our place for our sin. I am aware
that Islamic theology teaches differently but I pray that you will receive
the teachings in the Holy Bible with an open mind and a joyful heart. Jesus
said, "I am the way, the truth, and the life. No man comes to the  
Father but

by Me." He also said, speaking of Jehovah, "I and my Father are one." He is
who He says He is or He is a false prophet being either a blatant  
blasphemer

or a lunatic. You cannot simply classify Him as a "divine messenger and
servant of god (sic)." -- jl]

-->8=

--
Jim





--
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

Re: [libreoffice-users] LibreOffice Base - music cataloging

[Dries Feys]

You can import your mp3's into iTunes, and from there you can export a
xml with all the necessary data, which you can import in base or calc.

Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer

TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
Watch our company movies on www.tvh.tv



Business Innovation
through
Information Technology
bi2t.tvh.com


On 21 January 2016 at 21:48, charles meyer  wrote:
> Hi Libre Folks,
>
> Happy New Year to you all.
>
> I have many music files which appear as thus after creating a list of
> file names using DOS command and saving in a word processor file:
>
> 12/31/2015  10:40 PMFile Size in MBs  1-25-2016 Bryan Ferry - Dont
> Stop The Dance Art.mp3
> 01/09/2016  07:31 PMFile Size in MBs  1-9-2016 Talking Heads
> Puzzlin Evidence.mp3
> 07/30/2015  10:11 PM   File Size in MBs  7-26-2015 David Bowie - Cat
> People - Putting Out Fire.mp3
>
> That’s just a short example of all the music to be cataloged.
>
> It was suggested to me, so I could eventually sort alphabetically by
> artist, that I search for a music cataloging application.
>
> Then, I read Jack Wallen’s article
> (http://www.techrepublic.com/blog/five-apps/five-free-cataloging-applications/)
> where he suggested one might consider LibreOffice Base for cataloging.
>
> For those who’ve played around with LibreOffice Base (which I have not
> yet) would it be labor intensive to use Base for this purpose?
>
> It’s complicated to take this info and import it into Excel’s cells
> and columns to then sort.
>
> 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

-- 


 DISCLAIMER 

http://www.tvh.com/glob/en/email-disclaimer

"This message is delivered to all addressees subject to the conditions
set forth in the attached disclaimer, which is an integral part of this
message."

-- 
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] LibreOffice Base - music cataloging

[anne-ology]

   There are numerous programs - commercial & free for the individual
user - which will probably do what you seek;
  here's a listing from Gizmo's of the ones they recommend -
 http://www.techsupportalert.com/search/node/music%20sorting

   Hope you locate one you enjoy using,



From: charles meyer 
Date: Thu, Jan 21, 2016 at 2:48 PM
Subject: [libreoffice-users] LibreOffice Base - music cataloging
To: users@global.libreoffice.org

Hi Libre Folks,

Happy New Year to you all.

I have many music files which appear as thus after creating a list of
file names using DOS command and saving in a word processor file:

12/31/2015  10:40 PMFile Size in MBs  1-25-2016 Bryan Ferry - Dont
Stop The Dance Art.mp3
01/09/2016  07:31 PMFile Size in MBs  1-9-2016 Talking Heads
Puzzlin Evidence.mp3
07/30/2015  10:11 PM   File Size in MBs  7-26-2015 David Bowie - Cat
People - Putting Out Fire.mp3

That’s just a short example of all the music to be cataloged.

It was suggested to me, so I could eventually sort alphabetically by
artist, that I search for a music cataloging application.

Then, I read Jack Wallen’s article
(
http://www.techrepublic.com/blog/five-apps/five-free-cataloging-applications/
)
where he suggested one might consider LibreOffice Base for cataloging.

For those who’ve played around with LibreOffice Base (which I have not
yet) would it be labor intensive to use Base for this purpose?

It’s complicated to take this info and import it into Excel’s cells
and columns to then sort.

Thanks so much!

Charles.


This
email has been sent from a virus-free computer protected by Avast.
www.avast.com

<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

-- 
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] LibreOffice Base - music cataloging

[Tom Davies]

Hi :)
I think, there are a lot of apps that are purpose-built for
cataloguing and sorting music collections.  There are a couple of
hidden tags in music files to help sort them appropriately.  I think
id3v1 and id3v2.

If you are using any version of Linux then just use any of your
package manager's to search for "music" or something similar or be
more specific.  I think the default music/media-players tend to have
something that has a fairly good go at sorting music collections.
Mine used to use "Banshee" but now uses "Rhythmbox" by default.  Then
there are extra tools to help deal with pesky niggles where the 2
versions of tags seldom both get filled in.  I once tried copy
from one to the other but it quickly gets tedious and there are much
better tools for the job anyway, apparently.

I suspect that Base could probably be a good front-end for a good
range of such tools/apps.

If you are just trying to
Regards form
Tom :)







On 22 January 2016 at 00:39, anne-ology  wrote:
>There are numerous programs - commercial & free for the individual
> user - which will probably do what you seek;
>   here's a listing from Gizmo's of the ones they recommend -
>  http://www.techsupportalert.com/search/node/music%20sorting
>
>Hope you locate one you enjoy using,
>
>
>
> From: charles meyer 
> Date: Thu, Jan 21, 2016 at 2:48 PM
> Subject: [libreoffice-users] LibreOffice Base - music cataloging
> To: users@global.libreoffice.org
>
> Hi Libre Folks,
>
> Happy New Year to you all.
>
> I have many music files which appear as thus after creating a list of
> file names using DOS command and saving in a word processor file:
>
> 12/31/2015  10:40 PMFile Size in MBs  1-25-2016 Bryan Ferry - Dont
> Stop The Dance Art.mp3
> 01/09/2016  07:31 PMFile Size in MBs  1-9-2016 Talking Heads
> Puzzlin Evidence.mp3
> 07/30/2015  10:11 PM   File Size in MBs  7-26-2015 David Bowie - Cat
> People - Putting Out Fire.mp3
>
> That’s just a short example of all the music to be cataloged.
>
> It was suggested to me, so I could eventually sort alphabetically by
> artist, that I search for a music cataloging application.
>
> Then, I read Jack Wallen’s article
> (
> http://www.techrepublic.com/blog/five-apps/five-free-cataloging-applications/
> )
> where he suggested one might consider LibreOffice Base for cataloging.
>
> For those who’ve played around with LibreOffice Base (which I have not
> yet) would it be labor intensive to use Base for this purpose?
>
> It’s complicated to take this info and import it into Excel’s cells
> and columns to then sort.
>
> Thanks so much!
>
> Charles.
>
> 
> This
> email has been sent from a virus-free computer protected by Avast.
> www.avast.com
> 
> <#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> --
> 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:

[Andreas Säger]

Am 22.01.2016 um 01:17 schrieb Dave Stevens:
> Quoting James Knott :
> 
>> And it's all nonsense.  The bible is provably fiction.
> 
> is it possible to park this thread or take it off-list?
> 
> Dave
> 

The religious bullshit is disturbing indeed. But we have to cope with it
wherever it rains down on us. Leave the censorship up to them and get
back to the drawing board.


-- 
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