[libreoffice-users] Video in LibreOffice Online Impress files?

2020-04-14 Thread Drew Jensen
Howdy, Does anyone know how to use LibreOffice Online (or one of it's derivatives) with an Impress file which includes an embedded video - the idea is to use Nextcloud/LibreOffice to offer a read only view of the file. Is this supported yet? Thanks, Drew -- To unsubscribe e-mail to:

Re: [libreoffice-users] Base created from xlsx file - move to proper DB

2020-03-18 Thread Drew Jensen
Base, as you have found out, is first just a front end to all manner of data sources. So, for what you want to do I would approach it thusly. 1st - create an empty Base file for whatever database I want to use. Just the default embedded is an example. 2nd - create the Base file which connects

Fwd: [libreoffice-users] Base created from xlsx file - move to proper DB

2020-03-18 Thread Drew Jensen
Forwarded to OP -- Forwarded message - From: Drew Jensen Date: Wed, Mar 18, 2020 at 9:05 PM Subject: Re: [libreoffice-users] Base created from xlsx file - move to proper DB To: users Base, as you have found out, is first just a front end to all manner of data sources. So

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread Drew Jensen
Fair enough what people have said. The one thing that hasn't been said is what you need to do with that that it needs to be in a database. Depending on what that is I may disagree with my colleagues and say go for the firebird engine. So - what are you hoping to get from the data in a database

Re: [libreoffice-users] Libo Extensions & Templates

2020-05-29 Thread Drew Jensen
I don't have an idea on a) For b) In the top right hand corner is a menu Item "Maintainer Info" Here is the resultant URL https://extensions.libreoffice.org/en/using-this-site-as-an-extension-maintainer/ Read that page and you will see exactly what to do to gain access to the admin page. Under

Re: [libreoffice-users] Logic of headers (and footers) or my lack of it!

2020-05-31 Thread Drew Jensen
Looking at your requirements I was curious if using captions for the images could give you what you want. If the caption was the name of the document then you can handle the different cases of single image documents vs multi-image documents in a straight forward way; Single image caption is just

Re: [libreoffice-users] Pivot Tables - Monthly subtotals

2021-05-19 Thread Drew Jensen
Well, the simple way. Select all of your Date cells with data and change the Cell format to display only the month portion of the date. When you create the pivot table, include the 'Transaction Date' column in both the Columns fields list and the Row fields list, along with Object. You could also

Re: [libreoffice-users] Pivot Tables - Monthly subtotals

2021-05-20 Thread Drew Jensen
log box. This will avoid group data from every January > from every year in the same row (if that's not what you want). > > What was getting me stuck was that the Transaction Date must be in the > rows field. You cannot do this with Transaction Date in the columns > field, as I wanted to

Re: [libreoffice-users] Draw: Rotate image by seconds of a degree

2021-03-28 Thread Drew Jensen
Howdy, With the object selected open either the "Position and Size" dialog or the "Position and Size" deck in the side bar. You will see a numeric field that allows you to enter a rotation value as 000.00" just use the decimal places. HTH Drew On Sun, Mar 28, 2021 at 2:19 PM toki wrote: > >

Re: [libreoffice-users] Collabora experience?

2021-03-12 Thread Drew Jensen
Howdy Thomas, Well, first I would direct you to an additional user support forum for questions going forward. https://forum.collaboraonline.com/ The short answer, IMO, is that you need pCloud to offer the ability to sync files on your hand held device to your cloud storage and looking at the

Re: [libreoffice-users] Calculating the difference between two time values by means of SQL

2021-03-05 Thread Drew Jensen
Howdy, The salient point here is the version of HSQLdb which comes with LibreOffice is rather old and lacking when it comes to date manipulation, but it can be done and hopefully this post over at ASK dot LibreOfffice will help answer you question:

<    1   2