[libreoffice-documentation] Re: Drew

[Drew Jensen]

Thank you for your kind words.


I also know he would want you to change his settings and dactivate
necessary things.

Joyce


On Tue, Oct 5, 2021, 12:04 PM Drew Jensen 
wrote:

> I am searching Drew's email.
>
> I am joyce Drew's girl.
> I am writing to let you know,  that Drew passed away after a week in the
> hospital, he passed away from a rare occurance after a Cardiac
> Catherization . He had major brain bleeds.
>
> I am sure he would want you to know.
>
> Joyce.
>
> joyce.demonbrun#gmail.com
> 11923 Messuck RD SE
> Cumberland, Md 21502
>
> 240-727-3011
>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Re: [libreoffice-projects] Documentation Team Meeting Minutes, Thursday July 16th 2020

[Drew Jensen]

Howdy Sam,

The edits are much appreciated there is one problem - the mailing
list, here, does not support attachments and so it was lost.

For the moment, given that I haven't done anything with what Olivier
posted yet, the easiest way would be for you to send the attachment
again but this time to my direct email address. I'll use the changes
for the starting point.

Thanks

Drew

On Fri, Jul 17, 2020 at 9:07 AM Samantha Hamilton
 wrote:
>
> Good morning,
>
> Attached is a copy of the presentation with some copyediting queries.
> Nothing major, just grammatical points and parallel structuring. The
> presentation had a great flow.
>
> (Also - I hope "commenting" on a copy of the presentation was an okay way
> to provide feedback; if there's an alternative way for the future, please
> let me know!)
>
> Cheers,
> Sam
>
>   Samantha Hamilton
>   darling docs
>
>    
> 
>
>
> On Thu, Jul 16, 2020 at 10:43 PM Olivier Hallot <
> olivier.hal...@libreoffice.org> wrote:
>
> > Hello Team
> >
> > Em 16/07/2020 16:16, Olivier Hallot escreveu:
> > > + Introductory Presentation on TDF Doc Team for Toronto, CA LibreOffice
> > > group - Aug 5th - virtual. Request is that presentation cover team
> > > overview and specifically how new contributors should on-board into the
> > > team. (Drew - Request for presentation from Marc Pare)
> > > AI:+ Will send a presentation to Drew (Olivier)
> >
> > Done, with no fancy template, please fix my English errors and add any
> > additional pertinent contents
> >
> > https://nextcloud.documentfoundation.org/s/Wz67FsGASioPnyp
> >
> > regards
> > --
> > Olivier Hallot
> > LibreOffice Documentation Coordinator
> > Comunidade LibreOffice
> > Rio de Janeiro - Brasil - Local Time: UTC-03:00
> > http://tdf.io/joinus
> >
> > --
> > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> > Problems?
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/documentation/
> > Privacy Policy: https://www.documentfoundation.org/privacy
> >
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Guides' Titles

[Drew Jensen]

Howdy,

The decision on a tag line for the TDF released binary (i.e. Personal
Edition or Community Edition or none) is ongoing so changing anything
presently would be premature.

Otherwise, I have seen no one from the documentation team weigh in on
the extensive conversation happening on the other MLs - you are all
part of the community and you have the option to give your feedback
there.

Drew

On Fri, Jul 10, 2020 at 4:50 AM Martin Srebotnjak  wrote:
>
> Well, that is the decision of the enterprise edition developers, not the
> community, whether they will have a link in menus for community version
> documentation or not.
>
> Since they are corporations, these are their business decisions. They can
> link to community guides, they can append community guides with their
> premium features descriptions and rebrand and republish, whichever they
> decide.
>
> Lp, m.
>
> V V pet., 10. jul. 2020 ob 09:54 je oseba Pulkit Krishna <
> pulkitkrishn...@gmail.com> napisala:
>
> > Yes, That is what I want to say - It sounds strange. Also, as I stated in
> > my previous email,  the help menu in the enterprise edition has a User
> > Guides option which opens the documentation website. The enterprise edition
> > do not have separate documentation. It has to be decided whether we write
> > documentation for only the personal/community edition or both and then name
> > the guide accordingly. Also, If we go with the second option then we will
> > have to do something about the Personal/Community edition tag as the
> > enterprise edition will not contain them.
> > Pulkit Krishna
> >
> >
> > On Fri, Jul 10, 2020 at 12:22 PM Martin Srebotnjak 
> > wrote:
> >
> >> Well, from LO70 there is no product named LibreOffice anymore, just two
> >> differently named products/modules, like LO Base Community and LO Base
> >> Professional... Or whatever they will be called... So Base Community Guide?
> >> It does sound strange.
> >> Lp, m.
> >>
> >> V pet., 10. jul. 2020 08:07 je oseba Pulkit Krishna <
> >> pulkitkrishn...@gmail.com> napisala:
> >>
> >>> Also, currently, we do not name our books like Getting Started with
> >>> Base. It is Base Guide. Getting Started with Base is a chapter in the
> >>> Getting Started Guide.
> >>> Pulkit Krishna
> >>>
> >>>
> >>> On Fri, Jul 10, 2020 at 11:34 AM Pulkit Krishna <
> >>> pulkitkrishn...@gmail.com> wrote:
> >>>
>  I think it will convey a completely different meaning - "Getting
>  Started with LibreOffice Community". It will sound as if it is a guide to
>  the LibreOffice community. Also, AFAIK the help menu in the enterprise
>  edition has a User Guides option which opens the documentation website. 
>  The
>  enterprise edition do not have separate documentation. It has to be 
>  decided
>  whether we write documentation for only the personal/community edition or
>  both and then name the guide accordingly. Also, If we go with the second
>  option then we will have to do something about the Personal/Community
>  edition tag as the enterprise edition will not contain them.
>  Pulkit Krishna
> 
> 
>  On Fri, Jul 10, 2020 at 3:14 AM Martin Srebotnjak 
>  wrote:
> 
> > Hi,
> >
> > on Windows I see that the title of modules is in LO7RC1 also appended
> > (with
> > "Personal", just like the suite itself, where "Personal Edition" is
> > appended), so open document in Writer has "NameOfTheDocument.odt -
> > LibreOffice Personal Writer) stated in the title bar.
> >
> > Of course, the "Personal" / "Personal Edition" sub-labeling is still an
> > open issue with the board/community and it seems that the naming
> > convention
> > for these "community", unsupported editions is leading to the brand
> > "Community Edition", but the community documentation team needs to
> > properly
> > name the suite/modules that the community guides refer to.
> >
> > So I guess LO7 community Guides (for "Personal"/ "Personal Edition" or
> > "Community" / "Community Edition" sub-labeling, which ever will be
> > adopted)
> > would be therefore renamed to "Getting Started with LibreOffice
> > Personal/Community Edition", "Getting Started with LibreOffice Writer
> > Personal/Community", "Getting Started with LibreOffice
> > Personal/Community
> > Online" etc.?
> >
> > Lp, m.
> >
> > --
> > To unsubscribe e-mail to:
> > documentation+unsubscr...@global.libreoffice.org
> > Problems?
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more:
> > https://wiki.documentfoundation.org/Netiquette
> > List archive:
> > https://listarchives.libreoffice.org/global/documentation/
> > Privacy Policy: https://www.documentfoundation.org/privacy
> >
> 
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> 

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Howdy,

OK - good feedback from everyone. quick status update - Saturday night
the desktop I work on decided to die - troubleshooting done and parts
on order for delivery tomorrow. On borrowed laptop with Windows for
the time being. Will be on the call this week but might not have much
new by then.

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Importing PostScript files

[Drew Jensen]

well, I've not tried it but postscript does support table structures
so I don't see why not.
It would be worth the time to find an example file and try I suppose.
Doing a quick search finds a couple of candidates,not sure if any have
a table,at the Univ of VA website - I'll give it a try and get back to
you.

Drew

On Sun, Jun 28, 2020 at 12:38 PM Steve (GMail)
 wrote:
>
> All,
>
> At the start of the Calc Guide (first page of Preface chapter) is a list
> of some features that Calc provides.
>
> One of these is the "import of spreadsheets from multiple formats,
> including .. PostScript".
>
> I know that Draw can import EPS files as drawings but can Calc really
> import spreadsheets from EPS files?
>
> Regards,
>
> Steve
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

I know - I said last time, last time...but almost forgot to make the
A4 sized, for PDF, pages match the new look
Also, the idea of a QR code - so I updated both the wrap around print
cover with a QR code and the A4 also
The odg files for both the wrap (print) and A4 (pdf) are up in the
cover7 folder or just to look at them a pdf here
https://nextcloud.documentfoundation.org/s/FtJW3Ce8DQ4REL7
and that is it, for real, for this ;-) till after the next meeting.

On Fri, Jun 26, 2020 at 9:36 PM Drew Jensen  wrote:
>
> Howdy,
>
> Just uploaded another png file from a second pass on layout of a print
> wrap cover, choose Writer this time.
> This time ripped all of the text out of the svg file, except the Logo
> text, and moved it to the ODG file.
> Used a single font for all text; Liberation Sans Narrow
> Two text colors (except the logo, of course) LibreOffice Blue_0 and White.
> Exported the Logo out separately, after a scale without losing the
> proper ratio and added that back in inside the ODG file also.
> So, there is still a bit of distortion on the background graphic but
> none at all for any of the text rendering.
> Worked a bit harder of making the spine background matchup with the
> back cover, and adding a bit of adornment.
> Exported it out as a full 13.25 x what ever it was ;-), 300 dpi print
> ready file - which you can find here
> https://nextcloud.documentfoundation.org/s/tNZYEN2tCNmZrSW
>
> I'm thinking there is time to do one more before the next team
> meeting, so if anyone wants to propose something different (fonts or
> font effects, ???) I'm open to giving it a try. Otherwise this is
> probably it between now and then.
>
> Drew
>
> On Wed, Jun 24, 2020 at 3:55 PM Drew Jensen  
> wrote:
> >
> > Sorry for two posts.
> >
> > One thing worth mentioning - if we go with adding text to the graphics
> > background in LibreOffice instead of the graphics editor the advantage
> > for the PDF release is that the cover text is available to screen
> > readers - it is not when the text is buried in the graphics
> > background, and the ability to add non-distorted text on the printer
> > ready cover.
> >
> >
> >
> > On Wed, Jun 24, 2020 at 3:50 PM Drew Jensen  
> > wrote:
> > >
> > > Howdy Jean,
> > >
> > > Excellent.
> > >
> > > So with that in mind I took a second pass on the covers, with the Base
> > > Guide pages for an example.
> > > For this pass I left the A4 front cover page unchanged.
> > > For the A4 back cover page I stripped all the text out of the SVG
> > > file, flipped the logo and wave graphic at the footer to form a mirror
> > > image layout of the front cover.
> > > This makes the two logos form what looks a bit like a label spanning the 
> > > spine.
> > > Added a shaded background graphic to the middle portion of the spine,
> > > and a solid color block to carry the wave at the footer across the
> > > spine.
> > > So the graphics background is scaled to fit the new page size. In the
> > > ODG file added the text back to the back cover and adjusted font size
> > > and line spacing so all the text fits without encroaching into the
> > > ISBN block.
> > > Here is how that came out (just a rough draft)
> > > https://nextcloud.documentfoundation.org/s/Jrjnq4eeSFPo3zW
> > >
> > > On Mon, Jun 22, 2020 at 10:05 PM Jean Weber  wrote:
> > > >
> > > > I have put in NextCloud (Contributor Resources > Cover7 folder) a
> > > > template (ODG) for 6x9-inch books printed at Lulu. Link below. This
> > > > template shows the bleed and trim areas for the covers. (The width of
> > > > the spine varies, of course, with the number of pages in the book.)
> > > >
> > > > Ideally, in addition to producing covers for the PDF version of the
> > > > books, someone would produce front and back covers set to the correct
> > > > size for the print edition, with the correct proportions and the extra
> > > > margin for bleed and trim. I (or whoever) can then drop those into the
> > > > wrap-cover template and add the book name on the spine. I've been
> > > > doing this in a sloppy manner (by distorting the A4 cover) for 15
> > > > years, and will continue to do so if necessary.
> > > >
> > > > https://nextcloud.documentfoundation.org/s/HTtTreGR4XN8Y4d
> > > >
> > > > Jean
> > > >
> > > > --
> > > > To unsubscribe e-mail to: 
> > > > documentation+unsubscr...@global.libreoffice.org
>

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Howdy,

Just uploaded another png file from a second pass on layout of a print
wrap cover, choose Writer this time.
This time ripped all of the text out of the svg file, except the Logo
text, and moved it to the ODG file.
Used a single font for all text; Liberation Sans Narrow
Two text colors (except the logo, of course) LibreOffice Blue_0 and White.
Exported the Logo out separately, after a scale without losing the
proper ratio and added that back in inside the ODG file also.
So, there is still a bit of distortion on the background graphic but
none at all for any of the text rendering.
Worked a bit harder of making the spine background matchup with the
back cover, and adding a bit of adornment.
Exported it out as a full 13.25 x what ever it was ;-), 300 dpi print
ready file - which you can find here
https://nextcloud.documentfoundation.org/s/tNZYEN2tCNmZrSW

I'm thinking there is time to do one more before the next team
meeting, so if anyone wants to propose something different (fonts or
font effects, ???) I'm open to giving it a try. Otherwise this is
probably it between now and then.

Drew

On Wed, Jun 24, 2020 at 3:55 PM Drew Jensen  wrote:
>
> Sorry for two posts.
>
> One thing worth mentioning - if we go with adding text to the graphics
> background in LibreOffice instead of the graphics editor the advantage
> for the PDF release is that the cover text is available to screen
> readers - it is not when the text is buried in the graphics
> background, and the ability to add non-distorted text on the printer
> ready cover.
>
>
>
> On Wed, Jun 24, 2020 at 3:50 PM Drew Jensen  
> wrote:
> >
> > Howdy Jean,
> >
> > Excellent.
> >
> > So with that in mind I took a second pass on the covers, with the Base
> > Guide pages for an example.
> > For this pass I left the A4 front cover page unchanged.
> > For the A4 back cover page I stripped all the text out of the SVG
> > file, flipped the logo and wave graphic at the footer to form a mirror
> > image layout of the front cover.
> > This makes the two logos form what looks a bit like a label spanning the 
> > spine.
> > Added a shaded background graphic to the middle portion of the spine,
> > and a solid color block to carry the wave at the footer across the
> > spine.
> > So the graphics background is scaled to fit the new page size. In the
> > ODG file added the text back to the back cover and adjusted font size
> > and line spacing so all the text fits without encroaching into the
> > ISBN block.
> > Here is how that came out (just a rough draft)
> > https://nextcloud.documentfoundation.org/s/Jrjnq4eeSFPo3zW
> >
> > On Mon, Jun 22, 2020 at 10:05 PM Jean Weber  wrote:
> > >
> > > I have put in NextCloud (Contributor Resources > Cover7 folder) a
> > > template (ODG) for 6x9-inch books printed at Lulu. Link below. This
> > > template shows the bleed and trim areas for the covers. (The width of
> > > the spine varies, of course, with the number of pages in the book.)
> > >
> > > Ideally, in addition to producing covers for the PDF version of the
> > > books, someone would produce front and back covers set to the correct
> > > size for the print edition, with the correct proportions and the extra
> > > margin for bleed and trim. I (or whoever) can then drop those into the
> > > wrap-cover template and add the book name on the spine. I've been
> > > doing this in a sloppy manner (by distorting the A4 cover) for 15
> > > years, and will continue to do so if necessary.
> > >
> > > https://nextcloud.documentfoundation.org/s/HTtTreGR4XN8Y4d
> > >
> > > Jean
> > >
> > > --
> > > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> > > Problems? 
> > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > > List archive: https://listarchives.libreoffice.org/global/documentation/
> > > Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Writer Guide WG6419-SpreadsheetsCharts

[Drew Jensen]

Howdy,

Grabbed this chapter for a 1st review - expected return by Sunday the 28th.

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Base Guide Chapter 10 - back from review into feedback folder w/1 edit

[Drew Jensen]

Howdy,

Finished reading over Chapter 10 this afternoon. I did make one edit
to the file and that was to pretty much replace the next to last
paragraph talking about performance problems with HSQLdb and referring
to issues from version 3.5, then that those issues were fixed in 4.1
and it just seems like that should all go away for a version 6.4
release.

What I added was a general comment about performance issues and when
to look at moving from the embedded database to a server based system.

BG6410-DatabaseMaintenance_PK_JS_PK_DJ_24June2020.odt is in the feedback folder.

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Sorry for two posts.

One thing worth mentioning - if we go with adding text to the graphics
background in LibreOffice instead of the graphics editor the advantage
for the PDF release is that the cover text is available to screen
readers - it is not when the text is buried in the graphics
background, and the ability to add non-distorted text on the printer
ready cover.



On Wed, Jun 24, 2020 at 3:50 PM Drew Jensen  wrote:
>
> Howdy Jean,
>
> Excellent.
>
> So with that in mind I took a second pass on the covers, with the Base
> Guide pages for an example.
> For this pass I left the A4 front cover page unchanged.
> For the A4 back cover page I stripped all the text out of the SVG
> file, flipped the logo and wave graphic at the footer to form a mirror
> image layout of the front cover.
> This makes the two logos form what looks a bit like a label spanning the 
> spine.
> Added a shaded background graphic to the middle portion of the spine,
> and a solid color block to carry the wave at the footer across the
> spine.
> So the graphics background is scaled to fit the new page size. In the
> ODG file added the text back to the back cover and adjusted font size
> and line spacing so all the text fits without encroaching into the
> ISBN block.
> Here is how that came out (just a rough draft)
> https://nextcloud.documentfoundation.org/s/Jrjnq4eeSFPo3zW
>
> On Mon, Jun 22, 2020 at 10:05 PM Jean Weber  wrote:
> >
> > I have put in NextCloud (Contributor Resources > Cover7 folder) a
> > template (ODG) for 6x9-inch books printed at Lulu. Link below. This
> > template shows the bleed and trim areas for the covers. (The width of
> > the spine varies, of course, with the number of pages in the book.)
> >
> > Ideally, in addition to producing covers for the PDF version of the
> > books, someone would produce front and back covers set to the correct
> > size for the print edition, with the correct proportions and the extra
> > margin for bleed and trim. I (or whoever) can then drop those into the
> > wrap-cover template and add the book name on the spine. I've been
> > doing this in a sloppy manner (by distorting the A4 cover) for 15
> > years, and will continue to do so if necessary.
> >
> > https://nextcloud.documentfoundation.org/s/HTtTreGR4XN8Y4d
> >
> > Jean
> >
> > --
> > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> > Problems? 
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/documentation/
> > Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Howdy Jean,

Excellent.

So with that in mind I took a second pass on the covers, with the Base
Guide pages for an example.
For this pass I left the A4 front cover page unchanged.
For the A4 back cover page I stripped all the text out of the SVG
file, flipped the logo and wave graphic at the footer to form a mirror
image layout of the front cover.
This makes the two logos form what looks a bit like a label spanning the spine.
Added a shaded background graphic to the middle portion of the spine,
and a solid color block to carry the wave at the footer across the
spine.
So the graphics background is scaled to fit the new page size. In the
ODG file added the text back to the back cover and adjusted font size
and line spacing so all the text fits without encroaching into the
ISBN block.
Here is how that came out (just a rough draft)
https://nextcloud.documentfoundation.org/s/Jrjnq4eeSFPo3zW

On Mon, Jun 22, 2020 at 10:05 PM Jean Weber  wrote:
>
> I have put in NextCloud (Contributor Resources > Cover7 folder) a
> template (ODG) for 6x9-inch books printed at Lulu. Link below. This
> template shows the bleed and trim areas for the covers. (The width of
> the spine varies, of course, with the number of pages in the book.)
>
> Ideally, in addition to producing covers for the PDF version of the
> books, someone would produce front and back covers set to the correct
> size for the print edition, with the correct proportions and the extra
> margin for bleed and trim. I (or whoever) can then drop those into the
> wrap-cover template and add the book name on the spine. I've been
> doing this in a sloppy manner (by distorting the A4 cover) for 15
> years, and will continue to do so if necessary.
>
> https://nextcloud.documentfoundation.org/s/HTtTreGR4XN8Y4d
>
> Jean
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Re: Chapter 10 Base Guide Review Complete

[Drew Jensen]

Howdy Jenna;

Thanks for the email heads up on that.
I've downloaded the latest file. Starting the 2nd review step.

Drew

On Tue, Jun 23, 2020 at 12:18 PM Pulkit Krishna
 wrote:
>
> Great, thanks for the update. I think I missed this email.
> Pulkit Krishna
>
>
> On Fri, Jun 19, 2020 at 9:03 PM Jenna Sargent 
> wrote:
>
> > I've completed my review of Chapter 10 of the Base guide, and it is now in
> > the feedback folder for review. I'm going to get started on Chapter 8 next.
> >
> > Jenna Sargent
> >
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Base Guide Chapter 10

[Drew Jensen]

Howdy,

Grabbed Chapter 10 Maintenance for the 2nd Review - expected return, the 25th.

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Base Guide Chapter 7

[Drew Jensen]

Howdy,

Uploaded the file BG6407-Linking_in_Databases_PK_DJ_21June2020.odt to
the feedback folder with two minor issues. One fixed a typo (tracked
change added) and the other about the screenshot of the data source
toolbar. One of the toolbar buttons text changed - it is explained in
a comment.

One issue however - the last part of the chapter required use of a
third party tool pdftk to extract form data from a PDF file. The pdftk
software offers binaries for Windows and RedHat/CentOS Linux only. I
tried first to install it on my Ubuntu 18.04 machine using the alien
tool to change package format from .rpm to .deb, and this did allow a
successful install but unsuccessful execution complaining about a
missing required file - I then tried to compile it from the source and
ran into a missing dependency (it appears that matches the runtime
error), as of right now I don't have a solution for that - so I'll put
that file up today as my review, with this caveat that I couldn't
actually check if that macro works with pdftk.

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

On Mon, Jun 22, 2020 at 10:09 AM Pulkit Krishna
 wrote:
>
> I think instead of giving a link to the extension website homepage, we
> should give the link of the extension page with the documentation tag:-
> https://extensions.libreoffice.org/?Tags%5B%5D=53

That's kind of ugly for typing it in - isn't it?
Maybe we could use the TDF URL shortener to generate a more legible
URL for this purpose.
Also - maybe add a QR code graphic for, and in addition to, one of the
URLs on the back cover?

> Pulkit Krishna
> Pulkit Krishna
>
>
> On Sun, Jun 21, 2020 at 9:28 AM Drew Jensen 
> wrote:
>
> > Howdy,
> >
> > One final update for today - added the current text from the Base
> > guide back cover to the 7.0 back with a couple of changes:
> > URL for downloaded, changed from documentation page on main website to
> > extension site. Is that the correct URL?
> > Reworded the last sentence about downloading a free copy. (minor)
> > Added two paragraphs about Professional Support services to the end.
> >
> > Updated https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p
> > with that change
> >
> > Full text of Base back cover follows:
> > Base Guide
> > Managing your data
> > About this book:
> > This book is for beginners to advanced users of LibreOffice Base. If
> > you have never used Base before, or you want an introduction to all of
> > LibreOffice's components, you might like to read Getting Started with
> > LibreOffice first.
> > This book introduces you to the most common functions of LibreOffice Base:
> > Creating a database
> > Input and output of data
> > Using macros
> > Maintaining a database
> > And much more
> > About the authors:
> > This book was written by volunteers from the LibreOffice community.
> > Profits from sales of the printed edition will be used to benefit the
> > community.
> > A PDF version of this book can be downloaded free from:
> > https://extensions.libreoffice.org
> > About LibreOffice:
> > LibreOffice is the free, libre, and open source personal productivity
> > suite from The Document Foundation. It runs on Windows, macOS, and
> > GNU/Linux. Support and documentation is free from our large, dedicated
> > community of users, contributors and developers.
> > You too can get involved with volunteer work in many areas:
> > development, quality assurance, documentation, translation, user
> > support, and more.
> > You can download the free Community release of LibreOffice from:
> > https://libreoffice.org/download/
> > For commercial use: You are encouraged to work with a certified
> > LibreOffice professional for your business needs, from deployment or
> > conversion off other office suites, staff training, or custom
> > development needs.
> > You can find information on professional support services at:
> > https://www.libreoffice.org/get-help/professional-support/
> >
> > On Sat, Jun 20, 2020 at 1:33 PM Drew Jensen 
> > wrote:
> > >
> > > Howdy Robert,
> > >
> > > Would you prefer a 'blank' back cover where you add your own text or a
> > > cover with the En text for translation?
> > >
> > > On Sat, Jun 20, 2020 at 12:07 PM Robert Großkopf
> > >  wrote:
> > > >
> > > > Hi Drew,
> > > >
> > > > looks good. I would need the *.svg for changing the English content to
> > > > German. I will update the German Base-Handbuch at the end of July.
> > > >
> > > > Regards
> > > >
> > > > Robert
> > > > --
> > > > Homepage: https://www.familiegrosskopf.de/robert
> > > >
> > > >
> > > > --
> > > > To unsubscribe e-mail to:
> > documentation+unsubscr...@global.libreoffice.org
> > > > Problems?
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > > Posting guidelines + more:
> > https://wiki.documentfoundation.org/Netiquette
> > > > List archive:
> > https://listarchives.libreoffice.org/global/documentation/
> > > > Privacy Policy: https://www.documentfoundation.org/privacy
> >
> > --
> > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> > Problems?
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/documentation/
> > Privacy Policy: https://www.documentfoundation.org/privacy
>

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Howdy Jean,

On Mon, Jun 22, 2020 at 5:36 AM Jean Weber  wrote:
>
> Drew and others,

> You probably are not aware that IF anyone wants the print books to be 
> available through Amazon and other retailers, several requirements must be 
> met. These include:
> 1) The “author” (LibreOffice Documentation Team) must be given on the front 
> cover as well as the copyright page.

The 'LbreOffice Documentation Team' as part of the logo on the page
has been mentioned a few times in this thread as a requirement, yes.

> 2) Enough space must be left at the bottom on the back cover for the ISBN 
> block.
True

Also, the current 'covers' are sized for A4 and expected to be part of
a PDF file. You're right the layout didn't account for an ISBN block
per se.

Not to mention the other differences for a print job:
Page format changes (at least as I look to the books currently printed
there) to US Trade (smaller than A4)
Bleeding edges for full page graphics
Single cover file (front, spine, back)
ISBN block
etc

This is really, really, early for covers here I know  - none the less
- accounting for the printer's needs now wouldn't hurt - but it is too
soon to try and generate the actual printer cover file IMO.

I am not sure, but I believe that you have been stuck handling all
that conversion from what was good for the PDF file to what was needed
for a commercial printer, so please keep up the nudges on that.

>
> We can continue publishing print books on Lulu and selling them only through 
> the Lulu store without meeting those requirements or even having an ISBN. 
> That’s certainly easier, and means the books are cheaper (about 60% of the 
> price).
>
> Jean

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Howdy,

On Sat, Jun 20, 2020 at 11:10 AM Olivier Hallot
 wrote:
>
> HI Drew
> The covers are getting really nice and beautiful... Thank you indeed.
>
> We also need a color/cover for the Getting Started and Math Guide.
>
> In the next LibreOffice Help pages I used a gray for the common (SHARED)
> pages and a teal blue for Math.
> https://help.libreoffice.org/7.0/en-US/text/smath/main.html?DbPAR=MATH
>
> https://help.libreoffice.org/7.0/en-US/text/shared/01/profile_safe_mode.html?DbPAR=SHARED

Alright - I created the first cut for the Getting Started and Math
guide overs - now in the pdf file
https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p

Grabbed the color setting from the two help web pages you linked above.
Also - for these two I left the Version number in place on the back
cover and altered the placement of the text - so folks can see if that
is preferable.

Drew

>
> But nothing is carved in stone.
>
> On the back cover, I think we copy the 6.0 back cover contents, and use
> it in the new 7.0 back cover, adjusting releases and dates.
>
> Kind regards
> Olivier
>
>
> Em 20/06/2020 11:53, Drew Jensen escreveu:
> > Quick two updates to the draft covers on the NC server.
> >
> > For the Base guide only - swapped out the TDF logo (top of the page)
> > for the community logo with "The Documentation Team" below it, per the
> > current guides, and added a, currently, blank back cover with the same
> > theme.
> > https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p has been
> > updated with the changes, but the zip file with the svg (inkscape)
> > files has not yet.
> >
> > On Sat, Jun 20, 2020 at 9:48 AM Drew Jensen  
> > wrote:
> >>
> >> Howdy,
> >>
> >> Well, here is a link to the pdf file so you can at least see what is
> >> happening here.
> >> https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p
> >>
> >>
> >> On Sat, Jun 20, 2020 at 2:57 AM Robert Großkopf
> >>  wrote:
> >>>
> >>> Hi Drew,
> >>>>
> >>>> During the jitsi meeting yesterday Olviier showed off a couple of
> >>>> front cover options. Two of those are available in the Documentation
> >>>> Team/English/Contributor Resources/Cover7 folder on the
> >>>> NC server as .svg files.
> >>>
> >>> I'm not the expert with this links. Don't know where to search for it,
> >>> because I have edited the documents without using the structure of
> >>> LO-documentation. But I will wait a little bit. I hve seen the English
> >>> guides haven't the same cover than the German guides. So I will also ask
> >>> in the German dicussion mailinglist ...
> >>>
> >>> Regards
> >>>
> >>> Robert
> >>> --
> >>> Homepage: https://www.familiegrosskopf.de/robert
> >>>
> >>>
> >>> --
> >>> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> >>> Problems? 
> >>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> >>> List archive: https://listarchives.libreoffice.org/global/documentation/
> >>> Privacy Policy: https://www.documentfoundation.org/privacy
> >
>
> --
> Olivier Hallot
> LibreOffice Documentation Coordinator
> Comunidade LibreOffice
> Rio de Janeiro - Brasil - Local Time: UTC-03:00
> http://tdf.io/joinus
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] 6.4 Calc Guide

[Drew Jensen]

Howdy Steve,


On Sun, Jun 21, 2020 at 4:28 PM Steve (GMail)
 wrote:
>
> All,
>
> The 6.4 Calc Guide is, I believe, almost ready for publication. The PDF
> version is available for inspection in the relevant Published folder in
> Nextcloud (CG64-CalcGuide.pdf).
>
> If anybody wishes to have glance at the PDF over the next 24 hours then
> feel free to do so; please email me if you spot any problems.
>
> I am not happy with the front and back pages. These are SVG format
> images in the .ODT file but lose something in the translation to PDF. Is
> this a known effect and is there a recommended solution?

Right - if you check the PDF files from the earlier guides you find
that the covers, front and back, are 100% graphics (including the
text).
This is because the SVG source files were used to generate a PNG file
equal to the page format (A4) and that image is what is used as the
page background for the cover pages.
That is not the only way it could be done, but the SVG file itself is
not suitable for use directly in LibreOffice and you want to always
generate the graphic from that source file as a PNG for use in the
final document.

Best wishes,

Drew

>
> One aspect of the document has not yet been reviewed by anybody and that
> is the alphabetical index at the back. I would encourage any team
> members to inspect this and let us know your thoughts. I hope it is a
> useful addition for the intended readers of the guide but others might
> think otherwise. It is straightforward to remove it before publication
> if that proves necessary.
>
> Finally, please could one of our experienced publishers advise me of the
> steps necessary to actually publish a guide (beyond placing all the
> files in the Published folder)?
>
> Regards,
>
> Steve Fanning
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Hopefully that early email didn't post..

- the current svg files and the ODG file which adds text and generates
the PDF file are in the file Cover7_colors_DJ21062020.zip

On Sun, Jun 21, 2020 at 11:17 AM Drew Jensen  wrote:
>
> Howdy Pilkit, Jean
>
> A version number of the back cover? Yes - I went with one option with
> the white 7.0 upper to the right of the logo at the top of the page.
> As you can see in the pdf example of the covers that is problematic
> with the current Draw cover.
>
> Then as for a font for the Title (and what about using the sub-title
> also on the front cover?)
>
> Actually fonts in general as open for some review also. For example
> the original SVG files Olivier sent over use a Font which I do not
> have, so right from the bat it was a case of using a nearly identical
> replacement.
>
> Anyway - I've gathered the text from the most recent Writer, Calc,
> Impress, Draw, and Base guides for a place to begin.
> Again the file https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p
> is updated with all of those.
>
> What is not done for these first drafts is
> - update all the covers to use the proper logo at the top of the page
> -- in that Base cover set I just used a bitmap of that community logo,
> needing to find or make a vector drawing instead as part of that since
> I assume if the covers are used for other languages they would want to
> translate the 'The Documentation Team' line also.
> - covers for the GS and Math guides
> - fix the Version number on back cover (move or color it) given the
> problem with Draw cover
>
> Otherwise general feedback as this goes along is good.
>
> On Sun, Jun 21, 2020 at 2:51 AM jean-francois
>  wrote:
> >
> > Hi!
> >
> > Le 21/06/2020 à 05:57, Drew Jensen a écrit :
> > >
> > > One final update for today - added the current text from the Base
> > > guide back cover to the 7.0 back with a couple of changes:
> > > URL for downloaded, changed from documentation page on main website to
> > > extension site. Is that the correct URL?
> > > Reworded the last sentence about downloading a free copy. (minor)
> > > Added two paragraphs about Professional Support services to the end.
> > >
> > > Updated https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p
> > > with that change
> >
> > I find the new covers to be a very important move from the v6 ones. In
> > particular, the graphic is great and colourful.
> >
> > But as the graphic first attracts view, the eye then goes to the second
> > much contrasted item which is the version number. At that moment, the
> > brains didn't catch what it is all about: just an image and a big 7.0
> > number.
> >
> > All this to say that I find the actual guide names not to be prominent
> > enough. Sure, the font type is nice and elegant (I do love it) but
> > there's not enough contrast there.
> >
> > I'd suggest having the title "boldified" and the version number
> > "deboldified", if you see what I mean :)
> > At the same time, make the title font grey more blackish, while the
> > version number could be smaller in size (was the v6 guides defect already).
> >
> >
> > Sure, the enhancement for v.6 is a big step forward and, again, I do
> > love it. Though, the respective weights of the graphic and text items
> > should be reworked to make important things more visible (the title!).
> >
> >
> > HTH,
> > --
> > Jean-Francois Nifenecker, Bordeaux
> >
> >
> > --
> > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> > Problems? 
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/documentation/
> > Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Also - the svg files, as they are at this moment, and the ODG file
which currently adds the text for the back covers and produces the pdf
are on the NC server as file Cover7_colors_draft1_DJ18062020.zip

On Sun, Jun 21, 2020 at 11:17 AM Drew Jensen  wrote:
>
> Howdy Pilkit, Jean
>
> A version number of the back cover? Yes - I went with one option with
> the white 7.0 upper to the right of the logo at the top of the page.
> As you can see in the pdf example of the covers that is problematic
> with the current Draw cover.
>
> Then as for a font for the Title (and what about using the sub-title
> also on the front cover?)
>
> Actually fonts in general as open for some review also. For example
> the original SVG files Olivier sent over use a Font which I do not
> have, so right from the bat it was a case of using a nearly identical
> replacement.
>
> Anyway - I've gathered the text from the most recent Writer, Calc,
> Impress, Draw, and Base guides for a place to begin.
> Again the file https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p
> is updated with all of those.
>
> What is not done for these first drafts is
> - update all the covers to use the proper logo at the top of the page
> -- in that Base cover set I just used a bitmap of that community logo,
> needing to find or make a vector drawing instead as part of that since
> I assume if the covers are used for other languages they would want to
> translate the 'The Documentation Team' line also.
> - covers for the GS and Math guides
> - fix the Version number on back cover (move or color it) given the
> problem with Draw cover
>
> Otherwise general feedback as this goes along is good.
>
> On Sun, Jun 21, 2020 at 2:51 AM jean-francois
>  wrote:
> >
> > Hi!
> >
> > Le 21/06/2020 à 05:57, Drew Jensen a écrit :
> > >
> > > One final update for today - added the current text from the Base
> > > guide back cover to the 7.0 back with a couple of changes:
> > > URL for downloaded, changed from documentation page on main website to
> > > extension site. Is that the correct URL?
> > > Reworded the last sentence about downloading a free copy. (minor)
> > > Added two paragraphs about Professional Support services to the end.
> > >
> > > Updated https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p
> > > with that change
> >
> > I find the new covers to be a very important move from the v6 ones. In
> > particular, the graphic is great and colourful.
> >
> > But as the graphic first attracts view, the eye then goes to the second
> > much contrasted item which is the version number. At that moment, the
> > brains didn't catch what it is all about: just an image and a big 7.0
> > number.
> >
> > All this to say that I find the actual guide names not to be prominent
> > enough. Sure, the font type is nice and elegant (I do love it) but
> > there's not enough contrast there.
> >
> > I'd suggest having the title "boldified" and the version number
> > "deboldified", if you see what I mean :)
> > At the same time, make the title font grey more blackish, while the
> > version number could be smaller in size (was the v6 guides defect already).
> >
> >
> > Sure, the enhancement for v.6 is a big step forward and, again, I do
> > love it. Though, the respective weights of the graphic and text items
> > should be reworked to make important things more visible (the title!).
> >
> >
> > HTH,
> > --
> > Jean-Francois Nifenecker, Bordeaux
> >
> >
> > --
> > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> > Problems? 
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/documentation/
> > Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Howdy Pilkit, Jean

A version number of the back cover? Yes - I went with one option with
the white 7.0 upper to the right of the logo at the top of the page.
As you can see in the pdf example of the covers that is problematic
with the current Draw cover.

Then as for a font for the Title (and what about using the sub-title
also on the front cover?)

Actually fonts in general as open for some review also. For example
the original SVG files Olivier sent over use a Font which I do not
have, so right from the bat it was a case of using a nearly identical
replacement.

Anyway - I've gathered the text from the most recent Writer, Calc,
Impress, Draw, and Base guides for a place to begin.
Again the file https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p
is updated with all of those.

What is not done for these first drafts is
- update all the covers to use the proper logo at the top of the page
-- in that Base cover set I just used a bitmap of that community logo,
needing to find or make a vector drawing instead as part of that since
I assume if the covers are used for other languages they would want to
translate the 'The Documentation Team' line also.
- covers for the GS and Math guides
- fix the Version number on back cover (move or color it) given the
problem with Draw cover

Otherwise general feedback as this goes along is good.

On Sun, Jun 21, 2020 at 2:51 AM jean-francois
 wrote:
>
> Hi!
>
> Le 21/06/2020 à 05:57, Drew Jensen a écrit :
> >
> > One final update for today - added the current text from the Base
> > guide back cover to the 7.0 back with a couple of changes:
> > URL for downloaded, changed from documentation page on main website to
> > extension site. Is that the correct URL?
> > Reworded the last sentence about downloading a free copy. (minor)
> > Added two paragraphs about Professional Support services to the end.
> >
> > Updated https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p
> > with that change
>
> I find the new covers to be a very important move from the v6 ones. In
> particular, the graphic is great and colourful.
>
> But as the graphic first attracts view, the eye then goes to the second
> much contrasted item which is the version number. At that moment, the
> brains didn't catch what it is all about: just an image and a big 7.0
> number.
>
> All this to say that I find the actual guide names not to be prominent
> enough. Sure, the font type is nice and elegant (I do love it) but
> there's not enough contrast there.
>
> I'd suggest having the title "boldified" and the version number
> "deboldified", if you see what I mean :)
> At the same time, make the title font grey more blackish, while the
> version number could be smaller in size (was the v6 guides defect already).
>
>
> Sure, the enhancement for v.6 is a big step forward and, again, I do
> love it. Though, the respective weights of the graphic and text items
> should be reworked to make important things more visible (the title!).
>
>
> HTH,
> --
> Jean-Francois Nifenecker, Bordeaux
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Howdy,

One final update for today - added the current text from the Base
guide back cover to the 7.0 back with a couple of changes:
URL for downloaded, changed from documentation page on main website to
extension site. Is that the correct URL?
Reworded the last sentence about downloading a free copy. (minor)
Added two paragraphs about Professional Support services to the end.

Updated https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p
with that change

Full text of Base back cover follows:
Base Guide
Managing your data
About this book:
This book is for beginners to advanced users of LibreOffice Base. If
you have never used Base before, or you want an introduction to all of
LibreOffice's components, you might like to read Getting Started with
LibreOffice first.
This book introduces you to the most common functions of LibreOffice Base:
Creating a database
Input and output of data
Using macros
Maintaining a database
And much more
About the authors:
This book was written by volunteers from the LibreOffice community.
Profits from sales of the printed edition will be used to benefit the
community.
A PDF version of this book can be downloaded free from:
https://extensions.libreoffice.org
About LibreOffice:
LibreOffice is the free, libre, and open source personal productivity
suite from The Document Foundation. It runs on Windows, macOS, and
GNU/Linux. Support and documentation is free from our large, dedicated
community of users, contributors and developers.
You too can get involved with volunteer work in many areas:
development, quality assurance, documentation, translation, user
support, and more.
You can download the free Community release of LibreOffice from:
https://libreoffice.org/download/
For commercial use: You are encouraged to work with a certified
LibreOffice professional for your business needs, from deployment or
conversion off other office suites, staff training, or custom
development needs.
You can find information on professional support services at:
https://www.libreoffice.org/get-help/professional-support/

On Sat, Jun 20, 2020 at 1:33 PM Drew Jensen  wrote:
>
> Howdy Robert,
>
> Would you prefer a 'blank' back cover where you add your own text or a
> cover with the En text for translation?
>
> On Sat, Jun 20, 2020 at 12:07 PM Robert Großkopf
>  wrote:
> >
> > Hi Drew,
> >
> > looks good. I would need the *.svg for changing the English content to
> > German. I will update the German Base-Handbuch at the end of July.
> >
> > Regards
> >
> > Robert
> > --
> > Homepage: https://www.familiegrosskopf.de/robert
> >
> >
> > --
> > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> > Problems? 
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/documentation/
> > Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Howdy Robert,

Would you prefer a 'blank' back cover where you add your own text or a
cover with the En text for translation?

On Sat, Jun 20, 2020 at 12:07 PM Robert Großkopf
 wrote:
>
> Hi Drew,
>
> looks good. I would need the *.svg for changing the English content to
> German. I will update the German Base-Handbuch at the end of July.
>
> Regards
>
> Robert
> --
> Homepage: https://www.familiegrosskopf.de/robert
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Quick two updates to the draft covers on the NC server.

For the Base guide only - swapped out the TDF logo (top of the page)
for the community logo with "The Documentation Team" below it, per the
current guides, and added a, currently, blank back cover with the same
theme.
https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p has been
updated with the changes, but the zip file with the svg (inkscape)
files has not yet.

On Sat, Jun 20, 2020 at 9:48 AM Drew Jensen  wrote:
>
> Howdy,
>
> Well, here is a link to the pdf file so you can at least see what is
> happening here.
> https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p
>
>
> On Sat, Jun 20, 2020 at 2:57 AM Robert Großkopf
>  wrote:
> >
> > Hi Drew,
> > >
> > > During the jitsi meeting yesterday Olviier showed off a couple of
> > > front cover options. Two of those are available in the Documentation
> > > Team/English/Contributor Resources/Cover7 folder on the
> > > NC server as .svg files.
> >
> > I'm not the expert with this links. Don't know where to search for it,
> > because I have edited the documents without using the structure of
> > LO-documentation. But I will wait a little bit. I hve seen the English
> > guides haven't the same cover than the German guides. So I will also ask
> > in the German dicussion mailinglist ...
> >
> > Regards
> >
> > Robert
> > --
> > Homepage: https://www.familiegrosskopf.de/robert
> >
> >
> > --
> > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> > Problems? 
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/documentation/
> > Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Howdy,

Well, here is a link to the pdf file so you can at least see what is
happening here.
https://nextcloud.documentfoundation.org/s/XkirCBX7QQqjc4p


On Sat, Jun 20, 2020 at 2:57 AM Robert Großkopf
 wrote:
>
> Hi Drew,
> >
> > During the jitsi meeting yesterday Olviier showed off a couple of
> > front cover options. Two of those are available in the Documentation
> > Team/English/Contributor Resources/Cover7 folder on the
> > NC server as .svg files.
>
> I'm not the expert with this links. Don't know where to search for it,
> because I have edited the documents without using the structure of
> LO-documentation. But I will wait a little bit. I hve seen the English
> guides haven't the same cover than the German guides. So I will also ask
> in the German dicussion mailinglist ...
>
> Regards
>
> Robert
> --
> Homepage: https://www.familiegrosskopf.de/robert
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Front- and Backcover for LO 7.0

[Drew Jensen]

Howdy Robert,

Nothing final yet.

During the jitsi meeting yesterday Olviier showed off a couple of
front cover options. Two of those are available in the Documentation
Team/English/Contributor Resources/Cover7 folder on the
NC server as .svg files.

There was some discussion about coloring the different covers based on
the module and in that same directory you will find a pdf file with an
example of how that could look (the source svg files are also in a zip
file there) That includes an example for Base also, of course. That is
only English so for a German cover you would need to update one of the
svg files.

Currently there is no start on a back cover, at least none which I've seen.

The subject of covers (front and back) is an item for the next jitsi
meeting, scheduled for two weeks from yesterday.

So, there are 13 days to work on other possibilities - any ideas?

Drew

On Fri, Jun 19, 2020 at 12:17 PM Robert Großkopf
 wrote:
>
> Hi *,
>
> next month I planned to publish the next Base-Handbuch in German. Is
> there any front- and backcover available for the new branding?
>
> Regards
>
> Robert
> --
> Homepage: https://www.familiegrosskopf.de/robert
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Documentation team meeting minutes June 18th 2020

[Drew Jensen]

I suppose it isn't right without the true colors.

The pdf is updated with the branding color values for each page.
The blurr you mention behind the title is in the base source file, as
a feature - when I updated the example covers I removed it from the
Draw Guide cover. Did not change the font.

Anyway - the source files are updated in the zip file also; otherwise
I grabbed Chapter 7 from the Base guide and I'll not crack those
graphic files till I've been into the review of that chapter.

Drew

On Thu, Jun 18, 2020 at 9:07 PM Olivier Hallot
 wrote:
>
> Hi Drew
> Good start
> Branding color are defined in this page
> https://wiki.documentfoundation.org/Marketing/Branding#Colors
>
> Note that for Draw, the white over yellow should be "dark" over yellow
> background.
>
> Also I see a blurr around the guide name and the guide title font is too
> thin for my personal taste.
>
> Thanks for the nice work.
>
> PS. We also need to design the back cover :-)
>
> Olivier
>
> Em 18/06/2020 21:10, Drew Jensen escreveu:
> > Howdy,
> >
> > per the conversation about the 7.0 covers - took a quick run at what I
> > thought I heard about colors.
> > NOTE I DID THE COLORS BY EYE - not the actual branding color rgb value
> > - easily updated - good enough for a quick gander though, me thinks.
> >
> > So for a look at big color change have uploaded a pdf file with sample
> > covers for writer, calc, impress, draw, base. Find it in the
> > Documentation Team/English/Contributor Resources/Cover7 folder on the
> > NC server as LOGuides7_colors_draft1.pdf
> >
> > The five svg files are also in that folder as
> > Cover7_colors_draft1_DJ18062020.zip
> >
> > Drew
> >
> > On Thu, Jun 18, 2020 at 3:42 PM Olivier Hallot
> >  wrote:
> >>
> >> Thursday June 18th 2020, 18:00 UTC
> >>
> >> Presents: Emiliano Vavassori, Dan Lewis, Drew Jensen, Collen Hayes,
> >> Annie Nguyen, Olivier Hallot
> >>
> >> IRC chanel:
> >> https://irc.documentfoundation.org/?settings=#libreoffice-doc
> >>
> >> Telegram Group
> >> https://t.me/joinchat/ALeRuUFCxyZY0wzoddldWQ
> >>
> >> Live TDF Jitsi Room
> >> https://jitsi.documentfoundation.org/tdfdocteam
> >>
> >> Completed items:
> >>
> >> Pending items:
> >> * Update Contributor Guide for e-PUB - Tabs issue (olivier)
> >>
> >> Topics and Discussion:
> >> * The road for 7.0
> >> + Cover
> >> + Proposals in the cloud at folder
> >>  (...)/Contributor resources/Cover7
> >> + Suggested changes (to be evaluated next meeting):
> >>+ light grey background to app light color (EV) x keep Light
> >>  Grey (Colleen)
> >>+ Wavy footer to have app color background, adjust "7.0" font
> >> color accordingly
> >>+ white background is OK too (Dan)
> >>+ Set header background with same as footer color, adjust
> >> logo color accordingly
> >>+  *please work on a copy of the source file*
> >>
> >> * The Extension & Documentation website
> >> + https://extensions.libreoffice.org/?Tags%5B%5D=53
> >> + Extension site framework is good for quick PDF/epub download 
> >> (olivier)
> >> + work in progress, several enhancements in the queue
> >> + easy of book upload management
> >> + has version control, allow revisions/erratas (as "upgrades")
> >> + Can anybody upload files? (Drew)
> >> + yes, but there is moderation though (olivier).
> >>
> >> + Questions and Answers
> >>+ Chapter 7.0 template
> >>   + The bullet/number list style must be adjusted before the b/n
> >> paragraph   style(Dan)
> >>+ export to EPUB
> >>+ LibreOffice Epub Export generates hundred of character styles
> >>+ can clean up 100's of them
> >>
> >>  + Question: Has anyone proposed a documentation presentation/other?
> >> session for the LO/OpenSuse conference? (drew)
> >> + Call for paper open until July 21st
> >>  + Linux South East virtual was awsome (Drew)
> >>  + Used zoom + Jisti, 100's attendants
> >>  + session has virtual moderators, for questions funneling
> >>  + questions sent by Telegram + IRC
> >>  + better than expected, good interaction (Drew)
> >>
> >> Next meeting : *THURSDAY* July 

Re: [libreoffice-documentation] Documentation team meeting minutes June 18th 2020

[Drew Jensen]

Howdy,

per the conversation about the 7.0 covers - took a quick run at what I
thought I heard about colors.
NOTE I DID THE COLORS BY EYE - not the actual branding color rgb value
- easily updated - good enough for a quick gander though, me thinks.

So for a look at big color change have uploaded a pdf file with sample
covers for writer, calc, impress, draw, base. Find it in the
Documentation Team/English/Contributor Resources/Cover7 folder on the
NC server as LOGuides7_colors_draft1.pdf

The five svg files are also in that folder as
Cover7_colors_draft1_DJ18062020.zip

Drew

On Thu, Jun 18, 2020 at 3:42 PM Olivier Hallot
 wrote:
>
> Thursday June 18th 2020, 18:00 UTC
>
> Presents: Emiliano Vavassori, Dan Lewis, Drew Jensen, Collen Hayes,
> Annie Nguyen, Olivier Hallot
>
> IRC chanel:
> https://irc.documentfoundation.org/?settings=#libreoffice-doc
>
> Telegram Group
> https://t.me/joinchat/ALeRuUFCxyZY0wzoddldWQ
>
> Live TDF Jitsi Room
> https://jitsi.documentfoundation.org/tdfdocteam
>
> Completed items:
>
> Pending items:
> * Update Contributor Guide for e-PUB - Tabs issue (olivier)
>
> Topics and Discussion:
> * The road for 7.0
> + Cover
> + Proposals in the cloud at folder
>  (...)/Contributor resources/Cover7
> + Suggested changes (to be evaluated next meeting):
>+ light grey background to app light color (EV) x keep Light
>  Grey (Colleen)
>+ Wavy footer to have app color background, adjust "7.0" font
> color accordingly
>+ white background is OK too (Dan)
>+ Set header background with same as footer color, adjust
> logo color accordingly
>+  *please work on a copy of the source file*
>
> * The Extension & Documentation website
> + https://extensions.libreoffice.org/?Tags%5B%5D=53
> + Extension site framework is good for quick PDF/epub download (olivier)
> + work in progress, several enhancements in the queue
> + easy of book upload management
> + has version control, allow revisions/erratas (as "upgrades")
> + Can anybody upload files? (Drew)
> + yes, but there is moderation though (olivier).
>
> + Questions and Answers
>+ Chapter 7.0 template
>   + The bullet/number list style must be adjusted before the b/n
> paragraph   style(Dan)
>+ export to EPUB
>+ LibreOffice Epub Export generates hundred of character styles
>+ can clean up 100's of them
>
>  + Question: Has anyone proposed a documentation presentation/other?
> session for the LO/OpenSuse conference? (drew)
> + Call for paper open until July 21st
>  + Linux South East virtual was awsome (Drew)
>  + Used zoom + Jisti, 100's attendants
>  + session has virtual moderators, for questions funneling
>  + questions sent by Telegram + IRC
>  + better than expected, good interaction (Drew)
>
> Next meeting : *THURSDAY* July 2nd 2020 at 18:00 UTC.
> --
> Olivier Hallot
> LibreOffice Documentation Coordinator
> Comunidade LibreOffice
> Rio de Janeiro - Brasil - Local Time: UTC-03:00
> http://tdf.io/joinus
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Re: LibreOffice Base 7.0 has not got Firebird engine without experimental mode

[Drew Jensen]

On Tue, Jun 9, 2020 at 11:05 AM Dan Lewis  wrote:
>
> Given this, what not update HSQLDB from 1.8 to 2.5?

IIRC there is a major architectural change to the HSQLDB code from 1.x
to 2.x and the cost of making the code changes for an embedded mode
(even the HSLQDB 1.8 is a customiazed release when used embedded in a
Base file) would be very high.
There is a secondary reason; to get away from an in-memory only DBMS
(which HSQLDB still is) anda tertiary reason to get away from Java if
possible, but of course that also means dumping the current Report
Builder for some non-Java replacement.

We were using this
> version on the daily builds and later the alpha and beta version back in
> 2005 and 2006. There has to be a way to convert from an embedded
> database with version 1.8 to connecting to the database with JDBC with
> version 2.5 that is not really difficult. The main problem is with
> moving the queries, forms, and reports.
>
> Dan
>
> On 6/9/20 07:45, Alexander Thurgood wrote:
> > Le 09/06/2020 à 06:28, Pulkit Krishna a écrit :
> >
> > Hi Pulkit,
> >
> > Yes, this change was made in master and also pushed into the 6.4.4
> > branch - it was deliberate.
> >
> > The reason is that the embedded Firebird support code just too much of a
> > liability at the moment, and virtually no one is fixing the bugs that
> > its introduction has created, or the bugs for features that one would
> > expect to see in such an engine, but which haven't been implemented in
> > the LO code. It was a whole sorry mess, just waiting to explode in the
> > faces of unwitting users, so it was felt better to switch it back to
> > experimental, that way, if people hose their data with it, they will
> > have made the decision knowingly, rather than by default building their
> > hopes up and then kicking them where it hurts.
> >
> > At least with embedded hsqldb 1.8.0, we know where all of the problems
> > lie, and the documentation doesn't need to be rewritten for a new db
> > engine that doesn't deliver on the promises our marketing communication
> > was so keen to tout (the engine itself is actually pretty capable, its
> > just the implementation within LO that is somewhat lacking).
> >
> >
> > Alex
> >
> >
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Re: Macro Code Colorizer

[Drew Jensen]

back to how this started, IIRC;

Those character styles used by Macro Formatter extension are added to
the odt file when the extension is run on the author's or editor's
machine. Given that I would not include them in the Guide/Team
template.

I would add a section in the template text content about coloring
example code and point to
https://extensions.libreoffice.org/en/extensions/show/code-colorizer-formatter
as the proper tool for the job. Let them know that after installing
the extension to open the configuration dialog and change the
paragraph entry from '_OooTextBody' to 'Text Body' (it will not
function until it is changed to an existing paragraph style).

There is no reason to have those character styles in a document that
has no example code, for one thing, and for another maybe the
extension is updated at some point, no reason to add an expectation as
to what those style names must be.

Drew

On Fri, Jun 5, 2020 at 10:11 AM Drew Jensen  wrote:
>
> Howdy,
>
> Following up from the meeting yesterday.
>
> So, I was wrong about the extension using direct formatting with
> regards to the extension 'Macro Formatter 4.1.1'. Using a fresh
> document it did add a set of character styles and the uses those in
> the formatting and colorizing process. (The only note to make here is
> that it needs to have the default configuration or _OOoTextBody
> changed for the paragraph style - I choose the standard Text Body and
> it worked fine)
>
> As for a second extension, 'Code Highlighter 1.6', this python
> extension does not run properly in the latest versions of LO so I
> could not answer the question of how it handles the document changes.
>
> Best wishes,
>
> Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Macro Code Colorizer

[Drew Jensen]

Howdy,

Following up from the meeting yesterday.

So, I was wrong about the extension using direct formatting with
regards to the extension 'Macro Formatter 4.1.1'. Using a fresh
document it did add a set of character styles and the uses those in
the formatting and colorizing process. (The only note to make here is
that it needs to have the default configuration or _OOoTextBody
changed for the paragraph style - I choose the standard Text Body and
it worked fine)

As for a second extension, 'Code Highlighter 1.6', this python
extension does not run properly in the latest versions of LO so I
could not answer the question of how it handles the document changes.

Best wishes,

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Universal Accessibility (PDF/UA) check tool in LO 7

[Drew Jensen]

Howdy,

Here is the blog which describes what this new feature checks
https://tomazvajngerl.blogspot.com/2020/01/accessibility-checker-and-support-for.html

The other day I ran a couple of chapters from the Calc Guide and was
quite surprised by the number of issues it flagged in each.

Five checks dominated the issues found:

No alt-text for images. None of the images had Alt-Text set.

Text conveys additional meaning with (direct) formatting - this fell
into two categories;
- 1st there were dozens of little chunks of texts (for example a
couple of letters in the middle of a word, and a bunch of single
spaces after sentences and before a style change) which have a direct
formatting tag on them.
- 2nd the coloring of text in code examples.

Insufficient contrast between text and the background. This was
prevalent in the screen shot images.

URL text. This is an interesting case because the check is for digital
files (PDF) and what is good for the screen reader is not necessarily
what is good for the paper document.

Anyway - perhaps the group should consider how this new tool could be
worked into the workflow.

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] cleaned published guide files

[Drew Jensen]

Wow that is great news.

Another tool which finds these very small direct formatting bits
spread throughout the files is the accessibility check tool found in
LO 7 (which is how I noticed it). I did only a couple of chapters of
from the Calc guide the other day and was amazed at how many little
bits there were.

On Mon, Jun 1, 2020 at 7:17 AM Milos Sramek  wrote:
>
> Hi,
>
> in order to help the teams which translate the guides, I have cleaned of
> the published guide files (GS64, LOOL63 and MG64). You can find them in
> the Shared/SK community/Cleaned directory in the nextcloud repository (I
> hope you can access that directory, if not, pls let me know). I suggest
> to replace by them the files in the Published directory, so that these
> are used in preparation of the new ones.
>
> I've done so already earlier. The motivation is that LO keeps sometimes
> enormous amount of hidden direct formatting tags, which are not visible
> in the document, but are visible in the OmegaT translation tool. These
> tags make translation a nightmare.
>
> I've replaced all direct character formatting by a corresponding style
> and removed all hidden direct formatting tags by a python script.
> Subsequently, I've compared the cleaned and uncleaned version to be sure
> that there are no unwanted changes.
>
> As far as I know, the Czech team is very active in translations
>
> cheers
>
> Milos
>
> --
> email & jabber: sramek.mi...@gmail.com
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Calc 6.4 Guide - keyboard shortcits

[Drew Jensen]

Howdy,

I finished checking each of these using Ubuntu(KDE) and found one key
which performs an OS (or OS desktop manager) function instead of the
expected LO function. Didn't copy of a feedback copy of the file for
this - not yet anyway. I should (might) be able to get an hour with a
Windows 10 box in the next couple days, if so will check there, if not
will upload what I have as is.

BTW - I noted in the tracking spreadsheet that the entry for the first
review was only for Linux.

Best wishes,

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] 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: 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
>>> libreoff...@lists.freedesktop.org
>>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>>
>>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

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
>> libreoff...@lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

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
> libreoff...@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] LibreOffice Base Guide

[Drew Jensen]

Don't grab it for review till tomorrow April 8th, after that I'm done
either way.

On Mon, Apr 6, 2020 at 12:42 AM Pulkit Krishna 
wrote:

> Hello Robert,
> I have written to Drew once more. If he replies that's the best. If he
> doesn't reply then can you take the macros chapter for a review. I think
> the Access2Base has to wait.
> Pulkit Krishna
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Re: LibreOffice Base Documentation

[Drew Jensen]

On Thu, Mar 26, 2020 at 1:24 AM Pulkit Krishna 
wrote:

> Hello Drew,
> Are you done with the review of chapter 09? You should have done that.


Howdy Pulkit,

You are right, I should of.

I am a bad mistress to the doc team, I know.

Thanks for the shake and I'll share what I have today.





>
> Pulkit Krishna
>
> On Thu, Mar 26, 2020 at 10:45 AM Pulkit Krishna  >
> wrote:
>
> > Hello Dan,
> > You should take chapter 7 DB connections for its second review.
> >
> > Pulkit Krishna
> >
> > On Wed, Mar 25, 2020 at 7:31 PM Dan Lewis 
> wrote:
> >
> >> I have complete the first review of chapter 10 uploading it to the
> >> feedback folder. The Guide Status has also been updated. I have
> >> something to do today but will be selecting another chapter either for
> >> the first or second review tomorrow. Yes, tomorrow is the next meeting
> >> at 1800 UTC (GMC for us older people...)
> >>
> >> Dan
> >>
> >> On 3/25/20 01:18, Jean Weber wrote:
> >> > I have now taken Appendix A for first review. Expected return date 28
> >> March.
> >> > Jean
> >> >
> >> > On Fri, Mar 20, 2020 at 4:35 PM Jean Weber 
> wrote:
> >> >> I may not have time to do any reviewing for several days. Sorry.
> >> >> Jean
> >> >>
> >> >> On Thu, 19 Mar 2020 at 19:33 Pulkit Krishna <
> pulkitkrishn...@gmail.com>
> >> wrote:
> >> >>> Hello Jean,
> >> >>> You can take appendix 1 for its first review.
> >> >>>
> >> >>> Pulkit Krishna
> >> >>>
> >>
> >> --
> >> To unsubscribe e-mail to:
> >> documentation+unsubscr...@global.libreoffice.org
> >> Problems?
> >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >> Posting guidelines + more:
> https://wiki.documentfoundation.org/Netiquette
> >> List archive:
> https://listarchives.libreoffice.org/global/documentation/
> >> Privacy Policy: https://www.documentfoundation.org/privacy
> >>
> >
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] FYI - LibreOffice Online on the TDF NC server supports personal templates

[Drew Jensen]

Howdy,

As it turns out (and found out by checking the release notes) that feature
showed up with the 6.3 release. So it should be in the guide already.

On the other hand 6.4 is out now and there are only a handful of updates,
all with screenshots it appears, in the wiki release notes.

On Wed, Mar 25, 2020 at 1:09 PM Martin Srebotnjak  wrote:

> Thanks, Drew.
>
> If this isn't already a part of LOOL guide (at least it seems to me), it
> could be added (Chapter 3 or 8?).
>
> As well as guidelines about finding and installing language packs for LOOL
> (to support UI in other languages and the
> spell-checking/hyphenation/thesaurus). Info is needed for non-English
> installs (Chapter 2). Without there is little sense in localizing LOOL
> guide to other languages.
>

Yes, an LOOL Admin guide.

Just now I went into the NC server and from the Settings function changed
my account to use Espanol as my language and local. Went into LOOL and sure
enough the application UI is Spanish. I still had to change the language
for the new document to Spanish but once I did that it found the right
spell checker - so it is all there and you are right it should be
documented how to admin it, but I wonder how much of that would be
dependent on which CMS LOOL is running with? IDK



>
> Lp, m.
>
> V V sre., 25. mar. 2020 ob 00:39 je oseba Drew Jensen <
> drewjensen.in...@gmail.com> napisala:
>
>> Howdy,
>>
>> Just thought I'd pass this along for those utilizing the LOOL services.
>>
>> LOOL 6.4 on the NC server allows you to setup your own template
>> directory which will be used when you create new documents.
>>
>> To set it up:
>>
>> 1 - Decide which directory (folder) you want to use. I created a new
>> folder
>> named 'My Templates' in my default folder and dropped the LO 6 Guide
>> template .ott file into it. Along with a Calc template.
>>
>> 2 - Go to the NextCloud settings page. Click on your avatar, upper right
>> corner of the screen, and select settings.
>>
>> 3 - Open the LOOL section.
>>
>> 4 - Enter the name of the folder in the text box belore: 'Select a
>> template
>> directory". I entered 'My Templates'
>>
>> 5 - Create a new Writer document, after you give it a name and click go a
>> window will open with two thumbnails, one named 'Blank' which is the
>> system
>> default (A4, German lang, etc) and one for the LO 6 Guide template. Just
>> click on the the thumbnail you want and away it goes.
>>
>> Best wishes,
>>
>> Drew
>>
>> --
>> To unsubscribe e-mail to:
>> documentation+unsubscr...@global.libreoffice.org
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/documentation/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Query on Base Table Creation Wizard

[Drew Jensen]

Well, damn those elements are just gone, same in the 7.0 build and I don't
see a bug report yet.

Would you like to report it?

On Wed, Mar 25, 2020 at 9:25 AM Stephen Fanning 
wrote:

> Please could one of our Base experts advise me?
>
> I am reviewing Chapter 8 of the draft 6.4 Getting Started Guide and am
> missing something. I have followed the text in the section entitled “Using
> the Wizard to create a table” and have selected the fields without incident
> (matching Figure 4). However when I press Next to go to page 2 of the
> Wizard (Set field types and formats), things go awry. I can only see the
> Field Name on the right hand side of this area – no sign of Field type,
> AutoValue, Auto-increment state, and Length.
>
> If it makes a difference, I am running on Windows 10 using LO 6.4.0.3. I’ve
> also tried on Ubuntu Linux and no difference.
>
> Any help gratefully received, and aplogies in advance if I'm being stupid!
>
> Regards,
>
> Steve
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] FYI - LibreOffice Online on the TDF NC server supports personal templates

[Drew Jensen]

Howdy,

Just thought I'd pass this along for those utilizing the LOOL services.

LOOL 6.4 on the NC server allows you to setup your own template
directory which will be used when you create new documents.

To set it up:

1 - Decide which directory (folder) you want to use. I created a new folder
named 'My Templates' in my default folder and dropped the LO 6 Guide
template .ott file into it. Along with a Calc template.

2 - Go to the NextCloud settings page. Click on your avatar, upper right
corner of the screen, and select settings.

3 - Open the LOOL section.

4 - Enter the name of the folder in the text box belore: 'Select a template
directory". I entered 'My Templates'

5 - Create a new Writer document, after you give it a name and click go a
window will open with two thumbnails, one named 'Blank' which is the system
default (A4, German lang, etc) and one for the LO 6 Guide template. Just
click on the the thumbnail you want and away it goes.

Best wishes,

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] LibreOffice Tutorial

[Drew Jensen]

On Tue, Mar 24, 2020 at 1:43 AM Pulkit Krishna 
wrote:

> I am not saying to remove the original guide. They can be there for the
> teachers. We can change it to make it for everyone and publish the new
> guides.
> I have asked the permission of Benard Poole for it.
>

That is all well and good and if you really want to spend time re-writing
it great.

What I'm saying is that what I would like to see first and also is for the
documentation page on the main website to have a place for listing these
types of resources so they get some visibility.

Another example, a series of books I didn't see listed there from Bruce
Byfield who did a nice job a couple years back on Typographic Design with
LibreOffice. I'm sure there are others. I think the ROI would be much
greater doing that then rewriting things so they are LO branded and
distributed from the TDF infrastructure.

Drew

>
> Pulkit Krishna
>
> On Tue, Mar 24, 2020 at 10:55 AM Pulkit Krishna  >
> wrote:
>
> > I am not saying to remove the original guide. They can be there for the
> > teachers. We can change it to make it for everyone and publish the new
> > guides.
> > I have asked the permission of Benard Poole for it.
> >
> > Pulkit Krishna
> >
> > On Tue, Mar 24, 2020 at 10:51 AM Drew Jensen  >
> > wrote:
> >
> >> Howdy,
> >>
> >> A short comings here, IMO (and it was inherited), is an uneasiness about
> >> promoting anything that isn't sitting on a TDF property.
> >>
> >> I would much rather see us put some thought into helping get the word
> out
> >> that the resource for teachers is there then to take the time to rebrand
> >> it
> >> and likely dilute it by changing the focus.
> >>
> >> At this moment it seems particularly fitting given the number of people
> >> faced with helping their children or themselves (k-college) deal with
> >> switch from brick and mortar schools to virtual.
> >>
> >> Drew
> >>
> >> On Tue, Mar 24, 2020 at 1:00 AM Pulkit Krishna <
> pulkitkrishn...@gmail.com
> >> >
> >> wrote:
> >>
> >> > I am talking about changing the whole guide so that it is meant for
> >> every
> >> > one instead of only teachers and then publishing it.
> >> >
> >> > Pulkit Krishna
> >> >
> >> > On Tue, Mar 24, 2020 at 10:26 AM Pulkit Krishna <
> >> pulkitkrishn...@gmail.com
> >> > >
> >> > wrote:
> >> >
> >> > > I am talking about changing the whole guide so that it is meant for
> >> every
> >> > > one instead of only teachers and then publishing it.
> >> > >
> >> > > Pulkit Krishna
> >> > >
> >> > > On Tue, Mar 24, 2020 at 10:25 AM Pulkit Krishna <
> >> > pulkitkrishn...@gmail.com>
> >> > > wrote:
> >> > >
> >> > >> I am talking about hanging the whole guide so that it is meant for
> >> every
> >> > >> one instead of only teachers and then publishing it.
> >> > >>
> >> > >> Pulkit Krishna
> >> > >>
> >> > >> On Tue, Mar 24, 2020 at 10:19 AM Drew Jensen <
> >> > drewjensen.in...@gmail.com>
> >> > >> wrote:
> >> > >>
> >> > >>> Why would we change it instead of simply promoting the location
> >> where
> >> > it
> >> > >>> already exists?
> >> > >>>
> >> > >>>
> >> > >>>
> >> > >>> On Tue, Mar 24, 2020 at 12:46 AM Pulkit Krishna <
> >> > >>> pulkitkrishn...@gmail.com> wrote:
> >> > >>>
> >> > >>>> Hello Everybody,
> >> > >>>> There is a set of LibreOffice tutorial written by Benard Poole.
> >> Those
> >> > >>>> tutorials are meant for y=teachers and for some extent for
> >> students. I
> >> > >>>> think those tutorials would be beneficial for everybody if we
> >> change
> >> > >>>> some
> >> > >>>> language in it. If we change the language so that it is meant for
> >> > >>>> everybody, give it the formatting of a typical LibreOffice guide
> >> > >>>> written by
> >> > >>>> documentation team and publish it with rest of the documentation
> >> then
> >> > >>>>

Re: [libreoffice-documentation] LibreOffice Tutorial

[Drew Jensen]

Howdy,

A short comings here, IMO (and it was inherited), is an uneasiness about
promoting anything that isn't sitting on a TDF property.

I would much rather see us put some thought into helping get the word out
that the resource for teachers is there then to take the time to rebrand it
and likely dilute it by changing the focus.

At this moment it seems particularly fitting given the number of people
faced with helping their children or themselves (k-college) deal with
switch from brick and mortar schools to virtual.

Drew

On Tue, Mar 24, 2020 at 1:00 AM Pulkit Krishna 
wrote:

> I am talking about changing the whole guide so that it is meant for every
> one instead of only teachers and then publishing it.
>
> Pulkit Krishna
>
> On Tue, Mar 24, 2020 at 10:26 AM Pulkit Krishna  >
> wrote:
>
> > I am talking about changing the whole guide so that it is meant for every
> > one instead of only teachers and then publishing it.
> >
> > Pulkit Krishna
> >
> > On Tue, Mar 24, 2020 at 10:25 AM Pulkit Krishna <
> pulkitkrishn...@gmail.com>
> > wrote:
> >
> >> I am talking about hanging the whole guide so that it is meant for every
> >> one instead of only teachers and then publishing it.
> >>
> >> Pulkit Krishna
> >>
> >> On Tue, Mar 24, 2020 at 10:19 AM Drew Jensen <
> drewjensen.in...@gmail.com>
> >> wrote:
> >>
> >>> Why would we change it instead of simply promoting the location where
> it
> >>> already exists?
> >>>
> >>>
> >>>
> >>> On Tue, Mar 24, 2020 at 12:46 AM Pulkit Krishna <
> >>> pulkitkrishn...@gmail.com> wrote:
> >>>
> >>>> Hello Everybody,
> >>>> There is a set of LibreOffice tutorial written by Benard Poole. Those
> >>>> tutorials are meant for y=teachers and for some extent for students. I
> >>>> think those tutorials would be beneficial for everybody if we change
> >>>> some
> >>>> language in it. If we change the language so that it is meant for
> >>>> everybody, give it the formatting of a typical LibreOffice guide
> >>>> written by
> >>>> documentation team and publish it with rest of the documentation then
> >>>> the
> >>>> new users would be benefited very much. I have asked Benard Poole for
> >>>> his
> >>>> permissions and he has agreed. He has even agreed to help us. He is a
> >>>> very
> >>>> good technical writer and can help us very much. Should I start the
> >>>> work? I
> >>>> want at least one helping hand for doing this. The original set of
> >>>> tutorials can be found at :-
> >>>> http://www.pitt.edu/~poole/libreoffice6frame.htm
> >>>>
> >>>>
> >>>> Pulkit Krishna
> >>>>
> >>>> --
> >>>> To unsubscribe e-mail to:
> >>>> documentation+unsubscr...@global.libreoffice.org
> >>>> Problems?
> >>>>
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >>>> Posting guidelines + more:
> >>>> https://wiki.documentfoundation.org/Netiquette
> >>>> List archive:
> >>>> https://listarchives.libreoffice.org/global/documentation/
> >>>> Privacy Policy: https://www.documentfoundation.org/privacy
> >>>>
> >>>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] LibreOffice Tutorial

[Drew Jensen]

Why would we change it instead of simply promoting the location where it
already exists?



On Tue, Mar 24, 2020 at 12:46 AM Pulkit Krishna 
wrote:

> Hello Everybody,
> There is a set of LibreOffice tutorial written by Benard Poole. Those
> tutorials are meant for y=teachers and for some extent for students. I
> think those tutorials would be beneficial for everybody if we change some
> language in it. If we change the language so that it is meant for
> everybody, give it the formatting of a typical LibreOffice guide written by
> documentation team and publish it with rest of the documentation then the
> new users would be benefited very much. I have asked Benard Poole for his
> permissions and he has agreed. He has even agreed to help us. He is a very
> good technical writer and can help us very much. Should I start the work? I
> want at least one helping hand for doing this. The original set of
> tutorials can be found at :-
> http://www.pitt.edu/~poole/libreoffice6frame.htm
>
>
> Pulkit Krishna
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Base Guide WiP

[Drew Jensen]

WiP = Work in Progress

and that is under Macros, not Base, btw

Anyway, looks like *Alain R. is scratching an itch. Nice, he is the guy for
this!*

*Wish him well,*

*Drew*



On Tue, Mar 24, 2020 at 12:32 AM Pulkit Krishna 
wrote:

> What is Base Guide WiP?
> There is a folder by this name inside the English Folder on Nextcloud.
> Inside this folder, there is a folder named Related Materials.
> Inside that folder there is a document named BG70nn-SyntaxDiagrams.
> The document is just a renamed chapter template with the title changed.
> The version number in the file is 7.0.
> We have not completed Base Guide 6.2 and not even started version 6.4. The
> version 7.0 is to be released in August. Shouldn't we focus on version 6.2
> and 6.4. Whoever has written this chapter should add his initials in the
> file name.
> The release note page of version 7.0 does not state any changes in bas,
> then why are we including this new chapter in version 7.0? Does this
> chapter apply to version 6.4 or 6.2? If so then we should include it in
> those guides too.
>
> Pulkit Krishna
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Exporting data: how is it done

[Drew Jensen]

Also, others may have also, but I wrote a small tutorial on doing this
(exporting using TEXT TABLES) for the old OOo forums and that should be
there still. I'll go this evening and see if I can find that and pass it
onto you if I can find it.

On Thu, Mar 19, 2020 at 12:37 PM Drew Jensen 
wrote:

> Howdy,
>
> Well, IMO, dumping the DB with a simple script command is great if you are
> migrating the data but for exporting data:
>
> You need to look at the HSQLdb documentation on TEXT TABLES and the SELECT
> INTO construct.
>
> Using that you can export all of a table or use the standard query
> functions to export a subset of records or to join records from multiple
> tables into a single export file.
>
> I hope that helps,
>
> Drew
>
> On Thu, Mar 19, 2020 at 12:26 PM Dan Lewis 
> wrote:
>
>> Page 6 of chapter 10 Database Maintenance contains this section. Can
>> anyone explain how to actually do this? I can use SCRIPT 'database
>> name'; and then SET SCRIPTFORMAT TEXT. This reduces the database folder
>> within the *.odb file. But how do I use Tools > SQL after these two steps?
>>
>> Dan
>>
>>
>> --
>> To unsubscribe e-mail to:
>> documentation+unsubscr...@global.libreoffice.org
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/documentation/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Exporting data: how is it done

[Drew Jensen]

Howdy,

Well, IMO, dumping the DB with a simple script command is great if you are
migrating the data but for exporting data:

You need to look at the HSQLdb documentation on TEXT TABLES and the SELECT
INTO construct.

Using that you can export all of a table or use the standard query
functions to export a subset of records or to join records from multiple
tables into a single export file.

I hope that helps,

Drew

On Thu, Mar 19, 2020 at 12:26 PM Dan Lewis  wrote:

> Page 6 of chapter 10 Database Maintenance contains this section. Can
> anyone explain how to actually do this? I can use SCRIPT 'database
> name'; and then SET SCRIPTFORMAT TEXT. This reduces the database folder
> within the *.odb file. But how do I use Tools > SQL after these two steps?
>
> Dan
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Base Guide Chapter 9 Macros; Expanding section on Access2Base

[Drew Jensen]

Howdy,

I grabbed the draft file for chapter 9 today and gave it a cursory read
over.

Jotted down a couple of items I would like to change.

By far the largest would be to expand the section on the Access2Base
standard basic library.

What is there now is inadequate IMO.

I would look to add a small reference section on the main function in the
library, using the access2base wiki as a source for but not a copy paste in
total.

Also would include the TTNorthWind Calc file and database (as the current
zip file from the acess2base wiki), for distribution with the other files
in the supplemental folder.

Then again use, figure it would save time, information about how that Calc
was crafted from the tutorial also found on the access2base wiki as my
template for that.

Before I start on something like though thought I'd run it by everyone
here.

Time wise, I think, after spending taking some time just now to go over the
embedded basic library in the example Calc file and if I borrow from the
wiki for text then something by Wednesday mid morning. Maybe ready for a
review, maybe not, but something.

Anyway, I'll start with that chapter by updating what is there with the new
styles, having been away for a few months remembering how to do that
properly will no doubt take me this afternoon ;-)

Otherwise on the Access2Base stuff I not do anything before tomorrow so
time then for any feedback here.

Best wishes,

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Re: LibreOffice Base Documentation

[Drew Jensen]

Howdy,

Downloaded Chapter 9 (macros) for 1st review, updated spreadsheet with
expected return on Tuesday, 17th.

Drew

On Sun, Mar 15, 2020 at 3:28 PM Drew Jensen 
wrote:

> Chapter 6 has been uploaded to the feedback folder
> (BH6206-Reports_PK_JHW_PK_DJ_20200315.odt).
>
> This file has 8 typos fixed and no additional comments added.
>
> I had almost added comments on a few paragraphs that spent a lot time on
> flaws in the Report Builder but, they are all still there and accurate so,
> backed on that.
>
> Drew
>
> On Sun, Mar 15, 2020 at 4:20 AM Jean Weber  wrote:
>
>> I am testing using LO 6.2.8 on Linux Mint when working on this book.
>>
>> On Sun, 15 Mar 2020 at 16:10 Pulkit Krishna 
>> wrote:
>>
>> > Hello Jean and Dan,
>> > I have accepted both your changes for chapter 7 and 8 respectively. I
>> have
>> > uploaded them back to draft folder. I have updated the spreadsheet.
>> >
>> > To Dan:
>> > I don't know about anything summer time. I have used google translate to
>> > translate that part. There is nothing like that in India, from where I
>> am.
>> > Do you think that the portion is incorrect? If so, can you kindly
>> correct
>> > it.
>> >
>> > To Jean:
>> > Many of your comments were right and I have edited the content to make
>> them
>> > correct but some of your comment were wrong. I think you are using a
>> later
>> > version of LibreOffice than 6.2.8. This guide is based on version 6.2,
>> so I
>> > h=am using version 6.2.8 and everything is working fine for me. Base
>> itself
>> > has not changed much but writer and calc has changed in the recent
>> updates.
>> > I have kept a copy of your edited file so that it would be easier when
>> we
>> > are updating this guide to version 6.4.
>> >
>> > Pulkit Krishna
>> >
>> >
>>
>> --
>> To unsubscribe e-mail to:
>> documentation+unsubscr...@global.libreoffice.org
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/documentation/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Re: LibreOffice Base Documentation

[Drew Jensen]

Chapter 6 has been uploaded to the feedback folder
(BH6206-Reports_PK_JHW_PK_DJ_20200315.odt).

This file has 8 typos fixed and no additional comments added.

I had almost added comments on a few paragraphs that spent a lot time on
flaws in the Report Builder but, they are all still there and accurate so,
backed on that.

Drew

On Sun, Mar 15, 2020 at 4:20 AM Jean Weber  wrote:

> I am testing using LO 6.2.8 on Linux Mint when working on this book.
>
> On Sun, 15 Mar 2020 at 16:10 Pulkit Krishna 
> wrote:
>
> > Hello Jean and Dan,
> > I have accepted both your changes for chapter 7 and 8 respectively. I
> have
> > uploaded them back to draft folder. I have updated the spreadsheet.
> >
> > To Dan:
> > I don't know about anything summer time. I have used google translate to
> > translate that part. There is nothing like that in India, from where I
> am.
> > Do you think that the portion is incorrect? If so, can you kindly correct
> > it.
> >
> > To Jean:
> > Many of your comments were right and I have edited the content to make
> them
> > correct but some of your comment were wrong. I think you are using a
> later
> > version of LibreOffice than 6.2.8. This guide is based on version 6.2,
> so I
> > h=am using version 6.2.8 and everything is working fine for me. Base
> itself
> > has not changed much but writer and calc has changed in the recent
> updates.
> > I have kept a copy of your edited file so that it would be easier when we
> > are updating this guide to version 6.4.
> >
> > Pulkit Krishna
> >
> >
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Re: LibreOffice Base Documentation

[Drew Jensen]

Added comments to file BH6205-Queries_DJ_PK_JHW_PK_20200312.odt and
uploaded to the feedback folder.

On Wed, Mar 11, 2020 at 1:48 PM Drew Jensen 
wrote:

> Howdy,
>
> I've been reading through Chapter 5 and 6 and I have a general question.
>
> There is a number of asides in these chapters about somethings being
> 'unfortunate' with regards to design decisions, or open bugs, and I would
> recommend all of those comments be removed, but before I mark them and put
> them back in feedback thought I'd ask how others felt about that.
>
> thanks
>
> Drew
>
>
> On Wed, Mar 11, 2020 at 9:29 AM Dan Lewis  wrote:
>
>> I wlll be finished with the first review of this chapter today.
>>
>> Dan
>>
>> On 3/11/20 1:57 AM, Pulkit Krishna wrote:
>> > Hello  Dan,
>> > Are you done with the review of chapter 4. Are you busy? If so then Jean
>> > can have the review of chapter 4.
>> >
>> > Pulkit Krishna
>> >
>> > On Wed, Mar 11, 2020 at 11:27 AM Pulkit Krishna <
>> pulkitkrishn...@gmail.com>
>> > wrote:
>> >
>> >> Sorry I wanted to send the last mail to list.
>> >>
>> >> On Wed, Mar 11, 2020 at 11:26 AM Pulkit Krishna <
>> pulkitkrishn...@gmail.com>
>> >> wrote:
>> >>
>> >>> Hello  Dan,
>> >>> Are you done with the review of chapter 4. Are you busy? If so then
>> Jean
>> >>> can have the review of chapter 4.
>> >>>
>> >>> Pulkit Krishna
>> >>>
>> >>> On Wed, Mar 11, 2020 at 11:06 AM drew-gmail [via Document Foundation
>> Mail
>> >>> Archive]  wrote:
>> >>>
>> >>>> Ah ha, yes I see my mistake.
>> >>>>
>> >>>> I'll give both chapters 5 and 6 in the draft folder a read in the
>> >>>> morning
>> >>>> then.
>> >>>>
>> >>>> I may have one suggestion for chapter 6 based on what I read tonight,
>> >>>> but I
>> >>>> didn't read it all, just the sections highlighted in the comments.
>> >>>>
>> >>>> Thanks again
>> >>>>
>> >>>> On Wed, Mar 11, 2020 at 1:31 AM Pulkit Krishna <[hidden email]
>> >>>> <http:///user/SendEmail.jtp?type=node=4275279=0>>
>> >>>> wrote:
>> >>>>
>> >>>>> Hello Jean and Drew,
>> >>>>> I have done everything Jean said for chapter 6 and have uploaded it
>> >>>> back to
>> >>>>> Draft Folder. I have updated the spreadsheet.
>> >>>>>
>> >>>>> Drew,
>> >>>>> You can take chapter 5 & 6 for their second review.
>> >>>>>
>> >>>>> Pulkit Krishna
>> >>>>>
>> >>>>> On Wed, Mar 11, 2020 at 10:56 AM drew-gmail [via Document Foundation
>> >>>> Mail
>> >>>>> Archive] <[hidden email]
>> >>>> <http:///user/SendEmail.jtp?type=node=4275279=1>> wrote:
>> >>>>>> No problem.
>> >>>>>>
>> >>>>>> I downloaded BH6206-Reports_PK_JHW_20200311.odt from the feedback
>> >>>>>> directory
>> >>>>>> about an hour ago.
>> >>>>>>
>> >>>>>> There are still a number of comments, about excising parts of the
>> >>>> text,
>> >>>>> in
>> >>>>>> this file.
>> >>>>>>
>> >>>>>> However if you have it with changes made I'll not worry about it.
>> >>>>>>
>> >>>>>> Either way, I'm off to bed in a few minutes and will check back
>> here
>> >>>> in
>> >>>>>> the
>> >>>>>> morning before I do anything with this file, OK.
>> >>>>>>
>> >>>>>> Thanks
>> >>>>>>
>> >>>>>> On Wed, Mar 11, 2020 at 1:19 AM Pulkit Krishna <[hidden email]
>> >>>>>> <http:///user/SendEmail.jtp?type=node=4275277=0>>
>> >>>>>> wrote:
>> >>>>>>
>> >>>>>>> The last messege was supposed to be for Drew.
>> >>>>>>>
>> >>>>>>> Pulkit Krishna
>> >

Re: [libreoffice-documentation] Re: LibreOffice Base Documentation

[Drew Jensen]

Howdy,

I've been reading through Chapter 5 and 6 and I have a general question.

There is a number of asides in these chapters about somethings being
'unfortunate' with regards to design decisions, or open bugs, and I would
recommend all of those comments be removed, but before I mark them and put
them back in feedback thought I'd ask how others felt about that.

thanks

Drew


On Wed, Mar 11, 2020 at 9:29 AM Dan Lewis  wrote:

> I wlll be finished with the first review of this chapter today.
>
> Dan
>
> On 3/11/20 1:57 AM, Pulkit Krishna wrote:
> > Hello  Dan,
> > Are you done with the review of chapter 4. Are you busy? If so then Jean
> > can have the review of chapter 4.
> >
> > Pulkit Krishna
> >
> > On Wed, Mar 11, 2020 at 11:27 AM Pulkit Krishna <
> pulkitkrishn...@gmail.com>
> > wrote:
> >
> >> Sorry I wanted to send the last mail to list.
> >>
> >> On Wed, Mar 11, 2020 at 11:26 AM Pulkit Krishna <
> pulkitkrishn...@gmail.com>
> >> wrote:
> >>
> >>> Hello  Dan,
> >>> Are you done with the review of chapter 4. Are you busy? If so then
> Jean
> >>> can have the review of chapter 4.
> >>>
> >>> Pulkit Krishna
> >>>
> >>> On Wed, Mar 11, 2020 at 11:06 AM drew-gmail [via Document Foundation
> Mail
> >>> Archive]  wrote:
> >>>
>  Ah ha, yes I see my mistake.
> 
>  I'll give both chapters 5 and 6 in the draft folder a read in the
>  morning
>  then.
> 
>  I may have one suggestion for chapter 6 based on what I read tonight,
>  but I
>  didn't read it all, just the sections highlighted in the comments.
> 
>  Thanks again
> 
>  On Wed, Mar 11, 2020 at 1:31 AM Pulkit Krishna <[hidden email]
>  >
>  wrote:
> 
> > Hello Jean and Drew,
> > I have done everything Jean said for chapter 6 and have uploaded it
>  back to
> > Draft Folder. I have updated the spreadsheet.
> >
> > Drew,
> > You can take chapter 5 & 6 for their second review.
> >
> > Pulkit Krishna
> >
> > On Wed, Mar 11, 2020 at 10:56 AM drew-gmail [via Document Foundation
>  Mail
> > Archive] <[hidden email]
>  > wrote:
> >> No problem.
> >>
> >> I downloaded BH6206-Reports_PK_JHW_20200311.odt from the feedback
> >> directory
> >> about an hour ago.
> >>
> >> There are still a number of comments, about excising parts of the
>  text,
> > in
> >> this file.
> >>
> >> However if you have it with changes made I'll not worry about it.
> >>
> >> Either way, I'm off to bed in a few minutes and will check back here
>  in
> >> the
> >> morning before I do anything with this file, OK.
> >>
> >> Thanks
> >>
> >> On Wed, Mar 11, 2020 at 1:19 AM Pulkit Krishna <[hidden email]
> >> >
> >> wrote:
> >>
> >>> The last messege was supposed to be for Drew.
> >>>
> >>> Pulkit Krishna
> >>>
> >>>
> >>> On Wed, Mar 11, 2020 at 10:48 AM Pulkit Krishna <[hidden email]
> >> 
> >>> wrote:
> >>>
>  Hello Jensen,
>  I don't understand what you are saying. I have done everything
>  that
> >> Jean
>  said and I am uploading the chapter back to draft folder. You
>  can
> > take
> >>> the
>  chapter for its second review. You can also take chapter 5 for
>  its
> >> second
>  review or chapter 8-12 for its first review.
> 
>  Pulkit Krishna
> 
>  On Wed, Mar 11, 2020 at 10:34 AM drew-gmail [via Document
>  Foundation
> >> Mail
>  Archive] <[hidden email]
> >> > wrote:
> > Howdy,
> >
> > I've grabbed chapter 6 and read the comments over once.
> >
> > Too a quick look at the comments.
> >
> > Will read over again in the morning and make the changes, will
>  post
> >> back
> > here when it is back in the feedback folder.
> >
> > Drew
> >
> > On Tue, Mar 10, 2020 at 9:18 PM Jean Weber <[hidden email]
> > >
>  wrote:
> >> I have reviewed Chapter 6 (Reports), updated styles, and
>  returned
> >> it
> >>> to
> > the
> >> Feedback folder. I left some questions in marginal comments.
> >> I have now taken Chapter 7 for first review.
> >> Jean
> >>
> >> On Mon, Mar 9, 2020 at 2:49 PM Pulkit Krishna <[hidden email]
> > >
> >> wrote:
> >>> Hello Jean,
> >>> I have deleted the first 2 paragraphs on which you
>  commented in
> > chapter 5
> >>> of Base Guide. But for 

Re: [libreoffice-documentation] Re: LibreOffice Base Documentation

[Drew Jensen]

Ah ha, yes I see my mistake.

I'll give both chapters 5 and 6 in the draft folder a read in the morning
then.

I may have one suggestion for chapter 6 based on what I read tonight, but I
didn't read it all, just the sections highlighted in the comments.

Thanks again

On Wed, Mar 11, 2020 at 1:31 AM Pulkit Krishna 
wrote:

> Hello Jean and Drew,
> I have done everything Jean said for chapter 6 and have uploaded it back to
> Draft Folder. I have updated the spreadsheet.
>
> Drew,
> You can take chapter 5 & 6 for their second review.
>
> Pulkit Krishna
>
> On Wed, Mar 11, 2020 at 10:56 AM drew-gmail [via Document Foundation Mail
> Archive]  wrote:
>
> > No problem.
> >
> > I downloaded BH6206-Reports_PK_JHW_20200311.odt from the feedback
> > directory
> > about an hour ago.
> >
> > There are still a number of comments, about excising parts of the text,
> in
> > this file.
> >
> > However if you have it with changes made I'll not worry about it.
> >
> > Either way, I'm off to bed in a few minutes and will check back here in
> > the
> > morning before I do anything with this file, OK.
> >
> > Thanks
> >
> > On Wed, Mar 11, 2020 at 1:19 AM Pulkit Krishna <[hidden email]
> > >
> > wrote:
> >
> > > The last messege was supposed to be for Drew.
> > >
> > > Pulkit Krishna
> > >
> > >
> > > On Wed, Mar 11, 2020 at 10:48 AM Pulkit Krishna <[hidden email]
> > 
> > > >
> > > wrote:
> > >
> > > > Hello Jensen,
> > > > I don't understand what you are saying. I have done everything that
> > Jean
> > > > said and I am uploading the chapter back to draft folder. You can
> take
> > > the
> > > > chapter for its second review. You can also take chapter 5 for its
> > second
> > > > review or chapter 8-12 for its first review.
> > > >
> > > > Pulkit Krishna
> > > >
> > > > On Wed, Mar 11, 2020 at 10:34 AM drew-gmail [via Document Foundation
> > Mail
> > > > Archive] <[hidden email]
> > > wrote:
> > > >
> > > >> Howdy,
> > > >>
> > > >> I've grabbed chapter 6 and read the comments over once.
> > > >>
> > > >> Too a quick look at the comments.
> > > >>
> > > >> Will read over again in the morning and make the changes, will post
> > back
> > > >> here when it is back in the feedback folder.
> > > >>
> > > >> Drew
> > > >>
> > > >> On Tue, Mar 10, 2020 at 9:18 PM Jean Weber <[hidden email]
> > > >> > wrote:
> > > >>
> > > >> > I have reviewed Chapter 6 (Reports), updated styles, and returned
> > it
> > > to
> > > >> the
> > > >> > Feedback folder. I left some questions in marginal comments.
> > > >> > I have now taken Chapter 7 for first review.
> > > >> > Jean
> > > >> >
> > > >> > On Mon, Mar 9, 2020 at 2:49 PM Pulkit Krishna <[hidden email]
> > > >> >
> > > >> > wrote:
> > > >> > >
> > > >> > > Hello Jean,
> > > >> > > I have deleted the first 2 paragraphs on which you commented in
> > > >> chapter 5
> > > >> > > of Base Guide. But for your third comment on the note, the not
> is
> > > >> still
> > > >> > > true. I have uploaded the file back to the draft folder and have
> > > >> updated
> > > >> > > the spreadsheet.
> > > >> > >
> > > >> > > Pulkit Krishna
> > > >> > >
> > > >> > > On Mon, Mar 9, 2020 at 8:59 AM Jean Weber [via Document
> > Foundation
> > > >> Mail
> > > >> > > Archive] <[hidden email]
> > > >> > wrote:
> > > >> > >
> > > >> > > > I have reviewed Chapter 5, updated styles, and returned it to
> > the
> > > >> > > > Feedback folder. I left three questions in marginal comments.
> > > >> > > > I have now taken Chapter 6 for first review.
> > > >> > > > Jean
> > > >> > > >
> > > >> > > > On Sat, Mar 7, 2020 at 5:26 PM Jean Weber <[hidden email]
> > > >> > > > >
> > wrote:
> > > >> > > >
> > > >> > > > >
> > > >> > > > > I've taken Chapter 5 for review.
> > > >> > > > > Jean
> > > >> > > > >
> > > >> > > > > On Sat, Mar 7, 2020 at 4:07 PM Pulkit Krishna <[hidden
> email]
> > > >> > > > >
> > wrote:
> > > >> > > > > >
> > > >> > > > > > Hello Dan and Jean,
> > > >> > > > > > To Dan:
> > > >> > > > > > Are you done with the review of chapter 4. How much time
> > will
> > > >> you
> > > >> > > > take?
> > > >> > > > > > Kindly add the expected return date to the spreadsheet.
> > > >> > > > > > To Jean:
> > > >> > > > > > You can take chapter 5 for its first review.
> > > >> > > > > >
> > > >> > > > > >
> > > >> > > > > > Pulkit Krishna
> > > >> >
> > > >> > --
> > > >> > To unsubscribe e-mail to: [hidden email]
> > > >> 
> > > >> > Problems?
> > > >> >
> > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > >> > Posting guidelines + more:
> > > >> 

Re: [libreoffice-documentation] Re: LibreOffice Base Documentation

[Drew Jensen]

No problem.

I downloaded BH6206-Reports_PK_JHW_20200311.odt from the feedback directory
about an hour ago.

There are still a number of comments, about excising parts of the text, in
this file.

However if you have it with changes made I'll not worry about it.

Either way, I'm off to bed in a few minutes and will check back here in the
morning before I do anything with this file, OK.

Thanks

On Wed, Mar 11, 2020 at 1:19 AM Pulkit Krishna 
wrote:

> The last messege was supposed to be for Drew.
>
> Pulkit Krishna
>
>
> On Wed, Mar 11, 2020 at 10:48 AM Pulkit Krishna  >
> wrote:
>
> > Hello Jensen,
> > I don't understand what you are saying. I have done everything that Jean
> > said and I am uploading the chapter back to draft folder. You can take
> the
> > chapter for its second review. You can also take chapter 5 for its second
> > review or chapter 8-12 for its first review.
> >
> > Pulkit Krishna
> >
> > On Wed, Mar 11, 2020 at 10:34 AM drew-gmail [via Document Foundation Mail
> > Archive]  wrote:
> >
> >> Howdy,
> >>
> >> I've grabbed chapter 6 and read the comments over once.
> >>
> >> Too a quick look at the comments.
> >>
> >> Will read over again in the morning and make the changes, will post back
> >> here when it is back in the feedback folder.
> >>
> >> Drew
> >>
> >> On Tue, Mar 10, 2020 at 9:18 PM Jean Weber <[hidden email]
> >> > wrote:
> >>
> >> > I have reviewed Chapter 6 (Reports), updated styles, and returned it
> to
> >> the
> >> > Feedback folder. I left some questions in marginal comments.
> >> > I have now taken Chapter 7 for first review.
> >> > Jean
> >> >
> >> > On Mon, Mar 9, 2020 at 2:49 PM Pulkit Krishna <[hidden email]
> >> >
> >> > wrote:
> >> > >
> >> > > Hello Jean,
> >> > > I have deleted the first 2 paragraphs on which you commented in
> >> chapter 5
> >> > > of Base Guide. But for your third comment on the note, the not is
> >> still
> >> > > true. I have uploaded the file back to the draft folder and have
> >> updated
> >> > > the spreadsheet.
> >> > >
> >> > > Pulkit Krishna
> >> > >
> >> > > On Mon, Mar 9, 2020 at 8:59 AM Jean Weber [via Document Foundation
> >> Mail
> >> > > Archive] <[hidden email]
> >> > wrote:
> >> > >
> >> > > > I have reviewed Chapter 5, updated styles, and returned it to the
> >> > > > Feedback folder. I left three questions in marginal comments.
> >> > > > I have now taken Chapter 6 for first review.
> >> > > > Jean
> >> > > >
> >> > > > On Sat, Mar 7, 2020 at 5:26 PM Jean Weber <[hidden email]
> >> > > > > wrote:
> >> > > >
> >> > > > >
> >> > > > > I've taken Chapter 5 for review.
> >> > > > > Jean
> >> > > > >
> >> > > > > On Sat, Mar 7, 2020 at 4:07 PM Pulkit Krishna <[hidden email]
> >> > > > > wrote:
> >> > > > > >
> >> > > > > > Hello Dan and Jean,
> >> > > > > > To Dan:
> >> > > > > > Are you done with the review of chapter 4. How much time will
> >> you
> >> > > > take?
> >> > > > > > Kindly add the expected return date to the spreadsheet.
> >> > > > > > To Jean:
> >> > > > > > You can take chapter 5 for its first review.
> >> > > > > >
> >> > > > > >
> >> > > > > > Pulkit Krishna
> >> >
> >> > --
> >> > To unsubscribe e-mail to: [hidden email]
> >> 
> >> > Problems?
> >> >
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >> > Posting guidelines + more:
> >> https://wiki.documentfoundation.org/Netiquette
> >> > List archive:
> >> https://listarchives.libreoffice.org/global/documentation/
> >> > Privacy Policy: https://www.documentfoundation.org/privacy
> >> >
> >>
> >> --
> >> To unsubscribe e-mail to: [hidden email]
> >> 
> >> Problems?
> >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >> Posting guidelines + more:
> https://wiki.documentfoundation.org/Netiquette
> >> List archive:
> https://listarchives.libreoffice.org/global/documentation/
> >> Privacy Policy: https://www.documentfoundation.org/privacy
> >>
> >>
> >> --
> >> If you reply to this email, your message will be added to the discussion
> >> below:
> >>
> >>
> http://document-foundation-mail-archive.969070.n3.nabble.com/LibreOffice-Base-Documentation-tp4274898p4275274.html
> >> To start a new topic under Documentation, email
> >> ml+s969070n1645240...@n3.nabble.com
> >> To unsubscribe from Documentation, click here
> >> <
> http://document-foundation-mail-archive.969070.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code=1645240=cHVsa2l0a3Jpc2huYTAwQGdtYWlsLmNvbXwxNjQ1MjQwfDE3MjYzNzY0MzI=
> >
> >> .
> >> NAML
> >> <
> 

Re: [libreoffice-documentation] Re: LibreOffice Base Documentation

[Drew Jensen]

Howdy,

I've grabbed chapter 6 and read the comments over once.

Too a quick look at the comments.

Will read over again in the morning and make the changes, will post back
here when it is back in the feedback folder.

Drew

On Tue, Mar 10, 2020 at 9:18 PM Jean Weber  wrote:

> I have reviewed Chapter 6 (Reports), updated styles, and returned it to the
> Feedback folder. I left some questions in marginal comments.
> I have now taken Chapter 7 for first review.
> Jean
>
> On Mon, Mar 9, 2020 at 2:49 PM Pulkit Krishna 
> wrote:
> >
> > Hello Jean,
> > I have deleted the first 2 paragraphs on which you commented in chapter 5
> > of Base Guide. But for your third comment on the note, the not is still
> > true. I have uploaded the file back to the draft folder and have updated
> > the spreadsheet.
> >
> > Pulkit Krishna
> >
> > On Mon, Mar 9, 2020 at 8:59 AM Jean Weber [via Document Foundation Mail
> > Archive]  wrote:
> >
> > > I have reviewed Chapter 5, updated styles, and returned it to the
> > > Feedback folder. I left three questions in marginal comments.
> > > I have now taken Chapter 6 for first review.
> > > Jean
> > >
> > > On Sat, Mar 7, 2020 at 5:26 PM Jean Weber <[hidden email]
> > > > wrote:
> > >
> > > >
> > > > I've taken Chapter 5 for review.
> > > > Jean
> > > >
> > > > On Sat, Mar 7, 2020 at 4:07 PM Pulkit Krishna <[hidden email]
> > > > wrote:
> > > > >
> > > > > Hello Dan and Jean,
> > > > > To Dan:
> > > > > Are you done with the review of chapter 4. How much time will you
> > > take?
> > > > > Kindly add the expected return date to the spreadsheet.
> > > > > To Jean:
> > > > > You can take chapter 5 for its first review.
> > > > >
> > > > >
> > > > > Pulkit Krishna
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] I'm using libreoffice viewer. I want to write a guide on it

[Drew Jensen]

Hi,

If you are referring to the Android LibreOffice viewer that package has
been retracted from the App store.

Not sure it is every coming back.

Best wishes,

Drew

On Sat, Feb 29, 2020 at 10:57 AM Utkarsh Singh <7878utka...@gmail.com>
wrote:

>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Re: Change to Base Guide Supplemental to include Firebird engine example files

[Drew Jensen]

On Mon, Feb 24, 2020 at 12:44 AM Jean Weber  wrote:

> Drew,
> Doing that for BG7.0 is a good idea.
> I assume you are keeping notes on what to do to fix up those things
> which would not migrate
> automagically. Might be a useful appendix to the book? Or... something.
>
> Indeed - there is already a page on the wiki, thanks Beluga, Robert,
Ohallot, K-J and Dan. I'll look to that and if there is anything to
contribute will update the page.

Best wishes,

Drew

> Jean
>
> On Mon, Feb 24, 2020 at 10:16 AM Drew Jensen 
> wrote:
> >
> > On Sun, Feb 23, 2020 at 4:45 PM Drew Jensen 
> > wrote:
> >
> > > Howdy,
> > >
> > > As you know starting with 6.4 both the HSQL and Firebird embedded
> > > databases are supported by default in the application.
> > >
> > > What I propose is to create two folders in the supplemental (HSQL and
> > > Firebird) under the 6.2 guide section each folder holding like named
> odb
> > > files, even though I don't expect the 6.2 guide will mention them -
> this
> > > way they are available for anyone to compare one against the other.
> > >
> >
> > Actually there is another way which may make much more sense.
> >
> > Leave the files in the Base Guide 6.2 folder untouched.
> >
> > Create a Base Guide 7.0 instead which supplemental/hsql and
> > supplemental/firebird folders and I suppose for the moment nothing else.
> >
> > I think that makes more sense.
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Re: Change to Base Guide Supplemental to include Firebird engine example files

[Drew Jensen]

sorry that wiki page is at
https://wiki.documentfoundation.org/Documentation/HowTo/MigrateFromHSQLDB

On Mon, Feb 24, 2020 at 2:45 PM Drew Jensen 
wrote:

>
>
> On Mon, Feb 24, 2020 at 12:44 AM Jean Weber  wrote:
>
>> Drew,
>> Doing that for BG7.0 is a good idea.
>> I assume you are keeping notes on what to do to fix up those things
>> which would not migrate
>> automagically. Might be a useful appendix to the book? Or... something.
>>
>> Indeed - there is already a page on the wiki, thanks Beluga, Robert,
> Ohallot, K-J and Dan. I'll look to that and if there is anything to
> contribute will update the page.
>
> Best wishes,
>
> Drew
>
>> Jean
>>
>> On Mon, Feb 24, 2020 at 10:16 AM Drew Jensen 
>> wrote:
>> >
>> > On Sun, Feb 23, 2020 at 4:45 PM Drew Jensen > >
>> > wrote:
>> >
>> > > Howdy,
>> > >
>> > > As you know starting with 6.4 both the HSQL and Firebird embedded
>> > > databases are supported by default in the application.
>> > >
>> > > What I propose is to create two folders in the supplemental (HSQL and
>> > > Firebird) under the 6.2 guide section each folder holding like named
>> odb
>> > > files, even though I don't expect the 6.2 guide will mention them -
>> this
>> > > way they are available for anyone to compare one against the other.
>> > >
>> >
>> > Actually there is another way which may make much more sense.
>> >
>> > Leave the files in the Base Guide 6.2 folder untouched.
>> >
>> > Create a Base Guide 7.0 instead which supplemental/hsql and
>> > supplemental/firebird folders and I suppose for the moment nothing else.
>> >
>> > I think that makes more sense.
>>
>> --
>> To unsubscribe e-mail to:
>> documentation+unsubscr...@global.libreoffice.org
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/documentation/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Change to Base Guide Supplemental to include Firebird engine example files

[Drew Jensen]

On Mon, Feb 24, 2020 at 1:36 AM Robert Großkopf 
wrote:

> Hi Drew,
>
> I have migated many of the databases to Firebird but havent translated
> these databases to English. The main problem is to migrate the queries
> and the views.
>

So far the queries have not been all that bad. The views are a bit of a
different story. But I've only touched one of those so far.


>
> But there is another discussion to set creation of Firebird back to
> experimental, because there are many bugs and nobody, who has time to
> fix these bugs:
>
> http://document-foundation-mail-archive.969070.n3.nabble.com/About-putting-Firebird-creation-option-experimental-td4274028.html


Darn, seems I was no longer signed up for the DEV ML. Fixed now.

Anyway, I pulled yesterday's builds for 6.4.2 and 7.0. This change has
already landed in 7 but not the 6.4 build.


>
>
> I will change the content of the Base-Handbuch a little bit, because
> there are many people, who have started with Firebird, which is
> described as the future of LO-Base there. But there is nearly no
> developement the last year and the bugs are almost the same. So I won't
> recommend people to change to Firebird.
>
> Fortunately with the change a user can open and run an embedded Firebird
file from a default install, just can't create new ones without first
turning on experimental features.

For myself I'm going continue on, if for no other reason it is a good way
to exercise the 7.0 code against Base. That already yielded one issue, as
you know, and there may be more.

Best wishes,

Drew


> Regards
>
> Robert
> --
> Homepage: https://www.familiegrosskopf.de/robert
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Re: Change to Base Guide Supplemental to include Firebird engine example files

[Drew Jensen]

On Sun, Feb 23, 2020 at 4:45 PM Drew Jensen 
wrote:

> Howdy,
>
> As you know starting with 6.4 both the HSQL and Firebird embedded
> databases are supported by default in the application.
>
> What I propose is to create two folders in the supplemental (HSQL and
> Firebird) under the 6.2 guide section each folder holding like named odb
> files, even though I don't expect the 6.2 guide will mention them - this
> way they are available for anyone to compare one against the other.
>

Actually there is another way which may make much more sense.

Leave the files in the Base Guide 6.2 folder untouched.

Create a Base Guide 7.0 instead which supplemental/hsql and
supplemental/firebird folders and I suppose for the moment nothing else.

I think that makes more sense.

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Change to Base Guide Supplemental to include Firebird engine example files

[Drew Jensen]

Howdy,

As you know starting with 6.4 both the HSQL and Firebird embedded databases
are supported by default in the application.

It seemed like a good idea to begin by offering the same set of example
databases using a Firebird RDBMS as currently exist for HSQLdb.

I've add Robert G. to CC on this email because it could be that he has
already done what I've just started.

Two days ago I started the conversion of the set of files to Firebird.

The initial step was to run each through the Migration assistant, this
rendered all files with migrated data tables.

Now comes the task of fixing up those things which would not migrate
automagically. Some views in a few of the files, queries and embedded SQL
in components and macros.

What I propose is to create two folders in the supplemental (HSQL and
Firebird) under the 6.2 guide section each folder holding like named odb
files, even though I don't expect the 6.2 guide will mention them - this
way they are available for anyone to compare one against the other.

I thought I'd start by putting this batch of files, as is, to the Firebird
folder with a calc file listing which are finished and which still need
work.

If there is no objection.

Thanks

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Getting Started Preface

[Drew Jensen]

oops - to correct the record from my last email.

Went back to make sure I hadn't erred and I had.
The odb was erroneously upload to the draft folder (for the base handbook)
and not feedback.
I can't say if there had been anything in that feedback directory or not
when I did that.
The odb file has been moved from draft to the feedback directory now.

On Sat, Feb 22, 2020 at 11:34 PM Drew Jensen 
wrote:

> weird - am on the server right now and just checked the feedback folder
> where I uploaded that odb file a few minutes ago.
>
> Right now that folder is reporting as empty - but it wasn't 15 minutes ago.
>
> On Sat, Feb 22, 2020 at 11:13 PM Jean Weber  wrote:
>
>> I do not see the Preface file in the Published folder for Getting
>> Started v6.4. I'm sure it was there before (and it's listed on the
>> Status spreadsheet as being there), but it isn't there now. Anyone
>> know what's going on?
>>
>> Jean
>>
>> --
>> To unsubscribe e-mail to:
>> documentation+unsubscr...@global.libreoffice.org
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/documentation/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Getting Started Preface

[Drew Jensen]

weird - am on the server right now and just checked the feedback folder
where I uploaded that odb file a few minutes ago.

Right now that folder is reporting as empty - but it wasn't 15 minutes ago.

On Sat, Feb 22, 2020 at 11:13 PM Jean Weber  wrote:

> I do not see the Preface file in the Published folder for Getting
> Started v6.4. I'm sure it was there before (and it's listed on the
> Status spreadsheet as being there), but it isn't there now. Anyone
> know what's going on?
>
> Jean
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Re: Base Guide Supplemental

[Drew Jensen]

actually I decided to answer my own question.

The file Example_Report_Bill_DJ_20200221.odb is in the feedback folder.

On Sat, Feb 22, 2020 at 10:37 PM Drew Jensen 
wrote:

> Howdy,
>
> Found a small single line typo in the macro, called from the example form,
> in Example_Report_Bill.odb. Fixed it and the form now runs the report as
> expected.
>
> How would you prefer to handle this, do you want these in the feedback
> folder also?
>
> Drew
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Base Guide Supplemental

[Drew Jensen]

Howdy,

Found a small single line typo in the macro, called from the example form,
in Example_Report_Bill.odb. Fixed it and the form now runs the report as
expected.

How would you prefer to handle this, do you want these in the feedback
folder also?

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Re: OpenCL entry in latest help system

[Drew Jensen]

I wanted to follow up on this.

Looking at the text from the 6.1 listing and the current entry in the 6.4
help it seems like one could just move the missing references from one to
the other as the first step.

It looks like that should be reasonably easy for someone like me to do
given the new tools for working on the help system.

So, what about that - should I just move, as is, the parts from the 6.1
help files to the current section in 6.4 for the OpenCL entry?

I'll do that tomorrow afternoon if there is no objection here.

Best wishes,

Drew

On Wed, Feb 19, 2020 at 3:11 PM Drew Jensen 
wrote:

> Howdy,
>
> Recently I needed to work the OpenCL setting in LibreOffice and had cause
> to check the help system.
> Under LibreOffice 6.4 help files:
>
> file:///home/drew/liboQA/libreoffice6.4/help/en-US/text/shared/optionen/opencl.html?DbPAR=SHARED#bm_id4077578
>
> There is very little information, not even listing the different
> options available in the Advanced Settings section for OpenCL.
>
> While back at release 6.1 there was a bit more information, see this old
> page:
>
> https://help.libreoffice.org/6.1/en-US/text/scalc/05/OpenCL_options.html?DbPAR=CALC
>
> So I was wondering if that was an oversight or was their a decision to par
> down the information i the help system?
>
> Thanks
>
> Drew
>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] OpenCL entry in latest help system

[Drew Jensen]

Howdy,

Recently I needed to work the OpenCL setting in LibreOffice and had cause
to check the help system.
Under LibreOffice 6.4 help files:
file:///home/drew/liboQA/libreoffice6.4/help/en-US/text/shared/optionen/opencl.html?DbPAR=SHARED#bm_id4077578

There is very little information, not even listing the different
options available in the Advanced Settings section for OpenCL.

While back at release 6.1 there was a bit more information, see this old
page:
https://help.libreoffice.org/6.1/en-US/text/scalc/05/OpenCL_options.html?DbPAR=CALC

So I was wondering if that was an oversight or was their a decision to par
down the information i the help system?

Thanks

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Changing content of FAQ Base

[Drew Jensen]

Howdy,

+1 for delete them.

On Fri, Feb 7, 2020 at 6:40 AM Ilmari Lauhakangas <
ilmari.lauhakan...@libreoffice.org> wrote:

> Drew Jensen kirjoitti 6.2.2020 klo 15.39:
> > On Wed, Feb 5, 2020 at 2:28 PM Robert Großkopf <
> rob...@familiegrosskopf.de>
> > wrote:
> >> I have tested connection to PostgreSQL for a German user:
> >>
> >> https://wiki.documentfoundation.org/Faq/Base/013
> >> isn't up to date. ODBC-connection works here without problems with
> >> UnixODBC. The answer doesen't give a hint which system is used, so I
> >> couldn't find such a version here.
> >>
> > Well, since the only version that gave that error was the version listed
> I
> > don't know that it is not correct.
> > In other words, if you aren't using that old driver then this is a moot
> > question because you aren't getting that error.
> >>
> >> https://wiki.documentfoundation.org/Faq/Base/014
> >> Same problem. ODBC works as expected, better than JDBC-connection. With
> >> ODBC-connection you could input data in queries with table-alias and
> >> datatype serial. Using JDBC-connection the autoincremented value will
> >> only return 0.
> >>
> > Same situation here - the question is the problem. It is a question
> caused
> > by an old driver, one that is now deprecated.
> >>
> >> https://wiki.documentfoundation.org/Faq/Base/015
> >> same problem as FAQ Base 13
> >>
> >
> > Yes, again this is a question based on a specific driver release and a
> > driver that is now well past what is current.
> >
> > So, overall I think the question is really;
> > Do we want to delete those questions as no longer being useful?
>
> While looking at the FAQ due to all the translation work, I did delete
> some obsolete questions. If there is consensus, I can click the buttons
> to get rid of these particular items.
>
> To answer a question in Robert's original mail, you can simply edit any
> FAQ article as you would a normal wiki page.
>
> Ilmari
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Changing content of FAQ Base

[Drew Jensen]

On Wed, Feb 5, 2020 at 2:28 PM Robert Großkopf 
wrote:

> Hi Drew,
> >
> > Looks like folks are just humming along with the guides.
> >
> > If you could list here the questions which you see as having wrong
> answers
> > on the EN faq page I'd take a quick look and try to clean up the answers,
> > that way the folks working the guides don't have to break their stride.
> > (of if you want to use irc or jitsi to do so that would work also)
>
> I have tested connection to PostgreSQL for a German user:
>
> https://wiki.documentfoundation.org/Faq/Base/013
> isn't up to date. ODBC-connection works here without problems with
> UnixODBC. The answer doesen't give a hint which system is used, so I
> couldn't find such a version here.
>

Well, since the only version that gave that error was the version listed I
don't know that it is not correct.
In other words, if you aren't using that old driver then this is a moot
question because you aren't getting that error.



>
> https://wiki.documentfoundation.org/Faq/Base/014
> Same problem. ODBC works as expected, better than JDBC-connection. With
> ODBC-connection you could input data in queries with table-alias and
> datatype serial. Using JDBC-connection the autoincremented value will
> only return 0.
>

Same situation here - the question is the problem. It is a question caused
by an old driver, one that is now deprecated.


>
> https://wiki.documentfoundation.org/Faq/Base/015
> same problem as FAQ Base 13
>

Yes, again this is a question based on a specific driver release and a
driver that is now well past what is current.

So, overall I think the question is really;
Do we want to delete those questions as no longer being useful?




> Regards
>
> Robert
> --
> Homepage: https://www.familiegrosskopf.de/robert
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Changing content of FAQ Base

[Drew Jensen]

Howdy Robert,

Looks like folks are just humming along with the guides.

If you could list here the questions which you see as having wrong answers
on the EN faq page I'd take a quick look and try to clean up the answers,
that way the folks working the guides don't have to break their stride.
(of if you want to use irc or jitsi to do so that would work also)

Best wishes

Drew

Drew



On Wed, Feb 5, 2020 at 1:20 PM Robert Großkopf 
wrote:

> Hi *,
>
> sometimes ago I translated most of the content of FAQ Base into German.
> Now I noticed there werde wrong answers in the FAQ. Could there has been
> changed something since the first time anybody wrote the FAQ. What is
> the way to upadte the FAQ?
> 1. Change the content in English FAQ and automatically change the
> content in all other translated languages? Then I have to wait, because
> my English isn't good enough for this.
> 2. Change content in the German FAQ and write here in this list there
> has to be changed something?
>
> Regards
>
> Robert
> --
> Homepage: https://www.familiegrosskopf.de/robert
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Firebird in Base

[Drew Jensen]

To follow up on that .

Downloaded 7.0 alpha and it is the same as 6.4 for now.

The migration assistant offers the chance to review a wiki page with
information about it, at
https://wiki.documentfoundation.org/Documentation/HowTo/MigrateFromHSQLDB

Which thanks mostly to Robert G. I believe has lots of good information
about it.

HTH

Drew

On Tue, Jan 28, 2020 at 11:18 PM Drew Jensen 
wrote:

> Howdy,
>
> I can only pass on what I see in 6.4 right now.
>
> On fresh install
> - HSQLdb is still the default, but Firebird is available
> - Opening an hsql based file does not trigger the migration assistant
>
> Turn on Experimental features:
> - Firebird becomes the default engine.
> - connecting to an HSQL based base file will trigger the migration
> assistant
> -- this includes opening the HSQL based base file in any way, mail merge,
> from the beamer window and vie the Base GUI.
>
> Best wishes,
>
> Drew
>
> On Tue, Jan 28, 2020 at 11:09 PM Jean Weber  wrote:
>
>> Release notes and related blog posts for Base 6.x say Firebird Embedded is
>> now the default, and DB files created using HSQLDB should be migrated to
>> Firebird. A Firebird Migration Assistant is mentioned. I’ve seen nothing
>> more about this (I may not be looking in the right places) and wonder how
>> much should be said in Getting Started Guide chapter on Base. Please
>> advise. Thanks.
>>
>> Jean
>>
>> --
>> To unsubscribe e-mail to:
>> documentation+unsubscr...@global.libreoffice.org
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/documentation/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Firebird in Base

[Drew Jensen]

Howdy,

I can only pass on what I see in 6.4 right now.

On fresh install
- HSQLdb is still the default, but Firebird is available
- Opening an hsql based file does not trigger the migration assistant

Turn on Experimental features:
- Firebird becomes the default engine.
- connecting to an HSQL based base file will trigger the migration assistant
-- this includes opening the HSQL based base file in any way, mail merge,
from the beamer window and vie the Base GUI.

Best wishes,

Drew

On Tue, Jan 28, 2020 at 11:09 PM Jean Weber  wrote:

> Release notes and related blog posts for Base 6.x say Firebird Embedded is
> now the default, and DB files created using HSQLDB should be migrated to
> Firebird. A Firebird Migration Assistant is mentioned. I’ve seen nothing
> more about this (I may not be looking in the right places) and wonder how
> much should be said in Getting Started Guide chapter on Base. Please
> advise. Thanks.
>
> Jean
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] ODF v1.2 vs ODF v1.2 extended

[Drew Jensen]

Excellent and thanks once again.



On Tue, Jan 21, 2020 at 8:45 PM Regina Henschel 
wrote:

> Hi Drew,
>
> Drew Jensen schrieb am 22-Jan-20 um 00:22:
> > Howdy,
> >
> > Can anyone point me in the direction of any details on what is different
> > between the two file formats ODF v1.2 and ODF v1.2 extended, for example
> > what features are lost by going to the strict version of the standard
> > rather then the LO specific extended version?
> >
>
> You can compare the standard ODF 1.2 schema with the schema used by
> LibreOffice extended.
>
> https://opengrok.libreoffice.org/xref/core/schema/odf1.2/OpenDocument-v1.2-os-schema.rng
> or for upcoming ODF 1.3
>
> https://docs.oasis-open.org/office/OpenDocument/v1.3/cs01/schemas/OpenDocument-schema-v1.3.rng
>
> and
>
> https://opengrok.libreoffice.org/xref/core/schema/libreoffice/OpenDocument-schema-v1.3%2Blibreoffice.rng
>
> Look for the namespaces, which are not included in the rng-file of the
> standard. And then find all elements and attributes, which use these
> namespaces.
> Some of the extensions will be include in ODF 1.3.
>
> And similar compare
>
> https://docs.oasis-open.org/office/OpenDocument/v1.3/cs01/schemas/OpenDocument-manifest-schema-v1.3.rng
> and
>
> https://opengrok.libreoffice.org/xref/core/schema/libreoffice/OpenDocument-manifest-schema-v1.3%2Blibreoffice.rng
>
> A list of extensions, but unfortunately not guaranteed to be complete,
> is in
>
> https://wiki.documentfoundation.org/Development/ODF_Implementer_Notes/List_of_LibreOffice_ODF_Extensions
>
> Kind regards
> Regina
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Saving as OOXML strict vs transitional

[Drew Jensen]

Howdy Regina,

Thank you very much.

On Tue, Jan 21, 2020 at 8:23 PM Regina Henschel 
wrote:

> Hi Drew,
>
> Drew Jensen schrieb am 22-Jan-20 um 00:06:
> > Howdy,
> >
> > I searched the Writer Guide and the ask forum with no luck on this
> question.
> >
> > In LibreOffice I would like save (export) files to the OOXML format. I
> > would like to if possible create OOXML strict files vs transitional
> files.
> >
> > Now in the Save As dialog there are a number of different choices for
> .docx
> > (as one example) file type.
> >
> > Two of these is "Word 2007-265 (.docx)" / "Word 2007-365 (.docm) and I'm
> > going out on a limb and guessing these generate 'transitional' files.
> >
> > The other choice is "Office Open XML Text (.docx)" and I'm going to guess
> > this is 'strict'.
> >
> > Can anyone tell if that is correct?
>
> No, it is not 'strict'. To be "strict" it would need an attribute
> conformance="strict". If that is missing it is "transitional". The
> attribute should be in subfile word/document.xml in node w:document.
> Same for presentations. There it should be in subfile
> ppt/presentation.xml in node p.presentation.
>
> For presentations exists roundtrip bug
> https://bugs.documentfoundation.org/show_bug.cgi?id=119087.
>
> Kind regards
> Regina
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] ODF v1.2 vs ODF v1.2 extended

[Drew Jensen]

Howdy,

Can anyone point me in the direction of any details on what is different
between the two file formats ODF v1.2 and ODF v1.2 extended, for example
what features are lost by going to the strict version of the standard
rather then the LO specific extended version?

Thanks for your help,

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Saving as OOXML strict vs transitional

[Drew Jensen]

Howdy,

I searched the Writer Guide and the ask forum with no luck on this question.

In LibreOffice I would like save (export) files to the OOXML format. I
would like to if possible create OOXML strict files vs transitional files.

Now in the Save As dialog there are a number of different choices for .docx
(as one example) file type.

Two of these is "Word 2007-265 (.docx)" / "Word 2007-365 (.docm) and I'm
going out on a limb and guessing these generate 'transitional' files.

The other choice is "Office Open XML Text (.docx)" and I'm going to guess
this is 'strict'.

Can anyone tell if that is correct?

Thanks so much for you help.

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] ODF formats

[Drew Jensen]

Howdy,

The ODF v.13 has been released by OASIS as a specification.

OASIS is not the actual standards authority, that would be ISO
(International Standards Organization).

So at the moment the v1.3 specification is available for implementing
vendors to work with and test.

That is reason, to be the best of my knowledge, why it is an option in this
release but not the default yet.

Best wishes,

Drew


On Tue, Jan 14, 2020 at 3:52 PM Stephen Fanning 
wrote:

> All,
>
> I have noticed a cause of potential confusion in the Tools - Options -
> Load/Save - General dialog page.
>
> On this page the user is able to select the ODF format version.
> (1) The default setting is the option "1.2 Extended".
> (2) The menu also contains an entry entitled "1.3 Extended (recommended)".
> (3) Below the selection menu is a note which reads "Not using ODF 1.3
> Extended may cause information to be lost".
>
> So we appear to be defaulting to an inferior option.
>
> Is this desirable or should it be considered for change (there may already
> be a bug that I haven't found yet)?
>
> If it isn't to be changed, what should be stated in the Getting Started
> Guide?
>
> Regards,
>
> Steve
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Tooltips

[Drew Jensen]

Howdy,

Those functions are currently not working, see open issue:
https://bugs.documentfoundation.org/show_bug.cgi?id=120538



On Thu, Jan 9, 2020 at 9:05 AM Stephen Fanning 
wrote:

> Please could anybody give me simple example in Calc or Writer showing the
> impact of selecting / deselecting the *Tools > Options > LibreOffice >
> General > Help > Extended tips* option? I have yet to find a control which
> gives a different tooltip dependent on this setting.
>
> In a similar way, could anybody give me an example which shows the impact
> of selecting *Help > What’s This?*
>
> Thanks in anticipation!
>
> Steve
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Calc Guide published

[Drew Jensen]

Thank you

I hope it is Ok that I just went ahead and used both of the links shown for
a couple of SM posts (instead of the
https://documentaiton.libreoffice.org/en link).

Best wishes,

Drew

On Sat, Dec 28, 2019 at 5:22 AM Jean Weber  wrote:

> The full book and individual chapters, in ODT and PDF, are on the wiki as
> well as NextCloud.  Olivier or someone will update the Docs page of the LO
> website.
>
> https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
>
> Printed copies are available from Lulu.
>
> http://www.lulu.com/content/paperback-book/libreoffice-62-calc-guide/26019667
>
> I still have some things to do, including making the master doc available
> on NextCloud.
> Some chapters were not reviewed by two people, but they looked good to me.
> If any further reviews are done and result in changes, the PDFs can be
> regenerated.
>
> I did not include an index, because many (most?) chapters’ indexing is
> incomplete and not updated. If/when they are done, we can recreate a book
> PDF with an index. It’s really only needed for the print edition, IMO.
>
> I changed the order of the last two appendixes, putting Calc Functions at
> the end of the book.
>
> Cheers, Jean
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Broken link on main website documentation page

[Drew Jensen]

Howdy,

Today look at this page on the main website:
https://documentation.libreoffice.org/en/english-documentation/

and clicking on the 'LibreOffice Online 6.3' document generates an error
message:

No webpage was found for the web address:
https://nextcloud.documentfoundation.org/s/BBkk6QxBCfH47BH

Best wishes,

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] LOOL and Draw

[Drew Jensen]

Howdy,

Recently the Collabora folks released both and iOS and Android app based on
LOOL.

LOOL (web browser) and iOS Collabora Online continue to show only Writer,
Calc, and Impress as available. (even though you could always work with
existing Draw files with the web browser application)

While the newest package, Android Collabora Online now allows you to create
Writer, Calc, Impress and Draw.

I assume then that Draw should be included in any documentation going
forward starting with any LOOL based on the LibreOffice 6.4 code base -
anyone know if that is true?

Thanks

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Re: LibreOffice Online Guide

[Drew Jensen]

On Fri, Dec 13, 2019 at 2:55 PM Drew Jensen 
wrote:

> Howdy,
>
> A couple of quick questions and a comment on the OnLine Guide.
>
> I see that for the moment the Link from the Blog and from the website are
> to the pdf version of the guide only. I assume there will be a link coming
> also for the .odt/.svg/etc file that go into making the pdf, just checking?
>
> Secondly, and this is a little nit picky, but; In the guide it states that
> there are two versions of LOOL to choose from, one from TDF (LibreOffice
> Online) and one from Collabora (Collabora Online). The guide then says it
> will focus on installing and working with the TDF (LibreOffice Online)
> option but it appears the Guide actually points exclusively to the
> Collabora Online product. That is a bit confusing IMO.
>

Well, I suppose I see why it was a bit confusing: The Guide shows the
address for downloading the TDF supplied LOOL image but the NextCloud
integration piece (in the NextCloud software) refers to Collabora Online. I
assume that this will, if the instructions were followed, use the instance
of LOOL that was installed form TDF silently.


>
> My comment - nice job on this overall.
>
> Best wishes,
>
> Drew
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] LibreOffice Online Guide

[Drew Jensen]

Howdy,

A couple of quick questions and a comment on the OnLine Guide.

I see that for the moment the Link from the Blog and from the website are
to the pdf version of the guide only. I assume there will be a link coming
also for the .odt/.svg/etc file that go into making the pdf, just checking?

Secondly, and this is a little nit picky, but; In the guide it states that
there are two versions of LOOL to choose from, one from TDF (LibreOffice
Online) and one from Collabora (Collabora Online). The guide then says it
will focus on installing and working with the TDF (LibreOffice Online)
option but it appears the Guide actually points exclusively to the
Collabora Online product. That is a bit confusing IMO.

My comment - nice job on this overall.

Best wishes,

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Calc Guide Chapter 11 - 2nd review finished

[Drew Jensen]

Howdy,

Finished review of CG6211-SharingAndReviewing_JHW_KK_JHW_20190626.odt from
the feedback folder.

Looked good. Copy to Draft folder as CG6211-SharingAndReviewing.odt

File in feedback is now in archive folder and the progress spreadsheet
updated.

Best wishes,

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Calc Guide chapters 6 and 11

[Drew Jensen]

Will do the second review on Chapter 11.
Updated the spreadsheet just now, looks like it should be a quick review.


On Wed, Jun 26, 2019 at 12:26 AM Jean Weber  wrote:

> I have gone through Kees's review of these chapters (which I had
> updated) and accepted the changes.
> I have put the clean files in the Feedback folder, ready for someone
> else to review. They may be ready to be moved to Drafts.
> I have put Kees's edited files in the Archive folder.
> I have updated the status spreadsheet.
>
> --Jean
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] "Save preview image with document"

[Drew Jensen]

Howdy,

IIRC Thumbnails replace icons only when Medium, Large or Extra Large icons
are selected under MS Windows 10 (and maybe 7 also) Explorer.

Best wishes,

Drew

On Thu, Jun 20, 2019 at 5:12 AM Ilmari Lauhakangas <
ilmari.lauhakan...@libreoffice.org> wrote:

> On 20.06.2019 11:22, Jean Weber wrote:
> > The General page of the Document Properties dialog has a checkbox
> > labelled "Save preview image with this document". What is a preview
> > image in this context? Why would a user choose to turn it on or off?
> > Thank you!
>
> If we uncheck it, there will be no Thumbnails/thumbnail.png inside the
> saved file.
> I assumed this would have affected the Start center previews, but they
> seem to work fine without the thumbnail.
> I guess any file manager can make use of the thumbnails.
>
> Ilmari
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Creating a How To Migrate HSQL Base File wiki page for reference from LO 6.3 binary

[Drew Jensen]

Howdy,

Well, the LibreOffice 6.4 daily builds are available and the link to the,
currently empty, wiki page is included. (haven't found a 6.3 daily build
just yet, but I'm sure it will be there also when I do)

So, will put the beginnings of the page there this afternoon. Yes.

Best wishes,

Drew

On Sat, Jun 15, 2019 at 10:57 AM Drew Jensen 
wrote:

> Howdy,
>
> Yes, that sounds about right if you are talking about either the Migration
> Assistant or the standard Import Wizard (drag drop).
>
> The road I'm going down is to move the schema by changing the DDL and the
> data by changing the DML generated from the HSQLdb SCRIPT command.
>
> Then running the DDL statements and the data load via the DML statements
> in a new Firebird sdbc .odb. The queries, forms and reports come via drag
> drop.
>
> Best wishes,
>
> Drew
>
> On Sat, Jun 15, 2019 at 10:46 AM Robert Großkopf <
> rob...@familiegrosskopf.de> wrote:
>
>> Hi *,
>>
>> I have updated
>>
>> http://robert.familiegrosskopf.de/index.php?=hsqldb_firebird_migration
>>
>> Will see if I will get to explain most of the problems (and
>> workarounds), which will appear while migrating from HSQLDB to Firebird.
>> - Views aren't migrated
>> - Tablenames and columnnmes must have less than 32 characters
>> - Datefields, timefields and date-time-fields will be migrated with
>> wrong values depending on the timezone (HSQLDB-bug)
>> - Subforms and parameter-queries aren't working
>> - Some functions in queries must be migrated later by the user
>>
>> Could be there are more problems while migrating. I will test all this
>> with the databases of the German Base-Handbuch.
>>
>> Regards
>>
>> Robert
>> --
>> Homepage: http://robert.familiegrosskopf.de
>> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
>>
>>
>> --
>> To unsubscribe e-mail to:
>> documentation+unsubscr...@global.libreoffice.org
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/documentation/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Creating a How To Migrate HSQL Base File wiki page for reference from LO 6.3 binary

[Drew Jensen]

Howdy,

Yes, that sounds about right if you are talking about either the Migration
Assistant or the standard Import Wizard (drag drop).

The road I'm going down is to move the schema by changing the DDL and the
data by changing the DML generated from the HSQLdb SCRIPT command.

Then running the DDL statements and the data load via the DML statements in
a new Firebird sdbc .odb. The queries, forms and reports come via drag drop.

Best wishes,

Drew

On Sat, Jun 15, 2019 at 10:46 AM Robert Großkopf 
wrote:

> Hi *,
>
> I have updated
>
> http://robert.familiegrosskopf.de/index.php?=hsqldb_firebird_migration
>
> Will see if I will get to explain most of the problems (and
> workarounds), which will appear while migrating from HSQLDB to Firebird.
> - Views aren't migrated
> - Tablenames and columnnmes must have less than 32 characters
> - Datefields, timefields and date-time-fields will be migrated with
> wrong values depending on the timezone (HSQLDB-bug)
> - Subforms and parameter-queries aren't working
> - Some functions in queries must be migrated later by the user
>
> Could be there are more problems while migrating. I will test all this
> with the databases of the German Base-Handbuch.
>
> Regards
>
> Robert
> --
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Draw templates for use in annotating screen shots in the guides.

[Drew Jensen]

Howdy,

This came up a couple of times and again in yesterday's meeting.

The idea is to a consistent style to use across the guides when annotating
screen shots.

Taking a simple approach to start, created two Draw templates. Both have
default style for graphics objects area and line coloring set to LO Green
color used in the LO 6.x writer template and font Liberation Sans (12) with
default color which matches the Figure style in the writer template.

GreenWideTall.otg has a default page setting of 4" x 3.6" with .25" margin

GreenWideShort.otg has a default page settng of 4" x 1.68" with .25" margin

I put those up on the NC server along with a readme.txt and example
annotated image in a pdf file "Untitled 3.pdf".

Find all that here:
https://nextcloud.documentfoundation.org/s/R3Erbd3S2qDwfpJ

There is already a section in the existing Guide Authoring docs (currently
on the wiki) and I think tailoring a couple custom templates like these
would work out fairly well - so these are hear as a starting step for
that.

Thoughts?

Best wishes,

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Documentation Nextcloud file organization

[Drew Jensen]

Howdy,

I was thinking about another way to look at the nextcloud resource.

Looking at NextCloud resource as a defined set of access links and not a
set of folders in the cloud.

I've set up an example of this using a single document project with
everything in a non shared folder.

A file (link on a wiki page perhaps) for the overview, though this could be
an entry on the shared calendar also.

Spread sheet to mark activity on files
online edit only/no download
https://nextcloud.documentfoundation.org/s/YJyofYRrLxCn64w

Draft
read-only/download
https://nextcloud.documentfoundation.org/s/Hw5t3LaRoRLm64t
online-edit/no download
https://nextcloud.documentfoundation.org/s/LHPeMANLr3wownH

Feedback
Upload (drop box style) only
https://nextcloud.documentfoundation.org/s/MGrA4T8r9dFasw2

Published (maybe, but not necessarily on NC at all given what is already
used)
Read-only/download as odt or pdf
https://nextcloud.documentfoundation.org/s/adqpZ66zRFtWMsi

A Workflow then:

Review the files in the draft directory via the link.

Choose a file to make changes in and download it.

Update the activity spread sheet appropriately.

Make your changes offline with tracked changes on or off.

Name the file using the ODFAuthors naming scheme.

Upload the file to the feedback link address only (even if the file were
not renamed there is no chance of writing over an existing file)

Doc team members acting as editors for the document then need to review and
resolve the changes in the uploaded file. Best would be if the full set of
changes can be resolved then move it to the draft folder.

Now that I think replicates fairly closely the front of the ODFAuthors work
flow.

This workflow can change to offer content editors the option of working
online for small changes. If they are members of the LibreOffice
documentation team they are given access via their logon name; individuals
not part of the team can be handled by an email (or confederated from
another nextcloud server account) with a link for online only edit rights.

=

Thinking out loud here, right before the weekly meeting.

Best wishes

Drew

On Wed, Jun 5, 2019 at 1:45 AM  wrote:

> Jean Weber schreef op 04.06.2019 10:21:
> > On Tue, Jun 4, 2019 at 3:32 PM  wrote:
> >>
> >> Jean Weber schreef op 04.06.2019 04:15:
> >> > On Tue, 4 Jun 2019 at 03:21 Dave Barton 
> wrote:
> >> >
> >> >> Hi Folks,
> >> >>
> >> >> While uploading a reviewed chapter of the Calc Guide I looked around
> >> >> at
> >> >> the Nextcloud folder structure (or lack thereof) and it put me in
> mind
> >> >> of a moderately well stacked garbage dump.
> >> >>
> >> >> I will refrain from getting back on my soapbox about the naming of
> the
> >> >> folders, but I would like to propose that we create an "Archive"
> >> >> folder
> >> >> within the English > Calc Guide > 6.2 path and when a
> >> >> new/revised/reviewed file is added to either the "Feedback" or
> "Draft"
> >> >> folders it's predecessor is moved to the "Archive" folder. At the
> >> >> moment
> >> >> we have files (old and new) scattered around "Feedback" folder like
> >> >> confetti.
> >> >
> >> >
> >> > I totally agree. I was going to do that, but didn’t get to it.
> >> > JJean
> >>
> >> I also think this is a good idea, so I took the liberty to make the
> >> folder and move the old file to it.
> >> It can easily change back if some others don't like it.
> >> Is it also a good idea to move the files that are alreadey finished
> >> and
> >> are in Draft?
> >>
> >> Kind regards,
> >> Kees
> >
> > Yes, please do.
> > Jean
> Done
> Kees
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Creating a How To Migrate HSQL Base File wiki page for reference from LO 6.3 binary

[Drew Jensen]

Perfect!

That is the way to start this and a translation with update as needed will
cover that migration path.

Thanks,

Drew


On Fri, Jun 7, 2019 at 3:54 PM jean-francois <
jean-francois.nifenec...@laposte.net> wrote:

> Hi Drew,
>
> Le 07/06/2019 à 20:28, Drew Jensen a écrit :
> > To follow up on my last email and the point about getting folks to
> migrate
> > off the embedded HSQL Base file format to an external rdbms - we are
> > already most of the way there with an existing How To style post on I
> think
> > both the ASK site and the AOO hosted forums - I'm sure about the later -
> > wich shows how to use an external HSQL server for the data (with more
> going
> > on in that posts then is needed here). It would be a straightforward
> > process to use a big chunk of that updated for use as a one time
> migration
> > How To. I'm sure the author would have no problem with putting the
> content
> > to the secondary use and it would be as simple a migration as possible
> with
> > HSQL rdbms being both the old and new engine.
>
> I had written, a while back, such a document -- mostly in French --
> titled as "Base - How to get rid of embedded HSQLDB".
>
> This document is hosted by a friend of mine. You can download it from
> that page: https://numericoach.net/LibreOffice-Base-et-HSQLDB
>
>
> FWIW.
>
> Best regards,
> --
> Jean-Francois Nifenecker, Bordeaux
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Creating a How To Migrate HSQL Base File wiki page for reference from LO 6.3 binary

[Drew Jensen]

To follow up on my last email and the point about getting folks to migrate
off the embedded HSQL Base file format to an external rdbms - we are
already most of the way there with an existing How To style post on I think
both the ASK site and the AOO hosted forums - I'm sure about the later -
wich shows how to use an external HSQL server for the data (with more going
on in that posts then is needed here). It would be a straightforward
process to use a big chunk of that updated for use as a one time migration
How To. I'm sure the author would have no problem with putting the content
to the secondary use and it would be as simple a migration as possible with
HSQL rdbms being both the old and new engine.


On Fri, Jun 7, 2019 at 2:06 PM Drew Jensen 
wrote:

> Howdy Robert,
>
> Yes - for me that is exactly the point of this - to say 'DO THIS WITH A
> COPY' and then address the facts of the situation as they are.
>
> Firebird engine went live with the 6.2 release so that horse is already
> out of the barn, as some would put it.
>
> There exists a real desire by a good number of people, for what seems to
> me reasonable reasons, to remove support for current embedded HSQL database
> code in an expeditious fashion.
>
> This migration assistant piece is something that would be nice but it is
> not a requirement for many of those using Base files.
>
> What would be best now would be to put together some cogent, concise steps
> for folks to follow in moving off of the embedded HSQL Base file to a new
> Base file with the database schema and data moved to another system, which
> could be another embedded Base file using Firebird or could be to an
> external rdbms.
>
> It is also known exactly as to what causes problems for the current,
> assuming nothing is fixed before release, migration assistant code; so this
> can tell users check your files for the following and if you don't use any
> of  run the migration assistant with confidence.
> If they do have known problem files then offer them steps they can take
> today, or let them know they should wait for fixes to the migration
> assistant in later 6.3 releases.
>
> At least that is my thoughts.
>
> Best wishes
>
> Drew
>
>
> On Fri, Jun 7, 2019 at 1:51 PM Robert Großkopf 
> wrote:
>
>> Hi Drew,
>> >
>> > In the ESC meeting yesterday the question of including the Migration
>> > Assistant (MA) feature by default in the pending 6.3 release finished
>> with
>> > a decision to do so with one update the UI. Which would show the user a
>> > link, on the dialog box which starts the process, to a wiki page with
>> > detailed information on what was possible with MA presently and
>> information
>> > on how to perform a migration with or without use of the MA tool.
>>
>> Seems there have people decided to do this who didn't use any database
>> in LO. Migration has many unsolved problems and also the internal
>> Firebird new bugs, which doesn't exist in HSQLDB ...
>> And now we should inform how to migrate? I am missing arguments for this
>> step.
>> So much databases won't run well when migrating to Firebird with the
>> Migrating Assistant. I could inform how to migrate, but the first I
>> would write down: Do all this with a copy of your database and don't
>> wonder if you are missing views, queries won't run as expected etc. Is
>> this really the intention of this HowTo?
>>
>> Regards
>>
>> Robert
>> --
>> Homepage: http://robert.familiegrosskopf.de
>> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
>>
>>
>> --
>> To unsubscribe e-mail to:
>> documentation+unsubscr...@global.libreoffice.org
>> Problems?
>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/documentation/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Creating a How To Migrate HSQL Base File wiki page for reference from LO 6.3 binary

[Drew Jensen]

Howdy Robert,

Yes - for me that is exactly the point of this - to say 'DO THIS WITH A
COPY' and then address the facts of the situation as they are.

Firebird engine went live with the 6.2 release so that horse is already out
of the barn, as some would put it.

There exists a real desire by a good number of people, for what seems to me
reasonable reasons, to remove support for current embedded HSQL database
code in an expeditious fashion.

This migration assistant piece is something that would be nice but it is
not a requirement for many of those using Base files.

What would be best now would be to put together some cogent, concise steps
for folks to follow in moving off of the embedded HSQL Base file to a new
Base file with the database schema and data moved to another system, which
could be another embedded Base file using Firebird or could be to an
external rdbms.

It is also known exactly as to what causes problems for the current,
assuming nothing is fixed before release, migration assistant code; so this
can tell users check your files for the following and if you don't use any
of  run the migration assistant with confidence.
If they do have known problem files then offer them steps they can take
today, or let them know they should wait for fixes to the migration
assistant in later 6.3 releases.

At least that is my thoughts.

Best wishes

Drew


On Fri, Jun 7, 2019 at 1:51 PM Robert Großkopf 
wrote:

> Hi Drew,
> >
> > In the ESC meeting yesterday the question of including the Migration
> > Assistant (MA) feature by default in the pending 6.3 release finished
> with
> > a decision to do so with one update the UI. Which would show the user a
> > link, on the dialog box which starts the process, to a wiki page with
> > detailed information on what was possible with MA presently and
> information
> > on how to perform a migration with or without use of the MA tool.
>
> Seems there have people decided to do this who didn't use any database
> in LO. Migration has many unsolved problems and also the internal
> Firebird new bugs, which doesn't exist in HSQLDB ...
> And now we should inform how to migrate? I am missing arguments for this
> step.
> So much databases won't run well when migrating to Firebird with the
> Migrating Assistant. I could inform how to migrate, but the first I
> would write down: Do all this with a copy of your database and don't
> wonder if you are missing views, queries won't run as expected etc. Is
> this really the intention of this HowTo?
>
> Regards
>
> Robert
> --
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
>
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-documentation] Creating a How To Migrate HSQL Base File wiki page for reference from LO 6.3 binary

[Drew Jensen]

Howdy,

In the ESC meeting yesterday the question of including the Migration
Assistant (MA) feature by default in the pending 6.3 release finished with
a decision to do so with one update the UI. Which would show the user a
link, on the dialog box which starts the process, to a wiki page with
detailed information on what was possible with MA presently and information
on how to perform a migration with or without use of the MA tool.

Caolán McNamra was quick about setting up the code for that URL link (Thank
you!) and provisionally used a URL for the wiki page of:
https://wiki.documentfoundation.org/Documentation/HowTo/MigrateFromHSQLDB

That location makes sense IMO. Currently that page doesn't exist.

There was a page started for the migration assistant a while back at
https://wiki.documentfoundation.org/Documentation/FirebirdMigration I think
it would be best to retire that page, replaced by the new page under
Documentation/How To. It could be raided for some content of course, but
there isn't much there by way of a How To/Tutroial style anyway.

The new page will be setup to take advantage of the MediaWiki translation
extension. ( got some info on setting that up yesterday on IRC).

I thought about top level categories for the new page, which you can see
here https://wiki.documentfoundation.org/User:Drew/tmpMA

That is about it for this email which was mostly to kick this off and get
some wisdom and feedback form the team.

Best wishes,

Drew

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Question of Terminology?

[Drew Jensen]

Howdy,

For toolbars, including the newer notebook and grouped bars there is this
page:
https://wiki.documentfoundation.org/Design/ToolBar



On Fri, May 31, 2019 at 1:05 PM Cathy Crumbley  wrote:

> I edited that chapter but do not remember running across the graphic in
> the wiki. In fact, I have rarely used the wiki, probably because I don't
> know what information is there.
>
> Is there further information in the wiki or someplace else that
> specifies the terminology for UI elements?
>
> On 5/31/2019 11:13 AM, Dave Barton wrote:
> > OK, so we already have clear definitions in the HIG Guide:
> > https://wiki.documentfoundation.org/File:LO-HIG_SideeBar-Terminology.png
> > which I guess is the basis for Figure 8 on page 15 in chapter 1 of the
> > most recent Getting Started Guide.
> >
> >
> > On 31.05.2019 15:34, Drew Jensen wrote:
> >> Howdy,
> >>
> >> An example of deck and panel usage is in this blog from 2017
> >>
> https://design.blog.documentfoundation.org/2017/02/16/guidelines-for-keyboard-navigation-in-the-sidebar/
> >>
> >>
> >> On Fri, May 31, 2019 at 9:24 AM Cathy Crumbley 
> wrote:
> >>
> >>> I don't have strong opinions about what we should use, but keep in mind
> >>> that we need two different terms to describe the subunits of sidebars.
> >>>
> >>> Thus, at least in other LO guides I have worked on, "decks" are the
> >>> equivalent of pages and "panels" are the equivalent of sections of
> >>> pages. When I first ran across this usage, I remember thinking that
> >>> "deck" seemed a somewhat unusual word for this context while "panel"
> >>> seemed like a good choice for either a "page" or a "section."
> >>>
> >>> An alternative could be to treat sidebars like dialogs, so they would
> be
> >>> composed of pages, with each page containing sections. As someone with
> >>> little knowledge of UX language, this would be more user friendly for
> me.
> >>>
> >>> However, "deck" and "panel" are already being used in LO documentation.
> >>> How important is it to be consistent with other documentation?
> >>>
> >>> On 5/30/2019 11:32 PM, kees...@libreoffice.org wrote:
> >>>> In Dutch we also call it "Paneel" (Panel).
> >>>> Don't know if this helps.
> >>>>
> >>>> Greetings,
> >>>> Kees
> >>>>
> >>>> Dave Barton schreef op 30.05.2019 13:00:
> >>>>> Thanks Luke, your input (2c worth) is much appreciated. I am
> inclined to
> >>>>> agree with you on this specific aspect, but I am seeking general
> >>>>> consensus from the wider team/community on the standardization of
> this
> >>>>> and other terminologies used in our documentation.
> >>>>>
> >>>>> Any other opinions about describing sidebar components as "Panels" or
> >>>>> "Decks" in the user guides?
> >>>>>
> >>>>> Dave
> >>>>>
> >>>>> On 27.05.2019 23:02, Luke (gmail) wrote:
> >>>>>> My 2c is that Panel is more commonly used and understood by the
> >>>>>> average person.
> >>>>>>
> >>>>>> "Decks" may well be more familiar to those within the UX profession.
> >>>>>>
> >>>>>> luke
> >>>>>>
> >>>>>> On 28/5/19 2:00 am, Dave Barton wrote:
> >>>>>>> Hi Folks,
> >>>>>>>
> >>>>>>> I am working to finish my (very slow) review of Jean's revision of
> >>>>>>> CG6204. In the process it occurred to me that in this and other
> guides
> >>>>>>> we have mostly used the term "Panel" to reference parts of the
> >>>>>>> sidebar,
> >>>>>>> whereas the UX/Design folks and some support channels commonly
> >>>>>>> refer to
> >>>>>>> sidebar "Decks".
> >>>>>>>
> >>>>>>> While this is definitely not a critical issue, I feel that we
> >>>>>>> should as
> >>>>>>> far as possible maintain consistency in the terminology we use to
> >>>>>>> identify the components of the software's UI.
> >>>>>>>
> >>>>>>> Any thoughts, or should we discuss at the next meeting?
> >>>>>>>
> >>>>>>> Dave
> >>>>>>>
> >>>>>>>
> >>> --
> >>> To unsubscribe e-mail to:
> documentation+unsubscr...@global.libreoffice.org
> >>> Problems?
> >>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >>> Posting guidelines + more:
> https://wiki.documentfoundation.org/Netiquette
> >>> List archive:
> https://listarchives.libreoffice.org/global/documentation/
> >>> Privacy Policy: https://www.documentfoundation.org/privacy
> >>>
> >
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Question of Terminology?

[Drew Jensen]

Howdy,

An example of deck and panel usage is in this blog from 2017
https://design.blog.documentfoundation.org/2017/02/16/guidelines-for-keyboard-navigation-in-the-sidebar/


On Fri, May 31, 2019 at 9:24 AM Cathy Crumbley  wrote:

> I don't have strong opinions about what we should use, but keep in mind
> that we need two different terms to describe the subunits of sidebars.
>
> Thus, at least in other LO guides I have worked on, "decks" are the
> equivalent of pages and "panels" are the equivalent of sections of
> pages. When I first ran across this usage, I remember thinking that
> "deck" seemed a somewhat unusual word for this context while "panel"
> seemed like a good choice for either a "page" or a "section."
>
> An alternative could be to treat sidebars like dialogs, so they would be
> composed of pages, with each page containing sections. As someone with
> little knowledge of UX language, this would be more user friendly for me.
>
> However, "deck" and "panel" are already being used in LO documentation.
> How important is it to be consistent with other documentation?
>
> On 5/30/2019 11:32 PM, kees...@libreoffice.org wrote:
> > In Dutch we also call it "Paneel" (Panel).
> > Don't know if this helps.
> >
> > Greetings,
> > Kees
> >
> > Dave Barton schreef op 30.05.2019 13:00:
> >> Thanks Luke, your input (2c worth) is much appreciated. I am inclined to
> >> agree with you on this specific aspect, but I am seeking general
> >> consensus from the wider team/community on the standardization of this
> >> and other terminologies used in our documentation.
> >>
> >> Any other opinions about describing sidebar components as "Panels" or
> >> "Decks" in the user guides?
> >>
> >> Dave
> >>
> >> On 27.05.2019 23:02, Luke (gmail) wrote:
> >>> My 2c is that Panel is more commonly used and understood by the
> >>> average person.
> >>>
> >>> "Decks" may well be more familiar to those within the UX profession.
> >>>
> >>> luke
> >>>
> >>> On 28/5/19 2:00 am, Dave Barton wrote:
>  Hi Folks,
> 
>  I am working to finish my (very slow) review of Jean's revision of
>  CG6204. In the process it occurred to me that in this and other guides
>  we have mostly used the term "Panel" to reference parts of the
>  sidebar,
>  whereas the UX/Design folks and some support channels commonly
>  refer to
>  sidebar "Decks".
> 
>  While this is definitely not a critical issue, I feel that we
>  should as
>  far as possible maintain consistency in the terminology we use to
>  identify the components of the software's UI.
> 
>  Any thoughts, or should we discuss at the next meeting?
> 
>  Dave
> 
> 
> >>>
> >>>
> >
>
> --
> To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/documentation/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-documentation] Image anchoring problem

[Drew Jensen]

Oops - I had to go play around and add that sound file! rendered one image
with half the screen capture gone and uploaded that, so that link is no
good.
The full 3 minutes of riveting video is here instead
https://youtu.be/xzq7VI0hrYQ

On Wed, May 29, 2019 at 11:36 PM Drew Jensen 
wrote:

> Howdy Dave,
>
> OK Yeah, it is a bit of a pain now isn't it.
>
> Did a screen capture.. here it is https://youtu.be/1HrKJSrn7bU
>
> Somebody should see if the first problem, start of the video, is already
> in the issue tracker ;-)
>
> Drew
>
> On Wed, May 29, 2019 at 8:33 AM Dave Barton  wrote:
>
>> Yes, creating the frame and inserting an image into it is a partial
>> workaround, but it is not they way OOo and earlier versions of LO
>> worked, even if anchoring was not always great.
>>
>> Inserting the image into the frame is fine, but the auto-generated frame
>> around the inserted caption still cannot be resized.
>>
>> I have tried just about every possible alternative to do what is the
>> easiest thing in the world to do with AOO.
>>
>> Tested with 6.2.4.2 and 6.3alpha under Windows 7, 8.1 & 10 both 32 & 64
>> bit. 6.2.4.2 64bit on Linux kernel 5.2 & 4.20 Haven't had time to test
>> on macOS, but wouldn't expect any different result.
>>
>> Dave
>>
>>
>> On 29.05.2019 12:38, Dan Lewis wrote:
>> > I have the same results as Drew. I am using LO 6.2.4.2 from our LO
>> > website. O/S: Ubuntu 18.04. I too opened a new Writer window, added a
>> > frame, and inserted a screenshot into it.
>> >
>> > Dan
>> >
>> > On 5/28/19 11:54 AM, Drew Jensen wrote:
>> >> I'm just not having the problems you are with images, in fact it
>> >> seems to
>> >> be working much better for me now then it ever did before.
>> >>
>> >> As for the autosizing option, I just did that with a blank document,
>> >> inserted image in a frame and the option is there.
>> >> Using Version: 6.2.5.0.0+
>> >> Build ID: 23ccf16e9e86ecc64367f41f4df695d0a6926d72
>> >> CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kde5;
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> On Tue, May 28, 2019 at 11:41 AM Dave Barton 
>> >> wrote:
>> >>
>> >>> Thanks Drew,
>> >>>
>> >>> Yes, that was the bug and linked blog from where I picked up that "
>> TDF
>> >>> put up a tender to improve the situation with image handling".
>> >>>
>> >>> I can't believe this obviously broken code got past alpha and finished
>> >>> up in a release.
>> >>>
>> >>> Unfortunately, your steps do not work for me. The image properties
>> >>> dialog offers "relative to", but there is no "autosize" option. I have
>> >>> seen the "autosize" option when editing previously inserted images,
>> but
>> >>> not on a first insert.
>> >>>
>> >>> Best Regards
>> >>> Dave
>> >>>
>> >>> On 28.05.2019 15:38, Drew Jensen wrote:
>> >>>> Howdy,
>> >>>>
>> >>>> Comments inline
>> >>>>
>> >>>> On Tue, May 28, 2019 at 10:13 AM Luke (gmail) <
>> luke.kend...@gmail.com>
>> >>>> wrote:
>> >>>>
>> >>>>> Neither. I believe Writer's handling of images is astonishingly
>> >>>>> buggy,
>> >>>>> and has been for many years.
>> >>>>>
>> >>>>> I draw your attention to
>> >>>>> https://bugs.documentfoundation.org/show_bug.cgi?id=47148 and also
>> >>>>>
>> >>>> There was a great of deal of coding changes dealing with image
>> >>>> handling
>> >>> in
>> >>>> the 6.1 release cycle.
>> >>>> You find the meta issue for known issues related to that work here:
>> >>>> https://bugs.documentfoundation.org/show_bug.cgi?id=116280
>> >>>> Then of course there are still some issues open on the meta issue
>> >>>> 47148
>> >>>> referenced above.
>> >>>>
>> >>>> That said I am able to resize a frame without resizing an image in
>> the
>> >>>> frame, but that is not the default behavior. To do so first I need to
>> >>>

Re: [libreoffice-documentation] Image anchoring problem

[Drew Jensen]

Howdy Dave,

OK Yeah, it is a bit of a pain now isn't it.

Did a screen capture.. here it is https://youtu.be/1HrKJSrn7bU

Somebody should see if the first problem, start of the video, is already in
the issue tracker ;-)

Drew

On Wed, May 29, 2019 at 8:33 AM Dave Barton  wrote:

> Yes, creating the frame and inserting an image into it is a partial
> workaround, but it is not they way OOo and earlier versions of LO
> worked, even if anchoring was not always great.
>
> Inserting the image into the frame is fine, but the auto-generated frame
> around the inserted caption still cannot be resized.
>
> I have tried just about every possible alternative to do what is the
> easiest thing in the world to do with AOO.
>
> Tested with 6.2.4.2 and 6.3alpha under Windows 7, 8.1 & 10 both 32 & 64
> bit. 6.2.4.2 64bit on Linux kernel 5.2 & 4.20 Haven't had time to test
> on macOS, but wouldn't expect any different result.
>
> Dave
>
>
> On 29.05.2019 12:38, Dan Lewis wrote:
> > I have the same results as Drew. I am using LO 6.2.4.2 from our LO
> > website. O/S: Ubuntu 18.04. I too opened a new Writer window, added a
> > frame, and inserted a screenshot into it.
> >
> > Dan
> >
> > On 5/28/19 11:54 AM, Drew Jensen wrote:
> >> I'm just not having the problems you are with images, in fact it
> >> seems to
> >> be working much better for me now then it ever did before.
> >>
> >> As for the autosizing option, I just did that with a blank document,
> >> inserted image in a frame and the option is there.
> >> Using Version: 6.2.5.0.0+
> >> Build ID: 23ccf16e9e86ecc64367f41f4df695d0a6926d72
> >> CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kde5;
> >>
> >>
> >>
> >>
> >>
> >> On Tue, May 28, 2019 at 11:41 AM Dave Barton 
> >> wrote:
> >>
> >>> Thanks Drew,
> >>>
> >>> Yes, that was the bug and linked blog from where I picked up that " TDF
> >>> put up a tender to improve the situation with image handling".
> >>>
> >>> I can't believe this obviously broken code got past alpha and finished
> >>> up in a release.
> >>>
> >>> Unfortunately, your steps do not work for me. The image properties
> >>> dialog offers "relative to", but there is no "autosize" option. I have
> >>> seen the "autosize" option when editing previously inserted images, but
> >>> not on a first insert.
> >>>
> >>> Best Regards
> >>> Dave
> >>>
> >>> On 28.05.2019 15:38, Drew Jensen wrote:
> >>>> Howdy,
> >>>>
> >>>> Comments inline
> >>>>
> >>>> On Tue, May 28, 2019 at 10:13 AM Luke (gmail)  >
> >>>> wrote:
> >>>>
> >>>>> Neither. I believe Writer's handling of images is astonishingly
> >>>>> buggy,
> >>>>> and has been for many years.
> >>>>>
> >>>>> I draw your attention to
> >>>>> https://bugs.documentfoundation.org/show_bug.cgi?id=47148 and also
> >>>>>
> >>>> There was a great of deal of coding changes dealing with image
> >>>> handling
> >>> in
> >>>> the 6.1 release cycle.
> >>>> You find the meta issue for known issues related to that work here:
> >>>> https://bugs.documentfoundation.org/show_bug.cgi?id=116280
> >>>> Then of course there are still some issues open on the meta issue
> >>>> 47148
> >>>> referenced above.
> >>>>
> >>>> That said I am able to resize a frame without resizing an image in the
> >>>> frame, but that is not the default behavior. To do so first I need to
> >>>> select the image, open the context menu 'properties' and on the
> >>>> first tab
> >>>> of the property dialog under 'size' ensure that 'autosize' and
> >>>> 'relative
> >>>> to' are not selected.
> >>>>
> >>>> Best wishes,
> >>>>
> >>>> Drew
> >>>>
> >>>>
> >>>
> http://www.linux-magazine.com/Online/Blogs/Off-the-Beat-Bruce-Byfield-s-Blog/The-mysteries-of-positioning-pictures-in-LibreOffice-OpenOffice
> >>>
> >>>>> luke
> >>>>>
> >>>>> On 28/5/19 11:23 pm, Dave Barton wrote:
> >>>>>> I have just r