[libreoffice-users] Re: modify calc dynamically with java

[Aurelius Octavian]

Am 08.09.2015 um 09:19 schrieb Aurelius Octavian:

[..] so I'm using version 0.5 (2013) which contains
any needed JARs in one Zip file.


Nearly; also v0.5 needs two external JARs which are referenced however on the 
web-page (I think) and downloadable from the provided links. It's these two:


– xercesImpl.jar
– xml-apis.jar

So in the end you need these four JARs to work with the ODF-Toolkit v0.5 
version:
– odfdom-0.8.8.jar
– simple-odf-0.7.jar
– xercesImpl.jar
– xml-apis.jar


Aurelius


--
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: modify calc dynamically with java

[Aurelius Octavian]

Hello Davide,

With the right tools this works very fine actually. It took me some time to 
figure out which tool to use, but now I use the well designed and well 
working "Apache ODF Toolkit" here: https://incubator.apache.org/odftoolkit/
It's still in "incubating mode", but I didn't encounter any grave problems so 
far.


The ODF Toolkit is relatively small, pure Java bundle consisting of two 
parts: "ODFDOM" and "Simple API". The first one does the more complex 
low-level work, while the second ones makes it all very high-level for us 
normal users.


There's some fine examples on the Apache website, too, which should get you 
going in a short time. Basically you only need to use the Simple-API in order 
to open some Opendocument file (Writer, Calc, or the others), then you can 
insert, modify, delete cells, rows, culumns, paragraphs etc in your .odt or 
.ods file, and then save the result as file. It's a great tool.


The most recent version is 0.61 (summer 2014) but it needs some external JAR 
which I couldn't find so far, so I'm using version 0.5 (2013) which contains 
any needed JARs in one Zip file. Version 0.61's bug fixes and new futures 
aren't that critical for my purposes yet, but in case you would find out 
where to get the needed external JAR(s) for the 0.61 version, please tell so! 
Thanks.


P.S. Just in case your Java programs needs to export the resulting .odt or 
.ods file to a PDF file, too, I can only recommend to directly call from 
within Java the Libreoffice executable via Java's ProcessBuilder class, i.e. 
"libreoffice|soffice--convert-to pdf", but skip the UNO API which didn't work 
(for me).


Good luck and enjoy your Java programming!

Aurelius



Am 08.09.2015 um 00:44 schrieb Davide:

Hi,

I want to modify libreoffice calc (ods) files. I have seen that within the ods
(a zip file) there is content.xml file that contains values. I have tried to
change it
and I can change the calc. Sometime formula are not update because there are
"cached values" within the cell. Removing this values (xml attributes)
formula are
recalulated. Quite the same with charts.

Is this a good way or there are better ways? There is another "better way" to
make calc to
recalculate formula or redraw charts?
It better a library to do this? In case some raccomandation for java?

Thanks in advance for any help!

Davide



--
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] Bug encounter

[Tim Lloyd]

Hi Julio,

you can certainly file a bug by following this link, creating an account 
and opening a report:


https://bugs.documentfoundation.org/

First off maybe wait and see whether anyone on this list has a suggestion

Cheers

On 08/09/15 08:23, Julio Saleme wrote:

I'm currently facing a bug in Writer which refresh constantly the part of
the document where I inserted a checklist (bullets) besides that I don't
know how to deactivate to track changes.

Is there I way for me to participate in reporting bugs to the developers.
Thanks

Using LibreOffice 5.0.1 running on Windows 10 64bits




--
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: Unable to Protect/Unprotect cells in Libreoffice 5

[Niklas Johansson]

Hi

Den 2015-09-06 kl. 17:26, skrev Tanstaafl:

...
I wonder - would it be possible to create a more generic (and I'm sure
more complicated) extension that allows you to create new sub-menu
content entries like this?

Or, maybe, just one that allows you to add one of the main menus (ie, in
this case, 'Table') to the context menu?

Anyway, just thinking how to make it more useful to others...
Well, the short answer is that sure it is possible, but it is quite an 
undertaking to do it.
It would require time that I simply don't have at the moment. However 
I'll probably
look into doing it, or at least a simplified version of it from time to 
time. ;)
One of the harder part would be to create a simple and intuitive dialog 
for the

feature.

Might be good to note that it is definitely easier to add context menu 
entries if

I only now what to add and where.

/Niklas



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

[Pedro]

Julio Saleme wrote
> I'm currently facing a bug in Writer which refresh constantly the part of
> the document where I inserted a checklist (bullets) besides that I don't
> know how to deactivate to track changes.

To deactivate just go to menu Edit > Track Changes and uncheck the option
Record Changes.

In any case the constant refresh should not happen, so please report the bug
including an example file.



--
View this message in context: 
http://nabble.documentfoundation.org/Bug-encounter-tp4159618p4159631.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] Thikening the contour of an square crashes Impress

[Ralf Kersanach]

Anne-ology,

thanks for your reply.

Well, I really don't know if this is an bug, but i can repeat it consistently 
in impress.

No I'm not streching an existing line, I use the square tool draw the square, 
clean the fill in and them I try to thikening the line and it crashes.

I mean with arquive, when I open an new clean/blank/fresh impress file, where 
the only object I have draw is the square draw which I create the same way I 
described above.

Ralf


-- 
Laboratório de Biodiversidade Genética
Instituto de Ciências Biológicas
Universidade Federal do Rio Grande - FURG
Av. Itália, s/n, Carreiros
96201-900, Rio Grande, RS - Brasil
Tel.:+.55.53.3293.5128
+.55.53.3233.6742/6538
e-mail:dmbralf"at"furg.br
msn:r_kersanach"at"hotmail.com
skype: ralfkersanach
On Monday 07 September 2015 14:16:51 anne-ology wrote:
>There are a couple possibilities which come to my mind as to the
> problem here;
> 
>   assuming there is no bug in any of your set-ups - which could be
> 1 cause.
> 
>Another possibility is that you're attempting to stretch an existing
> line rather than deleting the present one which you no longer desire;
>   if this is the case, then merely delete that which you no longer
> want & replace with that which you want.
> 
>Another possibility may be whatever you mean by 'arquive'  ???;
>   do you perchance mean archive?, as in saving the document?
>   if this is the case, then are you saving with a different name?,
> or are you starting fresh with a blank PP?
>You might try starting with a fresh/blank PP
>   then click on add file
>  then make any adjustments to the individual slides you want
> then save the document with a different name;
>Should be as you desire it,
> 
>Hoping this helps,
> 
> 
> 
> From: Ralf Kersanach 
> Date: Fri, Sep 4, 2015 at 6:40 AM
> Subject: [libreoffice-users] Thikening the contour of an square crashes
> Impress
> To: users@global.libreoffice.org
> 
> 
> Hi,
> 
> recently I was preparing a lecture and I needed to draw a square around a
> region of an image to get attention on that part of the image. When I try to
> thicken the perimeter of the square, crashes. I've tried on a new arquive
> without any elements and it crashes as well. Anybody with the same problem?
> 
> I'm a user of Arch linux with kernel 4.1.6-1, Kde 4.14.11 (according to
> kinfo) and my LO version is 5.0.1.2.0+ (buildID: 5.0.1.2 Arch Linux
> build-1),
> Locale pt-BR(interface (en_US.UTF-8).
> 
> Ralf


-- 
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: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

On 9/8/2015 4:04 PM, V Stuart Foote  wrote:
> "Unprotect cells" has been added after "Protect Cells" on the Table menu for
> the 5.0.2 rc1 build.
> 
> The Writer Table context menu for "Cells"  has been trimmed of bloat as
> indicated.
> 
> Niklas' Python UNO extension inserts a *Cell Protection* section with
> *Protect* (.uno:Protect) and *Unprotect* (.uno:UnsetCellsReadOnly)  entries
> on the Writer Table Cell context menu, and I've uploaded a copy to the 
> tdf#93837    --"
> Allow customization of the Context Menus" enhancement request for any that
> care to restore it to the context menu.

One mans 'bloat' is another mans gravy.

Please remember your classifying those context menu selections as
'bloat' is pure and mere opinion, nothing more.

I repeat...

This should NEVER have happened without first providing users a way to
customize these menus.

-- 
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: Unable to Protect/Unprotect cells in Libreoffice 5

[V Stuart Foote]

"Unprotect cells" has been added after "Protect Cells" on the Table menu for
the 5.0.2 rc1 build.

The Writer Table context menu for "Cells"  has been trimmed of bloat as
indicated.

Niklas' Python UNO extension inserts a *Cell Protection* section with
*Protect* (.uno:Protect) and *Unprotect* (.uno:UnsetCellsReadOnly)  entries
on the Writer Table Cell context menu, and I've uploaded a copy to the 
tdf#93837    --"
Allow customization of the Context Menus" enhancement request for any that
care to restore it to the context menu.






--
View this message in context: 
http://nabble.documentfoundation.org/Unable-to-Protect-Unprotect-cells-in-Libreoffice-5-tp4158473p4159744.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[V Stuart Foote]

Tanstaafl wrote
> One mans 'bloat' is another mans gravy.
> 
> Please remember your classifying those context menu selections as
> 'bloat' is pure and mere opinion, nothing more.
> 
> I repeat...
> 
> This should NEVER have happened without first providing users a way to
> customize these menus.

Hmm Charles, that seems rather like an opinion to me...  especially as
Niklas demonstrates you can customize them--after a fashion. Though doing it
with extensions very quickly gets messy.  

And as noted, providing customization of the context menu structures
requires substantial code refactoring that is not likely to happen anytime
soon--so saying changes should NEVER have happened is pure tripe.  Just
because you personally were not involved does not make the Design and UX
decision any less valid.

Design, development, QA is an ongoing volunteer effort, predominately merit
based. If you would like to have a voice in that aspect of the project then
you have to volunteer some effort.  And yes, I know you've been active on
the User ML for years and contribute often in that sense--but if you would
like more say, step-up.

On that note, have you taken the time to download and install (in parallel
is fine) current master?  As noted, there is a lot more change to menu,
toolbar and context menu behavior coming for the 5.1 release.  These are
changes that have been committed into master since the 5.0 branch on 20 May. 

Sorry, but the most effective time to comment is as changes are being
made--and that is on master branch. With weekly imput from Design and UX
advise collaborators and the QA and Dev community that follow along and use
these developmental builds. The time can not be when releases have been
finalized, spun and delivered--objections or "contributions" made then are
much less effective and of limited impact.

V Stuart Foote
QA, a11y advocacy, Desgn & UX advise, code contributor and hey a TDF member




--
View this message in context: 
http://nabble.documentfoundation.org/Unable-to-Protect-Unprotect-cells-in-Libreoffice-5-tp4158473p4159749.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] user's profile on an iMac

[Rob Jasper]

Guy,

library is standard invisible in Finder.

How to see the contents:
open finder
On the menu bar- Go -> Go to folder
Enter in the pop-up window: ~/library/application support/libreoffice/4 (tilde 
means current user home directory)

The directory "4" will open...

If you want to show hidden folder/files permanently in Finder, do the following:

Open a Terminal window and run the following commands in it, pressing Enter 
after each one:
defaults write com.apple.finder AppleShowAllFiles TRUE

killall Finder

This will kill all open finder processes. So if you restart Finder, all files 
will show.

Succes,
Rob.



On 8 sep. 2015, at 15:18, Guy Voets wrote:

> Hello,
> 
> I have a problem with sorting in Calc and the solution could be to throw
> out my user's profile.
> 
> Normally, this sits in user/libray/application support/libreoffice/4
> but on my Yosemite 27" iMac, there is no Library in my user map!
> The Library in the root map doesn't contain application support for LO.
> 
> Any idea where this could be hidden?
> In LO, the Paths indicate the path mentioned above, in the Library under
> user.
> 
> Thanks,
> -- 
> Guy
> using LibO 5.0.1 on a iMac Intel Yosemite 10.10.5
> Dodoes can't afford to have headaches
> 
> -- 
> 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] slide show style article from eWeek about the "Enterprise app" LibreOffice 5.0.1

[Tim---Kracked_P_P---webmaster]

You might want to look at this eWeek "article" for LO 5.0.1

it has 9 slides with info about LO 5.0.1

-

 "eWeek article/slideshow"
listed in the section called - Enterprise Apps


LibreOffice 5.0.1 Open-Source Productivity Suite at a Glance

By Sean M. Kerner  |  Posted 2015-09-01

http://www.eweek.com/enterprise-apps/slideshows/libreoffice-5.0.1-open-source-productivity-suite-at-a-glance.html


below is the quote from "slide 1"


Ever since the LibreOffice open-source office suite was forked from the 
Oracle OpenOffice suite in 2010, its community of developers has been 
working to improve it. The latest evolution of LibreOffice, version 
5.0.1, came out Aug. 27 and provides users with new features and 
improved performance. LibreOffice bundles multiple components as part of 
the suite, including the Writer Document, Calc Spreadsheet, Impress 
Presentation, Draw, Math Formula and Base Database applications. Being 
able to import and export in multiple formats has always been an 
important element of LibreOffice's interoperability capabilities. In 
LibreOffice 5.0.1, Writer now has improved Apple Pages document import 
capabilities. For PDF export, the ability to time-stamp a document is 
now enabled. Manipulating images is now improved across the suite, with 
the ability to crop an image with a mouse. The Calc spreadsheet now 
benefits from improved formula handling as well as new conditional 
formatting capabilities. LibreOffice is typically available as the 
default office suite in many Linux distributions and is also freely 
available for Apple Mac OS X and Microsoft Windows applications. Here, 
eWEEK takes a look at key features of LibreOffice 5.0.1.




--
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: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

Hi Niklas,

Just fyi, the extensions works great!

One thing... I do use the Quickstarter, and I tried the extension right
after installing it - without restarting  the Quickstarter - and
Libreoffice went into some kind of strange loop right after I
right-clicked on a cell in a new table inserted into a new/unsaved
writer doc.

I had to kill Libreoffice (kill all of the soffice.bin process), and
after that, it is now working great.

Thanks very much!!

On 9/6/2015 11:26 AM, Tanstaafl  wrote:
> Awesome, thanks Niklas!
> 
> I probably won't be able to try it until Tuesday, but will do so as soon
> as I can and let you know how it goes.
> 
> Thanks again!
> 
> On that note...
> 
> I wonder - would it be possible to create a more generic (and I'm sure
> more complicated) extension that allows you to create new sub-menu
> content entries like this?
> 
> Or, maybe, just one that allows you to add one of the main menus (ie, in
> this case, 'Table') to the context menu?
> 
> Anyway, just thinking how to make it more useful to others...
> 
> Thanks again!
> 
> On 9/5/2015 7:44 PM, Niklas Johansson  wrote:
>> Hi
>>
>> I created an extension that adds a submenu, Cell Protection, to the context
>> menu of tables. Feel free to give feedback, and I will try to publish the
>> extension to the LibreOffice Extension Center.
>>
>> Note that at the moment the extension is in English only.
>>
>> For the time being, you can download the extension from:
>> https://www.dropbox.com/s/3e3ok1kxyrshay8/CellProtectContextMenu.oxt?dl=1
>>
>> /Niklas
>>
>> 2015-09-01 15:35 GMT+02:00 Tanstaafl :
>>
>>> On 8/30/2015 1:19 PM, Tanstaafl  wrote:
 I'll go and create a new enhancement request to allow customizing the
 context menus.
>>>
>>> Done: bug 93837
>>>
>>> https://bugs.documentfoundation.org/show_bug.cgi?id=93837
> 
> 


-- 
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: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

Oh...

Any chance you can add the extension to the bug as a potential
workaround for others?

Or, I'd be happy to do it if you're ok with it.

Thanks again!

On 9/8/2015 1:21 PM, Tanstaafl  wrote:
> Hi Niklas,
> 
> Just fyi, the extensions works great!
> 
> One thing... I do use the Quickstarter, and I tried the extension right
> after installing it - without restarting  the Quickstarter - and
> Libreoffice went into some kind of strange loop right after I
> right-clicked on a cell in a new table inserted into a new/unsaved
> writer doc.
> 
> I had to kill Libreoffice (kill all of the soffice.bin process), and
> after that, it is now working great.
> 
> Thanks very much!!
> 
> On 9/6/2015 11:26 AM, Tanstaafl  wrote:
>> Awesome, thanks Niklas!
>>
>> I probably won't be able to try it until Tuesday, but will do so as soon
>> as I can and let you know how it goes.
>>
>> Thanks again!
>>
>> On that note...
>>
>> I wonder - would it be possible to create a more generic (and I'm sure
>> more complicated) extension that allows you to create new sub-menu
>> content entries like this?
>>
>> Or, maybe, just one that allows you to add one of the main menus (ie, in
>> this case, 'Table') to the context menu?
>>
>> Anyway, just thinking how to make it more useful to others...
>>
>> Thanks again!
>>
>> On 9/5/2015 7:44 PM, Niklas Johansson  wrote:
>>> Hi
>>>
>>> I created an extension that adds a submenu, Cell Protection, to the context
>>> menu of tables. Feel free to give feedback, and I will try to publish the
>>> extension to the LibreOffice Extension Center.
>>>
>>> Note that at the moment the extension is in English only.
>>>
>>> For the time being, you can download the extension from:
>>> https://www.dropbox.com/s/3e3ok1kxyrshay8/CellProtectContextMenu.oxt?dl=1
>>>
>>> /Niklas
>>>
>>> 2015-09-01 15:35 GMT+02:00 Tanstaafl :
>>>
 On 8/30/2015 1:19 PM, Tanstaafl  wrote:
> I'll go and create a new enhancement request to allow customizing the
> context menus.

 Done: bug 93837

 https://bugs.documentfoundation.org/show_bug.cgi?id=93837
>>
>>
> 


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