Re: Playing ping pong with ODF version; does it pose a danger to the end user.

[Drew Jensen]

Thanks for the feedback Regina & Thorsten.

Well, given the information in the replies and what I've seen
anecdotally I feel prepared to field questions if they come up.

BTW I added OnlyOffice into the mix last night. It behaves pretty much
as MSO 365 when handling these 1.3 files.

Best wishes,

Drew

On Thu, Apr 22, 2021 at 3:05 PM Regina Henschel  wrote:
>
> Hi Drew,
>
> Drew Jensen schrieb am 22.04.2021 um 18:59:
> > Howdy,
> >
> > Recently I exchanged a few documents between a number of ODF editors:
> > LO 7.1 (all documents were created here with default settings)
> > Google Docs
> > Microsoft Office 365
> > Apache OpenOffice
> >
> > In the case of all Google and MSO the files open up without any kind
> > of warning about the ODF version being 1.3. AOO (4.1.10 RC2) offers a
> > rather poorly worded warning.
>
> This is a step forward compared to the change to ODF 1.2,
>
>   So far I have noticed no obvious loss of
> > features, but I assume there must be some, somewhere.
>
> It depends on the content whether you loose something. Even if all would
> use ODF 1.3 you cannot expect that different applications support the
> same subset of features.
>
> >
> > When I save from Google or MS or AOO the ODF version is dropped down
> > to 1.2, silently.
>
> If they are not aware of the version, they cannot warn.
>
> >
> > Open it again in LO 7.1 and it is quiet, edit and save it and it is
> > quietly moved back up to ODF 1.3.
>
> That could be improved. MS Office has for ooxml a warning, that the file
> is transformed to the newest version, if it has opened a older file format.
>
> >
> > So, I was wondering if this is a potential problem for the end users
> > and if so should we recommend that they change from the new default in
> > LO of ODF 1.43 (a non standard) back to 1.2 if they are expecting to
> > share for editing with other editors?
>
> I see no problem for end users. The differences between applications
> using the same ODF version is larger than the differences between ODF
> 1.2 and 1.3. So when documents need to be exchanged between different
> applications, the sender and receiver should always agree on which
> features not to use. That is nothing special for ODF. You know it too
> for HTML and browsers and for documents in ooxml-formats.
>
> The advise should be to always save in "ODF 1.3 extended" and use other
> version or formats only if explicit required.
>
> Kind regards
> Regina
>
>
>
>
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Playing ping pong with ODF version; does it pose a danger to the end user.

[Drew Jensen]

Howdy,

Recently I exchanged a few documents between a number of ODF editors:
LO 7.1 (all documents were created here with default settings)
Google Docs
Microsoft Office 365
Apache OpenOffice

In the case of all Google and MSO the files open up without any kind
of warning about the ODF version being 1.3. AOO (4.1.10 RC2) offers a
rather poorly worded warning. So far I have noticed no obvious loss of
features, but I assume there must be some, somewhere.

When I save from Google or MS or AOO the ODF version is dropped down
to 1.2, silently.

Open it again in LO 7.1 and it is quiet, edit and save it and it is
quietly moved back up to ODF 1.3.

So, I was wondering if this is a potential problem for the end users
and if so should we recommend that they change from the new default in
LO of ODF 1.43 (a non standard) back to 1.2 if they are expecting to
share for editing with other editors?

Thanks

Drew
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] Live streaming LibreOffice bug triaging (week 10)

[Drew Jensen]

Howdy,

Am wondering if you would like this information shared via a SM post
targeted to potential QA contributors?
I saw that there were two such posts on a Twitter account a couple
months back but none others, so perhaps you wouldn't want that and
thought I'd ask first before doing so.

Thanks

Drew

On Sat, Mar 6, 2021 at 9:13 AM Ilmari Lauhakangas
 wrote:
>
> I will be live streaming a 1 hour LibreOffice bug triaging session in
> the Jitsi room https://jitsi.documentfoundation.org/ilmaritriages next
> week on
>
> Thu, 11 Mar 2021 at 08:00 UTC
>
> Anyone is welcome to interrupt me during the session and ask questions
> about the process or request me to test something specific.
>
> The session typically starts with me going through old enhancement
> requests. The point of this is to determine, if they need to be reviewed
> by the design team or if they are miscategorised somehow.
>
> Ilmari
> ___
> List Name: Libreoffice-qa mailing list
> Mail address: Libreoffice-qa@lists.freedesktop.org
> Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: Modify Libreoffice UI

[Drew Jensen]

Howdy Heiko,

Since I've switched almost entirely to use of the tabbed interface I
was wondering if there is any time frame for fully updating the tabbed
(notebookbar) interface using the customization dialog? I know there
is a limited support currently but far short of what is available for
the legacy toolbar.

Thanks

Drew

On Wed, Mar 3, 2021 at 11:43 AM Heiko Tietze
 wrote:
>
> Hi Mai,
>
> it is possible to modify/add toolbars (or menus) per Tools > Customization. 
> See
> [1] for the documentation of this feature. And you can also apply it to a
> specific document by changing the "Scope".
> Good place to ask specific questions is [2] or the user mailing lists [3]. 
> This
> one is intended for developers- and from what you ask I guess you don't plan 
> to
> change the source code.
>
> Cheers,
> Heiko
>
> [1]
> https://help.libreoffice.org/latest/en-US/text/shared/guide/edit_symbolbar.html?DbPAR=SHARED#bm_id3159201
> [2] https://ask.libreoffice.org/
> [3] https://www.libreoffice.org/get-help/mailing-lists/
>
> On 03.03.21 16:40, Mai Dinh wrote:
> > Hi there,
> >
> > I was looking into LibreOffice open source and potentially modifying the UI 
> > to
> > add a new toolbar field on the top of files I open, such as document and
> > spreadsheet. I was hoping for help in the direction to look at the source 
> > code.
> >
> > Any help would be appreciated, thank you!
> > Mai
> >
> > ___
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> >
>
> --
> Dr. Heiko Tietze, UX-Designer and UX-Mentor
> Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org
> The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE
> Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
> Legal details: https://www.documentfoundation.org/imprint
>
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Calc Solvers Info Doc/wiki page Re: Calc solvers - what to say in the Calc Guide

[Drew Jensen]

Howdy,

Adding The Documentation ML to the thread.
Quick recap for the folks on the list:
Currently the LibreOffice wiki includes under the FAQs section a
question on Calc Solvers.
https://wiki.documentfoundation.org/Faq/Calc/109
The answer in the second sentence, for languages other then French,
refer the user back to the AOO wiki for information specific to the
NLSolver extension from Sun Microsystems. That answer page also refers
the user to API information via the AOO SDK.

The French language answer points to a copy (it appears) of that page
translated to French but hosted on the LibreOffice wiki.

So - drafted a LibreOffice specific version of the information found
on the AOO wiki.
This draft adds information to cover the five solver engines which
ship with the TDF baseline LibreOffice code (including the coming
7.0).

The latest update to the draft
https://nextcloud.documentfoundation.org/s/ebisHjZo2rowM4Q

There is one final change I'd like to make and that is the example; I
would like to switch the basic code out for an example that uses the
spreadsheet and model used in the data analytics section of the Calc
Guide. I'll be working on that tonight.

Otherwise - any review of the current state of the document is most
welcome. At the moment the file is in my private storage space on the
NC server; I would prefer to move it to the shared documentation
folder but wasn't sure where to put it?

Thanks,

Drew


On Mon, May 18, 2020 at 6:54 PM Drew Jensen  wrote:
>
> Great - well for now we can use an odt file to draft the content.
> Added this section for COINMP in Solvers section:
> ---
> CoinMP
>
> The CoinMP optimizer is an open source solver, it is part of the
> COIN-OR project which is an initiative to spur the development of
> open-source software for the operations research community. CoinMP at
> present is a linear and integer optimizer.
>
> Algorithmic Features
>
> COIN-OR is a large group of projects ranging from linear to nonlinear
> programming right through to heuristic and modelling interfaces,
> CoinMP is integrates the COIN's CLP (linear programming), CBC (Branch
> and Cut library) and CGL (Cut Generation library) libraries into one
> easy to use tool. Thus CoinMP can solve linear programming problems
> accessing the functionality embedded in the CLP library, solve integer
> and mixed integer programming problems utilizing the algorithmic
> features of both the CBC and CGL libraries.
> --
> https://nextcloud.documentfoundation.org/s/ebisHjZo2rowM4Q has been
> updated with the change and that pdf file has the .odt embedded in it
> BTW.
>
> I could sure use feedback on that added text from more technical folks.
>
> Drew
>
> On Mon, May 18, 2020 at 5:17 AM Stephen Fanning
>  wrote:
> >
> > Drew,
> >
> > Many thanks for your efforts in trying to get to the bottom of this.
> >
> > I think that putting the information on the wiki is a good idea. The 
> > relevant chapter of the Calc Guide (Chapter 9, Data Analysis) is already 
> > very thick and would not benefit from being expanded further to include 
> > more solver details.
> >
> > Regards,
> >
> > Steve
> >
> >
> > On Mon, 18 May 2020 at 06:39, Drew Jensen  
> > wrote:
> >>
> >> HI,
> >>
> >> Well, I noticed something aside from the Guide and that is the FAQ
> >> over on the wiki.
> >> https://wiki.documentfoundation.org/Faq/Calc/109/fr
> >> Now, it turns out that the French version of that FAQ points to a page
> >> (first link on the page) on the TDF wiki but none of the other
> >> languages do. They point back to the AOO wiki and on that wiki page it
> >> has links to things like extensions LibreOffice doesn't need and API
> >> documentation in AOO SDK.
> >>
> >> So - I thought why not steal the content from the AOO page as a start
> >> of a TDF page (or PDF maybe ;-).
> >>
> >> I did that and then I updated a few things in it. Not done updating
> >> things, but done for tonight.
> >>
> >> You can review a draft of this
> >> https://nextcloud.documentfoundation.org/s/ebisHjZo2rowM4Q
> >>
> >> Can see some easy edits in the top part of the text and I need to ask
> >> for help filling in the information for scripting as needed for the
> >> additional algorithm engines in LO - for one thing maybe a bit more.
> >>
> >> Anyway, any feedback is welcome. Will post tomorrow when those changes
> >> are made.
> >>
> >> Thanks,
> >>
> >> Drew
> >>
> >> On Sat, May 16, 2020 at 7:31 PM Drew Jensen  
> >> wrote:
> >> &

Re: Calc solvers - what to say in the Calc Guide

[Drew Jensen]

Great - well for now we can use an odt file to draft the content.
Added this section for COINMP in Solvers section:
---
CoinMP

The CoinMP optimizer is an open source solver, it is part of the
COIN-OR project which is an initiative to spur the development of
open-source software for the operations research community. CoinMP at
present is a linear and integer optimizer.

Algorithmic Features

COIN-OR is a large group of projects ranging from linear to nonlinear
programming right through to heuristic and modelling interfaces,
CoinMP is integrates the COIN's CLP (linear programming), CBC (Branch
and Cut library) and CGL (Cut Generation library) libraries into one
easy to use tool. Thus CoinMP can solve linear programming problems
accessing the functionality embedded in the CLP library, solve integer
and mixed integer programming problems utilizing the algorithmic
features of both the CBC and CGL libraries.
--
https://nextcloud.documentfoundation.org/s/ebisHjZo2rowM4Q has been
updated with the change and that pdf file has the .odt embedded in it
BTW.

I could sure use feedback on that added text from more technical folks.

Drew

On Mon, May 18, 2020 at 5:17 AM Stephen Fanning
 wrote:
>
> Drew,
>
> Many thanks for your efforts in trying to get to the bottom of this.
>
> I think that putting the information on the wiki is a good idea. The relevant 
> chapter of the Calc Guide (Chapter 9, Data Analysis) is already very thick 
> and would not benefit from being expanded further to include more solver 
> details.
>
> Regards,
>
> Steve
>
>
> On Mon, 18 May 2020 at 06:39, Drew Jensen  wrote:
>>
>> HI,
>>
>> Well, I noticed something aside from the Guide and that is the FAQ
>> over on the wiki.
>> https://wiki.documentfoundation.org/Faq/Calc/109/fr
>> Now, it turns out that the French version of that FAQ points to a page
>> (first link on the page) on the TDF wiki but none of the other
>> languages do. They point back to the AOO wiki and on that wiki page it
>> has links to things like extensions LibreOffice doesn't need and API
>> documentation in AOO SDK.
>>
>> So - I thought why not steal the content from the AOO page as a start
>> of a TDF page (or PDF maybe ;-).
>>
>> I did that and then I updated a few things in it. Not done updating
>> things, but done for tonight.
>>
>> You can review a draft of this
>> https://nextcloud.documentfoundation.org/s/ebisHjZo2rowM4Q
>>
>> Can see some easy edits in the top part of the text and I need to ask
>> for help filling in the information for scripting as needed for the
>> additional algorithm engines in LO - for one thing maybe a bit more.
>>
>> Anyway, any feedback is welcome. Will post tomorrow when those changes
>> are made.
>>
>> Thanks,
>>
>> Drew
>>
>> On Sat, May 16, 2020 at 7:31 PM Drew Jensen  
>> wrote:
>> >
>> > This is an interesting point of differentiation.
>> > Reviewing some of the tools yesterday and this morning;
>> > AOO with 1 solver engine in default install (4.2 pre-release binary);
>> >
>> > OnlyOffice (latest desktop Linux binary) has no Solver equivalent in
>> > either the desktop binary or the cloud version, not that I can find
>> > (didn't see any in the available plug-ins, but maybe their is
>> > something behind the paywall areas).
>> >
>> > WSP (May 2020 release) includes only one, a simplex linear solver.
>> >
>> > MS 365 and Google Sheets both require an plug-in, Frontline Systems
>> > Inc looks to be the leading supplier for both tools, but there are
>> > multiple other choices for each.
>> >
>> > Looking at this the first couple sentences, "The standard Microsoft
>> > Excel Solver uses a basic implementation of the primal Simplex method
>> > to solve LP problems.  It is limited to 200 decision variables.", from
>> > this web page https://www.solver.com/linear-quadratic-technology and
>> > thinking that we should be able to run down answers to some of the
>> > bounds information for the different engines also.
>> >
>> > Below are the different options sets for the engines.  Most
>> > specifically give bounds (ie Epsilon Level), but a few don't (ie
>> > Learning Cycles); I don't know if it would be worth it to get those
>> > numbers or not.
>> >
>> > I think it is worth it to, per engine, list these in the guide/help
>> > file. It is a lot easier to highlight something like "ACR Comparator
>> > (instead of BCH)" from a PDF/HTML then from that dialog box in the
>>

Re: Calc solvers - what to say in the Calc Guide

[Drew Jensen]

HI,

Well, I noticed something aside from the Guide and that is the FAQ
over on the wiki.
https://wiki.documentfoundation.org/Faq/Calc/109/fr
Now, it turns out that the French version of that FAQ points to a page
(first link on the page) on the TDF wiki but none of the other
languages do. They point back to the AOO wiki and on that wiki page it
has links to things like extensions LibreOffice doesn't need and API
documentation in AOO SDK.

So - I thought why not steal the content from the AOO page as a start
of a TDF page (or PDF maybe ;-).

I did that and then I updated a few things in it. Not done updating
things, but done for tonight.

You can review a draft of this
https://nextcloud.documentfoundation.org/s/ebisHjZo2rowM4Q

Can see some easy edits in the top part of the text and I need to ask
for help filling in the information for scripting as needed for the
additional algorithm engines in LO - for one thing maybe a bit more.

Anyway, any feedback is welcome. Will post tomorrow when those changes
are made.

Thanks,

Drew

On Sat, May 16, 2020 at 7:31 PM Drew Jensen  wrote:
>
> This is an interesting point of differentiation.
> Reviewing some of the tools yesterday and this morning;
> AOO with 1 solver engine in default install (4.2 pre-release binary);
>
> OnlyOffice (latest desktop Linux binary) has no Solver equivalent in
> either the desktop binary or the cloud version, not that I can find
> (didn't see any in the available plug-ins, but maybe their is
> something behind the paywall areas).
>
> WSP (May 2020 release) includes only one, a simplex linear solver.
>
> MS 365 and Google Sheets both require an plug-in, Frontline Systems
> Inc looks to be the leading supplier for both tools, but there are
> multiple other choices for each.
>
> Looking at this the first couple sentences, "The standard Microsoft
> Excel Solver uses a basic implementation of the primal Simplex method
> to solve LP problems.  It is limited to 200 decision variables.", from
> this web page https://www.solver.com/linear-quadratic-technology and
> thinking that we should be able to run down answers to some of the
> bounds information for the different engines also.
>
> Below are the different options sets for the engines.  Most
> specifically give bounds (ie Epsilon Level), but a few don't (ie
> Learning Cycles); I don't know if it would be worth it to get those
> numbers or not.
>
> I think it is worth it to, per engine, list these in the guide/help
> file. It is a lot easier to highlight something like "ACR Comparator
> (instead of BCH)" from a PDF/HTML then from that dialog box in the
> application so that you can do a DDG search on the term ;)
>
> LibreOffice CoinMP Linear Solver & LibreOffice Linear Solver
> Options
> - Assume variables as integers. (Default FALSE)
> - Assume variables as non-negative. (Default FALSE)
> - Epsilon Level 0-3. (Default 0)
> - Limit branch and bound depth. (Default FALSE)
> - Solving time limit (seconds). (Default 100)
>
> DEPS Evolutionary Algorithm
> Options
> - Agent Switch Rate (DE Probability): (Default .05)
> - Assume non-negative variables (Default FALSE)
> - DE: Crossover Probability (0-1): (Default 0.9)
> - DE: Max Scaling Factor (0-1.2): (Default 0.5)
> - DE: Min Scaling Factor (0-1.2): (Default 0.5)
> - Learning Cycles: (Default 2000)
> - PS: Cognitive Constant: (Default 1.494)
> - PS: Mutation Probability (0-0.005): (Default 0.729)
> - PS: Social Constant: (Default 1.494)
> - Show enhanced solver status (Default TRUE)
> - Size of library; (Default 210)
> - Size of swarm; (Default 70)
> - Stagnation limit: (Default 70)
> - Stagnation tolerance: (Default 0.001)
> - Use ACR Comparator (instead of BCH). (Default FALSE)
> - Use random starting point. (Default FALSE)
> - Variable bounds testing. (Default TRUE)
> - Variable bounds threshold (when guessing): (Default 3)
>
> SCO Evolutionary Algorithm
> Options
> - Assume variables as non-negative. (Default FALSE)
> - Learning Cycles: (Default False)
> - Show enhanced solver status (Default TRUE)
> - Size of library; (Default 210)
> - Size of swarm; (Default 70)
> - Stagnation limit: (Default 70)
> - Stagnation tolerance: (Default 0.001)
> - Use ACR Comparator (instead of BCH). (Default FALSE)
> - Use random starting point. (Default FALSE)
> - Variable bounds testing. (Default TRUE)
> - Variable bounds threshold (when guessing): (Default 3)
>
> LibreOffice Swarm Non-Linear Solver (experimental)
> Options
> - Assume variables as integers. (Default FALSE)
> - Assume variables as non-negative. (Default FALSE)
> - Solving time limit (seconds). (Default 6000)
> - Swarm algorithm (0 - Differential Evolution, 1 - Particle Swarm
> Optimization): (Default 0)
>
> Saw y

Re: Calc solvers - what to say in the Calc Guide

[Drew Jensen]

This is an interesting point of differentiation.
Reviewing some of the tools yesterday and this morning;
AOO with 1 solver engine in default install (4.2 pre-release binary);

OnlyOffice (latest desktop Linux binary) has no Solver equivalent in
either the desktop binary or the cloud version, not that I can find
(didn't see any in the available plug-ins, but maybe their is
something behind the paywall areas).

WSP (May 2020 release) includes only one, a simplex linear solver.

MS 365 and Google Sheets both require an plug-in, Frontline Systems
Inc looks to be the leading supplier for both tools, but there are
multiple other choices for each.

Looking at this the first couple sentences, "The standard Microsoft
Excel Solver uses a basic implementation of the primal Simplex method
to solve LP problems.  It is limited to 200 decision variables.", from
this web page https://www.solver.com/linear-quadratic-technology and
thinking that we should be able to run down answers to some of the
bounds information for the different engines also.

Below are the different options sets for the engines.  Most
specifically give bounds (ie Epsilon Level), but a few don't (ie
Learning Cycles); I don't know if it would be worth it to get those
numbers or not.

I think it is worth it to, per engine, list these in the guide/help
file. It is a lot easier to highlight something like "ACR Comparator
(instead of BCH)" from a PDF/HTML then from that dialog box in the
application so that you can do a DDG search on the term ;)

LibreOffice CoinMP Linear Solver & LibreOffice Linear Solver
Options
- Assume variables as integers. (Default FALSE)
- Assume variables as non-negative. (Default FALSE)
- Epsilon Level 0-3. (Default 0)
- Limit branch and bound depth. (Default FALSE)
- Solving time limit (seconds). (Default 100)

DEPS Evolutionary Algorithm
Options
- Agent Switch Rate (DE Probability): (Default .05)
- Assume non-negative variables (Default FALSE)
- DE: Crossover Probability (0-1): (Default 0.9)
- DE: Max Scaling Factor (0-1.2): (Default 0.5)
- DE: Min Scaling Factor (0-1.2): (Default 0.5)
- Learning Cycles: (Default 2000)
- PS: Cognitive Constant: (Default 1.494)
- PS: Mutation Probability (0-0.005): (Default 0.729)
- PS: Social Constant: (Default 1.494)
- Show enhanced solver status (Default TRUE)
- Size of library; (Default 210)
- Size of swarm; (Default 70)
- Stagnation limit: (Default 70)
- Stagnation tolerance: (Default 0.001)
- Use ACR Comparator (instead of BCH). (Default FALSE)
- Use random starting point. (Default FALSE)
- Variable bounds testing. (Default TRUE)
- Variable bounds threshold (when guessing): (Default 3)

SCO Evolutionary Algorithm
Options
- Assume variables as non-negative. (Default FALSE)
- Learning Cycles: (Default False)
- Show enhanced solver status (Default TRUE)
- Size of library; (Default 210)
- Size of swarm; (Default 70)
- Stagnation limit: (Default 70)
- Stagnation tolerance: (Default 0.001)
- Use ACR Comparator (instead of BCH). (Default FALSE)
- Use random starting point. (Default FALSE)
- Variable bounds testing. (Default TRUE)
- Variable bounds threshold (when guessing): (Default 3)

LibreOffice Swarm Non-Linear Solver (experimental)
Options
- Assume variables as integers. (Default FALSE)
- Assume variables as non-negative. (Default FALSE)
- Solving time limit (seconds). (Default 6000)
- Swarm algorithm (0 - Differential Evolution, 1 - Particle Swarm
Optimization): (Default 0)

Saw your mail about the version 7 Guide, but already had that typed in
so figured I'd send it along anyway.


On Sat, May 16, 2020 at 5:22 PM Drew Jensen  wrote:
>
> Well here is something
> Looking at the help file for version 7
> https://help.libreoffice.org/7.0/en-US/text/scalc/01/solver.html?=CALC=UNIX
> the final text box states that 'only linear solvers are in the default 
> installation'.
>
> However 7.0 Alpha1 build adds a choice of, 'LibreOfficeDev Swarm non-linear 
> Solver (experimental)' for an engine.
>
> So, assuming that engine ships with 7 the text box in the help file could go.
>
>
>
> On Fri, May 15, 2020 at 7:02 AM Stephen Fanning  
> wrote:
>>
>> Kohei and Drew,
>>
>> Many thanks for getting back to me on this topic.
>>
>> For the 6.4 update to the Calc Guide, I will follow Kohei's advice that it 
>> is probably beyond the scope of the document to provide guidance on how to 
>> select a solver.
>>
>> I'll try to make some time before the 7.0 Calc Guide update to re-visit this 
>> decision.
>>
>> Regards,
>>
>> Steve
>>
>>
>> On Fri, 15 May 2020 at 07:40, Drew Jensen  wrote:
>>>
>>> Tonight took the LO 7 alpha1 file and the one example workbook from that 
>>> Excel tutorial and ran each of the five solver engines.
>>> For sure the LO CoinMP and LO Linear choices are cra

Re: Calc solvers - what to say in the Calc Guide

[Drew Jensen]

Well here is something
Looking at the help file for version 7
https://help.libreoffice.org/7.0/en-US/text/scalc/01/solver.html?=CALC=UNIX
the final text box states that 'only linear solvers are in the default
installation'.

However 7.0 Alpha1 build adds a choice of, 'LibreOfficeDev Swarm
non-linear Solver (experimental)' for an engine.

So, assuming that engine ships with 7 the text box in the help file could
go.



On Fri, May 15, 2020 at 7:02 AM Stephen Fanning 
wrote:

> Kohei and Drew,
>
> Many thanks for getting back to me on this topic.
>
> For the 6.4 update to the Calc Guide, I will follow Kohei's advice that it
> is probably beyond the scope of the document to provide guidance on how to
> select a solver.
>
> I'll try to make some time before the 7.0 Calc Guide update to re-visit
> this decision.
>
> Regards,
>
> Steve
>
>
> On Fri, 15 May 2020 at 07:40, Drew Jensen 
> wrote:
>
>> Tonight took the LO 7 alpha1 file and the one example workbook from that
>> Excel tutorial and ran each of the five solver engines.
>> For sure the LO CoinMP and LO Linear choices are crazy faster then DEPS
>> and SCO (The firth choice Swarm non-linear is just as quick but the results
>> are kaka, but it does say it is experimental).
>>
>> On Thu, May 14, 2020 at 7:55 PM Drew Jensen 
>> wrote:
>>
>>> hmm - there are bits and pieces here and there.
>>>
>>> For example the first two choices (DEPS & SCO) have some explanation
>>> over at AOO wiki
>>> https://wiki.openoffice.org/wiki/NLPSolver
>>> If that is still relevant for LibreOffice I can't say, but likely.
>>> CoinMD (which I assume here is type of Coin-MP) has a lot of generalized
>>> references, even a wiki page with a paragraph or two that might be worth
>>> drafting for service here:
>>> https://en.wikipedia.org/wiki/COIN-OR
>>>
>>> anyway - I'm just using DDG to search for info on the different solver
>>> types, and you get the idea.
>>>
>>> There is a couple of examples of tutorials the reference solvers in Calc
>>> (one of which actually uses the same example data to show how to solve both
>>> in Excel and Calc), but the couple I reviewed only use one as an example.
>>>
>>> I did find one for Excel that has an over view which I thought was a
>>> decent balance of information on the three solver models available there at:
>>>
>>> https://www.tutorialspoint.com/excel_data_analysis/advanced_data_analysis_optimization_with_excel_solver.htm
>>>
>>> IDK if any of the helps, hope it does.
>>>
>>> Best wishes,
>>>
>>>
>>>
>>>
>>> On Thu, May 14, 2020 at 7:19 PM Kohei Yoshida 
>>> wrote:
>>>
>>>> On 10.05.2020 10:59, Stephen Fanning wrote:
>>>>
>>>> > What guidance can I insert into the Calc Guide to help the user if he
>>>> > wonders which algorithm to select?
>>>>
>>>> This is strictly my personal opinion.
>>>>
>>>> Which optimization solver to pick really depends on the characteristics
>>>> of the data being optimized, how (well) the algorithm is implemented in
>>>> the versions included in Calc, the accuracy goal etc. etc.  It's more
>>>> an
>>>> art than science, and each user really needs to experiment with various
>>>> solvers to see which one works best for his or her optimization cases.
>>>> My personal opinion is that it is probably beyond the scope of Calc
>>>> user
>>>> guide to provide any sort of guidance on how to select a solver.
>>>>
>>>> Feel free to disagree with me on this.  I'm not an expert. :-)
>>>>
>>>> Kohei
>>>> ___
>>>> LibreOffice mailing list
>>>> LibreOffice@lists.freedesktop.org
>>>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>>>
>>>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Calc solvers - what to say in the Calc Guide

[Drew Jensen]

Tonight took the LO 7 alpha1 file and the one example workbook from that
Excel tutorial and ran each of the five solver engines.
For sure the LO CoinMP and LO Linear choices are crazy faster then DEPS and
SCO (The firth choice Swarm non-linear is just as quick but the results are
kaka, but it does say it is experimental).

On Thu, May 14, 2020 at 7:55 PM Drew Jensen 
wrote:

> hmm - there are bits and pieces here and there.
>
> For example the first two choices (DEPS & SCO) have some explanation over
> at AOO wiki
> https://wiki.openoffice.org/wiki/NLPSolver
> If that is still relevant for LibreOffice I can't say, but likely.
> CoinMD (which I assume here is type of Coin-MP) has a lot of generalized
> references, even a wiki page with a paragraph or two that might be worth
> drafting for service here:
> https://en.wikipedia.org/wiki/COIN-OR
>
> anyway - I'm just using DDG to search for info on the different solver
> types, and you get the idea.
>
> There is a couple of examples of tutorials the reference solvers in Calc
> (one of which actually uses the same example data to show how to solve both
> in Excel and Calc), but the couple I reviewed only use one as an example.
>
> I did find one for Excel that has an over view which I thought was a
> decent balance of information on the three solver models available there at:
>
> https://www.tutorialspoint.com/excel_data_analysis/advanced_data_analysis_optimization_with_excel_solver.htm
>
> IDK if any of the helps, hope it does.
>
> Best wishes,
>
>
>
>
> On Thu, May 14, 2020 at 7:19 PM Kohei Yoshida 
> wrote:
>
>> On 10.05.2020 10:59, Stephen Fanning wrote:
>>
>> > What guidance can I insert into the Calc Guide to help the user if he
>> > wonders which algorithm to select?
>>
>> This is strictly my personal opinion.
>>
>> Which optimization solver to pick really depends on the characteristics
>> of the data being optimized, how (well) the algorithm is implemented in
>> the versions included in Calc, the accuracy goal etc. etc.  It's more an
>> art than science, and each user really needs to experiment with various
>> solvers to see which one works best for his or her optimization cases.
>> My personal opinion is that it is probably beyond the scope of Calc user
>> guide to provide any sort of guidance on how to select a solver.
>>
>> Feel free to disagree with me on this.  I'm not an expert. :-)
>>
>> Kohei
>> ___
>> LibreOffice mailing list
>> LibreOffice@lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Calc solvers - what to say in the Calc Guide

[Drew Jensen]

hmm - there are bits and pieces here and there.

For example the first two choices (DEPS & SCO) have some explanation over
at AOO wiki
https://wiki.openoffice.org/wiki/NLPSolver
If that is still relevant for LibreOffice I can't say, but likely.
CoinMD (which I assume here is type of Coin-MP) has a lot of generalized
references, even a wiki page with a paragraph or two that might be worth
drafting for service here:
https://en.wikipedia.org/wiki/COIN-OR

anyway - I'm just using DDG to search for info on the different solver
types, and you get the idea.

There is a couple of examples of tutorials the reference solvers in Calc
(one of which actually uses the same example data to show how to solve both
in Excel and Calc), but the couple I reviewed only use one as an example.

I did find one for Excel that has an over view which I thought was a decent
balance of information on the three solver models available there at:
https://www.tutorialspoint.com/excel_data_analysis/advanced_data_analysis_optimization_with_excel_solver.htm

IDK if any of the helps, hope it does.

Best wishes,




On Thu, May 14, 2020 at 7:19 PM Kohei Yoshida  wrote:

> On 10.05.2020 10:59, Stephen Fanning wrote:
>
> > What guidance can I insert into the Calc Guide to help the user if he
> > wonders which algorithm to select?
>
> This is strictly my personal opinion.
>
> Which optimization solver to pick really depends on the characteristics
> of the data being optimized, how (well) the algorithm is implemented in
> the versions included in Calc, the accuracy goal etc. etc.  It's more an
> art than science, and each user really needs to experiment with various
> solvers to see which one works best for his or her optimization cases.
> My personal opinion is that it is probably beyond the scope of Calc user
> guide to provide any sort of guidance on how to select a solver.
>
> Feel free to disagree with me on this.  I'm not an expert. :-)
>
> Kohei
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

[Drew Jensen]

Also - I read in a couple of places online that if you have OpenCL support
enabled then the CPU threading stops.

I can't test that to see if it is true because I can't seem to get OpenCL
to work on this Linux desktop.

Trying it on a Windows machine should answer that question.

On Thu, Apr 23, 2020 at 4:56 PM Drew Jensen 
wrote:

> To follow up on that.
>
> Using LO 6.4 & 7.0 pre-release build on Ubuntu. Recalculating one of the
> OpenCL test xls files just now.
>
> Starting up with a command line
> MAX_CONCURRENCY=0 ./soffice
> Does turn the CPU threading off.
>
> Restarting with a command line
> MAX_CONCURRENCY=4 ./soffice
> Turns it back on (for my AMD a5800 processor this will give me two
> threads, because while the CPU is called a 4 core processor and it does
> have 4 accumulators it only has 2 floatingpoint cores and this is the
> limiting factor it seems) with recalculation time for the workbook is ~2x
> faster.
>
>
> On Thu, Apr 23, 2020 at 1:48 PM Drew Jensen 
> wrote:
>
>> BTW I'm copying a paragraph from an email on a different list.
>>
>> "Also - if you set MAX_CONCURRENCY=16 - or somesuch (ie. twice your
>> number of threads) - you may be able to defeat the hyper-threaded
>> halving, and see if this workload happens to be one that does better
>> with hyper-threading than without."M.M.
>>
>> It might be worth mentioning the MAX_CURRENCY setting for controlling CPU
>> thread usage.
>>
>> Also, I wonder if the folks answering could answer one other question:
>> Does LibreOffice OnLine also use cpu threading in the same way it does
>> when run for desktop or headless? It would be with noting in the
>> documentation if it does not, IMO.
>>
>>
>>
>> On Thu, Apr 23, 2020 at 9:56 AM Stephen Fanning <
>> stevemfanning...@gmail.com> wrote:
>>
>>> Mike and  Luboš,
>>>
>>> Many thanks for your help on this topic.
>>>
>>> Regards,
>>>
>>> Steve
>>>
>>> On Thu, 23 Apr 2020 at 11:16, Mike Kaganski 
>>> wrote:
>>>
>>>> On 23.04.2020 13:12, Luboš Luňák wrote:
>>>> > On Thursday 23 of April 2020, Stephen Fanning wrote:
>>>> >> As for the processing itself, I remain unclear about how Calc
>>>> allocates
>>>> >> tasks to threads. Can we give the user any general advice on how he
>>>> could
>>>> >> structure his spreadsheet to gain the maximum performance benefits
>>>> from the
>>>> >> availability of multiple cores? Or maybe there are ways to organise a
>>>> >> spreadsheet that will frustrate Calc's attempts to multi-thread,
>>>> which we
>>>> >> ought to advise against?
>>>> >
>>>> >  Technically threads are generally used only for formula groups,
>>>> which are a
>>>> > sufficient number of adjacent cells in a column that use the same
>>>> formula
>>>> > (and get different results because of relative cell addressing). In
>>>> UI terms,
>>>> > write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell
>>>> and extend
>>>> > down. But it's implementated this way because that's usually how
>>>> large
>>>> > spreadsheets are created. So I think it's a needless complication to
>>>> be
>>>> > specific about this.
>>>> >
>>>>
>>>> IMO it's still useful to mention that the optimization is column-based.
>>>> Because many people don't realize that row-based layout is potentially
>>>> less efficient. This would be beneficial to those who don't create
>>>> spreadsheets according to how it's "usually" done.
>>>>
>>>> --
>>>> Best regards,
>>>> Mike Kaganski
>>>>
>>> ___
>>> LibreOffice mailing list
>>> LibreOffice@lists.freedesktop.org
>>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>>
>>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

[Drew Jensen]

To follow up on that.

Using LO 6.4 & 7.0 pre-release build on Ubuntu. Recalculating one of the
OpenCL test xls files just now.

Starting up with a command line
MAX_CONCURRENCY=0 ./soffice
Does turn the CPU threading off.

Restarting with a command line
MAX_CONCURRENCY=4 ./soffice
Turns it back on (for my AMD a5800 processor this will give me two threads,
because while the CPU is called a 4 core processor and it does have 4
accumulators it only has 2 floatingpoint cores and this is the limiting
factor it seems) with recalculation time for the workbook is ~2x faster.


On Thu, Apr 23, 2020 at 1:48 PM Drew Jensen 
wrote:

> BTW I'm copying a paragraph from an email on a different list.
>
> "Also - if you set MAX_CONCURRENCY=16 - or somesuch (ie. twice your
> number of threads) - you may be able to defeat the hyper-threaded
> halving, and see if this workload happens to be one that does better
> with hyper-threading than without."M.M.
>
> It might be worth mentioning the MAX_CURRENCY setting for controlling CPU
> thread usage.
>
> Also, I wonder if the folks answering could answer one other question:
> Does LibreOffice OnLine also use cpu threading in the same way it does
> when run for desktop or headless? It would be with noting in the
> documentation if it does not, IMO.
>
>
>
> On Thu, Apr 23, 2020 at 9:56 AM Stephen Fanning <
> stevemfanning...@gmail.com> wrote:
>
>> Mike and  Luboš,
>>
>> Many thanks for your help on this topic.
>>
>> Regards,
>>
>> Steve
>>
>> On Thu, 23 Apr 2020 at 11:16, Mike Kaganski 
>> wrote:
>>
>>> On 23.04.2020 13:12, Luboš Luňák wrote:
>>> > On Thursday 23 of April 2020, Stephen Fanning wrote:
>>> >> As for the processing itself, I remain unclear about how Calc
>>> allocates
>>> >> tasks to threads. Can we give the user any general advice on how he
>>> could
>>> >> structure his spreadsheet to gain the maximum performance benefits
>>> from the
>>> >> availability of multiple cores? Or maybe there are ways to organise a
>>> >> spreadsheet that will frustrate Calc's attempts to multi-thread,
>>> which we
>>> >> ought to advise against?
>>> >
>>> >  Technically threads are generally used only for formula groups, which
>>> are a
>>> > sufficient number of adjacent cells in a column that use the same
>>> formula
>>> > (and get different results because of relative cell addressing). In UI
>>> terms,
>>> > write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell and
>>> extend
>>> > down. But it's implementated this way because that's usually how large
>>> > spreadsheets are created. So I think it's a needless complication to
>>> be
>>> > specific about this.
>>> >
>>>
>>> IMO it's still useful to mention that the optimization is column-based.
>>> Because many people don't realize that row-based layout is potentially
>>> less efficient. This would be beneficial to those who don't create
>>> spreadsheets according to how it's "usually" done.
>>>
>>> --
>>> Best regards,
>>> Mike Kaganski
>>>
>> ___
>> LibreOffice mailing list
>> LibreOffice@lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

[Drew Jensen]

BTW I'm copying a paragraph from an email on a different list.

"Also - if you set MAX_CONCURRENCY=16 - or somesuch (ie. twice your
number of threads) - you may be able to defeat the hyper-threaded
halving, and see if this workload happens to be one that does better
with hyper-threading than without."M.M.

It might be worth mentioning the MAX_CURRENCY setting for controlling CPU
thread usage.

Also, I wonder if the folks answering could answer one other question:
Does LibreOffice OnLine also use cpu threading in the same way it does when
run for desktop or headless? It would be with noting in the documentation
if it does not, IMO.



On Thu, Apr 23, 2020 at 9:56 AM Stephen Fanning 
wrote:

> Mike and  Luboš,
>
> Many thanks for your help on this topic.
>
> Regards,
>
> Steve
>
> On Thu, 23 Apr 2020 at 11:16, Mike Kaganski 
> wrote:
>
>> On 23.04.2020 13:12, Luboš Luňák wrote:
>> > On Thursday 23 of April 2020, Stephen Fanning wrote:
>> >> As for the processing itself, I remain unclear about how Calc allocates
>> >> tasks to threads. Can we give the user any general advice on how he
>> could
>> >> structure his spreadsheet to gain the maximum performance benefits
>> from the
>> >> availability of multiple cores? Or maybe there are ways to organise a
>> >> spreadsheet that will frustrate Calc's attempts to multi-thread, which
>> we
>> >> ought to advise against?
>> >
>> >  Technically threads are generally used only for formula groups, which
>> are a
>> > sufficient number of adjacent cells in a column that use the same
>> formula
>> > (and get different results because of relative cell addressing). In UI
>> terms,
>> > write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell and
>> extend
>> > down. But it's implementated this way because that's usually how large
>> > spreadsheets are created. So I think it's a needless complication to be
>> > specific about this.
>> >
>>
>> IMO it's still useful to mention that the optimization is column-based.
>> Because many people don't realize that row-based layout is potentially
>> less efficient. This would be beneficial to those who don't create
>> spreadsheets according to how it's "usually" done.
>>
>> --
>> Best regards,
>> Mike Kaganski
>>
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

[Drew Jensen]

On Thu, Mar 12, 2020 at 7:58 AM Jean-Pierre Ledure  wrote:

> FYI the number of sheets created in new Calc documents can be set to > 1
> by doing Options + LibreOffice Calc + Defaults.
>
> Maybe makes the test easier.
>

Indeed - the basic code was hard wired to expect three sheets in a new Calc
file and wanted to delete two. Changing the options setting from 1 to 3
allows it to run that function.
In fact the error was actually in a basic function called from an event
handler and the BAISC error dialog, and UI, was pointing at the calling
function not where the actual error happened.

Good job, thanks

Drew


>
> Jean-Pierre
>
> Le 11/03/20 à 21:34, Drew Jensen a écrit :
> > Actually as I think about it.
> >
> > Isn't one of the differences between AOO and LO that AOO creates a new
> > calc file with multiple sheets and LO creates a new calc file with
> > only one sheet.
> >
> > I don't think you can remove that last sheet, so perhaps that is it. A
> > test should tell on that also.
> >
> > On Wed, Mar 11, 2020 at 4:31 PM Drew Jensen
> > mailto:drewjensen.in...@gmail.com>> wrote:
> >
> > Interesting.
> >
> > Just did a search in the issue tracking system and there is an
> > open issue regarding RemoveByName, but in a different context.
> >
> > Taking a quick look at that function and where it is called from
> > it seems a quick test using a copy of that function should be a
> > fairly quick exercise.
> >
> > Before I try that though, just to be sure; This basic module is
> > embedded in the Calc file, yes?
> >
> > Thanks
> >
> > Drew
> >
> > On Wed, Mar 11, 2020 at 4:17 PM Andrew Pitonyak
> > mailto:and...@pitonyak.org>> wrote:
> >
> > Not able to test for at least a week, but am curious what this
> > causes an error.
> >
> > where it fails, it verifies is something by that name is there
> > and then it tries to remove it. If I was able to run a test I
> > could check to make sure that the method is exist, but the
> > real question, is do you have write access to whatever it is
> > is trying to modify?
> >
> > Sent from BlueMail <http://www.bluemail.me/r?b=15824>
> > On Mar 11, 2020, at 3:00 PM, Patrick Kariuki
> > mailto:patrick.kari...@gmail.com>>
> > wrote:
> >
> > I'm running a macro file on LibreOffice6.2.8.2  <
> http://6.2.8.2>  and keep getting this
> > -https://imgur.com/a/tpDocIu
> >
> > Error is on this code -https://pastebin.com/S9RtUWVK  at
> Line 1327
> >
> > Please assist (I can send more information if required)
> >
> > Thanks.
> >
>  
> >
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org   LibreOffice@lists.freedesktop.org>
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> >
> > ___
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org
> > <mailto:LibreOffice@lists.freedesktop.org>
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> >
> >
> > ___
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

[Drew Jensen]

On Thu, Mar 12, 2020 at 7:58 AM Jean-Pierre Ledure  wrote:

> FYI the number of sheets created in new Calc documents can be set to > 1
> by doing Options + LibreOffice Calc + Defaults.
>
> Maybe makes the test easier.
>

Indeed - the basic code was hard wired to expect three sheets in a new Calc
file and wanted to delete two. Changing the options setting from 1 to 3
allows it to run that function.

Good job, thanks

Drew

>
> Jean-Pierre
>
> Le 11/03/20 à 21:34, Drew Jensen a écrit :
> > Actually as I think about it.
> >
> > Isn't one of the differences between AOO and LO that AOO creates a new
> > calc file with multiple sheets and LO creates a new calc file with
> > only one sheet.
> >
> > I don't think you can remove that last sheet, so perhaps that is it. A
> > test should tell on that also.
> >
> > On Wed, Mar 11, 2020 at 4:31 PM Drew Jensen
> > mailto:drewjensen.in...@gmail.com>> wrote:
> >
> > Interesting.
> >
> > Just did a search in the issue tracking system and there is an
> > open issue regarding RemoveByName, but in a different context.
> >
> > Taking a quick look at that function and where it is called from
> > it seems a quick test using a copy of that function should be a
> > fairly quick exercise.
> >
> > Before I try that though, just to be sure; This basic module is
> > embedded in the Calc file, yes?
> >
> > Thanks
> >
> > Drew
> >
> > On Wed, Mar 11, 2020 at 4:17 PM Andrew Pitonyak
> > mailto:and...@pitonyak.org>> wrote:
> >
> > Not able to test for at least a week, but am curious what this
> > causes an error.
> >
> > where it fails, it verifies is something by that name is there
> > and then it tries to remove it. If I was able to run a test I
> > could check to make sure that the method is exist, but the
> > real question, is do you have write access to whatever it is
> > is trying to modify?
> >
> > Sent from BlueMail <http://www.bluemail.me/r?b=15824>
> > On Mar 11, 2020, at 3:00 PM, Patrick Kariuki
> > mailto:patrick.kari...@gmail.com>>
> > wrote:
> >
> > I'm running a macro file on LibreOffice6.2.8.2  <
> http://6.2.8.2>  and keep getting this
> > -https://imgur.com/a/tpDocIu
> >
> > Error is on this code -https://pastebin.com/S9RtUWVK  at
> Line 1327
> >
> > Please assist (I can send more information if required)
> >
> > Thanks.
> >
>  
> >
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org   LibreOffice@lists.freedesktop.org>
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> >
> > ___
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org
> > <mailto:LibreOffice@lists.freedesktop.org>
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> >
> >
> > ___
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

[Drew Jensen]

Actually as I think about it.

Isn't one of the differences between AOO and LO that AOO creates a new calc
file with multiple sheets and LO creates a new calc file with only one
sheet.

I don't think you can remove that last sheet, so perhaps that is it. A test
should tell on that also.

On Wed, Mar 11, 2020 at 4:31 PM Drew Jensen 
wrote:

> Interesting.
>
> Just did a search in the issue tracking system and there is an open issue
> regarding RemoveByName, but in a different context.
>
> Taking a quick look at that function and where it is called from it seems
> a quick test using a copy of that function should be a
> fairly quick exercise.
>
> Before I try that though, just to be sure; This basic module is embedded
> in the Calc file, yes?
>
> Thanks
>
> Drew
>
> On Wed, Mar 11, 2020 at 4:17 PM Andrew Pitonyak 
> wrote:
>
>> Not able to test for at least a week, but am curious what this causes an
>> error.
>>
>> where it fails, it verifies is something by that name is there and then
>> it tries to remove it. If I was able to run a test I could check to make
>> sure that the method is exist, but the real question, is do you have write
>> access to whatever it is is trying to modify?
>>
>> Sent from BlueMail <http://www.bluemail.me/r?b=15824>
>> On Mar 11, 2020, at 3:00 PM, Patrick Kariuki 
>> wrote:
>>>
>>> I'm running a macro file on LibreOffice 6.2.8.2 and keep getting this
>>> - https://imgur.com/a/tpDocIu
>>>
>>> Error is on this code - https://pastebin.com/S9RtUWVK at Line 1327
>>>
>>> Please assist (I can send more information if required)
>>>
>>> Thanks.
>>> --
>>>
>>> LibreOffice mailing list
>>> LibreOffice@lists.freedesktop.org
>>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>>
>>> ___
>> LibreOffice mailing list
>> LibreOffice@lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

[Drew Jensen]

Interesting.

Just did a search in the issue tracking system and there is an open issue
regarding RemoveByName, but in a different context.

Taking a quick look at that function and where it is called from it seems a
quick test using a copy of that function should be a fairly quick exercise.

Before I try that though, just to be sure; This basic module is embedded in
the Calc file, yes?

Thanks

Drew

On Wed, Mar 11, 2020 at 4:17 PM Andrew Pitonyak  wrote:

> Not able to test for at least a week, but am curious what this causes an
> error.
>
> where it fails, it verifies is something by that name is there and then it
> tries to remove it. If I was able to run a test I could check to make sure
> that the method is exist, but the real question, is do you have write
> access to whatever it is is trying to modify?
>
> Sent from BlueMail <http://www.bluemail.me/r?b=15824>
> On Mar 11, 2020, at 3:00 PM, Patrick Kariuki 
> wrote:
>>
>> I'm running a macro file on LibreOffice 6.2.8.2 and keep getting this
>> - https://imgur.com/a/tpDocIu
>>
>> Error is on this code - https://pastebin.com/S9RtUWVK at Line 1327
>>
>> Please assist (I can send more information if required)
>>
>> Thanks.
>> --
>>
>> LibreOffice mailing list
>> LibreOffice@lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Create my own function in Libreoffice Writer

[Drew Jensen]

Howdy,

For a first start I'd recommend you grab a copy of the Writer Guide (6.0 is
the latest of today) here:
https://documentation.libreoffice.org/assets/Uploads/Documentation/en/WG6.0/WG60-WriterGuideLO.pdf

Jump to Chapter 21 which covers basics of how to customize both menus and
toolbars.

If you are planning to run some type of script or macro from a menu and
looking for documentation I'd recommend downloading
First I'd recommend you download and install the LibreOffice SDK (software
developers kit) for the documentation of the LibreOffice API, all of the
scripting languages make use this API. This documentation becomes more
valuable as you get further into a project so I'd strongly recommend it.
Downloading that the SDK should match the version of the LibreOffice
installed, if it either 6.4.x or 6.3.x then you find that right on the
download page today: https://www.libreoffice.org/download/download/ if your
version is older you need to get it differently, just ask back here.

OK so if the built in Basic sounds good, this reference sheet:
https://documentation.libreoffice.org/assets/Uploads/Documentation/en/MACROS/RefCards/LibOBasic-2-Overview-Flat-Letter-EN-v110.pdf
as a start

There are other choices for scripting, such as Python and  you can find
information on that here;
https://wiki.documentfoundation.org/Macros/Python_Design_Guide

Hope that helps,

Drew

On Mon, Mar 2, 2020 at 7:33 PM meo meo  wrote:

> Hello Libreoffice Writer experts
>
> I want to create some functions of Libreoffice Writer (such as Labels,
> Bussiness Card, Templates) in File->New sub-menu to add into my own
> sub-menu in File menu. How can I do it?
>
> Thank you so much!
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

GSoC 2020

[Drew Jensen]

Howdy,

Noticed that Google has just released the selection for this years GSoC
mentoring projects; LibreOffice has been selected.

https://opensource.googleblog.com/2020/02/google-summer-of-code-2020-mentoring.html

Best wishes,

Drew
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Open Source Hackathon Mentorship Invitation

[Drew Jensen]

Hello Misha,

First I would like to thank you for taking the time to reach out to the
community here.

The work you are doing seems quite exciting and certainly appears to fit
well with the goals of The Document Foundation.

I suspect the biggest hurdle at the moment is time, or lack thereof, with
regards to this years HackIllinios event.

What I would like to propose is to set about working towards having a
mentor at the 2021 event, giving time to both recruit a developer and to
look at what coding projects would fit well with both your students and the
LibreOffice code base.

On the subject of coding projects I noted in reviewing the previous work
done at the HackIllinios events there seems to be strong use of Python for
projects. LibreOffice is predominantly written in C++ but also supports the
ability to integrate extensions to the application using python as the
development language and perhaps that is something which could fit well
here.

Of course someone may yet jump in here regarding this years event, but
should that not happen, what I would like to do is to add your event to the
community calendar so that next year the effort on our side can begin
earlier.

Best wishes for the success of this years event.

Drew

On Tue, Feb 18, 2020 at 1:43 PM Misha Patel 
wrote:

> Hello,
>
> My name is Misha Patel and I’m reaching out on behalf of the HackIllinois
> Outreach team. HackIllinois is a 36-hour collegiate Open Source hackathon
> that takes place annually at the University of Illinois Urbana-Champaign.
> This year, it will be from February 28th-March 1st, 2020. Our mission is to
> introduce college students to Open Source, while giving back to the
> community. We strive to create a collaborative environment in which our
> attendees can learn from and work with developers to make their own
> contributions. In past years, we’ve had developers from prominent projects
> such as npm, Rust, and Apache come to mentor students from our pool of 900+
> attendees.
>
> We’d love it if you could pass along this message to the LibreOffice
> community or any individuals you believe would be interested. We will
> provide meals throughout the event and can reimburse for travel and lodging
> up to a certain amount depending on where in the US people are coming from.
> More information on mentorship can be found at hackillinois.org/mentor.
> You can also visit opensource.hackillinois.org to see what kinds of
> projects were represented at our event last year.
>
> We'd be more than happy to discuss this further. Please have any
> interested individuals contact us at opensou...@hackillinois.org. Looking
> forward to hearing back!
>
> Best,
> Misha Patel
> HackIllinois 2020 Outreach Director
> misha.pa...@hackillinois.org
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Problem launching latest dev build of LO7

[Drew Jensen]

Howdy,

Running Ubuntu 18.04 (64bit) with LIBC_2.27 installed from the OS repo.

Was successfully running
Version: 7.0.0.0.alpha0+
Build ID: 4ff12ba6f4639c73587f2bb58afcc3ca6fb30105
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kf5;
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time:
2020-01-24_21:09:14

Today I grabbed the latest binary from the dev server, tinderbox:
Linux-archive-x86_64@80-updater
Current; dated today.

Unable to start the binary, a series of "can not find LIBC_2.29" and 2.30
in terminal. The last full error reported is:
/lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.30' not found (required
by
/home/drew/Downloads/lo7/LibreOfficeDev_7.0.0.0.alpha0_Linux_x86-64_archive/program/libuno_sal.so.3)

Reported on the IRC QA channel and was informed this build is reported as
running on the gandalf server.

Just letting you know what is happening here.

Best wishes,

Drew
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

LibreOffice and old Microsoft Binary file formats.

[Drew Jensen]

Howdy,

Today I worked with 5 different word processors (LibreOffice 6.4,
OnlyOffice 5.2, MS Word web, LibreOffice online and Google Docs, all
current and in use in the wild.

Of those 5 only one still allows the user to save files in the old
Microsoft Binary version.

In fact the other 4, including MS Word in the web (via onedrive) will open
old MS binary formats but if you edit the file then you can only save it
back as the newer iso standard OOXML format. I think that is a good thing
as it helps get rid of old binary format files.

The 1 which will allow a save in the binary format is LibreOffice.

Now IDK but wouldn't be surprised if MSO desktop still supports a save to
the binary format, but at least in the web version of the application that
option is gone.

I'm just wondering if maybe LibreOffice should also look at dropping write
support for those binary formats, at least in the online versions. It seems
to me a good thing to do.

Best wishes,

Drew
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: GPU optimization feedback (I hope ;-)

[Drew Jensen]

Well, Wikisteff, on Twitter, with the "25th order Runge-kutta integrator in
Excel without using VB" (To be honest I don't really know what that is ;-/)
test file responded to the thank you with;

"I, for one, cannot wait for more multicore/GPU. Libre is a fantastic
product, and I would be happy to share my sheets, such as they are, with
them."

So, question for the list; Take him up on the offer?

If there is a use for another test file I'll let them know and IDK get it
to the QA group, I guess - ?

Thanks



On Mon, Dec 9, 2019 at 2:10 PM Drew Jensen 
wrote:

> Howdy,
>
> Thought I'd pass on a twitter exchange, to the list here, between myself
> and Wikisteff regarding another attempt to benchmark some of the changes to
> Calc recently.
>
> Wikisteff: "Oh, yeah!
> I wrote a 25th order Runge-Kutta integrator in Excel without using VB as
> well."
>
> Wikisteff: "Well, it *was* part of a head-to-head test to see how GPU
> parallel evaluation of floating-point code worked in practice on
> @LibreOffice  Calc.
> @MSExcel  was the control. ;)"
>
> Me: "I would love to see results from a GPU parallel evaluation of
> floating-point code comparison between Calc and Excel. Is that available
> somewhere?  thanks."
>
> Wikisteff: "I didn't publish my results, but they amounted to "if the
> calculation is simple, like a uniform linear transformation or a matrix
> multiplication, high speedup. If the calculation is nonroutine, like a
> nonlinear transform interwoven with large matrix products, no speedup."
>
> Anyway, I haven't replied on twitter yet, will in a minute or two and
> thank him for his time and that piece of feedback.
>
> Personally I don't know if any of that is useful as feedback, hope so.
>
> Best wishes,
>
> Drew
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

GPU optimization feedback (I hope ;-)

[Drew Jensen]

Howdy,

Thought I'd pass on a twitter exchange, to the list here, between myself
and Wikisteff regarding another attempt to benchmark some of the changes to
Calc recently.

Wikisteff: "Oh, yeah!
I wrote a 25th order Runge-Kutta integrator in Excel without using VB as
well."

Wikisteff: "Well, it *was* part of a head-to-head test to see how GPU
parallel evaluation of floating-point code worked in practice on
@LibreOffice  Calc.
@MSExcel  was the control. ;)"

Me: "I would love to see results from a GPU parallel evaluation of
floating-point code comparison between Calc and Excel. Is that available
somewhere?  thanks."

Wikisteff: "I didn't publish my results, but they amounted to "if the
calculation is simple, like a uniform linear transformation or a matrix
multiplication, high speedup. If the calculation is nonroutine, like a
nonlinear transform interwoven with large matrix products, no speedup."

Anyway, I haven't replied on twitter yet, will in a minute or two and thank
him for his time and that piece of feedback.

Personally I don't know if any of that is useful as feedback, hope so.

Best wishes,

Drew
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Base without HSQL support?

[Drew Jensen]

On Thu, Jun 6, 2019 at 11:41 AM Caolán McNamara  wrote:

> On Wed, 2019-06-05 at 18:00 -0400, Drew Jensen wrote:
> >
> > Should the Migration Assistant be enabled by default yes, but the
> > default button on the Dialog box which opens when the connection to
> > an HSQL datasource is created stays No. I would recommend an
> > enhancement which is to include a URL to a TDF wiki page (with the
> > page setup for translation/NL support) which covers Why it should be
> > done now, and how to perform a migration both with the Migration
> > Assistant and without.
>
> On this, my patch at https://gerrit.libreoffice.org/#/c/73610/ would
> add such a link to the migration warning pointing provisionally to the
> blank page
> https://wiki.documentfoundation.org/Documentation/HowTo/MigrateFromHSQLDB
> which someone else would have to fill in. Is that the sort of thing you
> imagine here ?
>
>
Howdy,

Yes, and that page would be setup for native language support, hopefully
drawing folks to translate it.  I'll work with the documentation team to do
that.
Seems like the easiest way to go, to get details to the users as to what
the Migration Assistant (MA) will handle, easily updated as the MA code is
patched during the 6.3 minor release cycles.

Thanks,

drew
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Base without HSQL support?

[Drew Jensen]

Howdy,

I'm just going to jump into it.

If the question is; should Base not include the HSQL driver in the 6.3
release I would say no.
Should Firebird Embedded SDBC be the default selection for new Base files,
I'm agnostic.

But Yes to include it as an option (without needing experimental mode).
Here is a 2:40 video of why.
https://us.hostiso.cloud/index.php/s/HZLHLzeW4LBa5wi
tl/dw; Some simple features still don't work with parts of firebird sdbc.

Should the Migration Assistant be enabled by default yes, but the default
button on the Dialog box which opens when the connection to an HSQL
datasource is created stays No. I would recommend an enhancement which is
to include a URL to a TDF wiki page (with the page setup for translation/NL
support) which covers Why it should be done now, and how to perform a
migration both with the Migration Assistant and without.

Right now if the ODB file with HSQL does not have any of the following data
types, decimal, numeric, Image(Blob), Date, Time or TIMESTAMP, the data
transfer will succeed. How many odb files would have one or more of those
IDK but guessing it would be a fair percentage.

Here is the real problem though, imo, right now with 6.3 if you try to
import any external source into decimal and numeric fields with Firebird
there is an issue. If you drag drop a table from any Base file type or from
Calc or import a text file as CSV. The Date, time, TIMESTAMP and Boolean
fields in Firebird also have some issues with the those Import Wizard
functions, but less extreme in that the import function is more restrictive
on what is recognized as valid input compared to the Import Wizard when
using the HSQL sdbc.

More so however there are still prickly issues with Wizards and Designers
(query, form, report) still not fully functional, or working properly, with
Firebird sdbc.

So what I really think should be considered is to focus any developer
resources for the 6.3 release first on pushing the firebird sdbc much
closer to feature parity with the HSQL regarding how much of the Base UI
functions properly with the sdbc, even if that means there is no further
work on Migration Assistant before the 6.3 release.

I think that if the project really wants to be aggressive on ditching HSQL,
as with 6.4, then right now and thru to the 6.4 release there should be a
TDF emphasize on getting people to make the migration from HSQL odb files.
Either to Firebird embedded or an external data base. This would require
work from documentation folks (creating a tutorial, updating a wiki page or
online help and marketing folks to generate awareness and urgency. There
are advantages to actively pushing people to do this now while there is
both HSQL and Firebird in the LibreOffice package. Those advantages however
require that the current Import Wizard (drag drop of tables) would work,
right now all data types can move via the IW routines from a Firebird sdbc
file to a HSQLdb sdbc file BTW, but not back the other way.

Anyway, that is my two cents worth of opinion on how it is at the moment.

Thanks and best wishes,

Drew
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Myanmar dictionary

[Drew Jensen]

Just in case 64bit Linux is correct for you - if you start on the main
download page, find your OS and you will find a link to the language packs
there for your particular OS.

On Sat, Apr 27, 2019 at 3:18 PM Drew Jensen 
wrote:

> Howdy,
>
> If you are looking for Burmese there is a language pack listed on the
> download page.
> All available are listed here
>
> https://www.libreoffice.org/download/download/?type=deb-x86_64=6.2.3=pick
>
>
> Hope that helps.
>
> Best wishes,
>
> Drew
>
> On Sat, Apr 27, 2019 at 3:04 PM Cyrille  wrote:
>
>> Hello,
>> I'm currently helping a friend to use Libreoffice for the publication of
>> a book in Myanmar. But all the links for Myanmar/burmese in this page point
>> to very old package no more compatible with new LO release:
>> https://wiki.documentfoundation.org/Language_support_of_LibreOffice.
>> To type text the installation of the palauk font solve the problem on
>> Ubuntu.
>> For dictionary on this link
>> <http://thanlwinsoft.github.io/www.thanlwinsoft.org/ThanLwinSoft/Downloads/>
>> I found an old extension with an hunspell dic for OpenOffice and it is
>> probably possible to create a new extension for Libreoffice. I'm ready to
>> do the work, but I couldn't maintain it. Would it be possible to add it
>> directly to Libreoffice sources?
>> The same page says that the ui is translated but on Ubuntu I couldn't see
>> the translation with the "my" locale. the
>> http://thanlwinsoft.github.io/www.thanlwinsoft.org/ThanLwinSoft/Downloads/
>> page says too that graphite give this UI translation, then how to use it on
>> LO?
>>
>> Thanks for help.
>> Cyrille
>> ___
>> LibreOffice mailing list
>> LibreOffice@lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Myanmar dictionary

[Drew Jensen]

Howdy,

If you are looking for Burmese there is a language pack listed on the
download page.
All available are listed here
https://www.libreoffice.org/download/download/?type=deb-x86_64=6.2.3=pick


Hope that helps.

Best wishes,

Drew

On Sat, Apr 27, 2019 at 3:04 PM Cyrille  wrote:

> Hello,
> I'm currently helping a friend to use Libreoffice for the publication of a
> book in Myanmar. But all the links for Myanmar/burmese in this page point
> to very old package no more compatible with new LO release:
> https://wiki.documentfoundation.org/Language_support_of_LibreOffice.
> To type text the installation of the palauk font solve the problem on
> Ubuntu.
> For dictionary on this link
> <http://thanlwinsoft.github.io/www.thanlwinsoft.org/ThanLwinSoft/Downloads/>
> I found an old extension with an hunspell dic for OpenOffice and it is
> probably possible to create a new extension for Libreoffice. I'm ready to
> do the work, but I couldn't maintain it. Would it be possible to add it
> directly to Libreoffice sources?
> The same page says that the ui is translated but on Ubuntu I couldn't see
> the translation with the "my" locale. the
> http://thanlwinsoft.github.io/www.thanlwinsoft.org/ThanLwinSoft/Downloads/
> page says too that graphite give this UI translation, then how to use it on
> LO?
>
> Thanks for help.
> Cyrille
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Bug 123999] time change causes the return of "parameter index out of range... using mysql and J/connector

[Drew Jensen]

Howdy Dan,

You find all the daily builds at https://dev-builds.libreoffice.org/daily/

I install those in parallel on my system, which I figure you already know
how to do but for those who may not:
https://wiki.documentfoundation.org/Installing_in_parallel

Best wishes,

Drew


On Sat, Mar 30, 2019 at 9:11 PM Dan Lewis  wrote:

> I have run into a problem with this bug. I would like to download a daily
> build, but I do not know how. I have clicked on the link below, but I don't
> see any .deb files that I can download. I don't really know what it is that
> I am to download. (I use Ubuntu 18.04.) In fact, I do not see any builds
> available there. I could use some help so that I can test this patch to see
> if it works.
>
> Dan
> On 3/27/19 9:14 AM, bugzilla-dae...@bugs.documentfoundation.org wrote:
>
> *Comment # 17
> <https://bugs.documentfoundation.org/show_bug.cgi?id=123999#c17> on bug
> 123999 <https://bugs.documentfoundation.org/show_bug.cgi?id=123999> from
> Commit Notification  *
>
> Julien Nabet committed a patch related to this issue.
> It has been pushed to "libreoffice-6-2":
> https://git.libreoffice.org/core/+/15f4f8b7bfd666d69381696fe288da24302d2ecd%5E%21
> tdf#123999 <https://bugs.documentfoundation.org/show_bug.cgi?id=123999>: 
> ParameterNameSubstitution in mysqljdbc
>
> It will be available in 6.2.3.
>
> The patch should be included in the daily builds available 
> athttps://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
> information about daily builds can be found 
> at:https://wiki.documentfoundation.org/Testing_Daily_Builds
>
> Affected users are encouraged to test the fix and report feedback.
>
> --
> You are receiving this mail because:
>
>- You reported the bug.
>
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Bug 122520 foreign key constraints

[Drew Jensen]

Hola Dan,

Noticed that Tamas Bunth checked in two patchs today regarding MySQL
foreign keys, it is marked as fixing issues in
https://bugs.documentfoundation.org/show_bug.cgi?id=122437
I wonder if it might also address the problem here.

I would give it a try with the latest 6.3 daily build in a day or two and
see if that does it.

Best wishes,

Drew

On Sat, Jan 12, 2019 at 1:24 PM Dan Lewis 
wrote:

> When upgrading MySQL 8.0.13 from 5.7, a problem occurs if any of the
> foreign key restraints contains a primary key with one or more capital
> letters in it. MySQL converts any capital letters to lower case in the
> foreign key restraint while still recognizing the primary key with its
> capital.
>
> For example: the primary key is Primary_id and its foreign key is
> foreign_id. In practice, the restraint links these two fields:
> primary_id and foreign_id respectively. Since primary_id contains no
> data, the related tables can not be used in a query.
>
> A warning of some type should be made stating that primary keys are not
> to have any capital letters in it.
>
> Dan
>
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Bug 122675 MySQL native connector problem with LO 6.2.0.2

[Drew Jensen]

also from the MySQL documentation there is the option to reconfigure the
server to use the older default authentication:
"Further, it is always possible to change ––default-authentication-plugin
to a non-default value of your choice (At present, options other than
caching_sha2_password are: mysql_native_password and sha256_password). For
example, if ––default-authentication-plugin is set to
mysql_native_password, the behavior of the MySQL 8.0.4 server is similar to
MySQL 8.0.3 and prior. Correspondingly, libmysqlclient supports the
MYSQL_DEFAULT_AUTH options for mysql_options() C API function. (For
libmysqlclient based client tools available in MySQL packages, the
––default-auth command-line options achieves the same purpose.) The
client-side option is a performance tool and saves an extra round-trip when
used in tandem with ––default-authentication-plugin option on server side.
However, we recommend use of caching_sha2_password because of the enhanced
security that it offers. We also recommend updating libmysqlclient to MySQL
8.0.4 or later so that new default authentication plugin is supported by
clients that use it."

https://mysqlserverteam.com/mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password/

On Sat, Jan 12, 2019 at 1:11 PM Drew Jensen 
wrote:

> Howdy Dan,
>
> Some information on the problem and work around can be found here:
> https://tableplus.io/blog/2018/07/failed-to-load-caching-sha2-password-authentication-plugin-solved.html
>
> The issue was opened by another person yesterday and this issue was lined
> to it.
>
> Drew
>
> On Sat, Jan 12, 2019 at 12:23 PM Dan Lewis 
> wrote:
>
>> I get the following error message when using the Base Wizard in LO
>> 6.2.0.2 to connect to a MySQL database.
>>
>>Can't initialize character set unknown (path: compiled_in)
>>
>> I get as far as clicking the the Test Connection button. When entering
>> the password and clicking OK, I get this message. I have MySQL 8.0.13
>> for my back end. I set up to use SHA2 with my password. (This may well
>> be the where the problems lie.)
>>
>> Dan
>>
>> ___
>> LibreOffice mailing list
>> LibreOffice@lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Bug 122675 MySQL native connector problem with LO 6.2.0.2

[Drew Jensen]

Howdy Dan,

Some information on the problem and work around can be found here:
https://tableplus.io/blog/2018/07/failed-to-load-caching-sha2-password-authentication-plugin-solved.html

The issue was opened by another person yesterday and this issue was lined
to it.

Drew

On Sat, Jan 12, 2019 at 12:23 PM Dan Lewis  wrote:

> I get the following error message when using the Base Wizard in LO
> 6.2.0.2 to connect to a MySQL database.
>
>Can't initialize character set unknown (path: compiled_in)
>
> I get as far as clicking the the Test Connection button. When entering
> the password and clicking OK, I get this message. I have MySQL 8.0.13
> for my back end. I set up to use SHA2 with my password. (This may well
> be the where the problems lie.)
>
> Dan
>
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: What does checking the option "Formatted Display" on the Calc Find Toolbar actually do?

[Drew Jensen]

Thank you

On Sun, Dec 30, 2018 at 3:50 PM Jan-Marek Glogowski 
wrote:

> Am 30. Dezember 2018 20:57:34 MEZ schrieb Drew Jensen <
> drewjensen.in...@gmail.com>:
> >Howdy,
> >
> >Long and the short of this email is the question posed in the subject
> >line.
> >Can anyone point to where the answer to that question can be found?
> >
> >Thanks, in advance, for your time and help.
> >
> >Best wishes,
> >
> >Drew
>
> Search for the formatted / displayed value instead of the (stored) cell
> value ("65,536" vs "65536").
>
> https://bugs.documentfoundation.org/show_bug.cgi?id=48456
>
> Jan-Marek
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

What does checking the option "Formatted Display" on the Calc Find Toolbar actually do?

[Drew Jensen]

Howdy,

Long and the short of this email is the question posed in the subject line.
Can anyone point to where the answer to that question can be found?

Thanks, in advance, for your time and help.

Best wishes,

Drew
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Minutes from the UX/design meeting 2018-Dec-06

[Drew Jensen]

ah ok - once again I seem to be failing at understanding, I didn't notice
any of this till the email today and thought the patch was pending not that
it was already incorporated.
I was not attempting to comment on whether it was a good thing or not -
just that what I see in the UI using the tabbed bar makes reasonable sense
IMO. I just wanted to make sure to pay attention to the change for the
documentation work.



On Thu, Dec 6, 2018 at 11:12 AM Heiko Tietze  wrote:

> On 06.12.18 15:41, Drew Jensen wrote:
> > ...
> > My question Is; Will this change in menus to happen in the 6.2 release?
>
> Yes it is/was in 6.2 But I will revert the patch that disables
> header/footer by default and abort this menu change.
>
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Minutes from the UX/design meeting 2018-Dec-06

[Drew Jensen]

I was just now looking at this using the tabbed notebook interface (though
I'm running the 6.3Alpha0 build, so maybe there is some difference there
from 6.2) and I see that the different places where the header/footer
dialog is available already enables or disables depending on what was
selected in the page format dialog.  Given that the page format button is
next to the header/footer button it becomes a visual clue that when you
disable them in the page format dialog and return to the main window the
h/f dialog button is immediately disabled.

Plus it is good to see that both the page format and header/footer dialog
is available during print preview, which is where one can notice that it is
or isn't there, right.

My question Is; Will this change in menus to happen in the 6.2 release?

Thanks and best wishes,

Drew


On Thu, Dec 6, 2018 at 9:27 AM Samuel Mehrbrodt 
wrote:

> Am 06.12.2018 um 15:12 schrieb Heiko Tietze:
> > Please comment on BZ
> https://bugs.documentfoundation.org/show_bug.cgi?id=121759;
>
> I already commented a week ago:
> https://bugs.documentfoundation.org/show_bug.cgi?id=121759#c6
>
> >   so far there is no other opinion and yours would be 1 against 2.
> Since when is this decided by votes?
>
> I tried to do what you are doing (disable header and footer by default
> in Calc) some time ago, but I came to the conclusion that there needs to
> be some serious UX improvements before we can do that.
> Joe Average will not know how to enable them (that he has to go to
> Format->Page to enable them).
>
> If you want to disable headers and footers by default, you need to
>
> 1) Always enable the Insert->Header/Footer menu entry
> 2) Add an option to enable Header/Footer to the Header/Footer dialog
>
> or something similiar.
>
> Regards
> Samuel
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] Third dedicated session for bug hunting session on Monday - Base, Access2Base

[Drew Jensen]

Ok - well, seeing no objects.

Updated the wiki page
https://wiki.documentfoundation.org/QA/BugHuntingSession/6.2.0Beta#Dedicated_sessions
adding this session.

Didn't see any reason actually to move a copy of the graphic to the wiki,
leaving on the NC server
https://nextcloud.documentfoundation.org/s/Wy2PAXqRqgKGEfF

Also updated the release notes wiki page for Base and Basic
https://wiki.documentfoundation.org/ReleaseNotes/6.2

Will make a few posts about it.

Thanks for your support and I'll see you online tomorrow.

Drew




On Sun, Nov 18, 2018 at 3:10 AM Drew Jensen 
wrote:

> Howdy,
>
> Well, I realize this is last minute, but perhaps better late then never in
> these circumstances.
>
> I would like to add another session to the bug hunting session on Monday,
> from 13:00 to 15:00 UTC. Firebird becomes non experimental / Access2Base
> picks up full support for Firebird.
>
> I would be on-line the whole time and think I could act as mentor on the
> subject.
>
> I did not coordinate this with Jean-Pierre in advance, sorry. I am not
> asking you to help, just letting you know that what I would like to do here
> on Monday.
>
> I would update the QA bug hunting wiki page with the time slot.
> I've already made a marketing graphic, found here for the moment:
> https://nextcloud.documentfoundation.org/s/Wy2PAXqRqgKGEfF
> and would share to a few social media channels, also attach the graphic to
> the wiki page.
>
> I'm asking for very lazy consensus and after I wake up if no objected I'll
> do both.
>
> Best wishes,
>
> Drew
>
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] Third dedicated session for bug hunting session on Monday - Base, Access2Base

[Drew Jensen]

Howdy,

Well, I realize this is last minute, but perhaps better late then never in
these circumstances.

I would like to add another session to the bug hunting session on Monday,
from 13:00 to 15:00 UTC. Firebird becomes non experimental / Access2Base
picks up full support for Firebird.

I would be on-line the whole time and think I could act as mentor on the
subject.

I did not coordinate this with Jean-Pierre in advance, sorry. I am not
asking you to help, just letting you know that what I would like to do here
on Monday.

I would update the QA bug hunting wiki page with the time slot.
I've already made a marketing graphic, found here for the moment:
https://nextcloud.documentfoundation.org/s/Wy2PAXqRqgKGEfF
and would share to a few social media channels, also attach the graphic to
the wiki page.

I'm asking for very lazy consensus and after I wake up if no objected I'll
do both.

Best wishes,

Drew
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Next QA meeting: Oct 30 at 15:00 UTC

[Drew Jensen]

Thanks!

On Tue, Oct 30, 2018 at 10:53 AM Xisco Fauli 
wrote:

> Forgot the link:
>
> [1]
> http://document-foundation-mail-archive.969070.n3.nabble.com/Libreoffice-qa-Request-for-content-to-the-next-monthly-report-td4251302.html
> El 30/10/18 a les 15:50, Drew Jensen ha escrit:
>
> Laughing - letter?
>
> I'm not seeing something that is likely right in front of me then.
>
> You want us to review: https://wiki.documentfoundation.org/QA/GetInvolved
> is that it?
>
> On Tue, Oct 30, 2018 at 10:45 AM Xisco Fauli 
> wrote:
>
>> Hi Drew,
>>
>> I'd love to discuss Ilmari's email [1] more in detail to see how we
>> should handle this.
>>
>> Regards
>> El 30/10/18 a les 14:04, Drew Jensen ha escrit:
>>
>> Is there an agenda of any kind?
>>
>> On Mon, Oct 29, 2018 at 7:49 PM Xisco Fauli 
>> wrote:
>>
>>> Hello,
>>>
>>> Kindly Reminder: Next QA meeting will take place today Tue, October 30
>>> at 15:00 UTC in the IRC channel #libreoffice-qa. More information:
>>> https://wiki.documentfoundation.org/QA/IRC
>>>
>>>
>>> If you have any topic you would like to discuss during the meeting,
>>> please reply to this email or mention it at the beginning of the meeting.
>>>
>>> Regards
>>>
>>> --
>>> Xisco Faulí
>>> Libreoffice QA Team
>>> IRC: x1sc0
>>>
>>> ___
>>> List Name: Libreoffice-qa mailing list
>>> Mail address: Libreoffice-qa@lists.freedesktop.org
>>> Change settings:
>>> https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
>>> Problems?
>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
>>
>> --
>> Xisco Faulí
>> Libreoffice QA Team
>> IRC: x1sc0
>>
>> --
> Xisco Faulí
> Libreoffice QA Team
> IRC: x1sc0
>
>
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Next QA meeting: Oct 30 at 15:00 UTC

[Drew Jensen]

Laughing - letter?

I'm not seeing something that is likely right in front of me then.

You want us to review: https://wiki.documentfoundation.org/QA/GetInvolved
is that it?

On Tue, Oct 30, 2018 at 10:45 AM Xisco Fauli 
wrote:

> Hi Drew,
>
> I'd love to discuss Ilmari's email [1] more in detail to see how we should
> handle this.
>
> Regards
> El 30/10/18 a les 14:04, Drew Jensen ha escrit:
>
> Is there an agenda of any kind?
>
> On Mon, Oct 29, 2018 at 7:49 PM Xisco Fauli 
> wrote:
>
>> Hello,
>>
>> Kindly Reminder: Next QA meeting will take place today Tue, October 30
>> at 15:00 UTC in the IRC channel #libreoffice-qa. More information:
>> https://wiki.documentfoundation.org/QA/IRC
>>
>>
>> If you have any topic you would like to discuss during the meeting,
>> please reply to this email or mention it at the beginning of the meeting.
>>
>> Regards
>>
>> --
>> Xisco Faulí
>> Libreoffice QA Team
>> IRC: x1sc0
>>
>> ___
>> List Name: Libreoffice-qa mailing list
>> Mail address: Libreoffice-qa@lists.freedesktop.org
>> Change settings:
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
>> Problems?
>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
>
> --
> Xisco Faulí
> Libreoffice QA Team
> IRC: x1sc0
>
>
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Next QA meeting: Oct 30 at 15:00 UTC

[Drew Jensen]

Is there an agenda of any kind?

On Mon, Oct 29, 2018 at 7:49 PM Xisco Fauli 
wrote:

> Hello,
>
> Kindly Reminder: Next QA meeting will take place today Tue, October 30
> at 15:00 UTC in the IRC channel #libreoffice-qa. More information:
> https://wiki.documentfoundation.org/QA/IRC
>
>
> If you have any topic you would like to discuss during the meeting, please
> reply to this email or mention it at the beginning of the meeting.
>
> Regards
>
> --
> Xisco Faulí
> Libreoffice QA Team
> IRC: x1sc0
>
> ___
> List Name: Libreoffice-qa mailing list
> Mail address: Libreoffice-qa@lists.freedesktop.org
> Change settings:
> https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: OpenDocument spec tables row height [was: Writer - row-height, min-row-height and use-optimal-row-height]

[Drew Jensen]

For what it's worth as I am no sw expert, I'd say do the commit.
It isn't like there is a real chance of an interoperability  problem, AFAIK
only other implementation is AOO.
so... What could possibly go wrong?

On Sat, Sep 29, 2018 at 4:51 PM Lionel Elie Mamane  wrote:

> In the absence of feedback from sw people, we just commit the change?
>
> On Thu, Jul 26, 2018 at 03:10:37PM +0200, Lionel Elie Mamane wrote:
> > Anybody?
> >
> > On Sun, Jun 17, 2018 at 11:48:49AM +0200, Lionel Elie Mamane wrote:
> > > Hi,
> > >
> > > The Base report builder produces Writer (odt) documents directly (it
> > > spits out XML, not using Writer to produce it), and then opens them in
> > > Writer. It uses tables heavily.
> > >
> > > In the context of
> > > https://bugs.documentfoundation.org/show_bug.cgi?id=45789
> > > https://gerrit.libreoffice.org/53977
> > > Ilhan prepared a patch to make Report Builder mark some rows of some
> > > tables as "fit to size" in row height. By reading the OpenDocument
> > > specification, I thought this would happen by setting the
> > > style:use-optimal-row-height attribute on the row. However, it turns
> > > out that Ilhan had to change some sw code for that to work, and that
> > > made me suspicious whether that was the right thing to do.
> > >
> > > I looked into the XML generated by Writer with "Fit to Size" enabled
> > > and disabled, and apparently that checkbox in writer replaces
> > > "style:row-height" by "style:min-row-height, and
> > > style:use-optimal-row-height is nowhere to be seen.
> > >
> > > Could a Writer expert please look at the sw changes in
> > > https://gerrit.libreoffice.org/53977
> > > and let us know whether these changes are right or wrong with respect
> > > to OpenDocument? Is style:use-optimal-row-height supposed to override
> > > style:row-height or vice-versa?
> > >
> > > Thanks in advance,
> > >
> > ___
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How to Build LO Eclipse

[Drew Jensen]

Great and thanks.

I should just wait for the work to be finished and get it after it is
published.

Any idea when that might be?

Thanks again,

Drew

On Wed, Sep 12, 2018 at 6:49 AM Samuel Mehrbrodt 
wrote:

> Hi Drew,
>
> the python support has not yet been merged to master. You need to check
> out this pull request: https://github.com/LibreOffice/loeclipse/pull/68
>
> Regards
> Samuel
>
> Am 03.09.2018 um 16:28 schrieb Drew Jensen:
>
> Howdy Shobhan,
>
> First, a little embarrassed that I somehow skipped visually what was there
> for instructions.
>
> Not sure I understand about the python project, that is the only reason I
> cloned the repository https://github.com/LibreOffice/loeclipse was to
> pickup the python support. There was no python folder created at that time,
> so maybe I did something wrong right there. Is there a different repository?
>
> Anyway, imported the source into eclipse (committer-photon june 2018) and
> I've tried building with ant outside eclipse.
> (not sure that it matters but for the LibreOffice installation I'm using
> the 6.2 master daily build and sdk)
>
> So far no love from either build, but down to only a few errors when done
> inside Eclipse (4 total); outside using ANT many more.
>
> Anyway, thanks for the response, it was a needed gentle slap on the back
> of the head ;-0
>
> Will get back into later today and see if I can't get it all  worked out.
> If really get stuck I'll ask more.
>
> Thanks for the work on the project and best wishes,
>
> Drew
>
> On Mon, Sep 3, 2018 at 8:38 AM Shobhan Mandal 
> wrote:
>
>> Hello Drew,
>>
>> If you are looking forward to developing the eclipse addon directly from
>> the source, you can try the following:-
>>
>> *1.* Run this command (switch to the build folder in the downloaded
>> repository):
>>~/git/loeclipse/build$ *ant -Dlibreoffice.home=/usr/lib/libreoffice
>> -Declipse.home=/home/shobhan/Desktop//eclipse*
>> *2.* A new folder called 'site' is created beside the existing core,
>> java, python (*python folder will show up if there is Python module in
>> the repository that you downloaded*), build and script folder.
>> *3.* Go to Eclipse. Open the Help menu -> Install -> Click the Add
>> button -> Select Local -> Use the wizard to select the 'site' folder
>> created in above step.
>>
>> A concise version was mentioned under
>> https://github.com/LibreOffice/loeclipse#release-management
>>
>> If you are looking forward to contributing to the source code, following
>> the steps mentioned under
>> https://github.com/LibreOffice/loeclipse#development would help you get
>> started.
>>
>> Thanks and Regards,
>> Shobhan.
>>
>
>
> ___
> LibreOffice mailing 
> listLibreOffice@lists.freedesktop.orghttps://lists.freedesktop.org/mailman/listinfo/libreoffice
>
>
> --
> Samuel Mehrbrodt
> Softwareentwickler LibreOffice
> –––
> CIB software GmbH
> Geschäftsstelle Hamburg
> Flachsland 10
> 22083 Hamburg
> –––
> T +49 (40) / 28 48 42 -224
> F +49 (40) / 28 48 42 -100
>
> samuel.mehrbr...@cib.de
> www.cib.de
> –––
> Sitz: München
> Registergericht München, HRB 123286
> Geschäftsführer: Dipl.-Ing. Ulrich Brandner
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How to Build LO Eclipse

[Drew Jensen]

Howdy Shobhan,

First, a little embarrassed that I somehow skipped visually what was there
for instructions.

Not sure I understand about the python project, that is the only reason I
cloned the repository https://github.com/LibreOffice/loeclipse was to
pickup the python support. There was no python folder created at that time,
so maybe I did something wrong right there. Is there a different repository?

Anyway, imported the source into eclipse (committer-photon june 2018) and
I've tried building with ant outside eclipse.
(not sure that it matters but for the LibreOffice installation I'm using
the 6.2 master daily build and sdk)

So far no love from either build, but down to only a few errors when done
inside Eclipse (4 total); outside using ANT many more.

Anyway, thanks for the response, it was a needed gentle slap on the back of
the head ;-0

Will get back into later today and see if I can't get it all  worked out.
If really get stuck I'll ask more.

Thanks for the work on the project and best wishes,

Drew

On Mon, Sep 3, 2018 at 8:38 AM Shobhan Mandal 
wrote:

> Hello Drew,
>
> If you are looking forward to developing the eclipse addon directly from
> the source, you can try the following:-
>
> *1.* Run this command (switch to the build folder in the downloaded
> repository):
>~/git/loeclipse/build$ *ant -Dlibreoffice.home=/usr/lib/libreoffice
> -Declipse.home=/home/shobhan/Desktop//eclipse*
> *2.* A new folder called 'site' is created beside the existing core,
> java, python (*python folder will show up if there is Python module in
> the repository that you downloaded*), build and script folder.
> *3.* Go to Eclipse. Open the Help menu -> Install -> Click the Add button
> -> Select Local -> Use the wizard to select the 'site' folder created in
> above step.
>
> A concise version was mentioned under
> https://github.com/LibreOffice/loeclipse#release-management
>
> If you are looking forward to contributing to the source code, following
> the steps mentioned under
> https://github.com/LibreOffice/loeclipse#development would help you get
> started.
>
> Thanks and Regards,
> Shobhan.
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How to build LO Eclipse.

[Drew Jensen]

should probably also add.
I already cloned the git repository locally.
Now I'm reading over a generic article on how to build a Eclipse extension
and maybe this is the answer to my question.

SO, I'll post back if it I really need more help to work out this out.



On Sun, Sep 2, 2018 at 3:30 PM Drew Jensen 
wrote:

> Howdy,
>
> Over at https://github.com/LibreOffice/loeclipse
> the installation instructions are to use the Eclipse Marketplace.
>
> Currently the source has been updated from the recent GSOC project to add
> python support and I would like to give that a shot.
>
> Are there any instructions for building the Eclipse addon directly from
> the source. I've looked a bit for such and didn't find any, which of course
> doesn't mean they aren't somewhere.
>
> Thanks
> Drew
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

How to build LO Eclipse.

[Drew Jensen]

Howdy,

Over at https://github.com/LibreOffice/loeclipse
the installation instructions are to use the Eclipse Marketplace.

Currently the source has been updated from the recent GSOC project to add
python support and I would like to give that a shot.

Are there any instructions for building the Eclipse addon directly from the
source. I've looked a bit for such and didn't find any, which of course
doesn't mean they aren't somewhere.

Thanks
Drew
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: License information for extensions on LO's extension site

[Drew Jensen]

Hola,

Just curious if the Templates will also require a license to be eligible
for the TDF site.

Today:
- some don't declare a license on the website page.
- some state a license on the website page
-- some include a license declaration inside the template file.
 some of these do so in the file properties
 some do so with comments in embedded script libraries
 some which state a license on the web site do neither

Particularly in the case of templates with embedded scripts is not the
license not valid if the user is not forced to agree to it?

If the extension must ask the user(s) to accept the developers license on
install to be eligible for the TDF extensions site then why not the
templates?
-- granted there is no standard way to that during first use, but the
website could require they check a box as agreement with the license before
allowing them to download the file.

Seems like the two parts of the site would be consistent if possible.

Thanks much for you efforts and time.

Best wishes

Drew
-


This morning I downloaded a few.



On Thu, Aug 30, 2018 at 2:09 PM Andreas Mantke  wrote:

> Am 30.08.2018 um 19:02 schrieb Stephan Bergmann:
> > On 30/08/18 18:43, Andreas Mantke wrote:
> >> In my view it is necessary, that a LibreOffice extension that is
> >> published on a TDF resource, has a clear license statement and presents
> >> this license statement to the user during the installation process.
> >
> > Why should presenting the license during installation be necessary?
> > Installing LO itself, for example, doesn't do that, either.
>
> if you want to make an agreement with the user about the license, you
> have to present the license during the installing process and ask for
> accepting it.
>
> Otherwise there is no agreement on the license.
>
> Kind regards,
> Andreas
>
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Undefined symbols for architecture x86_64 in libmariadb-connector-c - build failure on master, with macOS

[Drew Jensen]

Noticed over on the QA IRC channel some talk about Mac and a recent change
to the MySQL sdbc code:
"Switch from mysql to MariaDB C API" :
https://cgit.freedesktop.org/libreoffice/core/commit/?id=3478d7453a3d65b3d8d164e8f898a0b79f005c58
for the change record.

On Mon, Aug 20, 2018 at 11:38 AM Alexander Thurgood 
wrote:

> Le 20/08/2018 à 17:24, Alexander Thurgood a écrit :
>
> The last change I see when git grepping mariadb is a commit from Miklos
> relating to fixing the Windows build...but this was back in May, and I
> have been successfully building from master on MacOS, including after
> make clean, git pull and make using an export in my environment to the
> mysql-connector-c source since well before May 30th, 2018...
>
>
>
>
>
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] Question on odd output on first start of lastest Libo 6.2 daily build

[Drew Jensen]

well, now I need to change something there.

Seems it is not just with the first startup. This was what written out to
the terminal on shutdown in a subsequent session:

[31371:31371:0617/152203.372545:ERROR:buffer_manager.cc(452)]
[.DisplayCompositor-0x55759ba63bb0]GL ERROR :GL_INVALID_OPERATION :
glBufferData: <- error from previous GL command
[1:18:0617/152632.126130:ERROR:adm_helpers.cc(73)] Failed to query stereo
recording.

Again, I've not seen this with prior builds, and this build is:
Version: 6.2.0.0.alpha0+
Build ID: 5bbf40fde5a6cefaf596c345f8997164dd92932f
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2018-06-17_11:17:04
Locale: en-US (en_US.UTF-8); Calc: group threaded

On Sun, Jun 17, 2018 at 3:00 PM Drew Jensen 
wrote:

> Howdy,
>
> Downloaded the latest 6.2 daily build for 64bit Linux, installed under
> Ubuntu 18.04 (w/gnome default desktop) and on first start got some output
> to stdout which I'd need before:
>
> from here---
> Using PPAPI flash.
>  --ppapi-flash-path=/usr/lib/adobe-flashplugin/libpepflashplayer.so
> --ppapi-flash-version=
>
> (chromium-browser:31324): Gtk-WARNING **: 10:55:46.641: Theme parsing
> error: gtk-main.css:73:38: Failed to import: Error opening file
> /usr/share/themes/Radiance/gtk-3.20/apps/gnome-builder.css: No such file or
> directory
> [31371:31371:0617/105546.812092:ERROR:sandbox_linux.cc(379)]
> InitializeSandbox() called with multiple threads in process gpu-process.
> [31324:31358:0617/105546.891093:ERROR:in_progress_cache_impl.cc(93)] Could
> not read download entries from file because there was a read failure.
> drew@drews-4banger:~/Desktop/libreofficedev6.2/program$
> [1:25:0617/111359.255751:ERROR:adm_helpers.cc(73)] Failed to query stereo
> recording.
> [1:18:0617/111845.783069:ERROR:adm_helpers.cc(73)] Failed to query stereo
> recording.
> [1:18:0617/112109.932063:ERROR:adm_helpers.cc(73)] Failed to query stereo
> recording.
> [1:18:0617/112221.144984:ERROR:adm_helpers.cc(73)] Failed to query stereo
> recording.
> [1:18:0617/113901.949051:ERROR:adm_helpers.cc(73)] Failed to query stereo
> recording.
> [31371:31371:0617/115136.120713:ERROR:gles2_cmd_decoder.cc(18288)]
> [.DisplayCompositor-0x55759949e740]GL ERROR :GL_INVALID_OPERATION :
> glCreateAndConsumeTextureCHROMIUM: invalid mailbox name
> [31371:31371:0617/115136.120851:ERROR:gles2_cmd_decoder.cc(10129)]
> [.DisplayCompositor-0x55759949e740]RENDER WARNING: texture bound to texture
> unit 0 is not renderable. It maybe non-power-of-2 and have incompatible
> texture filtering.
> [31371:31371:0617/115136.120942:ERROR:gles2_cmd_decoder.cc(18288)]
> [.DisplayCompositor-0x55759949e740]GL ERROR :GL_INVALID_OPERATION :
> glCreateAndConsumeTextureCHROMIUM: invalid mailbox name
> [31371:31371:0617/115136.121034:ERROR:gles2_cmd_decoder.cc(10129)]
> [.DisplayCompositor-0x55759949e740]RENDER WARNING: texture bound to texture
> unit 0 is not renderable. It maybe non-power-of-2 and have incompatible
> texture filtering.
> Gtk-Message: 13:10:37.082: GtkDialog mapped without a transient parent.
> This is discouraged.
> [1:18:0617/134603.977586:ERROR:adm_helpers.cc(73)] Failed to query stereo
> recording.
>
>  to here ---
>
> So, the ppapi line I have seen before to be clear (not that I know why,
> and don't really care regarding this email).
>
> The rest of it though I have not seen before today (at least haven't
> noticed before today) and my question is simple. Is this anything worth
> mentioning or not? It does not happen on subsequent starts, only on the
> first start after install (in parallel).
>
> Thanks
> Drew
>
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] Question on odd output on first start of lastest Libo 6.2 daily build

[Drew Jensen]

Howdy,

Downloaded the latest 6.2 daily build for 64bit Linux, installed under
Ubuntu 18.04 (w/gnome default desktop) and on first start got some output
to stdout which I'd need before:

from here---
Using PPAPI flash.
 --ppapi-flash-path=/usr/lib/adobe-flashplugin/libpepflashplayer.so
--ppapi-flash-version=

(chromium-browser:31324): Gtk-WARNING **: 10:55:46.641: Theme parsing
error: gtk-main.css:73:38: Failed to import: Error opening file
/usr/share/themes/Radiance/gtk-3.20/apps/gnome-builder.css: No such file or
directory
[31371:31371:0617/105546.812092:ERROR:sandbox_linux.cc(379)]
InitializeSandbox() called with multiple threads in process gpu-process.
[31324:31358:0617/105546.891093:ERROR:in_progress_cache_impl.cc(93)] Could
not read download entries from file because there was a read failure.
drew@drews-4banger:~/Desktop/libreofficedev6.2/program$
[1:25:0617/111359.255751:ERROR:adm_helpers.cc(73)] Failed to query stereo
recording.
[1:18:0617/111845.783069:ERROR:adm_helpers.cc(73)] Failed to query stereo
recording.
[1:18:0617/112109.932063:ERROR:adm_helpers.cc(73)] Failed to query stereo
recording.
[1:18:0617/112221.144984:ERROR:adm_helpers.cc(73)] Failed to query stereo
recording.
[1:18:0617/113901.949051:ERROR:adm_helpers.cc(73)] Failed to query stereo
recording.
[31371:31371:0617/115136.120713:ERROR:gles2_cmd_decoder.cc(18288)]
[.DisplayCompositor-0x55759949e740]GL ERROR :GL_INVALID_OPERATION :
glCreateAndConsumeTextureCHROMIUM: invalid mailbox name
[31371:31371:0617/115136.120851:ERROR:gles2_cmd_decoder.cc(10129)]
[.DisplayCompositor-0x55759949e740]RENDER WARNING: texture bound to texture
unit 0 is not renderable. It maybe non-power-of-2 and have incompatible
texture filtering.
[31371:31371:0617/115136.120942:ERROR:gles2_cmd_decoder.cc(18288)]
[.DisplayCompositor-0x55759949e740]GL ERROR :GL_INVALID_OPERATION :
glCreateAndConsumeTextureCHROMIUM: invalid mailbox name
[31371:31371:0617/115136.121034:ERROR:gles2_cmd_decoder.cc(10129)]
[.DisplayCompositor-0x55759949e740]RENDER WARNING: texture bound to texture
unit 0 is not renderable. It maybe non-power-of-2 and have incompatible
texture filtering.
Gtk-Message: 13:10:37.082: GtkDialog mapped without a transient parent.
This is discouraged.
[1:18:0617/134603.977586:ERROR:adm_helpers.cc(73)] Failed to query stereo
recording.

 to here ---

So, the ppapi line I have seen before to be clear (not that I know why, and
don't really care regarding this email).

The rest of it though I have not seen before today (at least haven't
noticed before today) and my question is simple. Is this anything worth
mentioning or not? It does not happen on subsequent starts, only on the
first start after install (in parallel).

Thanks
Drew
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] How it went with one of the files used in last weeks bug hunting session

[Drew Jensen]

to be clear, on my typo there in the 3rd frm last line;

I could NOT be happier with how that went.

On Sat, Jun 2, 2018 at 9:43 PM Drew Jensen 
wrote:

> Howdy Tamás, list;
>
> Last weekend during the 6.1 bug hunting session I prattled on, over on the
> QA irc channel, about running the base migration assistant against an odb
> file holding ~318 thousand records in an embedded hsql database.
>
> Thought I'd post a recap here, with an added bit from today.
>
> Before running the migration assistant;
> Ran SHUTDOWN COMPACT against the original hsql odb which then had a 32.8
> Meg disc image.
>
> - pass one started
> At the 4 hr and 30 minute mark I stopped the soffice process because I had
> an idea.
>
> Did the following;
> Dropped all indexes on all tables, recalling this schema is a reporting
> dataset generated from a larger transaction set so lots of indexing on a
> smaller number of tables.
>
> With all indexes gone and cleaned up the disc image was down to 18.5 Megs.
>
> Started
> - pass two
> Can't say exactly how long it took, as it was late and after seeing this
> change; during the first run the soffice process was writing data to disc
> at a steady ~500K Bi/s,
> during the second, without the indexs, the throuput went to ~1.2M Bi/s;
> I went to bed.
>
> In the morning and the migration complete the disc image was now 24.8 Megs
>
> Picked that migrated file up again today adding back all, exact, indexing
> and then jettisoned the old hsql files from the ODB.
>
> Final disc image, 6.4 Megs.
>
> BTW, the schema was advantageous in that it holds predominantly numeric
> data, all character data in varchar or char fields, no blob data at all. It
> included two text table definitions, which it dealt with properly by
> ignoring them. And a view which, unfortunately, referenced one of those -
> but the error again didn't stop the data load.
>
> Could be happier with the results here.
>
> My take away, how did I forget to check the indexing? (i'm getting
> forgetful in my golden years..;)
>
> Best wishes,
>
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] How it went with one of the files used in last weeks bug hunting session

[Drew Jensen]

Howdy Tamás, list;

Last weekend during the 6.1 bug hunting session I prattled on, over on the
QA irc channel, about running the base migration assistant against an odb
file holding ~318 thousand records in an embedded hsql database.

Thought I'd post a recap here, with an added bit from today.

Before running the migration assistant;
Ran SHUTDOWN COMPACT against the original hsql odb which then had a 32.8
Meg disc image.

- pass one started
At the 4 hr and 30 minute mark I stopped the soffice process because I had
an idea.

Did the following;
Dropped all indexes on all tables, recalling this schema is a reporting
dataset generated from a larger transaction set so lots of indexing on a
smaller number of tables.

With all indexes gone and cleaned up the disc image was down to 18.5 Megs.

Started
- pass two
Can't say exactly how long it took, as it was late and after seeing this
change; during the first run the soffice process was writing data to disc
at a steady ~500K Bi/s,
during the second, without the indexs, the throuput went to ~1.2M Bi/s;
I went to bed.

In the morning and the migration complete the disc image was now 24.8 Megs

Picked that migrated file up again today adding back all, exact, indexing
and then jettisoned the old hsql files from the ODB.

Final disc image, 6.4 Megs.

BTW, the schema was advantageous in that it holds predominantly numeric
data, all character data in varchar or char fields, no blob data at all. It
included two text table definitions, which it dealt with properly by
ignoring them. And a view which, unfortunately, referenced one of those -
but the error again didn't stop the data load.

Could be happier with the results here.

My take away, how did I forget to check the indexing? (i'm getting
forgetful in my golden years..;)

Best wishes,
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: HSQL to Firebird auto migration firebird data types

[Drew Jensen]

On Mon, May 7, 2018 at 4:25 AM Tamas Bunth <tamas.bu...@collabora.co.uk>
wrote:

> Hi,
>
> On Mon, May 07, 2018 at 03:24:49AM +, Drew Jensen wrote:
> > Looking at the open issues for the HSQL to Firebird auto migration
> > functionality particular the issues regarding data types and other test
> > files I put together a possible map of what I think makes sense in
> > translating hsql to firebird types.  [Read only view of it here
> > https://nextcloud.documentfoundation.org/s/TTBT4fJ2xTdbMJQ ]
> >
> > I'm sharing it here for two purposes, first it would be a big help to
> have
> > this type of thing with whatever the actual mapping is - so - if that is
> > already set I could really use for someone to let me know what would need
> > to change there.
>
> - Image type has a special subtype, so it can be distinguished from a
> normal
>   BLOB later: BLOB SUB_TYPE -9546
>
> - Binary [VARBINARY] is mapped to VARCHAR with a special character set
>   "OCTETS".
>
> - Binary(fix) is mapped to CHAR with character set "OCTETS".
>


> ok - updated my map and will do the same for wiki page
>


> > The are three suggested changes;
> > first is to treat OTHER[OTHER] as a custom subt_type (-1) of blob instead
> > of a CLOB as this would give the same behavior in Base with firebird as
> > with hsql
>
> IIRC I didn't implement any mapping from type OTHER. It just skips the
> column
> currently. I skipped it because I couldn't find any test files in Bugzilla
> for
> OTHER column types, so I assumed nobody uses it. :)
>
> It would make sense to map it to BLOB or to VARCHAR with character set
> octets
> though.
>

Well, I ran a test file through with a field of type OTHER and what I got
was a column of the same name and type of CLOB. I did NOT run any actual
data through, just the column however.

All the single data type tests I ran are found on the tdf nextcloud also. A
link for that is https://nextcloud.documentfoundation.org/s/W92TGtQpprximdB
(The are in the directory SingleFieldType)

The idea is to end up with a collection of test files that pass through the
migration function without error and with expected results. As the simpler
tests pass I start adding a bit more (so first it was just column
definitions then I added data) and as the project moves from stage to stage
(Alpha, Beta, RC, ... Release) I will go back and run the whole batch to
ensure no regressions.


> > second is to treat HSQL Binary(fix)[BINARY] as Binary[BINARY]  with
> > sub_type of 0 or 1 based on a scan of some number of the records checking
> > for text data
>
> I think if the user wanted to store textual data then he would have
> created a
> CHAR / VARCHAR column at the first place.
>
> Besides that, the user can change the character set from OCTETS to UTF8
> later
> (with a direct sql). After that the column would act like a normal
> CHAR/VARCHAR
> in the database.
>
> Thanks,
> Tamás
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

HSQL to Firebird auto migration firebird data types

[Drew Jensen]

Hi,

Looking at the open issues for the HSQL to Firebird auto migration
functionality particular the issues regarding data types and other test
files I put together a possible map of what I think makes sense in
translating hsql to firebird types.  [Read only view of it here
https://nextcloud.documentfoundation.org/s/TTBT4fJ2xTdbMJQ ]

I'm sharing it here for two purposes, first it would be a big help to have
this type of thing with whatever the actual mapping is - so - if that is
already set I could really use for someone to let me know what would need
to change there.

However; Secondarily and since it doesn't seem to be settled in the code at
the moment I wand to propose this mapping.

The are three suggested changes;
first is to treat OTHER[OTHER] as a custom subt_type (-1) of blob instead
of a CLOB as this would give the same behavior in Base with firebird as
with hsql

second is to treat HSQL Binary(fix)[BINARY] as Binary[BINARY]  with
sub_type of 0 or 1 based on a scan of some number of the records checking
for text data

And the third would be to display two additional labels in table editor
(Memo[Blob] and OTHER[BLOB]) for consistency with the current UI using hsql.

Either way it's good see the work going on and I'm excited to help as I can.

Best wishes,
Drew
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: API-CHANGE - dropping string properties which use vnd.sun.star.GraphicObject URL

[Drew Jensen]

Howdy,

Not at all sure this was from anything your work did, but to give you a
heads up;

Working with the latest daily build (may 4th) under Ubuntu 18.10 (64bit).

Entered an issue today
https://bugs.documentfoundation.org/show_bug.cgi?id=117435

The issue includes two test ODB files, almost identical. Single table, form
with image control, report (RB) with image control and 3 test images.

File one stores the images in the embedded database. File two stores a URL
to external image files.

File one (Image binary in table) works as expected under 6.1 for both the
form and report. However It fails to display any image data after migration
to a Firebird data engine.

File two (URL in table)  works as expected before and after the migration
to Firebird.

So, as I said thought I would just let you know.

Best wishes, Drew


On Sat, Apr 28, 2018 at 8:01 PM, Tomaž Vajngerl <qui...@gmail.com> wrote:

> Hi,
>
> On Sat, Apr 28, 2018 at 10:34 AM, Drew Jensen
> <drewjensen.in...@gmail.com> wrote:
> > Howdy list,
> >
> > Reading over this, and sorry if this is a naive question, but I was
> > wondering if this could effect the way image controls work in forms and
> > reports.
> >
> > When an imagecontrol on a form (or Report Builder report) is linked to a
> > character field in a data table the control reads a URL from the data
> field
> > and loads the image into the control as the user moves through the table
> or
> > as a report is generated.
> >
> > For a Form, the user can also insert a graphic into the control via the
> GUI
> > and table column with the URL.
> >
> > Like I say I don't have enough detail knowledge of how this works, under
> the
> > hood, to know if what is changing here could be an issue or not, so
> thought
> > I would ask.
> >
> > Thank you for your time in advance.
>
> Yes, it does effect the image controls but just in the way that you
> can't use the internal URL with the scheme
> vnd.sun.star.GraphicObject:. In that case you will need to load
> the image first with XGraphicProvider and set the "Graphic" property
> instead of the "ImageURL" property.
>
> It would be good to try this use cases out with the Report Builder
> with the current master.
>
> Regards, Tomaž
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: API-CHANGE - dropping string properties which use vnd.sun.star.GraphicObject URL

[Drew Jensen]

Howdy list,

Reading over this, and sorry if this is a naive question, but I was
wondering if this could effect the way image controls work in forms and
reports.

When an imagecontrol on a form (or Report Builder report) is linked to a
character field in a data table the control reads a URL from the data field
and loads the image into the control as the user moves through the table or
as a report is generated.

For a Form, the user can also insert a graphic into the control via the GUI
and table column with the URL.

Like I say I don't have enough detail knowledge of how this works, under
the hood, to know if what is changing here could be an issue or not, so
thought I would ask.

Thank you for your time in advance.




On Fri, Apr 27, 2018 at 7:06 AM, Tomaž Vajngerl  wrote:

> Hi,
>
> I'm have the API changes pending in gerrit [1] now (they need to pass
> the build) which are due to image handling rework. All the old
> properties that used the vnd.sun.star.GraphicObject URL scheme are
> still functioning, but only to set the property and only when an
> external URLs is provided (it loads the XGraphic from the URL). When
> getting the URL a RuntimeException is thrown. I have written the new
> behavior in the property description and marked the property as
> deprecated.
>
> The following properties were changed and are now "set-only":
> - FillBitmapURL -> FillBitmap
> - GraphicURL -> GraphicBitmap
> - ImageURL -> Graphic
> - SymbolBitmapURL -> SymbolBitmap
> - GraphicURL -> Graphic
> - BackGraphicURL -> BackGraphic
> - HeaderBackGraphicURL -> HeaderBackGraphic
> - FooterBackGraphicURL -> FooterBackGraphic
> - ParaBackGraphicURL -> ParaBackGraphic
>
> The following properties were changed and are now "set-only" but not in
> API:
> - ReplacementGraphicURL -> ReplacementGraphic
>
> The following properties were not in API and are removed:
> - ThumbnailGraphicURL -> ThumbnailGraphic
> - HeaderFillBitmapURL -> HeaderFillBitmap
> - FooterFillBitmapURL -> FooterFillBitmap
>
> [1] https://gerrit.libreoffice.org/#/q/owner:quikee%
> 2540gmail.com+status:open
>
> Regards, Tomaž
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Database migration in Base

[Drew Jensen]

sorry for the second post - but I should correct something I said.
Just realized; about today's build not starting, user error! I downloaded
the wrong daily build files ;- ( 32 but vs 64 bit), looks like I need to
wait a bit longer for the 64 bit Linux build to finish.


On Fri, Apr 13, 2018 at 3:49 PM, Drew Jensen <drewjensen.in...@gmail.com>
wrote:

>
> On Thu, Apr 12, 2018 at 3:33 AM, Bunth Tamás <btom...@gmail.com> wrote:
>
>> Hi Alex,
>>
>> On 10 April 2018 at 15:04, Alexander Thurgood <alex.thurg...@gmail.com>
>> wrote:
>> > Le 10/04/2018 à 12:30, Tamas Bunth a écrit :
>> > Read through your blog posts, sounds really promising, and I am
>> > interested in testing with various hsqldb ODB files that I have accrued
>> > over time through QAtriaging of Base problems.
>>
>> Thank you for that.
>>
>
> Same here, I just finished reading all your blogs and the referenced TDF
> pages; thanks for all that.
>
> Also took some to time to read over a number of the bugzilla items on the
> work, along with the most recent ESC notes on the ML.
> You've been busy ;-)
>
>>
>> > Is there any particular setup required to test, other than building from
>> > master ?
>> >
>> > Are any startup parameters required ?
>>
>> I build with --enable-firebird-sdbc flag, but I belive that it enabled
>> by default. So no, that's all.
>>
>> I noted in one of the blogs this line:
> "The migration can be enabled using DBACCESS_HSQL_MIGRATION=1 when starting
> LibreOffice."
>
> So, I grabbed another copy of the daily build (13-apr-2018), little
> problem with it (it won't start - but it's a daily build and I'll grab the
> again tomorrow)
> I'm hoping that with this that option to migrate will be there and, if so
> I'll, will put to use for testing gong forward.
>
> Thanks again,
>
> Drew
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Database migration in Base

[Drew Jensen]

On Thu, Apr 12, 2018 at 3:33 AM, Bunth Tamás <btom...@gmail.com> wrote:

> Hi Alex,
>
> On 10 April 2018 at 15:04, Alexander Thurgood <alex.thurg...@gmail.com>
> wrote:
> > Le 10/04/2018 à 12:30, Tamas Bunth a écrit :
> > Read through your blog posts, sounds really promising, and I am
> > interested in testing with various hsqldb ODB files that I have accrued
> > over time through QAtriaging of Base problems.
>
> Thank you for that.
>

Same here, I just finished reading all your blogs and the referenced TDF
pages; thanks for all that.

Also took some to time to read over a number of the bugzilla items on the
work, along with the most recent ESC notes on the ML.
You've been busy ;-)

>
> > Is there any particular setup required to test, other than building from
> > master ?
> >
> > Are any startup parameters required ?
>
> I build with --enable-firebird-sdbc flag, but I belive that it enabled
> by default. So no, that's all.
>
> I noted in one of the blogs this line:
"The migration can be enabled using DBACCESS_HSQL_MIGRATION=1 when starting
LibreOffice."

So, I grabbed another copy of the daily build (13-apr-2018), little problem
with it (it won't start - but it's a daily build and I'll grab the again
tomorrow)
I'm hoping that with this that option to migrate will be there and, if so
I'll, will put to use for testing gong forward.

Thanks again,

Drew
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Database migration in Base

[Drew Jensen]

Cool.

Grabbed the 6.1alpha daily build just now and there it is as the default.

Also grabbed a 6.04 and then the 5.whatever it is that comes out of the
Ubuntu repo so I could create fresh hsql embed to open in 6.1.
There are a bunch of older odb files on my computer which could feed some
tests (some of them are too old to worry about I think)

It's a been a long while since I did anything here but I'll put some time
into testing and send feedback on the list and bug tracker. I doubt I'll
build from since I am comfortable grabbing daily builds on a regular and
frequent basis.

Thanks for you efforts.

On Tue, Apr 10, 2018 at 6:30 AM, Tamas Bunth 
wrote:

> Hi,
>
> I recently finished the majority of HSQLDB database migration inside Base
> documents. You can test it with opening an old .odb file which contains
> embedded
> HSQL database.
>
> As part of this project I also:
>
> - removed "experimental" marker from Firebird.
>
> - removed the ability to create embedded HSQLDB documents from wizard. Now
>   embedded Firebird is the default choice.
>
> - Erased the hsqldb code entirely:
> https://gerrit.libreoffice.org/#/c/52611/
>
> I would like to ask you to CC me to any upcoming problems related to the
> migration or dbaccess. I'll try to do my best to make Base a reliable and
> useful
> part of LibreOffice.
>
> tldr:
> https://wastack.wordpress.com/2018/04/07/final-steps-of-
> libreoffice-database-migration/
>
> Thank you,
> Tamás Bunth
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Base: Slow search in form

[drew]

On Tue, 2012-04-24 at 13:51 +0100, Mark Stanton wrote:
  We have seen that if you do a search over a form in base, the speed of 
  the search in the form goes very slow in the second search once you have 
  reached the last register of the table.
  
  We have a Base with HSQL.
 
 
 Hi Egon,
 
 Just to be clear, do you have a link to an external HSQLDB database?

Wouldn't matter it is still slow. (Though it has improved of late)

Egon - you really want to use filters where you can versus searches.

For the most part anything you can do with a search you can do with
'filter by form' or the standard filter.

Granted though, there are some cases where search is just the only thing
you can do, but not that often really.

//drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: where can I load windows DLL file

[drew]

On Fri, 2012-03-23 at 11:09 +0200, Tor Lillqvist wrote:
  I don't open DLL files, I invoke DLL's function. for example, when LO open a
  .txt file, my program(DLL function) handle something first and then let's LO
  process continue.
Hi

That is a fairly common request - if you would move it to
ask.libreoffice.org site, likely a better place for user questions, you
should receive help pretty rapidly.

Thanks

//drew
 
 OK. Then you need to look into customization of LO using some
 extension and modification of the configuration so that what you say
 happens. I have no idea how to do that, let's hope somebody else
 follows up. You probably have a bit too optimistic view of how easy it
 is going to be... be warned that you will have to read into quite a
 lot of documentation, do a lot of experimentation, etc.
 
 Can you tell *why* you want to do this, by the way? What is the
 high-level goal? We might be ableto tell you better ways to achieve
 the same end result. Or, in case there is some reason for your users
 to want to avoid your code being called when they open a document,
 tell you how easy it will be for users to circumvent your attempts...
 
 --tml
 ___
 LibreOffice mailing list
 LibreOffice@lists.freedesktop.org
 http://lists.freedesktop.org/mailman/listinfo/libreoffice
 


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: where can I load windows DLL file

[drew]

On Fri, 2012-03-23 at 11:51 +0100, Michael Stahl wrote:
 On 23/03/12 09:28, huqitu du wrote:
  I don't open DLL files, I invoke DLL's function. for example, when LO
  open a .txt file, my program(DLL function) handle something first and
  then let's LO process continue.
 
 perhaps the GlobalEventBroadcaster can help you, its OnNew and
 OnLoad events look interesting but i don't know when exactly they are
 sent, see:
 
 http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/OfficeDev/Document_Events

Yes those are fine, but it depends on whether you want this to happen
for all documents or only specific documents. 

The user will need to declare the functions before they can be called -
but this gets into which scripting language they prefer to use. Basic is
sufficient for this, but some of course raise their noses to that.

Anyway, this is a common, if not particularly frequent request, one not
yet asked and answered on the libreoffice resource. 

//drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [libreoffice-website] Re: Promoting RCs on Facebook

[drew jensen]

On Fri, 2012-03-16 at 15:34 +0100, Volker Merschmann wrote:
 Hi Cor,
 
 2012/3/16 Cor Nouws oo...@nouenoff.nl:
  Volker Merschmann wrote (07-03-12 13:59)
  In the meantime I have found the names of the maintainers: Gerard
  Jensen, Don Crowley, Nikola Yanev
  I do not know any of them and they are not linked from the FB-page.
 
  Can anybody help?
 
 
  Don't know them either. But am willing to post a polite message, if in the
  mean time (we're only 9 days later ;-) ) not someone else took action on
  this.
 
 As there is no possiblity to write to the page owners I commented on
 https://www.facebook.com/libreoffice.org/posts/364685130219760 with
 some hints, but nobody of them replied.
 
 I think we have to wait for the next pre-release and see how they will act.

Well, at least the general public can post to their page - more then can
be said for some.


 
 
 Volker
 
 
 
 -- 
 Volker Merschmann
 Member of The Document Foundation
 http://www.documentfoundation.org
 


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Hosting LibreOffice online

[drew]

On Fri, 2012-02-17 at 17:54 +0100, Sophie Gautier wrote:
 Hi Drew,
 On 16/02/2012 06:50, drew wrote:
 [...]
 
  Just to wrap this thread up, I suppose.
 
  Well, after adding --enable-gtk3 it works.
 
  Had some issues related to the firewall, but got around that - turned it
  off (not likely a good long term solution :-)
 
  WebSocket support was (is) an issue.
  - Win7 and Vista with ie9: Fail
  - HP Mini 110, Mi (Linux) w/ FireFox [latest updates applied]: Fail
 
  All the other browsers I tried (FF under Natty, Chromium, Opera): Pass
 
  @Andor - if you just want to play with this, I could point you to a VM
  with everything pre-installed - I'd need a day or 2 to put it together I
  suppose, just let me know.
 
 I'm also interested in trying to play with it. But no hurry - I just 
 have some DVD labels to localize ;-) so when 
 yLiger__LOoL3.i686-0.0.9.vmx.tar.gz

 ou'll be ready, could you 
 ping me too, please? Thanks in advance.
 
 Kind regards
Hi Sophie

Well - the foundation is, A Foundation..good news yes!

And here is the link to a VM pre-enstalled (mostly :-? )
The sustudio profile page is:
http://susestudio.com/a/NfE1GU/lippity-lopity-loly_lazing-liger-lool-3

You know if I could maybe see to change the port number in the next
build one could actually demo this using the testdrive feature at
susestudio.

So, the VM there is just the installation files are the 3.6 (master)
build out from my machine (I'm sure they could be smaller) with the JeOS
(Just enough Operating System) template, and not much (not enough it
seems) more.

I put a copy of the download file here also (fo anyone not wanting to
register an account at suseStudio):
http://lo-portal.us/SBS/download/Liger__LOoL3.i686-0.0.9.vmx.tar.gz
MD5: 78de314bc29101f1e70674b27c39cf11

So it is pretty straight forward
Download the compressed file
un-pack to a directory of your choice
it will create a dir with that silly name
lippity-lopity-loly_lazying-liger-lool-3
by default
create your entry in your vm manager of choice (VBox, KVM, Quem)
Start the vm and get to a command prompt (logon as tux, password linux)
you can start LibO in listening mode with the shell script
~/liber.sh

Best wishes,

//drew




___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Hosting LibreOffice online

[drew]

On Fri, 2012-02-17 at 17:54 +0100, Sophie Gautier wrote:
 Hi Drew,
 On 16/02/2012 06:50, drew wrote:
 [...]
 
  Just to wrap this thread up, I suppose.
 
  Well, after adding --enable-gtk3 it works.
 
  Had some issues related to the firewall, but got around that - turned it
  off (not likely a good long term solution :-)
 
  WebSocket support was (is) an issue.
  - Win7 and Vista with ie9: Fail
  - HP Mini 110, Mi (Linux) w/ FireFox [latest updates applied]: Fail
 
  All the other browsers I tried (FF under Natty, Chromium, Opera): Pass
 
  @Andor - if you just want to play with this, I could point you to a VM
  with everything pre-installed - I'd need a day or 2 to put it together I
  suppose, just let me know.
 
 I'm also interested in trying to play with it. But no hurry - I just 
 have some DVD labels to localize ;-) so when you'll be ready, could you 
 ping me too, please? Thanks in advance.

Howdy Sophie

Excellent - will do that.

//drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Hosting LibreOffice online

[drew]

On Mon, 2012-02-13 at 12:24 +, Michael Meeks wrote:
 On Mon, 2012-02-13 at 11:43 +0100, Andor E wrote:
  https://wiki.documentfoundation.org/Using_LibreOffice_in_a_Web_Browser
  
  As promised I have created a first version of the Wiki page. I hope it
  is not too awful.
 
   Thanks for that ! :-) I tweaked it a bit, it'd be nice to link Drew's
 image in if he's happy with that I guess.

Howdy guys,


Great - Lookng at the wiki page, looks good, so I'm getting a bit more
confidence about having something worth pointing to and will add to the
page as soon as I do.

Where am I at in that: put together a couple of machine images.
Basically think a fat one with development tools and a svelte for a
deployment platform.

Managed to get the build to run w/out any type of error on the first of
those today, finally (took a few attempts). 

Built against master v 3.5
Noticed that talk about using system libs over building then, seemed
like this was the perfect use for such, and did so for every case I
found listed.


Fired LOoL up..and nothing 
- doesn't quit with an error
- doesn't respond to a request from the client either.

:-( checking...failed to include --enable-gtk3 .. ooops
..and it's off running make once again.

so - I'll let you know what's up a little later it seems..


Best wishes,

//drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Hosting LibreOffice online

[drew]

On Wed, 2012-02-15 at 16:10 -0500, drew wrote:
 On Mon, 2012-02-13 at 12:24 +, Michael Meeks wrote:
  On Mon, 2012-02-13 at 11:43 +0100, Andor E wrote:
   https://wiki.documentfoundation.org/Using_LibreOffice_in_a_Web_Browser
   
   As promised I have created a first version of the Wiki page. I hope it
   is not too awful.
  
  Thanks for that ! :-) I tweaked it a bit, it'd be nice to link Drew's
  image in if he's happy with that I guess.
 
 Howdy guys,
 
 
 Great - Lookng at the wiki page, looks good, so I'm getting a bit more
 confidence about having something worth pointing to and will add to the
 page as soon as I do.
 
 Where am I at in that: put together a couple of machine images.
 Basically think a fat one with development tools and a svelte for a
 deployment platform.
 
 Managed to get the build to run w/out any type of error on the first of
 those today, finally (took a few attempts). 
 
 Built against master v 3.5
 Noticed that talk about using system libs over building then, seemed
 like this was the perfect use for such, and did so for every case I
 found listed.
 
 
 Fired LOoL up..and nothing 
 - doesn't quit with an error
 - doesn't respond to a request from the client either.
 
 :-( checking...failed to include --enable-gtk3 .. ooops
 ..and it's off running make once again.
 
 so - I'll let you know what's up a little later it seems..

Just to wrap this thread up, I suppose.

Well, after adding --enable-gtk3 it works.

Had some issues related to the firewall, but got around that - turned it
off (not likely a good long term solution :-)

WebSocket support was (is) an issue.
- Win7 and Vista with ie9: Fail
- HP Mini 110, Mi (Linux) w/ FireFox [latest updates applied]: Fail

All the other browsers I tried (FF under Natty, Chromium, Opera): Pass

@Andor - if you just want to play with this, I could point you to a VM
with everything pre-installed - I'd need a day or 2 to put it together I
suppose, just let me know.

That's it for now,

//drew






___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Hosting LibreOffice online

[drew]

On Thu, 2012-02-09 at 20:23 +, Michael Meeks wrote:
 On Thu, 2012-02-09 at 12:56 -0500, drew wrote:
  Hope you don't mind.
 
   Of course not ! :-)
 
  Added Micheal's repo to SuseStudio.
 
   Neat.
 
  From within an OpenSUSE 12.1 (32bit) vm project, go to the Software tab,
  click on Add repository and enter the name: mm-gtk3
 
   I hope it'll get out there as a 12.1 update shortly and the problem
 will go away.
 
  That adds the repo to your project, then you can add individual packages
  as needed, as usual.
  
  ok, could of come up with a better name, I suppose ;)
 
   :-) didn't you have a nice database test / VM image that had a master
 build environment ? or at least all the dependencies for that ? I guess
 it'd be good to link that from Andor's wiki page as/when he has it
 working - and there's nothing like having a LibreOffice window, in a
 browser window, inside a virtual-machine window, inside another
 (test-drive) browser I suspect ;-)

I did use the service to generate a number of VM's, yes - not sure it
really made sense for just a straight build system, for most people, as
oo one downloaded it other then me :) have used the service to make
others though with pre-built stuff, and some even get played with from
time to time.

But I did want to make one just for the LOOL purpose.
so here it is http://susestudio.com/a/NfE1GU/lool-test

A basic lamp server(Apache, postgres, no gui) included the C++, Java and
Python development patterns from the SuseSTUDIO service, added the other
LibO dependencies as needed (well, not libGL for the moment), didn't
include a source code tarball (could I suppose)

Anyway - installed it here, under virtualbox, and it's been chugging
along for awhile on the first build - what I'd like to do is to, after
the build, put a version up with everything pre-installed, pull it down
and have it just start out of the box (no build required)..but later on
that I suppose.

@Andor I don't know if any of this would interest you, if so that would
be great I'd love to hear from you.

Thanks,

//drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Hosting LibreOffice online

[drew]

On Thu, 2012-02-09 at 16:38 +, Michael Meeks wrote:
 Hi Andor,
 
 On Thu, 2012-02-09 at 16:05 +0100, Andor E wrote:
  I have read recently that LibreOffice 3.5 will support an online mode.
 
   Correct :-) at least - this is a prototype feature, and it needs a
 chunk of work to productise it, but you can certainly play with it.
 
  I'm aware that this is still experimental, but I'd like to give it a
  test anyway, since we are highly interested in such a feature.
 
   Great :-)
 
   I was unable to find any documentation how to host LibreOffice.
  Could someone give me some pointers, where I have to start?
 
   So - I spent some time writing this out below. Do you think you can
 create a wiki page and dump the details in there in a prettier format by
 any chance ? [ that would help others with the same question ], and mail
 the link back :-)
 
   So - firstly, it requires a Linux server; and then it requires a very
 recent version (git master) of gtk3, or failing that, I back-ported the
 required fixes for openSUSE 12.1 here:
 
 http://download.opensuse.org/repositories/home:/michael_meeks:/branches:/openSUSE:/12.1:/Update/standard/i586/
 from
 https://build.opensuse.org/project/show?project=home%3Amichael_meeks%3Abranches%3AopenSUSE%3A12.1%3AUpdate

Howdy,

Hope you don't mind.

Added Micheal's repo to SuseStudio.

From within an OpenSUSE 12.1 (32bit) vm project, go to the Software tab,
click on Add repository and enter the name: mm-gtk3

That adds the repo to your project, then you can add individual packages
as needed, as usual.

ok, could of come up with a better name, I suppose ;)

//drew

snip

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] Handling confidential bug report supporting documents

[drew]

On Sun, 2012-02-05 at 18:35 -0500, drew wrote:
 Hi,
 
 Noticed on slashdot today that someone was complaining about LibreOffice
 not being willing to deal with their bug report because they had a
 document
[edit] with confidential information [/edit]

  showing the defect (I looked at the issue and suspect it may
 actually be a duplicate BTW) and according to this individual he was
 told that there was no way for TDF/LibreOffice QA to handle such a
 document. 
 
 I've been around the block enough times not to take this at face value
 necessarily, but I was wondering about it - I thought there had been
 some work done, procedure wise and even ML wise just for this type of
 situation.
 
 Anyway - I thought about responding to the person on slashdot but
 thought it best to touch base here first.
 
 Thanks much,
 
 //drew


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice] [PUSHED] Re: [PATCH] optimized zoom to use more common intervals

[drew]

On Thu, 2012-01-26 at 08:21 +0100, Jan Holesovsky wrote:
 Hi Cor,
 
 On 2012-01-26 at 00:16 +0100, Cor Nouws wrote:
 
   Also I changed the ZOOM_FACTOR from 1.1 to 2^(1/4), it feels better
   here, the 1.1 means way too much wheel rotation to increase / decrease
   the zoom considerably; but of course can be changed easily when another
   [..]
  
   I also thought that 1.2 was a better fit so fine with me.
  
  Hmm, the issue was that the zoom factor also is used for the + and - in 
  the zoom slider at the status bar. Jumping from 100 to 125% or so, is 
  way to fast. Of course just IMHO ..
  
  What do others think ?
 
 In my experience, I was never really using the +/-, because the +-5%
 step always made me clicking like mad to achieve what I needed, and in
 most cases I just fell back to using the slider directly (dragging the
 indicator); so I believe increasing the step for the +/- is the right
 thing to do here too - but maybe it is just me :-)
 

Howdy Kendy

Well, I'm with Cor on this one - I use that a fair bit also and the
finer step is usually what I am looking for.

However as you say there are times it's a real pain and with the slider
it's rather had to get precise control.
 
Instead of increasing the step amount by five fold I would rather see
the +/- auto-repeat if you hold the mouse button down. Not sure how that
would fair with keyboard bound users though.

Best wishes,

//drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] [PATCH] rpath / ... for extensions (and the case of PostgreSQL-SDBC)

[drew]

On Mon, 2012-01-23 at 15:28 +0100, Lionel Elie Mamane wrote:
 On Mon, Jan 23, 2012 at 02:20:31PM +0100, Stephan Bergmann wrote:
  On 01/23/2012 01:45 PM, Lionel Elie Mamane wrote:
 
  Users loose the feature to use a newer PostgreSQL-SDBC with an
  older LibreOffice. But Fridrich and you agree it fixes all our
  issues, so OK, I consent to it. I'm happy to let you and/or
  Fridrich do the change.
 
  Doing it.  Lionel, do you have a recipe for database-dummies how to
  actually test the postgresql-sdbc functionality?
 
 To really test it, you need a PostgreSQL server. However, you can do a
 very limited, but still meaningful, test without it:
 
  - Menu: File / New / Database
 
  - Connect to an existing database: PostgreSQL
 
  - Next
 
  - Datasource URL: host=localhost
 
  - Next
 
  - User name: blank
 
  - Test connection - the error message should be along the lines of:
 
Couldn't establish database connection to 'sdbc:postgresql:host=localhost'
could not connect to server: Connection refused
is the server running on host localhost (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
is the server running on host localhost (127.0.0.1) and accepting
TCP/IP connections on port 5432?
 
If you get any other error message (such as no driver registered
for URL), then there is something wrong with PostgreSQL-SDBC or
LibreOffice more generally. I you get the error message only with
127.0.0.1 and not with ::1, that's fine and not a problem.
 
  - OK to click error message away
 
  - next
 
  - no, do not register the database
 
  - uncheck open the database for editing
 
  - finish
 
  - choose a filename to save file to
 
  - save
 
  - close libreoffice
 
  - open libreoffice again, open file you just created
 
  - in the left part of the main screen, click tables
 
You should get the same error message as above with test
connection. If not, it is a problem.
 
 
 
 As to installing a PostgreSQL server, rather easy on Debian GNU/Linux
 and probably most other distros. Make sure you get version 8.4 or
 later.
 
 aptitude install postgresql
 sudo -u postgres createdb -O $USER name_you_choose $USER's test DB
 psql --db name_you_choose
 CREATE TABLE names ( num serial, name varchar(30) NOT NULL, PRIMARY KEY 
 (num) );
 # It says:
 # NOTICE:  CREATE TABLE will create implicit sequence names_num_seq for 
 serial column names.num
 # NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index names_pkey 
 for table names
 # CREATE TABLE
 INSERT INTO names (name) VALUES ('Alice'), ('Bob'), ('Eve'), ('Mallory');
 INSERT INTO names (num, name) VALUES (0, 'Nominem incognitum');
 \q
 #back to the shell
 
 Now, do as above in LibreOffice, except put:
 
 Datasource URL: host=localhost dbname=name_you_choose
 User name: Your UNIX username
 Do *not* check needs password.
 
 You'll see in tables the names table. You can double-click on it and
 modify data, insert new data, delete row, etc.
 


There is a rather extensive test(s) that I've been building 

I put the very first nugget of it to the wiki a while back
http://wiki.documentfoundation.org/User:Drew/BaseRegTest001
have not kept the wiki up to date, but I have extended it quite a bit,
locally. 

Worked over the bug hunting weekend on it a goodly bit, nearly done with
Query designer tests, including the latest join problems.

These are not scriptable tests..but if I can get a daily build with the
update I'll do it all against pg and push the tests and results up to
the wiki ASAP.

//drew 




___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] [Libreoffice-qa] [libreoffice-projects] [ANN] LibreOffice 3.4.4 RC2 available

[drew]

On Wed, 2011-11-02 at 17:24 +0100, Heinz W. Simoneit wrote:
 Hi Thorsten,  *,
 
 Thorsten Behrens schrieb:
  Hi *,
 
  for 3.4.4 rc2, we're now uploading builds to a public (but
  non-mirrored
 [...]
  The list of fixed bugs in this release is here:
 
  http://dev-builds.libreoffice.org/pre-releases/src/bugfixes-libreoffice-3-4-4-release-3.4.4.2.log
 
  So playing with the areas touched there also greatly appreciated - and
  validation that those bugs are really fixed.
 
 tried basics in  (de-)
 - writer
 - calc
 - base  (MySQL-DB)
 without any probs.
 
 One minor  flaw in base:
 When opening a table by double-click  it doesn't stay opened  --  you 
 have to right-click and open.

Running Ubuntu 10.10 (AMD64), Gnome - no problem opening a table with
dbl-click? (only checked for embedded DB and SQLite w/ODBC)

 
 Best,
 Heinz
 


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] [libreoffice-projects] [ANN] LibreOffice 3.4.4 RC2 available

[drew]

On Wed, 2011-11-02 at 17:24 +0100, Heinz W. Simoneit wrote:
 Hi Thorsten,  *,
 
 Thorsten Behrens schrieb:
  Hi *,
 
  for 3.4.4 rc2, we're now uploading builds to a public (but
  non-mirrored
 [...]
  The list of fixed bugs in this release is here:
 
  http://dev-builds.libreoffice.org/pre-releases/src/bugfixes-libreoffice-3-4-4-release-3.4.4.2.log
 
  So playing with the areas touched there also greatly appreciated - and
  validation that those bugs are really fixed.
 
 tried basics in  (de-)
 - writer
 - calc
 - base  (MySQL-DB)
 without any probs.
 
 One minor  flaw in base:
 When opening a table by double-click  it doesn't stay opened  --  you 
 have to right-click and open.

Running Ubuntu 10.10 (AMD64), Gnome - no problem opening a table with
dbl-click? (only checked for embedded DB and SQLite w/ODBC)

 
 Best,
 Heinz
 


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] db test VM

[drew]

On Wed, 2011-10-19 at 20:39 +0200, Petr Mladek wrote:
 Bernhard M. Wiedemann píše v St 19. 10. 2011 v 16:04 +0200:
  during package install I got
  /opt/lo-dev/program/unopkg.bin: error while loading shared libraries:
  libpng12.so.0: cannot open shared object file: No such file or directory
 
 It is related to https://bugs.freedesktop.org/show_bug.cgi?id=36497#c2
 We need to disable the splash also in the daily build. I am going to
 investigate it.
 
  which I worked around with a
  sudo zypper -n in libpng12-0
 
 This is a good workaround. 
 
  Then some configs or dirs were needed which I got by pulling the
  losmoketest-0.2.tar.bz2 that I found by googling.
 
 I am sorry. I should have told you about it. This was described in
 http://cgit.freedesktop.org/libreoffice/core/tree/smoketestoo_native/losmoketest.readme
 It is still work in progress. We are going to package this stuff and
 make it more convenient to use.
 
  and then, everything runs.
  Though 22 seconds total time for test is surprisingly quick.
 
 It is just a basic test. For example, it checks that all applications,
 calc, writer, impress, can be started.
 
  if you want to test:
  curl http://openqa.opensuse.org/opensuse/qatests/qa_office.sh|sh
 
 Great work! Please, find attached slightly updated version. There are
 two changes:
 
   + use mktemp instead of the hardcoded temp dir name
   + use --headless option to do the test even without working
   X11; heh, you might want to remove it, if you have running
   X11 session in the openQA framework
 
 I hope that it helps.
 
 I am very interested how the DB testing will work in the end.
 
 

Howdy all,

Well, thought I'd let folks know what I've been up to with the
SuseSTUDIO service...errr stuff. 

Creating a VM with the daily build files turned out to be really
straightforward.

-  OK, so it's not automated for daily updates, but doing so by hand now
is really quite simple and fairly quick (3 clicks and ~10 minutes), and
not that big a deal for what I personally had in mind.

Here is the latest configuration setup:
http://susegallery.com/a/EvUJ20/lo-client-daily-libreoffice_master

That VM image includes yesterdays (10-23-2011) build from Master,
located at /opt/lo-dev

Currently there is no menu integration (should be there tomorrow :)

Anyway - I'll update the wiki page with more details this afternoon.

//drew


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] automated testing of Base

[drew]

On Wed, 2011-10-05 at 22:27 -0400, Terrence Enger wrote:
 On Wed, 2011-10-05 at 11:00 +0100, Michael Meeks wrote:
  
  Ho hum ;-) is there an ODBC driver that sqlite provides that we could
  use (in conjunction with a SQLite backend (currently there is none)) to
  make a fast/light unit test for base ? it would be fantastic to have
  anything in this space at all really ...
 
 FWIW, on ubuntu-natty, I installed some packages; I think
 the relevant ones are sqlite3 and libsqliteodbc.
 LibreOffice, both Ubuntu package 1:3.3.3-1ubuntu2 and local
 build of commit id 0e1de41, is happy to work with an ODBC
 connection.

Hello Terry.

well, kind of - there is a number of features that do not work with ODBC
- so I'm just curious what the reason for using SQLite and ODBC would be
for a test bed?

Thanks

//drew

___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice] All Sun/Oracle code upgraded to LGPLv3?

[drew]

On Thu, 2011-08-11 at 10:15 +0200, Thorsten Behrens wrote:
 Lionel Elie Mamane wrote:
  [Postgresql connector]
 
  And the libreoffice pre-commit hooks complain about that. I was
  wondering if by any chance there is a general authorisation by Sun /
  Oracle that relicenses *all* OpenOffice-related code to LGPLv3 that
  would apply _also_ to this code?
  
 Hi Lionel,
 
 I'm afraid there is not. Unless there's any newer version of that
 file somewhere officially released, the best course of action is to
 ask on the ooo-...@incubator.apache.org list, to have all files you
 need for this added to the Oracle source code grant to Apache
 (Andrew Rist is the one managing that on the Oracle side).

If you like I can follow up on that, both hit the apache list and maybe
it's worth a quick email to the original contributor, if that makes
sense.

//drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] All Sun/Oracle code upgraded to LGPLv3?

[drew]

On Thu, 2011-08-11 at 18:14 +0200, Alexander Thurgood wrote:
 Le 11/08/11 16:05, Eike Rathke a écrit :
 
 Hi Eike,
 
  The current state of affairs from what I know is that the list of files
  prepared contains all files of OOO340 plus all new files in all of the
  pending CWSs. Whether all of the files really will end up at AOOo is yet
  to be seen. But I'm fairly confident that if at all there would be very
  rare exceptions.
 
 When I attempted to find the code in question a couple of months ago to
 look at it myself and see whether I could even get it to compile and
 build the extension it was not unfortunately at all in the 340 tree.

Hi Alex,

I'm not sure it ever was - you get the binary from the main OO.o webstie
and not the extensions site (that never changed did it?)

http://dba.openoffice.org/drivers/postgresql/index.html

the only source I knew off was at
http://dba.openoffice.org/drivers/postgresql/postgresql.zip

and the authors email address is
joergb...@gmx.de

so like I said, maybe you can address this with an email to Joerg?

//drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice] [Hackfest] Ohio Linux Fest

[drew]

On Thu, 2011-06-23 at 15:36 -0400, drew wrote:
 Just a quick note.
 
 Have sent off the formal request to the OHLF organizers..will keep folks
 posted as specifics firm up.
 

Hi,

Quick note.

Exchanged a few emails with one of the other organizers of the show.

No final yes - but looks good.

One slight change is looking likely - moving this from Friday the 9th to
Saturday the 10th. 

I think that would be a plus.

//drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] Hackfest - September 9th, Ohio Linux Fest

[drew]

Just a quick note.

Have sent off the formal request to the OHLF organizers..will keep folks
posted as specifics firm up.

Thanks,

drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice] Did you hear the news? LibreOffice is going to have a conference

[drew]

Greetings my hacker friends.

Well I know you all heard about this thing called the LibreOffice
Conference taking place in Paris France this year.

Conferences tend to work better if people present at the them.

The first step in presenting at a conference is usually to submit a
paper proposal.

*smile*...

OK - all kidding aside - the call for papers is open, you know that so
I'm just here to...hmm...nudge you all a little bit.. I know it is a
PITA to stop and put together a proposal but a necessary one IMO.

Thanks

Drew Jensen

ps - the number of nuisance reminders will be in an inverse relationship
to the number of proposals received..hint, hint.



___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] Hackfest - September 9th, Ohio Linux Fest

[drew]

On Sat, 2011-06-18 at 02:27 -0500, Norbert Thiebaud wrote:
 big snip

 
  Please let me know of any virtual attendance or way to work in parallel 
  that
  you devise.
 
  Thanks for the offer and I'll do my best to find a way to take you up on it 
  - shouldn't be all that hard to devise, if nothing else just knowing that 
  there would be people hanging out on IRC at the right time would help I 
  think.
 
 That would be much more workable for me than a 2000 miles road trip :-)
 

Hi Folks,

Alright then - I've sent an email to the contact at OHLF to get the ball
rolling. 

Does it make sense, I think it does, to include one of you as CC on the
planning emails gong forward? If so let me know who.

//drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] Hackfest - September 9th, Ohio Linux Fest

[drew]

On Wed, 2011-06-15 at 16:13 -0400, drew wrote:
 Howdy,
 
 Had a chance to speak with one of the organizers for the Ohio Linux fest
 (Columbus, Ohio, USA) regarding the possibility of holding a LibreOffice
 hackfest/QA session.
 
 They are quite interested and motivated to help us do this.
 
 The date would be Friday September 9th, this day is mostly used at this
 event for hand-on training and certification testing. 
 
 As this point the show organizers are waiting to here from us regarding
 our interest in putting this together.
 
 Before pursuing this with them and either waisting everyones time or
 setting up one big FAIL I would like to see if there is interest from
 other community members, particularly developers, willing to help.
 
 Let me know - sooner is much better then later on this.
 

Hello Again,

Well, I suppose there is something that I need to say to you folks - and
I am talking directly the developer crew.

I put my name on the apache project earlier commiter list - yes I did.
If you want to know why feel free to ask me on list.

But folks I'm a fairly simple guy, I don't do 'circles in circles, or
have hidden agendas. The idea for this project pre-dates anything to do
with Apache, it is about and for LibreOffice, period - full stop.

The idea is to help expand the base of people contributing to our
project - period.

I can not do it however without active support from you, the developers
- there are some things I can help with but actually helping make sense
of the code isn't one of them, not in this time frame.

Right now there is a window of opportunity with the organizers a OLF and
the organizers of SELF have said they will be watching with a
possibility of doing this next year in South Carolina. Today I received
word that the organizers of NWLF (North West Linux Fest) will also be
watching and interest in this type of event also. In other words there
is a reasonable chance to turn this into something that can get legs and
maybe do it every 2 months across the USA next year.

So - if you need to punish me for my putting my name on that list at the
other place, that is your prerogative but please reconsider and at least
talk to me about things before you make judgments.

Thanks and best wishes,

Drew Jensen
Proud member of the Document Foundation



___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] Hackfest - September 9th, Ohio Linux Fest

[drew]

On Fri, 2011-06-17 at 13:48 -0500, Norbert Thiebaud wrote:
 On Fri, Jun 17, 2011 at 11:19 AM, drew d...@baseanswers.com wrote:
  On Wed, 2011-06-15 at 16:13 -0400, drew wrote:
 
  So - if you need to punish me for my putting my name on that list at the
  other place, that is your prerogative but please reconsider and at least
  talk to me about things before you make judgments.
 
 Did I miss something ?
 
 Yes, I saw you name on the Apache commiter list...
 No, I did not draw any conclusion other than you are interested in
 that endeavor... which is fine... It your free time and yours to
 allocate according to your fancy.
 No, I have no intention to 'punish' you for that, nor that notion even
 crossed my mind or was in anyway a factor in my responses.

Hi Norbert,


 Hence my conclusion: I must have missed some part of the conversation
 at some point :-(

Then you have my apology. 

I'll just chalk the silence here up to really poor timing.

As for the actual event - I suppose I'll go ahead and pull the trigger
on trying to setup the logistics with the OLF folks and just keep my
fingers crossed as for developer support - and hit the books for my
part, so to speak.

Thanks once again for a quick reply and best wishes,

//drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] Hackfest - September 9th, Ohio Linux Fest

[drew]

On Fri, 2011-06-17 at 14:31 -0700, John LeMoyne Castle wrote: 
 Drew, 
 I appreciate your position and your moderate, thoughtful questions and
 responses all across the several boards I have seen them on.  I am still
 attracted to Apache and their OO project, but I finally balked on the
 proposal so clearly NOT written by a community or its representatives.  
 My late and non-binding vote --
 http://www.mail-archive.com/general@incubator.apache.org/msg29462.html

Hi John,

Honestly I was optimistic also but...

I'm rather sorry about the whole 'punish me' line in my earlier email -
but a couple of days after I put my name on the ASF wiki someone in
India went to my facebook wall and started a survey titled 'Drew should
be kiled' yes/no. I blew it off with a joke response and FB was kind
enough to remove the survey entry - followed by a few emails over the
next couple of days with suggestions ranging from taking a long walk of
a short pier to one request to perform an act which quite frankly I
don't think is physically possible. Anyway, I should not of let the
fringe element color my interaction here.

 
 Back to the subject of this thread, 

+1

 I am interested in participating in a
 HackFest and maybe even more interested if it has a QA focus. Distributed
 devlopment is tough, distributed QA needs definition and a lot of eyes on
 it.  Sadly, I do not see a way to attend.  From the mountain west, Ohio is
 only one order of magnitude closer than Europe and my car croaked last year.  
 
 Please let me know of any virtual attendance or way to work in parallel that
 you devise.  

Thanks for the offer and I'll do my best to find a way to take you up on it - 
shouldn't be all that hard to devise, if nothing else just knowing that there 
would be people hanging out on IRC at the right time would help I think.

 
 A distributed hackfest may pique more interest by the later LFs as well. 
 

Best wishes,

Drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice] Hackfest - September 9th, Ohio Linux Fest

[drew]

Howdy,

Had a chance to speak with one of the organizers for the Ohio Linux fest
(Columbus, Ohio, USA) regarding the possibility of holding a LibreOffice
hackfest/QA session.

They are quite interested and motivated to help us do this.

The date would be Friday September 9th, this day is mostly used at this
event for hand-on training and certification testing. 

As this point the show organizers are waiting to here from us regarding
our interest in putting this together.

Before pursuing this with them and either waisting everyones time or
setting up one big FAIL I would like to see if there is interest from
other community members, particularly developers, willing to help.

Let me know - sooner is much better then later on this.

Thanks very much,

Drew Jensen

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice] Interested in organizing a North America hackfest

[drew]

Howdy Devs one and all,

A bunch of talk about a Hackfest coming up in Munich lately.

Today on the discuss list someone (Robert Derman) suggested that this
would be a great thing to put together in the North America area.

One need would be development talent.

The next would be a place - on the first I can't really help much, but
on the second I might be able to. The thought that came to mind was the
Ohio Linux Fest (Columbus Ohio) in September. I won't bore you with
details, but I think if we moved quickly we could get the resources
needed for such an event.

So - if you are in the US or Canada and would be interested in working
on putting this together, please speak up.

Thanks much,

Drew Jensen

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] Does OO/LO have an API?

[drew]

On Mon, 2011-02-07 at 12:49 +0100, Thorsten Behrens wrote:
 Kevin Hunter wrote:
  After about 20 minutes of Googling, and random grepping through the
  code base, I'm having no luck.  Does such a beast exist?
  
 At least I'm not aware of any - thing is, higher-level functionality
 in LibO currently ~always assumes a running installation, mainloop,
 uno etc. - at least reducing that is one of the things being worked
 on, since it also makes unit testing a lot easier.
 
 Cheers,
 
Hi Thorsten

http://wiki.services.openoffice.org/wiki/API

This is not an API - it seems to fit the definition I was taught?

I'm not saying your wrong, just do not understand your answer here. Is
there something about Libo that is changing all this or is it just that
right now there is no API work on new features found only in LibO?

I have to admit that I've not installed a LibO SDK, something I did
always under OO.o, is there a big change?

Thanks for your patience on this,

Drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice] Consulting services required

[drew]

Howdy,

There are two Linux festivals in the month of March in the USA, one
established, in Washington state{1] and the other a first time event in
the state of Indiana[2]. In both cases the organizers would like to have
a presentation about TDF/LibreOffice and in both cases it appears there
is a person willing to stand and deliver same - so just a quick heads
up, will be looking for some input in creating this (these)
presentation, to get your input on what you (the developers) would like
highlighted.

Apologies for the rather late notice.

Thanks for the your time,

Drew

[1] http://linuxfestnorthwest.org/
[2] http://www.indianalinux.org/



___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] Consulting services required

[drew]

On Fri, 2011-02-04 at 10:14 -0500, drew wrote:
 Howdy,
 
 There are two Linux festivals in 
one in March and one in April (for accuracy :-/ )

  in the USA, one
 established, in Washington state{1] and the other a first time event in
 the state of Indiana[2]. In both cases the organizers would like to have
 a presentation about TDF/LibreOffice and in both cases it appears there
 is a person willing to stand and deliver same - so just a quick heads
 up, will be looking for some input in creating this (these)
 presentation, to get your input on what you (the developers) would like
 highlighted.
 
 Apologies for the rather late notice.
 
 Thanks for the your time,
 
 Drew
 
 [1] http://linuxfestnorthwest.org/
 [2] http://www.indianalinux.org/
 
 
 


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice] (OT) Windows shared package manager, CoAPP ready for 1st binary release

[drew]

Hi,

Thought some might find this interesting.

The CoApp project [1] is scheduled to release first CLI binary for folks
to play with tomorrow. In a nutshell this is a community developed
shared package manager for MS Windows under an apache license, lead by a
MS engineer in the MS OSS center in Redmond, with many non-MS devs
involved.

For a quick overview, a teaser video[2], if you just want the elevator
pitch :-)

Not 100% certain, but I believe this early version will support
non-CoApp specific MSI installation packages also, not sure to what
extent however. The native windows GUI is yet to be wrapped up but it
will more or less just run the CLI tool, IIRC.

Anyway - as I said, perhaps someone here might be interested.

Your are doing great work on Libo guys,

Drew

[1] https://launchpad.net/coapp
[2] http://www.youtube.com/watch?v=OOavxGRSt-k



___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] Error in en_us readme file ?

[drew]

On Tue, 2011-02-01 at 18:46 +0100, Andras Timar wrote:
 
 
 2011/2/1 Caolán McNamara caol...@redhat.com
 On Sun, 2011-01-30 at 16:38 -0500, drew wrote:
 
  Updated readme file attached.
 
 Do you think you could make a patch against the original
 README content,
 i.e. readlicense_oo/docs/readme/readme.xrm ?
 
 
 Here you go, please approve.
 
 Cheers,

Hola Andras

Thanks - I didn't move quick enough..


Drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice] Error in en_us readme file ?

[drew]

Hi,

Received a message from a user today regarding the install instructions
within the en_US readme file covering Mandriva:

'Doing commands like su urpmi *.rpm won't work; it either has to be
sudo urpmi *.rpm or su -c urpmi *.rpm'

I have never used Mandriva so don't know and thought I'd ask before just
opening a bug report for him.

Thanks

Drew



___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] Error in en_us readme file ?

[drew]

On Sun, 2011-01-30 at 16:38 -0500, drew wrote:
 On Sun, 2011-01-30 at 20:40 +0100, Andras Timar wrote:

 
 Updated readme file attached.

Well, sorry for the static noise on that - in pulling files together for
a distribution disc (as it seemed to be the day for everyone to do that)
I see now that it is not so easy as just attaching the text file here. 
- Will get it routed to the right place, just as soon as I figure out
who/where that is :-/

drew


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] LO 3.3 release. Why there no PR or celebration?

[drew]

On Tue, 2011-01-25 at 15:35 +, Michael Meeks wrote:
 Hi Nadav,
 
 On Tue, 2011-01-25 at 16:37 +0200, Nadav Vinik wrote:
  I saw that LO 3.3 released:
  http://www.libreoffice.org/download
  
  As the first stable version of LO, why there aren't any PR?
 
   No PR ? :-)
 
  even the home page don't mention it.

Howdy,

Well the user/enthusiast base (perhaps that is the term) sure hit it
big. Just before the announcements (blog, announce list, first press
coverage) the LibreOffice twitter stream was running at it's normal
baseline of ~20 posts per hour - that stream peaked about 2 hours ago at
687 posts per hour - currently running in the low 400's with a bevy of
on-line publications posting release announcement stories within the
last hours. (and when I say bevy I mean bevy - found a 2 paragraph
announcement at the Omaha Nebraska paper's website..Omaha Nebraska?..OK
it wasn't quite as prominent as the daily farm report but one has to
consider the local, which makes it fairly impressive actually)



 
   Are you certain ? ;-) read again - I guess perhaps the blog entry is
 not so prominent at the bottom ... perhaps we could have a more
 happy/clappy type front-page for the first day.
 
   Then again - this is the 1st time most people will hit that page I
 suspect. Perhaps for our next release, we will have an orange and green
 blink-tag saying New ;-)

Really - well if that is what you want...*chuckle*

Drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice] Question about changing the URL for extensions and templates

[drew]

Hi,

I was wondering - and yes I am being lazy - does anyone know off the top
of their head if it is possible to change which URL is used when the
user clicks on the get more templates and add new features.. buttons
on the start center and from the extension manager, short of a
recompile?

Are those URLs stored in a configuration file that can then simply be
updated?

Thanks

Drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] Question about changing the URL for extensions and templates

[drew]

On Sun, 2011-01-23 at 09:03 -0500, drew wrote:
 Hi,
 

 Are those URLs stored in a configuration file that can then simply be
 updated?
 

Ok - found it:

main.xcd - extensions and templates
brand.xcd - dictionaries


In case anyone wonders why (doubtful..*smile*).

Looking at a few school districts that are currently using OO.o I have
found that some of them have opted to run their own sites for acceptable
extensions / clipart / templates. I have heard also of a firm in Japan
that is doing the same for extensions and templates.

This gave me an idea to possibly create a distribution, not of just the
office suite but of a small business server (SBS), targeted to document
production use and expecting LibreOffice on the client machines. One of
the ideas I had was to make it possible for the SBS to offer the option
of supporting these internal repositories, right out of the box more or
less, and in these cases a simple way to have the LibO clients in the
organization point to these internal repos.

Anyway - off for more fund and games with the SUSEStudio tool..

drew







___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] Bug to confirm: 32427

[drew]

On Wed, 2010-12-15 at 23:23 +0100, Andrés Domínguez wrote:
 2010/12/15 Jan Holesovsky ke...@suse.cz:
  Hi,
 
  https://bugs.freedesktop.org/show_bug.cgi?id=32427
 
  Can anybody confirm this, please?  If yes, I'd nominate it as a blocker;
  hopefully easy to fix :-)
 
 It works great for me. Firefox is Iceweasel 3.5.15 from debian testing.
 LibO is master.
 

Hola,

Ubutnu 10.10 and FF 3.6.13 - works as expected here.

Drew

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice] [Base] Unable to open form (design, control) toolbar - form navigator opens w/out buttons XCfe only

[drew]

On Thu, 2010-12-09 at 20:45 -0500, drew wrote:
 On Thu, 2010-12-09 at 19:34 -0500, drew wrote:
  Using a build of OpenSUSE 11.3, XCfe and LibreOffice RC1 the problems
  show up. 
 
 oops - little mix-up there..the actual test machine is:
 OpenSUSE 11.3, iceWM, LibO RC1 
 

Used SUSEStudio build service to construct a second set of files:
OpenSUSE 11.3, Gnome and LibreOffice RC1

Same exact problem as yesterdays build - These three toolbars
malfunction, ONLY, at design time with a Base embedded form.

Now otherwise everything I've tried works - but this is a minimal OS
that is being build with SUSEStudio and when I say it is just the OS,
Gnome and LibrOOffice that is it, given that I can't reproduce this on
any of my regular distro based desktops I'll hold off one more day on
opening an issue - but remember another person reported the exact error
ton their system, so it is something.

Thanks

Drew




___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice