[libreoffice-users] Problems with Libre Office base on Ubuntuoffice.org

[Peter]

I have an existing data base with a number of reports. These were 
working last year at tax time. Now The existing reports do not run and I 
cannot create new reports. Each time I create a new report or run an 
exiisting report the data base crashes and I have to do a recovery. The 
data base was created from within Libre base.


Where do I look for error reports and has anyone else had this problem. 
I am running the software with Ubuntu on a laptop.



Regards


Peter Goggin




--
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] Can LO build a TOC from a PDF file?

[gordon cooper]

  There is a round-about way of doing this using Nuance's PDF 
Converter, but

I have not used it since I abandoned Windows® several years ago. With the
PDF Converter, one can make a Word file which could be read by LO, then
use LO's Insert ToC tool and export the result back to PDF.

Gordon

Tauranga N.Z.


On 10/07/17 05:20, Gilles wrote:

Hello,

This PDF file

has no Table of Contents, and I was wondering if LO could grab all the
headers and build a TOC.

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/Can-LO-build-a-TOC-from-a-PDF-file-tp4217910.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] Can LO build a TOC from a PDF file?

[Cley Faye]

2017-07-09 23:58 GMT+02:00 Jean-Francois Nifenecker <
jean-francois.nifenec...@laposte.net>:

> Hello Gilles,
>
> Le 09/07/2017 à 19:20, Gilles a écrit :
>
>> Hello,
>>
>> This PDF file
>> > e=LEGITEXT06074228=pdf>
>> has no Table of Contents, and I was wondering if LO could grab all the
>> headers and build a TOC.
>>
>
> In order to create a PDF with a TOC/index you'll have to set heading
> styles to the appropriate paragraphs.
>
> Opening a PDF with LibO won't go anywhere as the tool for that is Draw
> which can't set styles for a text processor.
>
> I can't see a way to do that quickly, I'm afraid: a copy/paste from the
> PDF document to Writer is possible but you'll have to fix a lot of things
> (eg. useless carriage returns) and apply heading styles by hand. On a 400+
> pages document this a big PITA.
>
> Hopefully someone else will come with brighter ideas.
>
>
>
​You want brighter ideas? Say no more!

So... hmm... I'm afraid there won't be many fully-automated tools that can
build a TOC for you. A PDF basically contains a lot of individual elements,
that are arranged to look like ​something coherent.
From the document you linked, it could theoretically be possible to write a
tool that split every pages, grab the raw text, use a regex to find actual
titles, build a TOC, and inject it in the PDF. This would assume:
- Text extraction works correctly (it's not always the case with PDF)
- Titles always follow the same format

But on this kind of document, you could definitely get some acceptable
results. I experimented a bit. The output is here:
http://www.cjoint.com/c/GGjw0OtPkGc
And for the curious, the "script" I used is here:
​https://pastebin.com/icQSZxQr

As you'll see, it is VERY specific to this document, ​but it is possible to
do something.

-- 
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] Problem with LibreOffice 5

[Girvin Herr]

Tom,

Not just windows. I had a similar problem with, I can't remember if it 
was LibreOffice or OpenOffice on Linux years ago. After I installed it 
as root, I discovered the system directory permissions were all changed 
to 400 or some such - which means only the owner (root) can read them - 
no write or execute for anybody. Needless to say, that brought my system 
down and I too, had to do a lot of manual file permission changes. Thank 
goodness for the "-R" argument to "chmod" to change all recursively. 
From then on, I always build/package programs as a normal user first, 
not root. That way I get a lot of "Permission Denied" messages if some 
package installation is ill-behaved. My packaging scripts also change 
all package file permissions and owners to sane values before it is 
packaged. Since I instituted this policy, I have not had my system 
compromised by bad packages, and I build hundreds of them. Once bitten, 
twice shy.


Girvin Herr



On 07/09/2017 02:33 PM, Tom Davies wrote:

Hi :)
There was a Win 10 update that messed up the permissions in one of the
places i volunteer at.

I have no idea how to fix it.  I think we went through each individual
folder to reset the permissions but that sounds like a very inefficient and
highly error-prone way of trying to fix it generally.  Still, 'everyone'
loves Windows.

Regards from
Tom :)



On 9 July 2017 at 17:46, Tom Williams  wrote:


On 07/08/2017 02:56 AM, MICHAEL HELY wrote:

I am having trouble with this suite.   Normally I have been able to

open, amend, and save a document without any problem.However, in the
last week or so I can only open a document in read-only form.   To change
the contents I have to open a copy for editing, save that under a different
name, delete the original, and then rename the new document to fit in with
my filing system. This is time consuming, and very inconvenient.

The only event that I can identify as a possible cause is that about the

same time there was an automatic update to Windows 10, and there might be
some incompatablity between the updated Windows and LibreOffice.(I have
since installed the latest update to LibreOffice5, but to no avail;  the
problem is still there).However that is only a wild guess! I would
be grateful for your advice and a remedy

regards
M. Hely


I have two basic questions:

  1. Have you confirmed the original file wasn't already "read-only"
 before attempting to open it?
  2. Are you opening files from the file system or directly from an email
 attachment?


These are things you have probably already thought of but I want to ask
anyway.  :)   I've run LibreOffice 5 on a couple of Windows 10 systems
and have been able to open, edit, and save documents without issue.

Peace...

"The Other" Tom

--
/When we dance, you have a way with me,
Stay with me... Sway with me.../

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

Re: [libreoffice-users] Can LO build a TOC from a PDF file?

[Jean-Francois Nifenecker]

Hello Gilles,

Le 09/07/2017 à 19:20, Gilles a écrit :

Hello,

This PDF file

has no Table of Contents, and I was wondering if LO could grab all the
headers and build a TOC.


In order to create a PDF with a TOC/index you'll have to set heading 
styles to the appropriate paragraphs.


Opening a PDF with LibO won't go anywhere as the tool for that is Draw 
which can't set styles for a text processor.


I can't see a way to do that quickly, I'm afraid: a copy/paste from the 
PDF document to Writer is possible but you'll have to fix a lot of 
things (eg. useless carriage returns) and apply heading styles by hand. 
On a 400+ pages document this a big PITA.


Hopefully someone else will come with brighter ideas.


Bien cordialement,
--
Jean-Francois Nifenecker, Bordeaux


--
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] Problem with LibreOffice 5

[Tom Davies]

Hi :)
There was a Win 10 update that messed up the permissions in one of the
places i volunteer at.

I have no idea how to fix it.  I think we went through each individual
folder to reset the permissions but that sounds like a very inefficient and
highly error-prone way of trying to fix it generally.  Still, 'everyone'
loves Windows.

Regards from
Tom :)



On 9 July 2017 at 17:46, Tom Williams  wrote:

> On 07/08/2017 02:56 AM, MICHAEL HELY wrote:
> > I am having trouble with this suite.   Normally I have been able to
> open, amend, and save a document without any problem.However, in the
> last week or so I can only open a document in read-only form.   To change
> the contents I have to open a copy for editing, save that under a different
> name, delete the original, and then rename the new document to fit in with
> my filing system. This is time consuming, and very inconvenient.
> > The only event that I can identify as a possible cause is that about the
> same time there was an automatic update to Windows 10, and there might be
> some incompatablity between the updated Windows and LibreOffice.(I have
> since installed the latest update to LibreOffice5, but to no avail;  the
> problem is still there).However that is only a wild guess! I would
> be grateful for your advice and a remedy
> > regards
> > M. Hely
> >
> I have two basic questions:
>
>  1. Have you confirmed the original file wasn't already "read-only"
> before attempting to open it?
>  2. Are you opening files from the file system or directly from an email
> attachment?
>
>
> These are things you have probably already thought of but I want to ask
> anyway.  :)   I've run LibreOffice 5 on a couple of Windows 10 systems
> and have been able to open, edit, and save documents without issue.
>
> Peace...
>
> "The Other" Tom
>
> --
> /When we dance, you have a way with me,
> Stay with me... Sway with me.../
>
> --
> 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] Can LO build a TOC from a PDF file?

[Gilles]

Hello,

This PDF file

  
has no Table of Contents, and I was wondering if LO could grab all the
headers and build a TOC.

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/Can-LO-build-a-TOC-from-a-PDF-file-tp4217910.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] Problem with LibreOffice 5

[Tom Williams]

On 07/08/2017 02:56 AM, MICHAEL HELY wrote:
> I am having trouble with this suite.   Normally I have been able to open, 
> amend, and save a document without any problem.However, in the last week 
> or so I can only open a document in read-only form.   To change the contents 
> I have to open a copy for editing, save that under a different name, delete 
> the original, and then rename the new document to fit in with my filing 
> system. This is time consuming, and very inconvenient.
> The only event that I can identify as a possible cause is that about the same 
> time there was an automatic update to Windows 10, and there might be some 
> incompatablity between the updated Windows and LibreOffice.(I have since 
> installed the latest update to LibreOffice5, but to no avail;  the problem is 
> still there).However that is only a wild guess! I would be grateful 
> for your advice and a remedy
> regards
> M. Hely
>
I have two basic questions:

 1. Have you confirmed the original file wasn't already "read-only"
before attempting to open it?
 2. Are you opening files from the file system or directly from an email
attachment?


These are things you have probably already thought of but I want to ask
anyway.  :)   I've run LibreOffice 5 on a couple of Windows 10 systems
and have been able to open, edit, and save documents without issue.

Peace...

"The Other" Tom

-- 
/When we dance, you have a way with me,
Stay with me... Sway with me.../

-- 
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] Problem with LibreOffice 5

[Tim-L--Elmira-NY]

On 07/08/2017 05:56 AM, MICHAEL HELY wrote:

I am having trouble with this suite.   Normally I have been able to open, 
amend, and save a document without any problem.However, in the last week or 
so I can only open a document in read-only form.   To change the contents I 
have to open a copy for editing, save that under a different name, delete the 
original, and then rename the new document to fit in with my filing system. 
This is time consuming, and very inconvenient.
The only event that I can identify as a possible cause is that about the same 
time there was an automatic update to Windows 10, and there might be some 
incompatablity between the updated Windows and LibreOffice.(I have since 
installed the latest update to LibreOffice5, but to no avail;  the problem is 
still there).However that is only a wild guess! I would be grateful for 
your advice and a remedy
regards
M. Hely



I have not done this with Windows, but I know it works with Linux.

I would look into the "config" folder. If some configuration value is 
set wrong, like opening as read-only instead of editable,  you will need 
to have LibreOffice restore the config files to their default status.  
When LibreOffice installs, it creates certain folders. If some of these 
folders are renamed, LibreOffice will try to replace them on its startup.


"Users/timothy/Application Data/LibreOffice/4/user/config"

In this folder location, "timothy" will be replaced with your user name 
that you log into Windows 10 with.


What you should try is renaming the "config" folder to something like 
"config-backup". Then open LibreOffice.  See if the read-only issue is 
fixed.  If not, then it is some other folder than the config folder.


I know there was a simple set of documentation describing the specific 
folder that may need to be "renamed", but I do not remember its location 
online.




--
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: Urgent LibreOffice 5.2.5.1.

[Tom Davies]

Hi :)
I'm not sure how to clear the error-log.  Does it appear when you start-up
LibreOffice?  Sometimes when you start LibreOffice it asks if you want to
recover the document you were last working on.  Sometimes there's a list of
several documents to recover.  Most times if you just cancel that message
the documents are completely up-to-date and all fine.
regards from
Tom :)





On 9 July 2017 at 16:38, Huntly Ness  wrote:

> Hello Tom, just to tell you the wonderful news that, on advice from Brian
> Barker, I   RESTARTED my laptop and then Installed L.O. 5.3.4.2. and lo and
> behold, the installation was successful.
>
>
> Do you know how to CLEAR the content of the ERROR LOG ?
>
>
> Thanks for your support,
>
> Best regards,
>
> Huntly   
>
>
> --
> *From:* Tom Davies 
> *Sent:* 09 July 2017 14:47
> *To:* Huntly Ness; users@global.libreoffice.org
>
> *Subject:* Re: [libreoffice-users] Re: Urgent LibreOffice 5.2.5.1.
>
> Hi :)
> No worries.
>
> It's best to include the mailing list;
>
> Users@Global.LibreOffice.org
>
> so that anyone can pitch in to correct or develop ideas or come up with
> something completely different.
>
> Note that upper-case in email addresses all get converted to lower-case by
> emailing systems so the capital-letters in an address are only there to
> make it easier for humans to read or as decoration.  It'd be a tad awkward
> if using an upper-case G sent it to one lot of people but a lower-case sent
> it to someone else!!
>
> Thanks, good luck and regards from
> Tom :)
>
>
>
> On 9 July 2017 at 00:40, Huntly Ness  wrote:
>
>> Thank you Tom, for your input to my problem,  will contact you later on'
>>
>> Best regards,
>>
>> Huntly
>>
>>
>> --
>> *From:* Tom Davies 
>> *Sent:* 08 July 2017 22:22
>> *To:* anne-ology
>> *Cc:* Huntly Ness; users@global.libreoffice.org
>> *Subject:* Re: [libreoffice-users] Re: Urgent LibreOffice 5.2.5.1.
>>
>> Hi :)
>> All the music should still be there.  Even if LibreOffice has gone the
>> music files should still be there.  The icons will look very different for
>> them because the pretty little colourful icons will have been replaced by
>> plain greyish (or something else dull) ones.  However the file-names and
>> file-sizes should still be the same (please see note at end if you still
>> can't find them).
>>
>> If Anne-ology's advice doesn't work then simply download LibreOffice
>> again.  You don't need to contribute any more so it's completely free.
>>
>> Downloading a newer version is the usual way to upgrade LibreOffice.  I
>> think most people on this mailing list tend to stick with the "Still"
>> version rather than "Fresh" branch for machines we need to work reliably.
>> Some people stick with much older versions.  The "Fresh" branch is good for
>> experimenting with newer features.
>>
>> Note:  When you install, or rather reinstall, LibreOffice it should
>> automatically find it's "User Profile".  So it should have all the same
>> settings and configurations that you set-up for the previous version of
>> LibreOffice.  This works even if you install an older version than you last
>> had.  The "User Profile" also contains "Galleries" and other folders and
>> hopefully things like your "Recent Files" list should be intact.
>>
>> So, one way or another you should be ab le to recover your files
>> automagically.  :))
>>
>> Good luck and regards from
>> Tom :)
>>
>>
>>
>> On 7 July 2017 at 15:25, anne-ology  wrote:
>>
>>>Unless you somehow deleted LO, then it should still be on your
>>> machine with all its files intact.
>>>
>>>What machine do you have?; if a MsFt WIN product, then go to the
>>> 'start' ... then either
>>>   (1) 'search' for one of the files which were in LO ... this
>>> will
>>> lead you to where its located;
>>>   (2) click on 'computer' then 'app data' then 'roaming' ...
>>> scroll
>>> down to LO's file;
>>>
>>>if you have a Mac. then click on 'finder' then check 'apps';
>>>
>>>if another machine, 'search' for the files may be the easiest.
>>>
>>>Unless you deleted these files then your files should be wherever
>>> you placed them.
>>>
>>>Hoping this helps,
>>>
>>>
>>>
>>>
>>> From: Huntly Ness 
>>> To: "users@global.libreoffice.org" 
>>> Cc:
>>> Bcc:
>>> Date: Wed, 5 Jul 2017 21:09:59 +
>>> Subject: [libreoffice-users] Urgent LibreOffice 5.2.5.1.
>>>
>>> Hello Libre Office,
>>>
>>>
>>> I hope you can help me.  I went to use Libre Office (as above) today and
>>> found that it was no longer available. The above was installed 15/02/17
>>> and
>>> I had contributed towards en earlier version.
>>>
>>> I really need Libre to write my private mail.
>>>
>>> For your information I am a very Senior Citizen (85) and this has  really
>>> 

Re: [libreoffice-users] [calc] Get a list of conditional formattings

[Jean-Francois Nifenecker]

Gabriele,

Le 09/07/2017 à 10:12, Gabriele Ponzo a écrit :


Please consider filling it in bugzilla as feature request, after a quick
look if someone else already did it.


Done. Bugzilla #109035.


I've never been there, but I've been told it's a beautiful area.


it is, just like many places in Italy are (dunno many of them but I 
appreciated all the ones I visited so far).


All the best,
--
Jean-Francois Nifenecker, Bordeaux


--
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: Urgent LibreOffice 5.2.5.1.

[Tom Davies]

Hi :)
No worries.

It's best to include the mailing list;

Users@Global.LibreOffice.org

so that anyone can pitch in to correct or develop ideas or come up with
something completely different.

Note that upper-case in email addresses all get converted to lower-case by
emailing systems so the capital-letters in an address are only there to
make it easier for humans to read or as decoration.  It'd be a tad awkward
if using an upper-case G sent it to one lot of people but a lower-case sent
it to someone else!!

Thanks, good luck and regards from
Tom :)



On 9 July 2017 at 00:40, Huntly Ness  wrote:

> Thank you Tom, for your input to my problem,  will contact you later on'
>
> Best regards,
>
> Huntly
>
>
> --
> *From:* Tom Davies 
> *Sent:* 08 July 2017 22:22
> *To:* anne-ology
> *Cc:* Huntly Ness; users@global.libreoffice.org
> *Subject:* Re: [libreoffice-users] Re: Urgent LibreOffice 5.2.5.1.
>
> Hi :)
> All the music should still be there.  Even if LibreOffice has gone the
> music files should still be there.  The icons will look very different for
> them because the pretty little colourful icons will have been replaced by
> plain greyish (or something else dull) ones.  However the file-names and
> file-sizes should still be the same (please see note at end if you still
> can't find them).
>
> If Anne-ology's advice doesn't work then simply download LibreOffice
> again.  You don't need to contribute any more so it's completely free.
>
> Downloading a newer version is the usual way to upgrade LibreOffice.  I
> think most people on this mailing list tend to stick with the "Still"
> version rather than "Fresh" branch for machines we need to work reliably.
> Some people stick with much older versions.  The "Fresh" branch is good for
> experimenting with newer features.
>
> Note:  When you install, or rather reinstall, LibreOffice it should
> automatically find it's "User Profile".  So it should have all the same
> settings and configurations that you set-up for the previous version of
> LibreOffice.  This works even if you install an older version than you last
> had.  The "User Profile" also contains "Galleries" and other folders and
> hopefully things like your "Recent Files" list should be intact.
>
> So, one way or another you should be ab le to recover your files
> automagically.  :))
>
> Good luck and regards from
> Tom :)
>
>
>
> On 7 July 2017 at 15:25, anne-ology  wrote:
>
>>Unless you somehow deleted LO, then it should still be on your
>> machine with all its files intact.
>>
>>What machine do you have?; if a MsFt WIN product, then go to the
>> 'start' ... then either
>>   (1) 'search' for one of the files which were in LO ... this will
>> lead you to where its located;
>>   (2) click on 'computer' then 'app data' then 'roaming' ...
>> scroll
>> down to LO's file;
>>
>>if you have a Mac. then click on 'finder' then check 'apps';
>>
>>if another machine, 'search' for the files may be the easiest.
>>
>>Unless you deleted these files then your files should be wherever
>> you placed them.
>>
>>Hoping this helps,
>>
>>
>>
>>
>> From: Huntly Ness 
>> To: "users@global.libreoffice.org" 
>> Cc:
>> Bcc:
>> Date: Wed, 5 Jul 2017 21:09:59 +
>> Subject: [libreoffice-users] Urgent LibreOffice 5.2.5.1.
>>
>> Hello Libre Office,
>>
>>
>> I hope you can help me.  I went to use Libre Office (as above) today and
>> found that it was no longer available. The above was installed 15/02/17
>> and
>> I had contributed towards en earlier version.
>>
>> I really need Libre to write my private mail.
>>
>> For your information I am a very Senior Citizen (85) and this has  really
>> upset me that Libre was suddenly unavailable.
>>
>> Needless to say I have lost all the Church music I had on it and other
>> data.
>>
>> The sooner I can get it back the better.
>>
>> Thank you Libre Officeus, in anticipation.
>>
>> Huntly M.Ness
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
>> ubscribe/
>> 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

Re: [libreoffice-users] [calc] Get a list of conditional formattings

[Tom Davies]

Hi :)
I'm not sure if this is still relevant but ...

There are guides on;
https://wiki.documentfoundation.org/Documentation/Publications

Chapter 12 of the Calc Guide.

There is also an excellent unofficial guide about Macros written by Andrew
Pitonyak.

One advantage of LibreOffice is that macros can be written in a variety of
languages - and that includes sensible languages such as C++ and Python.
So you don't need to have someone learn a language specifically for
"Office".  Also macros don't need to be written in an archaic, easily
corruptible, flaky version of Basic.  So macros are much less likely to
suffer breakage when you upgrade to a newer version of "Office"

Another advantage is the relative ease of writing add-ons/plug-ins.
LibreOffice was one of the first programs (under a previous name) to offer
such a feature and went with the name "Extensions".  Again these can be
written in a wide variety of languages and either published under a wide
variety of licenses or kept in-house.  Personally i'd tend to recommend an
OpenSource license such as GPL or Mozilla License to free yourself up from
'having to' keep it updated yourself - and publishing it gives a much
larger potential audience of testers to help the code mature faster
and be more robust.


By far the biggest advantage of LibreOffice for organisations (imo) is the
ability to employ a dev locally to work on your company's own tier 3 issues
or pet bugs or on developing add-ons or macros or whatever your company
chooses as the priority.  This could be as a part-timer or as part of an
in-house team and could vary over time to suit the amount of work your
company needs to have done.  Your company's dev(s) might work on other
OpenSource projects such as Firefox/Chrome and whatever esle - or they
could be allowed to work on general developments within LibreOffice.
Whichever way they would be working with an international team but giving
your company a very tight focus on the work they see as being most
important to them.

Almost invariably employing dev(s) is MUCH less expensive than the costs of
buying licenses for equivalent proprietary software.  If around 10% of the
cost of such licenses is enough to be a salary for a dev then it's well
worth considering.

One company, openSuSE, found it worthwhile to employ so many devs that
eventually that whole support department budded off to form an independent
company who openSuSE now outsource a lot of their work to.  Collabora now
have several companies and individuals who they provide professional
support services to so they are not completely dependent on openSuSE any
more.

Of course outsourcing the work significantly reduces the dedication of the
support staff and the control you have over them but it also dramatically
reduces costs so some sort of combination of in-house and outsourcing might
be the best-fit for your company.

Regards from
Tom :)



On 9 July 2017 at 09:12, Gabriele Ponzo  wrote:

> Now I got what you meant, sorry.
>
> And thanks to Regina for pointing out what I meant and the solution for
> your need.
>
>
>
> Il 9 lug 2017 8:37 AM, "Jean-Francois Nifenecker" <
> jean-francois.nifenec...@laposte.net> ha scritto:
>
>
> ...
>
>
> BTW, as documenting is a key point of spreadsheets develepment, I think
> this conditional formatting listing could/should be made available
> somewhere in the UI, à-la range names insert.
>
>
> Please consider filling it in bugzilla as feature request, after a quick
> look if someone else already did it.
>
>
> Thanks again,
> Cheers from France,
> --
> Jean-Francois Nifenecker, Bordeaux
>
>
> I've never been there, but I've been told it's a beautiful area.
> Probably one of the few still missing to visit in France for me. Hope to
> come sooner or later ;)
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> 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
>

-- 
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] [calc] Get a list of conditional formattings

[Gabriele Ponzo]

Now I got what you meant, sorry.

And thanks to Regina for pointing out what I meant and the solution for
your need.



Il 9 lug 2017 8:37 AM, "Jean-Francois Nifenecker" <
jean-francois.nifenec...@laposte.net> ha scritto:


...


BTW, as documenting is a key point of spreadsheets develepment, I think
this conditional formatting listing could/should be made available
somewhere in the UI, à-la range names insert.


Please consider filling it in bugzilla as feature request, after a quick
look if someone else already did it.


Thanks again,
Cheers from France,
-- 
Jean-Francois Nifenecker, Bordeaux


I've never been there, but I've been told it's a beautiful area.
Probably one of the few still missing to visit in France for me. Hope to
come sooner or later ;)




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
ubscribe/
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

Re: [libreoffice-users] [calc] Get a list of conditional formattings

[Jean-Francois Nifenecker]

Hi Regina,

Le 09/07/2017 à 00:18, Regina Henschel a écrit :


You can get all conditions from the saved file. In case you use "ODF
1.2. extended" the conditions are written in the LO-specific element
. In addition some of the conditions are
written in  attributes as defined by ODF 1.2. In case you use
ODF 1.2, only  attributes are used, so that not all kind of
conditions are possible.


Not sure I'll go the file-unpacking route but this might be a way.



In the API look for "Condition..." in the com::sun::star::sheet module
reference (in the SDK).

For the ODF 1.2 strict way, you can look at
https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Conditional_Formats



Thanks a lot for your insights. I'll have a look.



You might consider to write all hints and explanations more human
readable into a separate (hidden?) sheet.


In fact this is the aim.

BTW, as documenting is a key point of spreadsheets develepment, I think 
this conditional formatting listing could/should be made available 
somewhere in the UI, à-la range names insert.



Thanks again,
Cheers from France,
--
Jean-Francois Nifenecker, Bordeaux


--
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] [calc] Get a list of conditional formattings

[Jean-Francois Nifenecker]

Gabriele,

Le 08/07/2017 à 23:30, Gabriele Ponzo a écrit :

I'm on the smartphone at the moment, but I'm quite sure the UI does list
the conditional formatting existing on a sheet or in a file.

It should be in a specific sub menu item to manage such feature.

I clearly remember from my last lessons (I'm a teacher of LO) that there
is a dialog window showing them all.

Isn't it enough for your need?


I probably didn't make myself clear enough: I know of the UI you're 
talking about. I'm in need of some way to list them all separately on a 
document of some sort. Thanks anyway. I'll read about Regina's hints 
which seem to do what I need.



All the best,
--
Jean-Francois Nifenecker, Bordeaux


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