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

[Drew Jensen]

Howdy,

Excellent!

Turns out I was so intent on trying to force that row to column header
trick I gave you a bogus answer anyway.

Glad you found a solution.

Best wishes

Drew

On Thu, May 20, 2021 at 11:19 AM Julian So  wrote:
>
> Actually, I figured out how to get what I wanted. This is the way:
>
>  1. Build the pivot table with Transaction Date as rows, Object as
> columns, and counts of Transacations as data fields
>  2. Click any date in the Transaction Date column
>  3. Date | Group and Outline | Group
>  4. Select the "Intervals" radio button under "Group By"
>  5. Check the "Months" checkboxes under "Group By"
>
> This will group transaction data by month. If there are data from
> multiple years, then also check the "Years" checkboxes under "Group By"
> in the Group dialog 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.
>
> Julian
>
> On 2021-05-19 9:12 p.m., Drew Jensen wrote:
> > 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 set the Filters list to include Object if you wanted to
> > look at Cars or Trucks.
> >
> >
> > I hope that works for you, best wishes,
> >
> > Drew
> >
> > On Wed, May 19, 2021 at 3:57 PM Julian So  wrote:
> >> Hello,
> >>
> >> I have data like the following:
> >>
> >> Transaction Date | Object | Transaction
> >> 2021-01-01 | Car | Bought
> >> 2021-03-01 | Car | Bought
> >> 2021-03-15 | Truck | Bought
> >> 2021-03-16 | Car | Bought
> >> 2021-03-18 | Car | Sold
> >> 2021-04-01 | Truck | Sold
> >>
> >> I want to create a pivot table with Transaction Date as columns, Object
> >> as rows, and counts of Transaction as data fields . However, I do not
> >> want individual dates as columns, I want to look at the data by month.
> >> In other words, instead of this:
> >>
> >> Object | 2021-01-01 | 2021-03-01 | 2021-03-15 | 2021-03-16 | 2021-03-18
> >> | 2021-04-01
> >> Car | 1 | 1 | 0 | 1 | 1 |
> >> Truck | 0 | 0 | 1 | 0 | 0 | 1
> >>
> >> I want this:
> >>
> >> Object | January | February | March | April
> >>
> >> Car | 1 | 0 | 3 | 0
> >>
> >> Truck | 0 | 0 | 1 | 1
> >>
> >> How do I do this in LibreOffice Calc?
> >>
> >> Julian
> >> --
> >>
> >> Julian So, B.Sc.,
> >> Director of Quality Assurance
> >> Immuni T
> >> 5th floor, suite SB-5180
> >> 141 President-Kennedy Avenue
> >> Montreal QC, H2X 1Y4
> >> 514 545 3097 x105 Office
> >> 514 545 3064 Fax
> >>
> >> Confidentialité:
> >> Ce courrier électronique est confidentiel et protégé. Toute
> >> diffusion, utilisation ou copie de ce message ou des renseignements
> >> qu'il contient par une personne autre que le (les) destinataire(s)
> >> désigné(s) est interdite. Si vous recevez ce courrier électronique
> >> par erreur, veuillez informer l'expéditeur par courriel immédiatement
> >> et effacer ce message et en détruire toute copie.
> >>
> >> Confidentiality:
> >> This message is confidential and privileged. Any distribution, use or
> >> copying of this e-mail or the information it contains by other than
> >> an intended recipient is unauthorized. If you are not the addressee,
> >> please inform the sender by return e-mail immediately and delete this
> >> message and destroy all copies.
> >>
> >>
> >> --
> >> To unsubscribe e-mail to: users+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/users/
> >> Privacy Policy: https://www.documentfoundation.org/privacy
>
> --
> Julian So, B.Sc.,
> Director of Quality Assurance
> Immuni T
> 5th floor, suite SB-5180
> 141 Preside

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

[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 set the Filters list to include Object if you wanted to
look at Cars or Trucks.


I hope that works for you, best wishes,

Drew

On Wed, May 19, 2021 at 3:57 PM Julian So  wrote:
>
> Hello,
>
> I have data like the following:
>
> Transaction Date | Object | Transaction
> 2021-01-01 | Car | Bought
> 2021-03-01 | Car | Bought
> 2021-03-15 | Truck | Bought
> 2021-03-16 | Car | Bought
> 2021-03-18 | Car | Sold
> 2021-04-01 | Truck | Sold
>
> I want to create a pivot table with Transaction Date as columns, Object
> as rows, and counts of Transaction as data fields . However, I do not
> want individual dates as columns, I want to look at the data by month.
> In other words, instead of this:
>
> Object | 2021-01-01 | 2021-03-01 | 2021-03-15 | 2021-03-16 | 2021-03-18
> | 2021-04-01
> Car | 1 | 1 | 0 | 1 | 1 |
> Truck | 0 | 0 | 1 | 0 | 0 | 1
>
> I want this:
>
> Object | January | February | March | April
>
> Car | 1 | 0 | 3 | 0
>
> Truck | 0 | 0 | 1 | 1
>
> How do I do this in LibreOffice Calc?
>
> Julian
> --
>
> Julian So, B.Sc.,
> Director of Quality Assurance
> Immuni T
> 5th floor, suite SB-5180
> 141 President-Kennedy Avenue
> Montreal QC, H2X 1Y4
> 514 545 3097 x105 Office
> 514 545 3064 Fax
>
> Confidentialité:
> Ce courrier électronique est confidentiel et protégé. Toute
> diffusion, utilisation ou copie de ce message ou des renseignements
> qu'il contient par une personne autre que le (les) destinataire(s)
> désigné(s) est interdite. Si vous recevez ce courrier électronique
> par erreur, veuillez informer l'expéditeur par courriel immédiatement
> et effacer ce message et en détruire toute copie.
>
> Confidentiality:
> This message is confidential and privileged. Any distribution, use or
> copying of this e-mail or the information it contains by other than
> an intended recipient is unauthorized. If you are not the addressee,
> please inform the sender by return e-mail immediately and delete this
> message and destroy all copies.
>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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:
>
>
> All:
>
>
> In Draw, how does one rotate images by seconds of a degree?
> None of the documentation I have, explains how to do so.
> None of the menu items even hint at that possibility.
> One of my acquaintances claims that LibO Draw does have that functionality.
>
> jonathon
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Collabora experience?

[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 pCloud listing feedback, at their app store listing just now,
that feature appears to have a number of limitations and shortcomings
at the moment, per feedback posts.

You have already noted that Collabora Online (Android) only works with
files stored in local storage on the handheld device. This is a
feature not likely to change given the architecture of the application
- but with a sync function of your local storage to a cloud account
doesn't pose any real loss of functionality.

So, to get what you want you need to push the pCloud folks to get that
feature working properly.

Best wishes,

Drew

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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:
 
https://ask.libreoffice.org/en/question/75480/how-to-do-basic-arithmatic-with-dates-in-libre-base-queries/

best wishes,

Drew

On Thu, Mar 4, 2021 at 9:04 AM Markus Elfring  wrote:
>
> Hello,
>
> Two columns of a table (for the database engine “HyperSQL” within the 
> application
> “LibreOffice Base 7.1.0.3-985.1”) have got the data type “TIME”.
> I would like to compute a difference for these fields.
>
> It seems that the following SQL statement is insufficient so far.
>
> SELECT ID, t1, t2, t2 - t1 AS duration FROM time_measurements1
>
>
> I would appreciate your advices.
>
> Would you like to point further information sources out besides query examples
> which work with dates and time stamps?
>
> Regards,
> Markus
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 the name of the document.
A document spanning two images would have the name of the document and
which page it is.
There is perhaps a bonus also in that you could generate a table of
images at the front of the document which uses the caption text and
offers the option to create an internal link to the page with the
image.
Just a thought.

Best wishes,

Drew

On Sun, May 31, 2020 at 3:18 PM Harvey Nimmo  wrote:
>
> Hello Regina,
>
> Thanks for taking the trouble to offer help.
>
> Perhaps if I describe my 'case' it will help to see where I am coming
> from. I wanted to define a header for each page that is either a
> copy of the previous header or a new one.
>
> The application in my current case is collection of handwritten court
> papers (from 1813) that I want to transcribe. The originals are in
> jpeg. Some are just single sheets, some sheets are left and right pages
> together, some are just snippets. Obviously the order is
> important, and the source names of the jpeg files serve very well as a
> header that should not of itself belong the the transcription text.
> hence my simple requirement.
>
> It was a deliberate choice to try to use the header feature (rather
> than headings within the body of the text) because it made sense to me
> to keep the metadata (i.e. file names of each sheet) separate from the
> actual content of each sheet. In the end, I would have a complete LO
> text document in which each page was headed with the file name to
> identify its source and a page full of text showing the textual content
> of each sheet. The resulting document would evidently contain 29 pages
> with about 20 different headers.
>
> I was expecting some simple implementation but, to my surprise, did not
> find such. In the meantime Remy has made a suggestion that show how
> much more complex it could be, than expected.
>
> Greetings
> Harvey
>
>
>
>
> On Sat, 2020-05-30 at 22:49 +0200, Regina Henschel wrote:
> > Harvey Nimmo schrieb am 30-May-20 um 18:54:
> > > My intention was to use the header function to describe each page
> > > of a
> > > 29 page document separately, with a couple of exceptions where two
> > > pages may have the same header.
> >
> > What do you mean by "describe"? There exists some variables like
> > chapter
> > number and text, that will adapt automatically to the content of the
> > page.
> >
> > >
> > > I thought that it would just be a simple question of telling the
> > > header
> > > of each page to copy (or not) the header of the previous page. How
> > > mistaken could I be?!!
> >
> > ?? You really need to describe more detailed the desired content of
> > the
> > "header".
> >
> > Kind regards
> > Regina
> >
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Libo Extensions & Templates

[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 the new system extensions and templates, as far as I can tell,
are treated exactly the same.

HTH

Drew

On Fri, May 29, 2020 at 9:43 PM toki  wrote:
>
> All:
>
> a) Is there a way to sort search results:
> * Chronologically;
> * Alphabetically;
>
> Currently, the results appear to be randomly ordered.
>
> b) Where do you login, to upload updated templates & extensions?
>
> jonathon
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 table vs the
spreadsheet?

Thanks

On Thu, Mar 19, 2020 at 11:32 AM bunk3m  wrote:

> Thank you Alex, Paulo and Drew.
> I didn't realize there were so many "bugs" still to work out.
> I'll stick with HSQLDB for now.
> I trust there will eventually be a way to migrate to the new DB in the
> future?
>
> On Thu, 19 Mar 2020 at 10:10, Alexander Thurgood 
> wrote:
>
>> Le 19/03/2020 à 13:32, bunk3m a écrit :
>>
>> I would only recommend using embedded Firebird if you're comfortable
>> with all of its still numerous bugs, and are happy to get your hands
>> dirty correcting data types, lengths, etc and possibly corrupted data.
>>
>> Also, it is my understanding that there is currently still a limitation
>> of 64Kb for the total insert length of any transaction, meaning that you
>> have to be especially wary of the number, and length of any VARCHAR data
>> that you have in your spreadsheet.
>>
>> If you have Unicode characters in any cell, you might also get an import
>> failure because these are coded over 4 bits per character, which can
>> rapidly cause the automatically created insert statement to exceed the
>> 64KB limit, and again, fail.
>>
>>
>> My advice would be to stick to embedded HSQLDB until, or unless, you are
>> comfortable with such limitations.
>>
>>
>> Alex
>>
>>
>>
>> > Thank you Alex and Drew.
>> > I'll try your suggestions today.
>> > I appreciate your help!
>> >
>> > One more question if I might.
>> > If I understand correctly, HSQLDB is being replace by Firebird.  So I'd
>> > like the engine to be Firebird so I don't end up with an issue in the
>> > future.
>> > How does one know that Firebird is being used?
>> >
>> > On Thu, 19 Mar 2020 at 05:52, Alexander Thurgood <
>> alex.thurg...@gmail.com>
>> > wrote:
>> >
>> >> Le 19/03/2020 à 01:57, bunk3m a écrit :
>> >>
>> >> As Drew has said, you can use your existing flat file in several ways :
>> >>
>> >> 1) Go via the empty ODB file method to drag the linked XLSX sheet from
>> >> your first ODB file to the second, empty ODB file and then follow the
>> >> import wizard.
>> >>
>> >> 2) Create an empty ODB file and keep it open. Open your XLSX sheet
>> >> directly in LO Calc. Select all of the data including column headers,
>> >> that you want to import.
>> >> Drag and drop this selected data onto your open ODB.
>> >> Use the import wizard options to configure the way you want the data to
>> >> be imported into a new table that will be created as a result of the
>> >> drag and drop maneuver.
>> >>
>> >> Be aware that the import wizard isn't perfect, depending on the version
>> >> of LO you are using, it might cause you a bit of grief, so double-check
>> >> afterwards that it has done what you wanted (within the confines of
>> what
>> >> it can actually do, of course). You might find that some post-import
>> >> database alteration statements might be necessary.
>> >>
>> >>
>> >> Alex
>> >>
>> >
>>
>>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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, 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 to the xlsx file as the data
source. I take it you have that already.

Now with both open, with the mouse drag the table (the spread sheet data)
from the 2nd file to the 1st, dropping onto the Tables section.

This triggers the import dialog.

Hope that helps,

Drew

On Wed, Mar 18, 2020 at 8:58 PM bunk3m  wrote:

> Hello all.
>
> I thought I had gotten the data from a flat file (xlsx) into Base.  I
> was trying to import and create a new database.
>
> My work requires my data to be in the company OneDrive.  When I try to
> open the connected flat file, I get errors that the file location or
> parameters are not OK.  So all the work I did is lost.  This is likely a
> bug but I don't have time to report this at the moment.
>
> Apparently I incorrectly used: "File:Connect to an existing database" as
> that just appears to connect to the flat file but won't actually create
> a proper table in Base.  While I can understand the use case for just
> accessing a flat table, I'd like to import not just connect.
>
> There has to be an easy way to import the data without having to
> manually create a table and then import the csv file.  What am I missing?
>
> I'm just trying to get data into Base easily.
>
> LO v6.4.0.3 on Win10 64B.
>
> Thanks in advance.
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 to the xlsx file as the data
source. I take it you have that already.

Now with both open, with the mouse drag the table (the spread sheet data)
from the 2nd file to the 1st, dropping onto the Tables section.

This triggers the import dialog.

Hope that helps,

Drew

On Wed, Mar 18, 2020 at 8:58 PM bunk3m  wrote:

> Hello all.
>
> I thought I had gotten the data from a flat file (xlsx) into Base.  I
> was trying to import and create a new database.
>
> My work requires my data to be in the company OneDrive.  When I try to
> open the connected flat file, I get errors that the file location or
> parameters are not OK.  So all the work I did is lost.  This is likely a
> bug but I don't have time to report this at the moment.
>
> Apparently I incorrectly used: "File:Connect to an existing database" as
> that just appears to connect to the flat file but won't actually create
> a proper table in Base.  While I can understand the use case for just
> accessing a flat table, I'd like to import not just connect.
>
> There has to be an easy way to import the data without having to
> manually create a table and then import the csv file.  What am I missing?
>
> I'm just trying to get data into Base easily.
>
> LO v6.4.0.3 on Win10 64B.
>
> Thanks in advance.
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Libreoffice office cloud version

[Drew Jensen]

Howdy,

Good news! There is already a solution for what you are looking for.

LibreOffice OnLine has been under development and available for a couple of
years.

You can find a user level guide to the software on the documentation page:
https://documentation.libreoffice.org/en/english-documentation/

Now - the part that may not be what you are hoping for:

You have to either host an instance yourself, which is both easy and hard
at the same time, or find a service that offers it.

At least one major email provider is offering LOOL as part of their
package: gmx.com

There are bunches of internet hosting providers who offer managed versions
of LOOL as part of their packaged offerings.

The way most folks self host today is in tandem with a file sharing or CMS
type platform. One of the more common is NextCloud and LibreOffice is an
available optional module that you can install from the standard control
panel.

Anyway, I hope that helps point in the direction you are looking to go.

Best wishes,

Drew



On Fri, Mar 6, 2020 at 12:52 PM  wrote:

> Rather than saying this is a question. This is more like expressing what I
> am looking for, after searching online. My search result doesn't find
> anything similar, so ask it here (and appreciate any suggestions if any
> similar service existed).
>
> I am looking for something like Google doc, sheet but purely libreoffice
> version where I can do online collaborative editing, sharing doc, and so
> on. I understand there are services like MS sharepoint, Google doc, and so
> on. But I am more interested in using open source software, and I know some
> of my friends who also want to use such service as well, though I
> understand that might not be big enough request in triggering to create
> such service. But anyway that'd be nice to see such service that people can
> use.
>
> And thanks community's effort to create such kind of software!
>
>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] LO 6.4 -vs- 6.3 Margin Changes

[Drew Jensen]

Well, I've got both 6.3 and 6.4 open and in the Format top level menu the
only change was to a string.

With 6.3 it is Format->Page...
With 6.4 it is Format->Page Style

But both versions do the same thing, which is they open the Page Style
dialog.

In both versions I can also change the margin for the current page by using
the Page stack in the sidebar.

Unfortunately your first line refers to 'Paul' and I don't see an email
prior to this in my email reader, so if there was more to the question I
don't see it.

Best wishes,

Drew

On Tue, Mar 3, 2020 at 10:47 AM charles meyer 
wrote:

> Do others agree with Paul and you're not using the latest LO?
>
> Did you have a bad experience with the latest LO?
>
> I have the latest installed but changing margins is not the same in the
> latest LO - there doesn't seem to have a Page Layout in the news version
> under Format.
>
> If the latest should be avoided then, I'll have to uninstall and then
> install the 6.3 version.
>
> Thanks so much,
>
> Charles
>
> From: "Paul D. Mirowsky" 
> To: charles meyer 
> Cc: users@global.libreoffice.org
> Bcc:
> Date: Mon, 2 Mar 2020 10:59:46 -0500
> Subject: [libreoffice-users] Re: Libre Writer Help download + Margin
> adjustment
> Hello Charles
>
> Suggest you go to a more current stable version, 6.3.5.
>
> https://www.libreoffice.org/download/download/
>
> Allow download to begin. On that page, click on "LibreOffice built-in
> help".
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: LO Calc 6.3.5 Cell comment box

[Drew Jensen]

Well, when the font changes the box will grow vertically to
accommodate larger font or line spacing changes even. The width of the box
doesn't change automatically however.

I don't know of any way to change the default font setting for comments.
Which doesn't at all mean it can't be done.

On Sun, Mar 1, 2020 at 5:32 PM Ken Springer  wrote:

> Hmm.
>
> Is there a work around to take a resized box and copy it to other cells?
>
> One box at a time is basically worthless to me.  I need to resize all
> boxes, as I use a larger font so I can read the comments, enter the
> comments, etc.
>
>
>
> On 3/1/20 3:21 PM, Drew Jensen wrote:
> > Yes, but only for existing comments.
> > You can not expand the size of the box when you are entering the initial
> > comment text.
> > In a cell with some comment text select View Comment and you can then
> > resize the box and the custom size is retained for each cell comment
> > changed when saved.
> >
> > On Sun, Mar 1, 2020 at 5:04 PM Ken Springer  wrote:
> >
> >> Can the comment box be resized by dragging the sides with a mouse?
> >>
> >>
> >> --
> >> Ken
> >> MacOS 10.14.6
> >> Firefox 70.0.1
> >> Thunderbird 60.8
> >> "My brain is like lightning, a quick flash
> >>and it's gone!"
> >>
> >>
> >> --
> >> To unsubscribe e-mail to: users+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/users/
> >> Privacy Policy: https://www.documentfoundation.org/privacy
> >>
> >
>
>
> --
> Ken
> MacOS 10.14.6
> Firefox 70.0.1
> Thunderbird 60.8
> "My brain is like lightning, a quick flash
>   and it's gone!"
>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] LO Calc 6.3.5 Cell comment box

[Drew Jensen]

Yes, but only for existing comments.
You can not expand the size of the box when you are entering the initial
comment text.
In a cell with some comment text select View Comment and you can then
resize the box and the custom size is retained for each cell comment
changed when saved.

On Sun, Mar 1, 2020 at 5:04 PM Ken Springer  wrote:

> Can the comment box be resized by dragging the sides with a mouse?
>
>
> --
> Ken
> MacOS 10.14.6
> Firefox 70.0.1
> Thunderbird 60.8
> "My brain is like lightning, a quick flash
>   and it's gone!"
>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Redaction

[Drew Jensen]

Sounds like a trip to the bug reporting system is in order then.

On Tue, Jan 21, 2020 at 1:44 PM Dave Barton  wrote:

> Hi Drew,
>
> Thanks for the feedback, but under Win 10 I get a 100% readable PDF
> (redactions appear as semi-transparent gray blobs) if I use "Export
> Directly as PDF" or either one of the two "Redacted Export" options. No
> issue under Linux.
>
> Best Regards
> Dave
>
> On 21/01/2020 18:21, Drew Jensen wrote:
> > Howdy Dave,
> >
> > That is the review mode (the grey out blocks) so that the reviewers can
> see
> > what is being redacted.
> >
> > You get that when you select the 'direct to pdf' button on the tool bar.
> >
> > To the left are two drop down buttons, White and Black, click either of
> > those and you get the PDF with the final redaction.
> >
> > Best wishes,
> >
> > Drew
> >
> > On Tue, Jan 21, 2020 at 1:12 PM Dave Barton 
> wrote:
> >
> >> I have heard the LO Redaction feature mentioned recently and have never
> >> investigated it. Out of simple curiosity I followed the in-built Help
> >> instructions (not available on-line) "How redaction works in
> LibreOffice?".
> >>
> >> With LO 6.4.0.2 x64 under Win10 the resulting PDF does not show either a
> >> white or black redaction, only a semi-transparent gray blob over the
> >> supposedly redacted area(s) and the text is fully visible.
> >>
> >> With LO 6.3.4.2 under Linux both the black and white redactions work as
> >> expected.
> >>
> >> Does anyone else see this issue with LO 6.4.0.2 x64 under Win10?
> >>
> >> Dave
> >>
> >> --
> >> To unsubscribe e-mail to: users+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/users/
> >> Privacy Policy: https://www.documentfoundation.org/privacy
> >>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Redaction

[Drew Jensen]

Howdy Dave,

That is the review mode (the grey out blocks) so that the reviewers can see
what is being redacted.

You get that when you select the 'direct to pdf' button on the tool bar.

To the left are two drop down buttons, White and Black, click either of
those and you get the PDF with the final redaction.

Best wishes,

Drew

On Tue, Jan 21, 2020 at 1:12 PM Dave Barton  wrote:

> I have heard the LO Redaction feature mentioned recently and have never
> investigated it. Out of simple curiosity I followed the in-built Help
> instructions (not available on-line) "How redaction works in LibreOffice?".
>
> With LO 6.4.0.2 x64 under Win10 the resulting PDF does not show either a
> white or black redaction, only a semi-transparent gray blob over the
> supposedly redacted area(s) and the text is fully visible.
>
> With LO 6.3.4.2 under Linux both the black and white redactions work as
> expected.
>
> Does anyone else see this issue with LO 6.4.0.2 x64 under Win10?
>
> Dave
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] LO 6.2.x save dialog on Linux

[Drew Jensen]

To follow up with the last email.

Recently I added KDE to my Linux desktop (had been using Gnome) and with
that the file manage switched to Dolphin.  Dolphin out of the box had
nothing setup for the usual directory links, but it was easy enough to add
them one time and after that the save dialog picks all of those up. So
after a couple minutes what I had when ran under Gnome is also there under
KDE.

HTH

Drew

On Fri, Jun 14, 2019 at 9:15 AM Drew Jensen 
wrote:

> LibreOffice no longer offers custom open and save dialog boxes and instead
> rely on the OS support dialogs.
>
> On Fri, Jun 14, 2019 at 8:00 AM aguador  wrote:
>
>>
>> El vie, 14-06-2019 a las 08:35 +0100, Mike Scott escribió:
>> > On 12/06/2019 19:12, aguador wrote:
>> > > Does anyone on the list, whether from the DF or a user, know if
>> > > there
>> > > are plans to improve the save dialog?
>> > >
>> > > As it stands, at least on Linux, separate partitions and connected
>> > > drives are no longer shown in the dialogue. Saving to such a
>> > > partition
>> > > or drive means navigating there through the root directory. I know
>> > > that
>> > > it is possible to save the location, but this does not help if you
>> > > are
>> > > saving to a new or infrequently used external device.
>> >
>> > Which dialogue box style have you selected?
>> >
>> > Under Tools|Options|LibreOffice|general you get the option to choose
>> > LO-style dialogues.
>> >
>> > If I pick 'LO-style' I see what you appear to be describing;
>> > clearing
>> > that checkbox gives a more sensible (IMO) dialogue box.
>> >
>> > (LO 5.1.6.2 on Mint Sylvia)
>> >
>> Thanks, Mike, but there is no such setting in LO-6.2.3.2. If you would
>> like to follow this, there is an active bug report . . .:
>>
>> https://bugs.documentfoundation.org/show_bug.cgi?id=125908
>>
>>
>> --
>> To unsubscribe e-mail to: users+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/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] LO 6.2.x save dialog on Linux

[Drew Jensen]

LibreOffice no longer offers custom open and save dialog boxes and instead
rely on the OS support dialogs.

On Fri, Jun 14, 2019 at 8:00 AM aguador  wrote:

>
> El vie, 14-06-2019 a las 08:35 +0100, Mike Scott escribió:
> > On 12/06/2019 19:12, aguador wrote:
> > > Does anyone on the list, whether from the DF or a user, know if
> > > there
> > > are plans to improve the save dialog?
> > >
> > > As it stands, at least on Linux, separate partitions and connected
> > > drives are no longer shown in the dialogue. Saving to such a
> > > partition
> > > or drive means navigating there through the root directory. I know
> > > that
> > > it is possible to save the location, but this does not help if you
> > > are
> > > saving to a new or infrequently used external device.
> >
> > Which dialogue box style have you selected?
> >
> > Under Tools|Options|LibreOffice|general you get the option to choose
> > LO-style dialogues.
> >
> > If I pick 'LO-style' I see what you appear to be describing;
> > clearing
> > that checkbox gives a more sensible (IMO) dialogue box.
> >
> > (LO 5.1.6.2 on Mint Sylvia)
> >
> Thanks, Mike, but there is no such setting in LO-6.2.3.2. If you would
> like to follow this, there is an active bug report . . .:
>
> https://bugs.documentfoundation.org/show_bug.cgi?id=125908
>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base Firebird reserved words

[Drew Jensen]

Howdy,

Just tried this using the latest build (yesterday) of 6.3 and created a
table with two three fields named; id, Select and Integer.

Used query designer to generate this SQL select statement
SELECT "id", "Select", "Integer" FROM "tblKeyWords"
and it is working as expected.

Perhaps you mean you are passing an SQL string as a prepared statement in a
Basic macro? If that is it then if you could share the line of Basic and
will take a look for you, if you like.

Best wishes,

Drew

On Wed, May 22, 2019 at 9:50 AM Paul D. Mirowsky 
wrote:

> I have recently been battling with the change to Firebird.
>
> When using query, I would continuously get some form of
> 'isc_dsql_prepare' errors.
>
> As it turns out, I repeatedly used "Select" as a field name within
> "Tables".
>
> Changing the field names from "Select" to "Selection" has eliminated all
> of the 'isc_dsql_prepare' errors.
>
> I checked the reserved words for Firebird 2.5 and 3.0.  "Select" is a
> reserved keyword in 2.5.
>
> My suspicion is that there is some kind of misinterpretation during the
> analysis of field name vs keyword when opening and/or using a query.
>
> Can someone confirm that Firebird keywords should never be used as field
> names.
>
> Thanks
>
> Paul
>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Getting a line break through a query

[Drew Jensen]

Howdy,

The carriage return is in the string but in the case of the Query designer
the result grid only displays single line data so it appears it is not
there.

If the query is used to populate controls on a form (grid or single field)
there is a property for the control 'MultiLine Input' and default is NO.

For a Grid control you would select a column and change that 'MultiLine
Input' property for the column from No to Yes and the string will break.

Best wishes,

Drew

On Wed, May 15, 2019 at 4:56 PM Adam Fenn  wrote:

> The base documentation states that you can get a line break using Char(13)
> e.g.
>
> SELECT "Firstname"||' '||"Surname"||Char(13)||"Road"||Char(13)||"Town"
> FROM "Table"
>
>
> However, when I run this I just get the concatenated query on one line
> with no line breaks.
>
> What am i doing wrong?
>
> Thanks for your help,
> Adam Fenn.
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] CSV import trouble (numbers & locale)

[Drew Jensen]

Howdy,

Well, I'm using LibreOffice 6.2.3 (with Ubuntu) and have created a csv file
with two data rows
12.12
12.123

Then set my global locale to Italian(Italy) and try to open the csv file.
(which is using a tab to separate values btw)
If in the dialog box I change the defaulted Italian(Italy) locale to
English(USA) everything works as expected, with the data in the now
Italian(Italy) local file:
12,12
12,123

If I do not set the locale in the import dialog to a locale which used the
'.' for decimal it does not work properly.

But if doing it in that order does is not working on the MAC then I would
say yes you should open an issue in the bug tracker.

Best wishes,

drew



On Tue, Apr 23, 2019 at 11:08 PM Andrea Venturoli  wrote:

> On 4/23/19 10:39 PM, Italo Vignoli wrote:
> > IMHO the issue could be related to the cell format, either to the number
> > of decimals or to the thousands separator. In any case, the cell format
> > can be tweaked.
>
> Thanks for your answer.
> However I'm not sure what you mean here:
>
> _ tweaking on the CSV side? Sure I can, but I'd rather not: the file has
> other uses, besides being importe in LibreOffice; also it's already
> correct (for some definition of correct, i.e. English locale);
>
> _ tweaking during import? I don't see any option to choose decimal
> separator; only locale setting, which, as I said, does not work.
>
> _ settings decimal separator globally? This is not what my customer
> wants: she wants to work with Italian locale, but be able to import this
> single file with dot as decimal separator; the option seems to be there,
> just not working.
>
> _ Something else? What?
>
>
>
>
> What I'm trying to understand is whether the fact that setting locale in
> the import dialog has no effect is a bug (which I should report) or if
> I'm just trying something that will never work conveniently and I'll
> need to think about a different workflow.
>
>   bye & Thanks
> av.
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Transparency in Write

[Drew Jensen]

Hi,

Right, so just tried this with 6.1.4.2 and it seem that from the dialog box
the transparency setting is being ignored.

On an upside, if instead I use the Transparency setting in the  Sidebar
Image page that is working fine.

BTW also checked 6.2 (Ubuntu) and same thing.
Not sure if there is an existing issue open on that, will look.

Drew

On Sat, Apr 13, 2019 at 1:38 PM Gregory Forster 
wrote:

> Hi,
> I remember many years ago, with LO 3.3, you could import an image, and
> adjust its transparency, so that it was like a watermark, showing behind
> other text or graphics. Now I'm using 6.1.4.2 and I insert the image, go
> to Format, Select Image, Select Properties,then select Transparency -
> Nothing happens.  I checked the version 6 documentation and I could not
> find anything else.  What's wrong?
>
> Greg
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Concatenate Function inCalc

[Drew Jensen]

Howdy,

I believe that the difference is in where the function hails from:
CONCATENATE is defined in the ODF standard.
CONCAT comes by way of Excel support.

I think you have a point about how the system should respond when
erroneously using ranges for the ODF function (not supported) and could be
worth opening an issue.

Best wishes,

Drew

On Tue, Apr 2, 2019 at 10:31 AM Michael H  wrote:

> Why are we defending invalid output of a function?
>
> When I send invalid data like range to a function, say ABS(c1:c4), I expect
> it to return an error (#VALUE! comes up in linux).
>
> In linux on LO 6.0.7, I'm getting the 2nd value in the range as a valid
> output of the function CONCATENATE(C1:C4).  That is erroneous. broken.
> should-not-happen.
>
> This thread is about CONCATENATE being disfunctional in that it accepts
> ranges, but does not act on them correctly. Please stop referring to CONCAT
> as the reason that CONCATENATE is broken.
>
> However, in regard to CONCAT, I see zero reason for the CONCATENATE
> function to be separate from CONCAT.  CONCATENATE  should be replaced with
> an alias or redirect to CONCAT. But thats not a bug, just poor design.
>
> On Tue, Apr 2, 2019 at 9:13 AM Robert Großkopf  >
> wrote:
>
> > Hi Michael,
> >
> > > CONCATENATE must either fail to accept ranges (with an error), or
> accept
> > > them and provide the combination that acceptance suggests. It is a bug
> > that
> > > it accepts ranges, but returns something else.
> >
> > Have opened Calc and looking for fuction CONCATENATE. Help in the dialog
> > says: "Combines several text items into one."
> > Then looked for CONCAT. Help in the dialog says: "Combines several text
> > items into one, accepts cell ranges as arguments."
> >
> > I don't see in the help CONCATENATE accepts cell ranges.
> >
> > Regards
> >
> > Robert
> > --
> > Homepage: http://robert.familiegrosskopf.de
> > LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> >
> >
> > --
> > To unsubscribe e-mail to: users+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/users/
> > Privacy Policy: https://www.documentfoundation.org/privacy
> >
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base/Firebird Queries broken

[Drew Jensen]

On Wed, Jan 16, 2019 at 2:46 PM Paul D. Mirowsky 
wrote:

> When editing the query, it works using RunQuery (F5)
>
> After editing and it is working, I save the Query.
>
> Then clicking on the saved Query from main Query window results in error
> again.
>

IDK on that, haven't seen that particular problem before.

Did you say that the SQL statement will run with Run SQL Direct turned on?





>
> On 1/16/2019 1:06 PM, Drew Jensen wrote:
> > So, can you open that Query definition, the one that raised the error
> when
> > you double clicked on it, in design view and Run it and it works?
> >
> > Is that what you are saying?
> >
> > Thanks
> >
> >
> > On Wed, Jan 16, 2019 at 12:17 PM Paul D. Mirowsky <
> p_mirow...@bentaxna.com>
> > wrote:
> >
> >> Ok, things are narrowing down on this issue.
> >>
> >> I have a Query Design view in which I have a field Series set to 134.
> >>
> >> I remove the 134 and press enter.
> >>
> >> Run Query (F5)
> >>
> >> It works.
> >>
> >> Add back in 134 to Series field.
> >>
> >> It works
> >>
> >> Save it and save the database.
> >>
> >> Double click on the query to run it.
> >>
> >> Result in:
> >>
> >>> Error code: 1
> >>>
> >>> firebird_sdbc error
> >>> *Dynamic SQL Error
> >>> *SQL error code = -104
> >>> *Invalid usage of boolean expression
> >>> caused by
> >>> 'isc_dsql_prepare'
> >> It appears that the run function is adding an operation that is not in
> >> Query Design view.
> >>
> >> Any suggestions?
> >>
> >> Thanks
> >>
> >> Paul
> >>
> >>
> >> On 1/15/2019 6:19 PM, Paul D. Mirowsky wrote:
> >>> I am receiving the following error when opening a query.
> >>>
> >>>> firebird_sdbc error:
> >>>> *Dynamic SQL Error
> >>>> *SQL error code = -104
> >>>> *Invalid usage of boolean expression
> >>>> caused by
> >>>> 'isc_dsql_prepare'
> >>> The table names are: Amps   Volts-High
> >>>
> >>> The two tables involved both have one boolean field each, so I removed
> >>> them from the query. The error still occurs.
> >>>
> >>> I am taking this to mean that there is a boolean comparison happening
> >>> that is not in the SQL generated by Base.
> >>>
> >>> Is this possible?
> >>>
> >>> Thanks
> >>>
> >>> Paul
> >>>
> >>>
> >>>
> >> --
> >> To unsubscribe e-mail to: users+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/users/
> >> Privacy Policy: https://www.documentfoundation.org/privacy
> >>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Base/Firebird Queries broken

[Drew Jensen]

Howdy Paul,

No you don't need to go back - the parameter substitution is for problems
with sub forms and now I think you are just dealing with SQL differences
between HSQL and Firebird with regards to how it implements joins in select
statements.

On Wed, Jan 16, 2019 at 2:36 PM Paul D. Mirowsky 
wrote:

> Hello Drew
>
> I assumed that you are answering the question on error 104.
>
> I changed the file as per your instructions to
>
> db:parameter-name-substitution="true"
>
> , but error 104 is still there.
>
> Do I have to go back to my original file a migrate again with this fix
> or am I fixing
>
> SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION
> Thanks
>
> Paul
>
> On 1/16/2019 11:42 AM, Drew Jensen wrote:
> > Howdy,
> >
> > Yes, I have a suggestion - there is a property in the Base file which is
> > incorrectly set during the Migration Assistant run and must be fixed. The
> > error message looks like this is what is biting you.
> >
> > The fastest way to fix it is at follows:
> > Close the base file and exit LibreOffice.
> > Rename the base file from .odb to .zip
> > Now open the file with your favorite zip tool.
> > You fill find a file named content.xml in the root of the file.
> > Open that with a text editor.
> > Search for this string: db:parameter-name-substitution="false"
> > Edit that so that it reads db:parameter-name-substitution="true"
> > Save your changes.
> > Close the zip file, it should ask if you want to update the file with the
> > change and answer yes.
> > Change file name back to .odb and you should be good to go.
> >
> > Best wishes,
> >
> > Drew
> >
> > On Wed, Jan 16, 2019 at 11:27 AM Paul D. Mirowsky <
> p_mirow...@bentaxna.com>
> > wrote:
> >
> >> Found this at
> >>
> >>
> https://stackoverflow.com/questions/31611233/determine-firebird-version-with-sql-version-2-1
> >>
> >> |SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION
> >>   >= 2.1 Only problem is, when run as "Execute SQL Statement" menu item,
> >> it errors as
> >>> 1: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104
> >>> *Token unknown - line 1, column 50 *. caused by 'isc_dsql_prepare'
> >> I'm sure it's buried somewhere. Any hints anyone? I am by no means an
> >> SQL expert, Thank you for being patient. Paul |
> >>
> >> On 1/16/2019 2:27 AM, Alexander Thurgood wrote:
> >>> Le 16/01/2019 à 00:19, Paul D. Mirowsky a écrit :
> >>>> Invalid usage of boolean expression
> >>> This bug perhaps ?
> >>>
> >>>
> >>
> http://tracker.firebirdsql.org/browse/CORE-5367?page=com.atlassian.jira.plugin.ext.subversion%3Asubversion-commits-tabpanel
> >>> Not sure which version of Firebird we are using in LO - 3.0.1 or 3.0.2
> ?
> >>>
> >>>
> >>> Alex
> >>>
> >> --
> >> To unsubscribe e-mail to: users+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/users/
> >> Privacy Policy: https://www.documentfoundation.org/privacy
> >>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base/Firebird Queries broken

[Drew Jensen]

Sorry - that last email wen to the wrong mailing list - please disregard it
here.

On Wed, Jan 16, 2019 at 1:14 PM Drew Jensen 
wrote:

> Before I forget - the files used for to gather these runtime numbers are
> found here:
> https://gerrit.libreoffice.org/#/admin/projects/benchmark
>
> There are five xls files with an explanation as to what the spreadsheet is
> evaluating.
>
> They are 4 years old it looks like but seem to be as good as I've found
> for example files for this feature.
>
> Seems to me it might be worthwhile to offer them for download (maybe as a
> zip file) and reference that download location in the video and/or
> associated posting text.
>
> On Wed, Jan 16, 2019 at 1:06 PM Drew Jensen 
> wrote:
>
>> So, can you open that Query definition, the one that raised the error
>> when you double clicked on it, in design view and Run it and it works?
>>
>> Is that what you are saying?
>>
>> Thanks
>>
>>
>> On Wed, Jan 16, 2019 at 12:17 PM Paul D. Mirowsky <
>> p_mirow...@bentaxna.com> wrote:
>>
>>> Ok, things are narrowing down on this issue.
>>>
>>> I have a Query Design view in which I have a field Series set to 134.
>>>
>>> I remove the 134 and press enter.
>>>
>>> Run Query (F5)
>>>
>>> It works.
>>>
>>> Add back in 134 to Series field.
>>>
>>> It works
>>>
>>> Save it and save the database.
>>>
>>> Double click on the query to run it.
>>>
>>> Result in:
>>>
>>> > Error code: 1
>>> >
>>> > firebird_sdbc error
>>> > *Dynamic SQL Error
>>> > *SQL error code = -104
>>> > *Invalid usage of boolean expression
>>> > caused by
>>> > 'isc_dsql_prepare'
>>> It appears that the run function is adding an operation that is not in
>>> Query Design view.
>>>
>>> Any suggestions?
>>>
>>> Thanks
>>>
>>> Paul
>>>
>>>
>>> On 1/15/2019 6:19 PM, Paul D. Mirowsky wrote:
>>> > I am receiving the following error when opening a query.
>>> >
>>> >> firebird_sdbc error:
>>> >> *Dynamic SQL Error
>>> >> *SQL error code = -104
>>> >> *Invalid usage of boolean expression
>>> >> caused by
>>> >> 'isc_dsql_prepare'
>>> > The table names are: Amps   Volts-High
>>> >
>>> > The two tables involved both have one boolean field each, so I removed
>>> > them from the query. The error still occurs.
>>> >
>>> > I am taking this to mean that there is a boolean comparison happening
>>> > that is not in the SQL generated by Base.
>>> >
>>> > Is this possible?
>>> >
>>> > Thanks
>>> >
>>> > Paul
>>> >
>>> >
>>> >
>>>
>>> --
>>> To unsubscribe e-mail to: users+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/users/
>>> Privacy Policy: https://www.documentfoundation.org/privacy
>>>
>>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base/Firebird Queries broken

[Drew Jensen]

Before I forget - the files used for to gather these runtime numbers are
found here:
https://gerrit.libreoffice.org/#/admin/projects/benchmark

There are five xls files with an explanation as to what the spreadsheet is
evaluating.

They are 4 years old it looks like but seem to be as good as I've found for
example files for this feature.

Seems to me it might be worthwhile to offer them for download (maybe as a
zip file) and reference that download location in the video and/or
associated posting text.

On Wed, Jan 16, 2019 at 1:06 PM Drew Jensen 
wrote:

> So, can you open that Query definition, the one that raised the error when
> you double clicked on it, in design view and Run it and it works?
>
> Is that what you are saying?
>
> Thanks
>
>
> On Wed, Jan 16, 2019 at 12:17 PM Paul D. Mirowsky 
> wrote:
>
>> Ok, things are narrowing down on this issue.
>>
>> I have a Query Design view in which I have a field Series set to 134.
>>
>> I remove the 134 and press enter.
>>
>> Run Query (F5)
>>
>> It works.
>>
>> Add back in 134 to Series field.
>>
>> It works
>>
>> Save it and save the database.
>>
>> Double click on the query to run it.
>>
>> Result in:
>>
>> > Error code: 1
>> >
>> > firebird_sdbc error
>> > *Dynamic SQL Error
>> > *SQL error code = -104
>> > *Invalid usage of boolean expression
>> > caused by
>> > 'isc_dsql_prepare'
>> It appears that the run function is adding an operation that is not in
>> Query Design view.
>>
>> Any suggestions?
>>
>> Thanks
>>
>> Paul
>>
>>
>> On 1/15/2019 6:19 PM, Paul D. Mirowsky wrote:
>> > I am receiving the following error when opening a query.
>> >
>> >> firebird_sdbc error:
>> >> *Dynamic SQL Error
>> >> *SQL error code = -104
>> >> *Invalid usage of boolean expression
>> >> caused by
>> >> 'isc_dsql_prepare'
>> > The table names are: Amps   Volts-High
>> >
>> > The two tables involved both have one boolean field each, so I removed
>> > them from the query. The error still occurs.
>> >
>> > I am taking this to mean that there is a boolean comparison happening
>> > that is not in the SQL generated by Base.
>> >
>> > Is this possible?
>> >
>> > Thanks
>> >
>> > Paul
>> >
>> >
>> >
>>
>> --
>> To unsubscribe e-mail to: users+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/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base/Firebird Queries broken

[Drew Jensen]

So, can you open that Query definition, the one that raised the error when
you double clicked on it, in design view and Run it and it works?

Is that what you are saying?

Thanks


On Wed, Jan 16, 2019 at 12:17 PM Paul D. Mirowsky 
wrote:

> Ok, things are narrowing down on this issue.
>
> I have a Query Design view in which I have a field Series set to 134.
>
> I remove the 134 and press enter.
>
> Run Query (F5)
>
> It works.
>
> Add back in 134 to Series field.
>
> It works
>
> Save it and save the database.
>
> Double click on the query to run it.
>
> Result in:
>
> > Error code: 1
> >
> > firebird_sdbc error
> > *Dynamic SQL Error
> > *SQL error code = -104
> > *Invalid usage of boolean expression
> > caused by
> > 'isc_dsql_prepare'
> It appears that the run function is adding an operation that is not in
> Query Design view.
>
> Any suggestions?
>
> Thanks
>
> Paul
>
>
> On 1/15/2019 6:19 PM, Paul D. Mirowsky wrote:
> > I am receiving the following error when opening a query.
> >
> >> firebird_sdbc error:
> >> *Dynamic SQL Error
> >> *SQL error code = -104
> >> *Invalid usage of boolean expression
> >> caused by
> >> 'isc_dsql_prepare'
> > The table names are: Amps   Volts-High
> >
> > The two tables involved both have one boolean field each, so I removed
> > them from the query. The error still occurs.
> >
> > I am taking this to mean that there is a boolean comparison happening
> > that is not in the SQL generated by Base.
> >
> > Is this possible?
> >
> > Thanks
> >
> > Paul
> >
> >
> >
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Base/Firebird Queries broken

[Drew Jensen]

Also - if you would prefer you can make this fix with a small basic macro.

If you would rather go that way here is what you do.

Open the Base file in Libreoffice.
From the menu select:  Tools -> Macros -> Organize Dialogs.
On the Organize Dialogs dialog select the 'Libraries' tab.
On this tab there is a drop down list for 'Location'
Pull that down and you will see your ODB file listed, select it.
Click on the button 'New'
Default name should be 'Library1', choose that DO NOT PUT THIS CODE IN THE
STANDARD LIBARARY
With the basic editor open copy and past the following into the editor

Option Explicit
Sub ensureConnection()
Dim DBDocUI as Object
on error resume next
DBDocUI = ThisDatabaseDocument.currentController
if not DBDocUI.isConnected then
DBDocUI.connect
end if
on error goto 0
End Sub

Sub Main
ensureConnection()
ThisDatabaseDocument.DataSource.Settings.ParameterNameSubstitution = true
End Sub

Execute the macro - the property will be updated.

Now you can remove the 'Library 1' basic library you added, it is no longer
needed.

PS the reason for not updating the standard library is that in Libreoffice
once the Standard library is updated with anything it is difficult to drop
it completely and the file, even if you remove all the code, will form then
on act as if it has embedded macros when it doesn't. If you add a library
with a different name however you can remove it and if standard is also
empty at that time it is also removed and the file will open without the
embedded macro complaint.



On Wed, Jan 16, 2019 at 11:42 AM Drew Jensen 
wrote:

> Howdy,
>
> Yes, I have a suggestion - there is a property in the Base file which is
> incorrectly set during the Migration Assistant run and must be fixed. The
> error message looks like this is what is biting you.
>
> The fastest way to fix it is at follows:
> Close the base file and exit LibreOffice.
> Rename the base file from .odb to .zip
> Now open the file with your favorite zip tool.
> You fill find a file named content.xml in the root of the file.
> Open that with a text editor.
> Search for this string: db:parameter-name-substitution="false"
> Edit that so that it reads db:parameter-name-substitution="true"
> Save your changes.
> Close the zip file, it should ask if you want to update the file with the
> change and answer yes.
> Change file name back to .odb and you should be good to go.
>
> Best wishes,
>
> Drew
>
> On Wed, Jan 16, 2019 at 11:27 AM Paul D. Mirowsky 
> wrote:
>
>> Found this at
>>
>> https://stackoverflow.com/questions/31611233/determine-firebird-version-with-sql-version-2-1
>>
>> |SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION
>>  >= 2.1 Only problem is, when run as "Execute SQL Statement" menu item,
>> it errors as
>> > 1: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104
>> > *Token unknown - line 1, column 50 *. caused by 'isc_dsql_prepare'
>> I'm sure it's buried somewhere. Any hints anyone? I am by no means an
>> SQL expert, Thank you for being patient. Paul |
>>
>> On 1/16/2019 2:27 AM, Alexander Thurgood wrote:
>> > Le 16/01/2019 à 00:19, Paul D. Mirowsky a écrit :
>> >> Invalid usage of boolean expression
>> >
>> > This bug perhaps ?
>> >
>> >
>> http://tracker.firebirdsql.org/browse/CORE-5367?page=com.atlassian.jira.plugin.ext.subversion%3Asubversion-commits-tabpanel
>> >
>> > Not sure which version of Firebird we are using in LO - 3.0.1 or 3.0.2 ?
>> >
>> >
>> > Alex
>> >
>>
>> --
>> To unsubscribe e-mail to: users+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/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Base/Firebird Queries broken

[Drew Jensen]

Howdy,

Yes, I have a suggestion - there is a property in the Base file which is
incorrectly set during the Migration Assistant run and must be fixed. The
error message looks like this is what is biting you.

The fastest way to fix it is at follows:
Close the base file and exit LibreOffice.
Rename the base file from .odb to .zip
Now open the file with your favorite zip tool.
You fill find a file named content.xml in the root of the file.
Open that with a text editor.
Search for this string: db:parameter-name-substitution="false"
Edit that so that it reads db:parameter-name-substitution="true"
Save your changes.
Close the zip file, it should ask if you want to update the file with the
change and answer yes.
Change file name back to .odb and you should be good to go.

Best wishes,

Drew

On Wed, Jan 16, 2019 at 11:27 AM Paul D. Mirowsky 
wrote:

> Found this at
>
> https://stackoverflow.com/questions/31611233/determine-firebird-version-with-sql-version-2-1
>
> |SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION
>  >= 2.1 Only problem is, when run as "Execute SQL Statement" menu item,
> it errors as
> > 1: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104
> > *Token unknown - line 1, column 50 *. caused by 'isc_dsql_prepare'
> I'm sure it's buried somewhere. Any hints anyone? I am by no means an
> SQL expert, Thank you for being patient. Paul |
>
> On 1/16/2019 2:27 AM, Alexander Thurgood wrote:
> > Le 16/01/2019 à 00:19, Paul D. Mirowsky a écrit :
> >> Invalid usage of boolean expression
> >
> > This bug perhaps ?
> >
> >
> http://tracker.firebirdsql.org/browse/CORE-5367?page=com.atlassian.jira.plugin.ext.subversion%3Asubversion-commits-tabpanel
> >
> > Not sure which version of Firebird we are using in LO - 3.0.1 or 3.0.2 ?
> >
> >
> > Alex
> >
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: [libreoffice-website] capabilty to execute macro on a "server" version of libreoffice

[Drew Jensen]

On Sun, Jan 6, 2019 at 10:54 AM Bruno Patin - wanadoo <
bruno.pa...@wanadoo.fr> wrote:

> Hi,
>

Howdy,


>
> I would like to know if there exists roadmap that would allow to create
> a server version of libreoffice that would execute macros job on office
> docs. It would mean a version not using all the interface part of
> libreoffice that would be much more compact. The goal would be to
> process many files using remote services or on some files to automate
> some processing such as creation of html files. Is there something
> foreseen? Is it totally ridiculous? Has it been done and I do not find
> the correct documentation?
>

First - redirecting the reply email to the User mailing list (the website
ML you originally posted to is for issues regarding the LibreOffice website
not the application).

Second - LibreOffice has always had the ability to run in what is referred
to as 'headless' mode. This means there is no GUI active while all the
document processing functions are available. The application even has
command line options specifically designed to take ODF files and generate
other fie types (html for instance) from them, in this non-GUI mode. This
feature is used as a backend for web applications today in production
environments. You can also call macros (sriptis) from the command line and
again if the macro is written properly can run just fine in this headless
mode.

Finally - I don't personally have a bunch of links for you with information
on setting that up but expect others on the users list will.

Best wishes,

Drew

>
>
> Thanks in advance
>
> Bruno
>
>
> --
> To unsubscribe e-mail to: website+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/website/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: How to actually find something with Find in Calc?

[Drew Jensen]

Thanks for finding those issues - I guess lots of folks thinking the same
thing. I tried searching the expert configuration looking for any option
that might change the behavior also.

Also searched the on-line help and the last version of the Calc guide and
found zero entries for "Formatted Display". HMM, but given I'm supposed to
be helping update that guide I suppose I know who can change that, and I
will as soon as I can figure out what it is supposed to actually do ;-)

For whatever it is worth I would happy if the following could be coded:
Allow the setting of the option on the "Find & Replace" dialog under
search[ Formulas, Values, Notes] to stick and to influence the way the
"Find" toolbar searches.


Off to see about adding a comment to the first issue on that, if that
hasn't been suggested yet.

Best wishes,

Drew
Drew

On Sun, Dec 30, 2018 at 12:35 PM V Stuart Foote 
wrote:

> Knew this had come up, with open BZ issues to correct:
>
> tdf#102506 
> ... add Expert configuration option to set search for cell Values in stead
> of Formulas
>
> tdf#102615 
> ... Have Find Bar (Ctrl+F) and Find & Replace (Ctrl+H) search Values by
> default
>
> Think issue was to not change defaults until they could be recorded to user
> profile--UI or Expert Configuration
>
> At the moment with the OpenGrok git reindex running for CORE I'm unable to
> figure out what "Formatted Display" checkbox does.
>
>
>
> --
> Sent from:
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: How to actually find something with Find in Calc?

[Drew Jensen]

Well, just to be clear - tried this with the example spreadsheet here with
version 6.0.7 and 5.4.7 and using FIND does not do what the original poster
is looking for. It seems the only way to find all of those values is by
using FIND & REPLACE.

Now I'm not sure what 'FORMATTED DISPLAY' actually does.

On Sun, Dec 30, 2018 at 10:58 AM Drew Jensen 
wrote:

> @V Stuart
> I thought that also - but that isn't working, as I just proved to myself,
> with LO 6.2.0.1 RC1 (under Ubuntu 18.04.1) at least.
>
> On Sun, Dec 30, 2018 at 10:56 AM V Stuart Foote 
> wrote:
>
>> @Johnny,
>>
>> Unless I am really misunderstanding, the "Formatted Display" check box
>> will
>> shift search results to match against the *values* as formatted to cell.
>>  A
>> generalized implementation of the Find & Replace dialog's "Search in"
>> listbox selection.
>>
>> Should give you your find results via the Find toolbar.
>>
>>
>>
>>
>>
>> --
>> Sent from:
>> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>>
>> --
>> To unsubscribe e-mail to: users+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/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: How to actually find something with Find in Calc?

[Drew Jensen]

@V Stuart
I thought that also - but that isn't working, as I just proved to myself,
with LO 6.2.0.1 RC1 (under Ubuntu 18.04.1) at least.

On Sun, Dec 30, 2018 at 10:56 AM V Stuart Foote 
wrote:

> @Johnny,
>
> Unless I am really misunderstanding, the "Formatted Display" check box will
> shift search results to match against the *values* as formatted to cell.
>  A
> generalized implementation of the Find & Replace dialog's "Search in"
> listbox selection.
>
> Should give you your find results via the Find toolbar.
>
>
>
>
>
> --
> Sent from:
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Scripting LO

[Drew Jensen]

Howdy,

Support for that is built in and is available from a command line or script
as you prefer.

Here is a good overview of that:
https://ask.libreoffice.org/en/question/2641/convert-to-command-line-parameter/

Best wishes,

Drew

On Sun, Dec 23, 2018 at 11:29 AM bunk3m  wrote:

> Hello.
>
> I see that there are a number of ways to script LO  within the program
> itself, but is it possible to automate LO open file and save as odt,
> ods, odp?  Something like Applescript used to be able to manipulate
> programs?
>
> For example,
>
> I have many old files in various formats like .doc, .xls, .ppt,
> Pagemaker, etc. etc. I have concerns about future compatibility and
> access to those documents.
>
> I would to run perhaps a bash script on a folder to open each file in
> the folder and then save it in the appropriate ODF 2.0 format.
>
> Is there a way to script LO like that?
>
> Thank you in advance.
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Calc week number problem

[Drew Jensen]

Howdy,

On Sat, Dec 22, 2018 at 5:17 PM .  wrote:

> Don't know  how the formatting here gets wrecked.  Is there a way to
> attach a file?


Yes - by posting the question using the TDF web site at
https://ask.libreoffice.org/en/questions/ which has full support for
attaching files.

The mailing list however does not support attached files, for the ML  you
would need to supply a url to a networked storage location of your choosing
in the text.

Personally, I can't think of a good answer for you question off the top of
my head and I would like to look as the spreadsheet to see if maybe it
helps to spark an idea of one.

Of course maybe someone else will have a solution just from the description
in your text.

Best wishes,

Drew



> Looks like the one added didn't "attach"
>
> Peter
>
>
> On 12/22/18 3:56 PM, . wrote:
> > I found a LO Calc spreadsheet that provides the year’s day number,
> > remaining days and week number. It's attached herein.Depending upon
> the year it’s tedious to move each week number, which
> > begins on Sunday, so that the week number is in the row which
> > contains a Sunday.Is there a way to modify the sheet in columns F,
> J, N, R, V, Z so
> > that beside each “Sun” (the row in which “Sun” appears) the correct
> > week number will be provided? Thanks,Peter (at least I think that's
> my name...today)   p { margin-bottom: 0.1in; line-height: 120%; }p.western
> { font-family: "Ubuntu"; }p.cjk { font-size: 10pt; }
>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] lobase and postgresql views

[Drew Jensen]

Howdy Lou,

OK, so first thing. Base does not support updating data in Views (postgres
or any other database backend).

Second thing, the order of your columns in a table definition in a
relational database is meaningless for the most part. I know that the Base
Table viewer doesn't allow you to rearrange them, but it should.

Third, what the table viewer doesn't do, the grid control in forms does, so
If you want to see your table in a column (grid) view and with the columns
in a different order than what is in the table definition and you want to
update that data you can use a form.
Start with just a single table. Use the form wizard to create a form based
on the table and select the default grid control for the data. (easiest way
is to just start the wizard, select a table and click Done) With the
physical form opened in edit mode click on the 'Design mode' button on the
form toolbar, you will see the data in the grid control, now you can use
the mouse to move columns around by dragging them, you can expand or
condense the width of columns and change the display formatting for
columns. When you have the columns arranged as you like you save the form
and that will be the default view of the table layout when you open the
form normally going forward.

Fourth - if you need to update data in two tables Base does have limited
support, but again not using Views, with queries. You join the tables
there, include all the keys from both tables in the result set along with
other columns you want to edit and be sure the query runs with the designer
mode enabled in query builder. In those case the resultset should capable
of updates. Otherwise the use of a form-subform using the two tables
certainly will be.

Hope that helps,

Drew

On Tue, Dec 4, 2018 at 2:04 AM Lou  wrote:

> Hi everyone,
>
> This is my first post here.
>
> I have a postgresql database with two tables with an inner join. There
> are about 25 columns in each table, and about 9,500 rows. Since columns
> were added to the table in an order I don't like, I use a view to put
> them in a more logical order.
>
> Problem: when I use lobase to create a form based on the view, it will
> not allow updating.  I can view the data, but not save edited data. Am I
> doing something wrong, or is updating not allowed on views?
>
> Thanks in advance for any help.
>
> Lou
>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: [libreoffice-documentation] Find Character Styles

[Drew Jensen]

Howdy Dave

I just now tried the latest release of the extension (ver 1.4.2) with
6.2Alpha1 and you are correct it fails searching for a character style.
Also, just now, tried that extension with 6.1.3 -> 5.4.7 (all using Ubuntu
18.04) and it works fine for character style searches.

Are you sure the extension is no longer maintained?

Drew

On Sat, Oct 27, 2018 at 10:48 AM Dave Barton  wrote:

> Hi Folks,
>
> Does anyone have any info or pointers about how to find character styles
> in a Writer document?
>
> In the past the Alternative Find & Replace extension was very useful for
> this, but unfortunately it is no longer maintained and something must
> have changed in the 6.x series which causes it to fail in some operations.
>
> TIA
>
> 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: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] [Base] PostgreSQL column w/ default value & Forms: broken in 6.1.2

[Drew Jensen]

Howdy,

Yes that was reported and the issue has been resolved in the coding. Next
releases will include the fix.
See https://bugs.documentfoundation.org/show_bug.cgi?id=120245 for details.

Best wishes,

Drew

On Mon, Oct 8, 2018 at 1:32 PM Albrecht Dreß 
wrote:

> Hi all,
>
> I use LibreOffice as frontend for a PostgreSQL 10.5 database, using the
> native (*not* JDBC) driver.  The minimum way to reproduce the issue is a
> table like
>
> CREATE TABLE tab1 (
>  id bigserial PRIMARY KEY,
>  value text,
>  modtime timestamp without time zone DEFAULT timezone('utc'::text,
> now()) NOT NULL
> );
>
> In LibreOffice I created a form containing these elements, and set the
> property “Input required” on the “Data” tab to “No” for all of them.
>
> Using LibreOffice 6.0.6.2 (Build-ID: 1:6.0.6-0ubuntu0.18.04.1) coming with
> Ubuntu 18.04, this works just fine, in particular it is /not/ necessary to
> enter a value for “id” (marked “” in the form) or for “modtime”.
>
> However, using the official package (Version 6.1.2.1; Build ID:
> 65905a128db06ba48db947242809d14d3f9a93fe) the form is broken.  When I do
> not enter anything in the “modtime” entry, LibreOffice rejects adding a new
> record: a popup is shown, reading
>
> 
> Error writing data to database
> Input required in field 'modtime'. Please enter a value.
> 
>
> which is obviously wrong.
>
> It looks as if LibreOffice 6.1.2 ignores the “Input required” property
> (Actually, in the more complex real project, LibreOffice 6.1.2 requires
> input for columns which are /not/ defined as “NOT NULL” *and* have “Input
> required” set to “No”, but it seems to be harder to reproduce it in a
> minimalistic example).
>
> Did I miss something in the configuration (what?), or is this a bug?
>
> Thanks in advance,
> Albrecht.
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

[Drew Jensen]

Hi,

I would not be surprised if a change in behavior happened recently, there
was some reworking of the sdbc drivers recently which I think had the
chance to touch basically all of them. NOTE: I'm not a developer of that
code but I try to follow along with the generalities through the QA group.

Given two folks seeing the same problem with the latest 6.1.2 build then
whether the postgreSQL driver should be updated for that option or needs
fixing I can't say, but the step right now is to open an issue and get it
started whichever way.

Best way, IMO, since you noticed it first here would be to go ahead and do
that yourself.
This URL assumes you have an account in the bug tracking system.
https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice;component=Base
If you don't have one and register then submit it you will get
notifications as it is worked.

Otherwise, if you really would rather not than one of us in the QA group
can do it.

Let us know.

Thanks

Drew

On Mon, Oct 1, 2018 at 12:57 PM Kamil Jońca  wrote:

> Drew Jensen  writes:
>
> > Hi,
> >
> > You would want to open an issue in the LibreOffice bug tracker and the
> > module would be Base.
> > postgreSQL should be in the summary of course.
> >
> > I know you said this form works with LibreOffice 6.1.1 rc, but I'm
> curious
> > how long it was working in your production environment. Was it working in
> > 6.0 for instance?
>
> I never have registered such probolem, and I use my "application" for
> years.
>
> KJ
>
>
> --
> http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
> "I never let my schooling get in the way of my education."
> -- Mark Twain
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

[Drew Jensen]

BTW

Currently the native MySQL ( MariaDB) sdbc has a setting '
FormsCheckrequiredFields' which can turn that function on or off.
Checking just now the PostgreSQL sdbc code does not currently have that
option.
Yeah, that needs to go into the issue tracker for sure.

Drew

On Mon, Oct 1, 2018 at 10:50 AM Alexander Thurgood 
wrote:

> Le 01/10/2018 à 12:08, Kamil Jońca a écrit :
>
> Hi Kamil,
>
>
> >
> > I  use libreoffice with libreoffice-sdbc-postgresql driver. I do not
> > know where the bug is.
> >
> > I have simple form based on postgresql table.
> > In this table there is a column
> >
> > nametype  nullable
> default value
> > utw timestamp without time zone   not null now()
> >
> > This column does not have its field in form.
> > With package:
> >
>
> I can reproduce this with :
>
> MacOS 10.13.6
> postgres 9.5
> LibreOffice 6.1.2.1
> sdbc built-in postgres driver
>
> If I enter the data in Table data edit mode, then the date is added
> automatically.
>
> However, like you, filling in a simple form including the timestamp
> field and leaving the timestamp field blank always throws an error when
> I try to move to either a new record, or back to a previous record. What
> should happen is that the timestamp value should be generated and the
> record validated (as in Table data edit mode).
>
>
> Alex
>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] libreoffice base/postgres - null columns with trigger/default values

[Drew Jensen]

Also,

In the issue be sure to show which version of PostgreSQL you are using?

Thanks

On Mon, Oct 1, 2018 at 8:08 AM Drew Jensen 
wrote:

> Hi,
>
> You would want to open an issue in the LibreOffice bug tracker and the
> module would be Base.
> postgreSQL should be in the summary of course.
>
> I know you said this form works with LibreOffice 6.1.1 rc, but I'm curious
> how long it was working in your production environment. Was it working in
> 6.0 for instance?
>
> Best wishes,
>
> Drew.
>
>
>
>
>
> On Mon, Oct 1, 2018 at 6:09 AM Kamil Jońca  wrote:
>
>>
>> (This is also described at
>> https://lists.debian.org/debian-user/2018/09/msg01107.html)
>>
>> I  use libreoffice with libreoffice-sdbc-postgresql driver. I do not
>> know where the bug is.
>>
>> I have simple form based on postgresql table.
>> In this table there is a column
>>
>> nametype  nullable
>> default value
>> utw timestamp without time zone   not null now()
>>
>> This column does not have its field in form.
>> With package:
>>
>> --8<---cut here---start->8---
>> Package: libreoffice-base
>> Version: 1:6.1.2-1
>> Package: libreoffice-sdbc-postgresql
>> Version: 1:6.1.2-1
>> --8<---cut here---end--->8---
>>
>> I cannot save filled form to database, because
>> "required utw field has no value"
>>
>> When I drop "not null" from column, and restart libreoffice - form could
>> be saved to database.
>>
>> When I tried with version: 1:6.1.1~rc1-2 of libreoffice packages its
>> works as expected.
>>
>> Should I fill a bug? On debian's page or here? Aginst which
>> package/module?
>> KJ
>>
>>
>>
>> --
>> http://stopstopnop.pl/stop_stopnop.pl_o_nas.html
>> Three may keep a secret, if two of them are dead.
>> -- Benjamin Franklin
>>
>> --
>> To unsubscribe e-mail to: users+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/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] What happened to Base report copy-paste?

[Drew Jensen]

I don't mysql up and running and a slightly newer LibreOffice
Version: 5.4.7.2
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2;

Also a slightly older version
5.3.0 Alpha

This is under Ubuntu 18.04, and I also checked with a couple of newer
versions of LibreOffice, again though only with hsql and firebird embedded
(in some of the newer versions) databases.

I have no problem doing a copy/paste of a report, either into the same ODB
or into a different ODB.

So it is only reports. I assume you can run those RB reports with your
current installation without problem.



On Sat, Sep 22, 2018 at 3:57 PM Girvin Herr  wrote:

> Greetings,
>
> I am running LO 5.3.4.2 under Linux 4.4 and gtk2 2.24.31 and with
> Mariadb 10.0.35 and the mysql-connector-java 5.1.4.2 driver.
>
> I just realized I can no longer copy a Base report and paste it as a new
> report for modification. I do not get the "Insert as" dialog popup to
> change the destination report name. No error, no nothing - as if I never
> did the paste. I tried the mouse popup, ctrl-v, and the edit > Paste
> functions. None worked. This feature works for all but reports. This
> worked fine on older versions, but I do not know where it broke. What
> happened to this valuable feature and is there another way to do a
> report copy-paste?
>
> Thanks.
> Girvin Herr
>
>
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: LibreOffice Basic macro stops working after upgrade from LO 6.0 to LO 6.1

[Drew Jensen]

XGrphic information I've found in the SDK documentation at
sdk/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1graphic_1_1XGraphic.html

Wanting use this also, later this week, for reading images into database
fields with a python script - so happened to look that up over the weekend.
Haven't tried using it yet though.

On Tue, Aug 21, 2018 at 11:40 AM Pusteblumi  wrote:

> Hi Alex,
>
>
> Alex Thurgood wrote
> > Look for a message with the following title on the dev mailing list :
> >
> > API-CHANGE - dropping string properties which use
> > vnd.sun.star.GraphicObject URL
>
> Thanks for your info. After lots of reading, now I know that I used a
> deprecated way of loading image files into a document, and that I'll have
> to
> replace that outdated code.
> I learned that the use of GraphicURL has to be replaced by something called
> XGraphic.
> Now the big question is, where can I find a documentation of that?
>
> Or is this something I should ask directly in that thread on the dev
> mailing
> list?
>
> Cheers,
> Klaus
>
>
>
>
> --
> Sent from:
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base: check boxes in forms lost after update

[Drew Jensen]

Hi,

First the mailing list does not support binary attachments, so the screen
shot is not available. (if you want to share those you need to push them up
to an on-line location and share the url)

As for the form controls, they have changed homes - some of the controls
that in earlier versions where on the 'More Controls' toolbar are now on
the 'Form Controls' toolbar.

I'm using Ubuntu 18.04 and Libo 6.1 RC3 from the tdf download, I'm having
no problem here working with check box controls on Base forms,

So, what might be different from your environment and mine - I'm using GTK2
not 3, what about you?

//drew





On Thu, Aug 9, 2018 at 12:28 PM Albrecht Dreß 
wrote:

> Hi all,
>
> after updating LibreOffice on a Debian stretch system to 6.1.0.2 (build-ID
> 1:6.1.0~rc2-3~bpo9+1), all check boxes in data base forms are lost, and it
> looks as if the icons for form controls toolbar are partly lost (see
> attached screen shot, German locale, i.e. “Markierfeld” is the newly added
> check box).
>
> Furthermore, I see many messages like
>
> (soffice:22104): Gdk-WARNING **: gdk_window_set_icon_list: icons too large
>
> on the console – not sure if this is related.
>
> Is this a “known” issue, for Debian at least?  Any idea how I can fix it?
>
> Thanks in advance
> Albrecht.
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Strange Macro folder behavior

[Drew Jensen]

One more reference for you, particularly if you are trying to use Record
Macro, with much better detail on what could be culprit here.
https://forum.openoffice.org/en/forum/viewtopic.php?f=9=80579#p371390

How it helps,

Drew

On Sun, Jul 22, 2018 at 5:49 PM Peggy <33mar...@gmail.com> wrote:

> I selected some all capitalized text in a title, wanting to make a macro to
> change it to initial caps. Ran the macro, stopped it and it worked. Went to
> the macros under "My macros" in the library to assign a shortcut key.
>
> I couldn't find the macro but found a whole new Folder named with the Title
> I'd selected. Worse yet was a folder with the title of another document I'd
> started. I couldn't find any way to delete either of them.
>
> And even worse, when I looked at "My Macros" they were all gone.
>
> Searched online and there were a couple of questions from people who had
> lost all their macros, but they weren't answered. One was closed by a
> moderator because (something like) it was untimely. Don't quote me on that.
> Whatever it didn't seem the reason for closing it was valid.
>
> I will uninstall and reinstall Libre Office, just losing one template I
> made since my macros are gone. But can anyone tell me what I did to cause
> those new folders? My macors were simple but convenient, and I can create
> them again.
>
> Peggy
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Strange Macro folder behavior

[Drew Jensen]

Howdy,

So, I see that on ask libreoffice this has come up twice and both times
closed out (without an answer) or left unanswered.

There is an old forum post on this that might help in your case. You can
find it here:
https://forum.openoffice.org/en/forum/viewtopic.php?f=5=42324 but that is
back form 2012.

By any chance had you been using the Record Macro feature also?

Best wishes,

Drew

On Sun, Jul 22, 2018 at 5:49 PM Peggy <33mar...@gmail.com> wrote:

> I selected some all capitalized text in a title, wanting to make a macro to
> change it to initial caps. Ran the macro, stopped it and it worked. Went to
> the macros under "My macros" in the library to assign a shortcut key.
>
> I couldn't find the macro but found a whole new Folder named with the Title
> I'd selected. Worse yet was a folder with the title of another document I'd
> started. I couldn't find any way to delete either of them.
>
> And even worse, when I looked at "My Macros" they were all gone.
>
> Searched online and there were a couple of questions from people who had
> lost all their macros, but they weren't answered. One was closed by a
> moderator because (something like) it was untimely. Don't quote me on that.
> Whatever it didn't seem the reason for closing it was valid.
>
> I will uninstall and reinstall Libre Office, just losing one template I
> made since my macros are gone. But can anyone tell me what I did to cause
> those new folders? My macors were simple but convenient, and I can create
> them again.
>
> Peggy
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base : How to control insert into a form in order to generat my own keys by macro ?

[Drew Jensen]

On Sun, Jul 22, 2018 at 2:58 AM Patrick Gelin  wrote:

> Hi,
>
> I would like to control key generation by macro when inserting a new row
> into a form with Base. But the risk is to execute twice insert action :
> the first with my handling insert event (I want to manage the mapping
> and use my own generated keys) and the second by the form base code
> automatically 


There are two paths to this:
One: setup a inert trigger in the database engine to do this.
Details on creating triggers vary depending on the engine you are using.
This works if the data you use to assemble your key is already in the
database (fields in other tables for instance).
OR
Two: handle it with the client application (Base) which seems to be the
advice you are getting so far.

The decision as to which way to go depends on how you want to use it, doing
it with a triggere means that any form, or table grid, attached to the
table will pick up the function but you if you want to read values from
form controls to construct your key the client side work work best.

Best wishes,

Drew

>


> So, if I set the property {AllowInserts = false}, do the Form stop to
> handling the insert but continue to fired /"Before Record Action"/ and
> /"After Record Action"/ events ? I think no, because the form could will

not display the new line to insert ...
>

Ok, that question gets into


>
> So I need to stop the handlind to the Form after my own into events. But
> I understand /"After Record action"/ event handling use a /"Sub"/ action
> not a /"function"/, so I can't return false after my handling ...
>
> So how to do ?
>
> Thank you for your help...
> Patrick
> /
> /
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Predefinied constants (Macro, Basic)

[Drew Jensen]

Howdy,

To the best of my knowledge those are it.

You would need to recreate those once and then include them in later
projects. It's a common thing for folks to do, make their own include
library with such.
In fact you might want to look at the Access2Base library in the
libreoffice distribution, I believe the author may have defined a number of
constants (the whole library recreated VBA functions for use in
LibreOffice), it may be that what you are looking for is already there you
would simply need to load it at runtime. Not to mention you might find some
others things there, coming from a VBA background, useful.

Best wishes,

Drew

On Sun, Jul 22, 2018 at 4:26 PM Johnny Rosenberg 
wrote:

> Hi!
>
> I have done some searching and finally I found this at
> https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants:
>
> ”OpenOffice.org Basic predefines several constants. Among the most useful
> are:
>
>- True and False, for Boolean assignment statements
>- PI as a type Double numeric value”
>
> I assume this is true for LibreOffice as well, but I can't find the rest of
> the ”several constants”.
>
> At work a use Excel (I don't really want to and it's full of bugs, but at
> least I get paid…) and I wrote some macros in VBA. VBA has a lot of
> predefined constants, for instance vbNewLine and a lot more, and I'm now
> trying to find out what constants are available in LibreOffice Basic, since
> LibreOffice is what I use exclusively at home, so I don't have to reinvent
> the wheel.
>
> So a link to a list of ALL predefined Basic constants would be very
> appreciated.
>
> Kind regards
>
> Johnny Rosenberg
>
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] About pseudo objects with Basic code ...

[Drew Jensen]

Let's try sending that reply to the list also. (sorry)

On Mon, Jul 9, 2018 at 6:01 PM Drew Jensen 
wrote:

> Howdy Patrick, et al;
>
> On Mon, Jul 9, 2018 at 9:11 AM Patrick Gelin 
> wrote:
>
>> I think there is a problem with python: nomadism ! If I want to use my
>> USB key with Base connecting to HSQLDB I need to install
>> LibreOffice/OpenOffice into the PC, then JAVA, Then HSQLDB ... then
>> Python ! It's a lot. I would like to use nn install system at work
>> because admin installed LibreOffice and Java but not Python ... So may
>> be for me java would be better than python in this context. What I love
>> with Basic programmation : all it's embeded with my Base application !
>>
>
> Well, maybe the flatpak release package would work better for your
> situation; just a thought.
>
>>
>> *** Do you know a good book for LibreOffice/OpenOffice/UNO Java/Python
>> programmation ? ***
>> What about UNO API if I use Python/Java ? Is there inline documentation ?
>>
> I would recommend first the SDK documentation. The with basic or python
> the use of an object inspector extension wich can link to that
> documentation.
> The SDK is available for download from the main site.
> You can find some information about python object inspectors and editors
> on the wiki at
> https://wiki.documentfoundation.org/Macros/Python_Design_Guide
>
>
>>
>> What about events management if I'm using event catch into extern
>> application ? With basic I can open a simple dialog box to connect
>> events to catch function, but with extern program I will need to
>> register manualy. The interest to use LibreOffice Base is to build
>> rapidedly a simple database interface...
>>
> A lot of the 'how to' pages I find for libreoffice/python start with an
> example of running libreoffice in a mode that allows an external python
> application to interact with it.
> However you can also use python code from within the libreoffice
> application, through the macro support. When you do that then you can setup
> your listeners on many things, like documents or forms, just as easily
> using python as basic. Dialog boxes, as you note, is not one of them. Yes
> you have to set that up in your python script when you prep to instantiate
> the dialog and if you want to use the basic IDE dialog editor you have to
> do a tab bit more in python than basic.
>
>
>>
>> I know, if you use Python or Java you are connected with Uno. But I know
>> also there is some complexity with typing variables between Uno or
>> Java/Python scripts ... And then, I know also Python is using some C++
>> interfaces,by memory for event mangement  Uno is C++ also, isn't it ?
>>
> I would say, think of uno as a specification for an API and the uno
> objects which service requests through the api could be written in more
> then c++. (but IIRC, it has some c++ ish quirks)
>
> I think a python/libreoffice cookbook would be a great idea, btw.
>
> Best wishes,
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] About pseudo objects with Basic code ...

[Drew Jensen]

Howdy Patrick, et al;

On Mon, Jul 9, 2018 at 9:11 AM Patrick Gelin  wrote:

> I think there is a problem with python: nomadism ! If I want to use my
> USB key with Base connecting to HSQLDB I need to install
> LibreOffice/OpenOffice into the PC, then JAVA, Then HSQLDB ... then
> Python ! It's a lot. I would like to use nn install system at work
> because admin installed LibreOffice and Java but not Python ... So may
> be for me java would be better than python in this context. What I love
> with Basic programmation : all it's embeded with my Base application !
>

Well, maybe the flatpak release package would work better for your
situation; just a thought.

>
> *** Do you know a good book for LibreOffice/OpenOffice/UNO Java/Python
> programmation ? ***
> What about UNO API if I use Python/Java ? Is there inline documentation ?
>
I would recommend first the SDK documentation. The with basic or python the
use of an object inspector extension wich can link to that documentation.
The SDK is available for download from the main site.
You can find some information about python object inspectors and editors on
the wiki at
https://wiki.documentfoundation.org/Macros/Python_Design_Guide


>
> What about events management if I'm using event catch into extern
> application ? With basic I can open a simple dialog box to connect
> events to catch function, but with extern program I will need to
> register manualy. The interest to use LibreOffice Base is to build
> rapidedly a simple database interface...
>
A lot of the 'how to' pages I find for libreoffice/python start with an
example of running libreoffice in a mode that allows an external python
application to interact with it.
However you can also use python code from within the libreoffice
application, through the macro support. When you do that then you can setup
your listeners on many things, like documents or forms, just as easily
using python as basic. Dialog boxes, as you note, is not one of them. Yes
you have to set that up in your python script when you prep to instantiate
the dialog and if you want to use the basic IDE dialog editor you have to
do a tab bit more in python than basic.


>
> I know, if you use Python or Java you are connected with Uno. But I know
> also there is some complexity with typing variables between Uno or
> Java/Python scripts ... And then, I know also Python is using some C++
> interfaces,by memory for event mangement  Uno is C++ also, isn't it ?
>
I would say, think of uno as a specification for an API and the uno objects
which service requests through the api could be written in more then c++.
(but IIRC, it has some c++ ish quirks)

I think a python/libreoffice cookbook would be a great idea, btw.

Best wishes,

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] About pseudo objects with Basic code ...

[Drew Jensen]

Howdy Tom,

Well, I was specifically asking Mauricio, after looking over the example
basic code particularly, I am interested in his thoughts.

As for this being the user mailing list, macros are user level question I
would think, Basic is assumed usually, but Python is just as valid and
about as easily done these only to drop in a couple of extensions.  Maybe
it is a power user question, but still a user question, yes?

However, I suppose your'e right when moving on to talking about generating
extension packages from macros libraries (basic or python).

Thanks

On Sun, Jul 8, 2018 at 3:50 PM Tom Davies  wrote:

> Hi :)
> I think the Devs Mailing list or IPA, IIRC or whatever is prolly better at
> giving a good answer to that.  They may be annoyed as it's prolly not what
> they usually post to there.  Maybe it's best to try the QA Team?
>
> There used to be a "mentoring" program to help people start to code for
> LibreOffice.
>
> I think LibreOffice is mainly Python but with significant chunks of C, C++
> and C# and smaller amounts of other code.  I think pretty much all the Java
> has been over-written in Python now.
>
> There may be some devs on this mailinglist who can answer you but it
> doesn't hurt to have other places to ask too.  Actually i thought you were
> one of our devs but there we go.  I know you have done a lot for LO.
> Good luck and regards from
> a Tom :)
>
>
>
>
> On 8 July 2018 at 20:30, Drew Jensen  wrote:
>
>> Howdy, Mauricio, Patrick
>>
>> I am curious as to why you think python is always the better choice? (ie.
>> error handling, or whatever; or is it just always so in Patrick's use case
>> and the example code you supplied there)
>>
>> Also, I you don't mind me asking. I'm new python scripting in LibreOffice.
>>
>> Do you have recommendations for setting up tools with LibreOffice to with
>> Python scripts and perhaps then turning those into an extension.
>>
>> Right now I am using the following: LibreOffice 6.x, APSO (latest), MRI
>> (latest), MS Video Code. Which of those would, if any, would you suggest I
>> look at replacing.
>>
>> Thanks and best wishes,
>>
>>
>> On Sun, Jul 8, 2018 at 3:13 PM Mauricio Baeza Servin 
>> wrote:
>>
>> > On Sun, 8 Jul 2018 21:03:02 +0200, Patrick Gelin > >
>> > wrote:
>> >
>> > > Ok, with a factory for self variable into pseudo objects. I was
>> thinking
>> > > of this solution already, but I was hoping a better solution in next
>> > > version ...
>> > > - Do you need this pseudo object code could be better object model
>> > > complient next day ?
>> > > - Or do you think python will be a better way for
>> OpenOffice/LibreOffice
>> > > futur ?
>> > >
>> >
>> >
>> > Of course, definitely, Python is much better, I always recommend; learn
>> > and used Python with LibreOffice
>> >
>> >
>> > Best regards
>> > --
>> > To unsubscribe e-mail to: users+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/users/
>> > Privacy Policy: https://www.documentfoundation.org/privacy
>> >
>>
>> --
>> To unsubscribe e-mail to: users+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/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] About pseudo objects with Basic code ...

[Drew Jensen]

Howdy, Mauricio, Patrick

I am curious as to why you think python is always the better choice? (ie.
error handling, or whatever; or is it just always so in Patrick's use case
and the example code you supplied there)

Also, I you don't mind me asking. I'm new python scripting in LibreOffice.

Do you have recommendations for setting up tools with LibreOffice to with
Python scripts and perhaps then turning those into an extension.

Right now I am using the following: LibreOffice 6.x, APSO (latest), MRI
(latest), MS Video Code. Which of those would, if any, would you suggest I
look at replacing.

Thanks and best wishes,


On Sun, Jul 8, 2018 at 3:13 PM Mauricio Baeza Servin 
wrote:

> On Sun, 8 Jul 2018 21:03:02 +0200, Patrick Gelin 
> wrote:
>
> > Ok, with a factory for self variable into pseudo objects. I was thinking
> > of this solution already, but I was hoping a better solution in next
> > version ...
> > - Do you need this pseudo object code could be better object model
> > complient next day ?
> > - Or do you think python will be a better way for OpenOffice/LibreOffice
> > futur ?
> >
>
>
> Of course, definitely, Python is much better, I always recommend; learn
> and used Python with LibreOffice
>
>
> Best regards
> --
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] LibreOffice - Macro - Java - Eclipse

[Drew Jensen]

For Python there is an extension available which helps, don't think it
would do much with Eclipse, but for generalized use it seems pretty good.
https://extensions.libreoffice.org/extensions/apso-alternative-script-organizer-for-python



On Tue, Sep 19, 2017 at 12:11 PM, Volker Lenhardt <
volker.lenha...@uni-due.de> wrote:

> Hi Thomas,
>
> Am 19.09.2017 um 13:38 schrieb Thomas Wielatt:
>
>>
>> I do think it's quite uncomfortable to use the basic language to code any
>> macros. It's possible to use Java or Python but it's not easy to add these
>> macros to the document. I really do think it'll be a major breakthrough for
>> LO if it's bundled with Eclipse.
>>
>> Is there anyone working on this kind of feature or is there any developer
>> group where to ask this question?
>>
>
> I can't help you with an LO IDE for Java or Python. But I found a way to
> work with embedded macros using Python under Linux. At first sight it seems
> to be complicated, but once established it works smoothly.
>
> I made a PDF file describing my experiences - in German. Maybe you get
> some clues out of it.
>
> https://www.uni-due.de/~abi070/count.php?id=Erfahrungsbericht.pdf
>
> If you come up to some more straightforward solution, I'll be happy to get
> informed.
>
> Good luck
> Volker
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

[Drew Jensen]

Howdy Peter,

I'm only a user of the software. Anyone can request a change and it is
pretty easy to do.
Likely getting one of the developers to want to code it will be a bit more
of a trick, but there is a process and if no one ever enters a request it
certainly won't happen.

Just in case:
- the project uses a ticket system called Bugzilla to track defect reports
and enhancement requests found at https://bugs.documentfoundation.org
- you don't need to create an account in that system if all you want to do
is view what is in the works, but you will need to create one to open a new
request or report a bug.
- there is an explanation of the bug entry process here:
https://wiki.documentfoundation.org/QA/BugReport
--  for an enhancement the only difference is enter a severity level of
'enhancement'

Anyway, I haven't said boo here in a long while but recently have been
looking at the issue tracker and I noticed that there is some talk of
adding a 'search and replace' feature for Base which is what got me
thinking it might be a good moment. On the other hand there is a big push
to finish up the support for a different db engine so an RFE might get lost
in the noise of that..

But hey it sounds like a good idea and if you want to start the process
great, if not, I just might..

Best wishes,






On Sat, Jan 28, 2017 at 5:37 AM, ptoye  wrote:

> Hi Drew,
>
> I'm very happy to hear that Base is being worked on. It's always struck me
> as the Cinderella app in the suite.
>
> Would you like me to issue a RFE or will you do it yourself?
>
> IMHO, even more important than this would be Update and Delete queries.
> It's been decades since I used MS Office, but I remember them as being
> available in about 2000. And very useful as one doesn't have to learn SQL.
>
> Best regards,
>
> Peter
> mailto:l...@ptoye.com
> www.ptoye.com
>
> -
> Friday, January 27, 2017, 5:43:50 PM, you wrote:
>
>
> howdy,
>
> Ah, considering that the project is actively working on the Base module at
> the moment this might be a great time to open a Request For Enhancement.
> In this case a request to add a ReloadWith (for example) function on the
> data set (form) which would reload the data using the current parameter
> variables entered on the initial load.
>
> Just a thought and it couldn't hurt. I think your use case is common enough
> that merits a discussion at least.
>
>
> On Fri, Jan 27, 2017 at 10:21 AM, ptoye <[hidden email]> wrote:
>
> > Hi Robert,
> >
> > I've had a look at some of your forms now, especially
> > filter_without_macros and I'm a bit puzzled. I see that the table in the
> > Display part of the form is populated by the "filterquery" query, which
> > references "filter". The table "filter" has one entry - the selection(s)
> I
> > made in the listbox. But I can't see how the listbox selections get put
> > into the "filter" table. Can you please help me there? I also can't
> > understand why there are two columns in the "listbox_n_simple", but
> that's
> > of less importance.
> >
> > Best regards,
> >
> > Peter
> > mailto:[hidden email]
> > www.ptoye.com
> >
> > -
> > Tuesday, January 24, 2017, 4:47:52 PM, you wrote:
> >
> >
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > Hi Peter,
> >
> > have a look here:
> > http://robert.familiegrosskopf.de/lo_hb_en/Example_Search_and_Filter.odb
> >
> > You don't need anything elese but a form and a subform. The example
> > includes different forms, some of them working without any macro.
> >
> > Regards
> >
> > Robert
> > - --
> > Homepage: http://robert.familiegrosskopf.de
> > LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> > -BEGIN PGP SIGNATURE-
> > Version: GnuPG v2
> >
> > iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k
> > bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N
> > huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q
> > alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL
> > SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6
> > rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ
> > gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3
> > q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd
> > hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa
> > 3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5
> > JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd
> > ILXQuH+aT+/Mas+L4BdB
> > =zULF
> > -END PGP SIGNATURE-
> >
> > --
> > To unsubscribe e-mail to: [hidden email]
> > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> > unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
> >
> >
> >
> >
> > If you 

Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

[Drew Jensen]

howdy,

Ah, considering that the project is actively working on the Base module at
the moment this might be a great time to open a Request For Enhancement.
In this case a request to add a ReloadWith (for example) function on the
data set (form) which would reload the data using the current parameter
variables entered on the initial load.

Just a thought and it couldn't hurt. I think your use case is common enough
that merits a discussion at least.


On Fri, Jan 27, 2017 at 10:21 AM, ptoye  wrote:

> Hi Robert,
>
> I've had a look at some of your forms now, especially
> filter_without_macros and I'm a bit puzzled. I see that the table in the
> Display part of the form is populated by the "filterquery" query, which
> references "filter". The table "filter" has one entry - the selection(s) I
> made in the listbox. But I can't see how the listbox selections get put
> into the "filter" table. Can you please help me there? I also can't
> understand why there are two columns in the "listbox_n_simple", but that's
> of less importance.
>
> Best regards,
>
> Peter
> mailto:l...@ptoye.com
> www.ptoye.com
>
> -
> Tuesday, January 24, 2017, 4:47:52 PM, you wrote:
>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi Peter,
>
> have a look here:
> http://robert.familiegrosskopf.de/lo_hb_en/Example_Search_and_Filter.odb
>
> You don't need anything elese but a form and a subform. The example
> includes different forms, some of them working without any macro.
>
> Regards
>
> Robert
> - --
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k
> bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N
> huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q
> alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL
> SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6
> rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ
> gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3
> q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd
> hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa
> 3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5
> JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd
> ILXQuH+aT+/Mas+L4BdB
> =zULF
> -END PGP SIGNATURE-
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>
>
>
> If you reply to this email, your message will be added to the discussion
> below:
> http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-
> parameter-query-tp4206066p4206117.html
> To unsubscribe from Can I reload a form based on a parameter query?, click
> here.
> NAML
>
>
>
> -
> Peter
> --
> View this message in context: http://nabble.documentfoundation.org/Can-I-
> reload-a-form-based-on-a-parameter-query-tp4206066p4206363.html
> Sent from the Users mailing list archive at Nabble.com.
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

[libreoffice-users] Fwd:

[Drew Jensen]

http://lasvegassuites.org/downrightawesome.com/nanw54.php?s=ot


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

Re: [libreoffice-users] Re: Keyboard Shortcuts for Buttons in Base

[Drew Jensen]

Howdy Noel,

Sure, for a button in the label add a tilde ~ before the letter you want to
use as the keyboard accelerator.

In the case of a data control on a form you do similar, add a label
control, in the text for the label add the ~ before the character you want
to use and then for the actual data entry control, in the property editor
for the control set the property 'Label Field' to the name of the label
control. hmm, easier to do then to write, that last bit atually.

//drew


On Thu, Jan 17, 2013 at 10:16 AM, Tom tomdavie...@yahoo.co.uk wrote:

 Hi :)
 Sorry for the lack of responses from the Users List!  Have you been able to
 solve this issue or move on or are you still hunting for an answer.  Please
 let us know and we might try to be better at answering this time.  New Year
 was a bit hectic for a lot of us.
 Regards from
 Tom :)



 --
 View this message in context:
 http://nabble.documentfoundation.org/Keyboard-Shortcuts-for-Buttons-in-Base-tp4026266p4029949.html
 Sent from the Users mailing list archive at Nabble.com.

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



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

Re: [libreoffice-users] Libreoffice 3.6

[drew jensen]

On Wed, 2012-08-08 at 21:22 +0200, Johnny Rosenberg wrote:
 2012/8/8 Jeff Hahn kr...@hotmail.com:
 
 
 
 
  I have two questions on LibreOffice
  3.6.0. First, when I go to the Macro in Calc
  (Tools – Macros) the record macro function is no longer there.
 
 I have LibreOffice 3.5.5.3 and there is no record macro option there
 either. Seems that they gave up that crap a while ago. Good. It was
 embarrassingly useless anyway.
 There is a better macro recorder extension somewhere, but it is pretty
 useless anyway.

Hi,

The record macro feature is turned off by default in the newer releases,
it is however still there.

For version 3.6:
ToolsOptionsGeneral
You will find a separate setting option for the macro recorder.

For version 3.5.5:
Same options dialog, but record macro is enabled/disabled by using the
experimental features option.
[I believe - if I'm wrong then it will be a separate option there also]

Otherwise, the record macro feature has be considered rather buggy for a
long while and if you do make heavy use of macros I would urge to take
the time to learn how to write them directly, versus the record feature.

One good resource for this is the Macro document put together by Andrew
Pitonyak and available at:

http://www.pitonyak.org/oo.php/

The branding is all wrong ;) but the information is still valid - for
now.

HTH,

//drew

 
   I
  can run existing macros, I just cannot find where to create new ones.
   Where do I go to create new one?
 
 Do you mean how to record them, or how to write them?
 
 
 
 Kind regards
 
 Johnny Rosenberg
 ジョニー・ローゼンバーグ
 



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

Re: [libreoffice-users] Re: I have a question

[drew jensen]

On Sat, 2012-07-28 at 08:35 -0700, Lynne Stevens wrote:
 
 omega
   The
 Omega sector
 America's Last
 Line of
 Defense
 
 *That sounds like they will be merged ! . . They are to remain separate 
 and the B file is to be used for a mailing thing after it has the 
 duplicates removed . . the mailing thing I have figured out and what 
 fields/columns to use ! !

Hi Lynne, others

First - do you want to do this here or on the Ubuntu forums.. :)


If this where a relational database and two tables (with the same
columns structure) then it is a simple MINUS function:

SELECT * FROM TABLE1
MINUS
SELECT * FROM TABLE2

That statement will return all records in TABLE1 that are not also in
TABLE2.

However you have here 2 CSV files, and one of those files IIRC has a
column with a different name.

I don't thin you told folks here about how you are getting the data.

Andreas may have a good way to do that completely in Calc (he is much
better at Calc then I ever will be)

However is this is something you will need to do on a continuing basis
(with new CSV files arriving from time to time) then I would set this up
under Base and attach the two CSV files as TEXT tables. With that done,
then you can use the MINUS command.

It's a little bit of work to set up the connection, but one done you can
reuse it just by overwriting the source files with the data as need. 

//drew

 
 
 
 *
 
 On 07/28/2012 06:38 AM, Andreas Säger wrote:
  Am 28.07.2012 14:17, Lynne Stevens wrote:
 
 
  omega
   The
  Omega sector
  America's Last
  Line of
  Defense
 
  *How do I check for duplicates in a data base using another data base ?
 
 
 
  *
 
 
 
  SELECT A.*
  FROM A JOIN B ON A.ID = B.ID
 
  returns all rows from table A with an equivalent ID in table B.
 
 
 
 



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

Re: [libreoffice-users] Other SQL question as it affects Base

[drew jensen]

On Sat, 2012-07-28 at 15:36 -0400, Dan wrote:
 An example of an inner join:
 table1 INNER JOIN table2 ON table1.foreign key=table2.primary key
 
   Mathematically the following seems to be possible:
 table1 INNER JOIN table2 ON table1.foreign key=2*table2.primary 
 key
 
  Is the latter also an INNER JOIN? There seems to be other possible 
 multipliers other 
 than 2. Also, what about inequalities? For example, wanting to see all the 
 rows of data 
 for which the foreign key is less than the MAX, MIN, or Ave of the primary 
 key. (These are 
 three suggested ON expressions for an INNER JOIN. Using greater than rather 
 than less 
 than is another possibility.)
 
   I'm curious since I have a mathematical background. Any ideas?
 
 --Dan
 

Absolutely 
- or even odder things, often with a where

tbl1 as t1 inner join tbl2 as t2
on t1.ID = t2.FK
where mod( t2.ID,2 )  0


back to watching men's floor exercise then..

//drew




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

Re: [libreoffice-users] starting Base - works for me

[drew jensen]

On Fri, 2012-07-27 at 10:41 -0400, webmaster-Kracked_P_P wrote:
 OK
 I just installed the non-repository version of 3.5.5 as an upgrade to 
 3.5.4 on my Ubuntu 12.04/MATE laptop.
 
 I still have Base listed, and working, in my Applications/Office menu 
 listing.

Hi,

Right - if you already had Base installed then an update will include
it.

//drew

 
 It shows:
 
  LibreOffice 3.5
  LibreOffice 3.5 Base
  LibreOffice 3.5 Calc
  LibreOffice 3.5 Draw
  LibreOffice 3.5 Impress
  LibreOffice 3.5 Printer Administration
  LibreOffice 3.5 Writer
 
 in that order.
 
 SO
 it could be the Repository version of LO and its desktop-integration 
 package, of it could be Unity's menu system.
 
 As I said, I use MATE for Ubuntu 12.04 and I see Base in the menu.
 
 I use MATE so I have the best looking GNOME desktop that looks and 
 acts like the GNOME desktop that I use for my desktop's 10.04/GNOME 
 system.  I use the 10.04 system as my default system and wanted any of 
 my other Ubuntu systems run either 10.04 or 12.04/MATE so it looks/works 
 like I want it to do.
 
 On 07/27/2012 10:23 AM, webmaster-Kracked_P_P wrote:
 
  I have not loaded 3.5.5, but I have 3.5.4 on my Ubuntu 12.04 laptop 
  with MATE as its desktop environment and it does show Base in the 
  applications/office menu.
 
  Also, I installed LibreOffice from the download site and not the 
  repository.
 
  I was planning on installing 3.5.5 on the laptops [Ubuntu, XP, and 
  Vista] but I did not have the time.
 
  Actually we had a tornado pass by yesterday about 1 mile north of me 
  and almost hit one of our two hospitals.  They are stopping people 
  from entering our city, unless you live or work here - and can prove it.
 
  I will install 3.5.5 on my laptop in a few minutes and see what 
  happens with Base.
 
 
  On 07/27/2012 10:00 AM, Don C. Myers wrote:
  Hi,
 
  I run Ubuntu 12.04 with Unity. Did you download LO 3.3.5 from 
  LibreOffice, or are you using the Ubuntu repository version. In 
  Ubuntu, the default install from Ubuntu for LibreOffice does not 
  include Base. It can be added separately through the software center. 
  Be careful also not to mix the two versions, the one from the 
  repository and the one from LibreOffice directly.
 
  Don
 
 
  On 07/27/2012 09:43 AM, Heinrich Stoellinger wrote:
  Hello,
  I have just installed libreoffice 3.5.5 on my lately upgraded Mint
  system (Maya). When I now start LO the entry for base doesn't appear.
  On the other hand, writer, impress, calc, etc. DOES appear. Any idea
  what might be the cause?
  Thanks
  H. Stoellinger
 
 
 
 
 
 



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

Re: [libreoffice-users] now can Purchase a NA-DVD

[drew jensen]

On Sat, 2012-07-21 at 18:18 -0400, webmaster-Kracked_P_P wrote:
 DO you have a broadband Internet connection?  The .iso file is listed here.
 http://www.libreoffice.org/download/?type=boxversion=3.5.5
 If you do not have broadband connection, there should be a way for you 
 to get a copy from some source.  I have shipped one to Malta from the 
 USA, but do not like to spend my own money on shipping, most of the time.
 
 --

Hi Anthony,


Please remember I'm still waiting on a review copy - so I would
recommend holding off till that arrives 

I did receive a ship notice / tracking number, for the review disk today
via email - so it should be here in a couple of days. 

On the retail order page there is a drop down for country - this lists
all the locations they will ship to - New Zealand? Yes.

Look also, if you are willing to go with postal delivery, that the
shipping fees are not too bad, at all, for NZ.

Best wishes,

//drew


 
 Here is a link to the Online version of the DVD. [actually to the 
 Install page]
 http://libreoffice-na.us/English-3.5-installs/install.html
 
 Browse this site and you will find all of the files and such on the 
 DVD.  The online site tends to get updated more often than the physical 
 media or the .iso file does, but still it will give you a look at the DVD.
 
 Right now, the only real updates to the online version [same as the 
 physical one really] is the fact that there are 2 more chapters in Draw 
 online than the one that can be bought or the .iso file to be downloaded.
 
 Mostly there are the documentation, the 180+ dictionaries, the 
 extensions, templates, artwork, the extra free packages, etc., etc..  I 
 did not fee that a DVD should contain only the basic install files for 
 LibreOffice.  That would be a waste of a DVD. So it got filled with a 
 lot of things that I [and others] thought a user might want to have with 
 him/her on a DVD so that they did not have to go looking for it 
 elsewhere.  I must have 99% of the dictionaries that can work with 
 LibreOffice, unless you get them via any language packages, like you 
 need for a Linux install.
 
 http://www.libreoffice.org/download/?type=boxversion=3.5.5
 On 07/21/2012 05:44 PM, Anthony Easthope wrote:
  I am curious as to what the 2gb of extras contain! I am considering
  purchasing a dvd but not sure if it is able to be shipped to New Zealand
  if it could that would be great!
 
  On Sat, 21 Jul 2012, at 04:07 AM, Fabian Rodriguez wrote:
  On 07/20/2012 10:08 AM, webmaster-Kracked_P_P wrote:
  Thanks to Drew, we now have a service that will print-on-demand a
  copy of the LibreOffice North American Community DVD - version 3.5.5.
 
  Here is a link for a direct retail page:
  http://kunaki.com/sales.asp?PID=PX00B1FF2L
  **Kunaki handles all the payment collection.**
 
  [...]
 
  Well done, Drew! I had been researching manufacturers, this is the same
  used by Raphael Hertzog to distribute his Debian remix:
  http://raphaelhertzog.com/products/debian-cd-dvd/
 
  I had that in my personal ToDo for a while
  (http://wiki.documentfoundation.org/User:MagicFab/LibODVD#ToDo), glad
  you're validating it. If/when you have a sample of what they ship, it'd
  be important to have pictures. I'll order one to carry it and use as a
  demo. I plan to finish my local design and use the same ship by
  september.
 
  Cheers,
 
  Fabian Rodriguez
  http://libreoffice.magicfab.ca
 
 
  -- 
 
 
 
  -- 
  For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
  Problems?
  http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
  Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
  List archive: http://listarchives.libreoffice.org/global/users/
  All messages sent to this list will be publicly archived and cannot be
  deleted
 
 
 
 



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

Re: [libreoffice-users] Base and SQL statement

[drew jensen]

On Fri, 2012-07-20 at 09:51 -0400, Dan wrote:
 The outline for the FROM clause for a LEFT OUTER JOIN is
 
 FROM “table1 name” LEFT OUTER JOIN “table2 name” ON “table1 
 name”.”foreign key” = “table2 name”.”primary key”
 
   This is what I entered into a query yesterday. Yet, today when I 
 edited the query in SQL view I saw
 
 FROM { OJ Persons LEFT OUTER JOIN Orders ON Persons.P_ID = 
 Orders.P_ID }
 
   Braces and OJ were added. This is using LO 3.5.5.3. I got a 
 similar result when using SQL to create a RIGHT OUTER JOIN. Does anyone 
 know where this is documented? It appears Base is adding this for 
 clarity. Should this be included this in the documentation?
 

Hi Dan

The use of ODBC conventions, '{ OF' for example, is controlled with an
option on the ODB file.

Open the ODB.
Open the dialog for options:
EditDatabaseAdvanced Options

//drew




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

Re: [libreoffice-users] Quickstarter is missing from LO3.5.5. onDebian

[drew jensen]

On Fri, 2012-07-13 at 09:27 -0400, webmaster-Kracked_P_P wrote:
 On 07/13/2012 06:48 AM, Mirosław Zalewski wrote:
  On 13/07/2012 at 12:28, Anthony Easthope antiso...@myopera.com wrote:
 
  I thought most debian releases had unity or at least GNOME 3 as their
  GUI and they all feature a Dock.
  There is no Unity for virtually anything apart from Ubuntu (+derivatives, 
  such
  as Kubuntu, Mint etc.). Fedora and Arch had packages for 2D version (that is
  fallback version without desktop effects), but at least Fedora strongly
  considered removing them. Unity was never in Debian repository. There was 
  some
  team that wanted to package Unity and put it Debian's repo, but there hasn't
  been any progress for quite long time. It's unlikely to see Unity in Debian
  anytime soon, if ever.
 
  But most of distributions out there has packages of GNOME 3, yes.
 
 I use MATE with my Ubuntu 12.04 desktop, instead of GNOME 3 or Unity.  
 Works better for me.
 
 I do not like a tablet-looking environment for my desktop work. Win8 
 went this route and it was just bad.
 
 As for the quickstart, well I prefer to have start icons on my top 
 panel.  Some extensions need the quickstart to be turned off to 
 update, of at least they use to when I used a quickstart.
 
 I find that with a desktop running a mid-range 2 year old CPU, LO starts 
 up very fast compared to what it did last year, so a quick starting 
 option is no longer needed.

Hi Tim,

I couldn't agree more with that last comment.

Here is a quick screen capture I did for an example:
https://plus.google.com/b/100933269401814278228/100933269401814278228/posts/K157cWoutd5

In the video it starts just as I click on the LibO icon on the desktop.
As I say in the post there this is a warm start - then I open the about
box just to show the version.

Best wishes,

//drew

 
 



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

Re: [libreoffice-users] Quickstarter is missing from LO3.5.5. onDebian

[drew jensen]

On Fri, 2012-07-13 at 15:16 +0100, AG wrote:
 On 13/07/12 15:04, drew jensen wrote:
  On Fri, 2012-07-13 at 09:27 -0400, webmaster-Kracked_P_P wrote:
  On 07/13/2012 06:48 AM, Mirosław Zalewski wrote:
  On 13/07/2012 at 12:28, Anthony Easthopeantiso...@myopera.com  wrote:
 
snip

 
  I find that with a desktop running a mid-range 2 year old CPU, LO starts
  up very fast compared to what it did last year, so a quick starting
  option is no longer needed.
  Hi Tim,
 
  I couldn't agree more with that last comment.
 
  Here is a quick screen capture I did for an example:
  https://plus.google.com/b/100933269401814278228/100933269401814278228/posts/K157cWoutd5
 
  In the video it starts just as I click on the LibO icon on the desktop.
  As I say in the post there this is a warm start - then I open the about
  box just to show the version.
 
  Best wishes,
 
  //drew
 
 
 Hi Drew
 
 I noticed from the video that you are using 3.6 beta. How long have you 
 been using it for and is sufficiently stable to rely on for academic 
 work? Any noticeable advantages over 3.5.*?
 

Actually over all it seems rather stable - I've run into rough spots
with one extension is all.

As for the video being 'so yesterday' - seems 3.5 RC1 is out and ready -
from the announcement a few minutes ago:

Please be aware that LibreOffice 3.6.0 RC1 is not ready for
production use, you should continue to use LibreOffice 3.5.5 for that.

The release is available for Windows, Linux and Mac OS X from our QA
builds download page at

  http://www.libreoffice.org/download/pre-releases/

The (still growing) list of features for the upcoming 3.6.0 is on our
wiki - please help filling gaps there, e.g. by providing more
screenshots:

 http://wiki.documentfoundation.org/ReleaseNotes/3.6 

so - I haven't tired that RC with my problematic extension, it is still
only a 'candidate'.

//drew


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

Re: [libreoffice-users] Folders for QUERIES in the DATABASE window?

[drew jensen]

On Sun, 2012-06-24 at 19:14 -0700, frofa wrote:
 Is it possible to create virtual FOLDERS in the QUERIES pane of the BASE
 database window - as one can in the FORMS and REPORTS panes?

Hi Frofa,

No - that is not implemented for query definitions, only forms and
reports.

//drew

 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Folders-for-QUERIES-in-the-DATABASE-window-tp3992040.html
 Sent from the Users mailing list archive at Nabble.com.
 



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

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

[drew jensen]

On Sat, 2012-05-26 at 12:53 +0200, Andreas Säger wrote:
 Am 26.05.2012 00:47, Girvin R. Herr wrote:
 
  As an update to my problem with Report Builder, my 1500+ record database
  takes 94 pages of a Report Builder / Writer document. I put on my
  patience hat and timed how long it takes to format the report, ready for
  printing. As a baseline, it takes about 49 minutes to create the
  original document. I cleared my preferences and re-entered them, using
  mostly defaults and timed it again: 49 minutes. So it is not preference
  corruption from previous versions. I then updated my java to 1.6u30 and
  timed it again: 49 minutes. So, it doesn't look like Java is the
  problem. I then went back to my original use of SQL from when I created
  the report with the wizard, rather than using a query for the data and
  timed it: 49 minutes! No matter what I do, it takes about the same
  excruciatingly long time to build my report. What is really frustrating
  is that there is no status popup to inform me of what it is doing. It
  just goes out to lunch. Actually, it seems to initially create 128 pages
  with header and footer, but no data, at the end of the first sleep.
  When the page status at the bottom of the writer window drops to 94
  pages, I know it is done. Every so many pages, it does come back alive
  for a second or two and then goes out to lunch again for several
  minutes. Each time it returns, a few more pages are populated with data.
  Girvin
 
 
 
 Every time when there is a performance problem with this office suite, 
 Tom blames Java. It has to be Java just because Java is evil.
 
 Now this may be related to the one and only Java related performance 
 problem and Tom does not even notice.
 
 You are running the combination of Linux, Base plus JDBC?

Ah I missed that last bit - yup, those JDBC connections can suck - has
the OP tried ODBC?

//drew

 
 



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

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

[drew jensen]

On Fri, 2012-05-25 at 15:47 -0700, Girvin R. Herr wrote:
 
 Tom Davies wrote:
  Hi :)
  I have just done a bit of digging around.
 
  Looking back through Andreas' answers
  http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodesuser=254826i=80
 
  I found this but i'm not sure it's much help for you 
  http://nabble.documentfoundation.org/database-td3926217i20.html#a3928210
 
  This one seems to expand on the useful line at the end there
  http://nabble.documentfoundation.org/Base-3-5-2-2-hangs-td3910280.html#a3911654
 
  This one is a bit of an overview with nothing specific but might be useful 
  to skim through for ideas
  http://nabble.documentfoundation.org/Address-Books-td3829696.html#a3832514
 
  This one looks brilliant to me
  http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3819387
 
  There is some documentation at 
  https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
  and an FAQ (translated from the French team's) at 
  https://wiki.documentfoundation.org/Faq
 
  Sadly most of the people that know a lot about the ins-and-outs of Base are 
  unwilling to help write the Base guide so it's down to 1 person who is 
  desperately busy with a lot of other projects.  
 

Hi Tom

Really - you seem to know a lot, are you writing a manual?

@Girvin - there is no place that I've seen the report builder be that
slow and not have an installation problem - not saying it is impossible
but sounds really odd. 1500 records in a tabular report, 49 seconds is a
long time for that actually. There is one exception to that, graphics -
is your report including graphics stored in data fields?

On the other hand Calc, as has been pointed out, might be your preferred
path.

Best,

//drew

 

 
 Tom,
 Your brilliant link looks interesting.  I knew Calc and Base have some 
 similarities internally, but I wasn't aware that my data could be 
 imported into Calc from my MySQL server.  All of my reports are tabular 
 in format anyway, so Calc could be an option, if it could get my data.  
 One limit to using Calc would be Calc's row limit.  I think I read that 
 LO just raised the maximum rows, but if there are more database records 
 than available Calc rows, then...
 Can Calc be linked to a Base query to get its data?
 If so, then all my sorting can be done in the query.  I do not do any 
 grouping in my reports at this time.
 
 As an update to my problem with Report Builder, my 1500+ record database 
 takes 94 pages of a Report Builder / Writer document.  I put on my 
 patience hat and timed how long it takes to format the report, ready for 
 printing.  As a baseline, it takes about 49 minutes to create the 
 original document.  I cleared my preferences and re-entered them, using 
 mostly defaults and timed it again: 49 minutes.  So it is not preference 
 corruption from previous versions.  I then updated my java to 1.6u30 and 
 timed it again: 49 minutes.  So, it doesn't look like Java is the 
 problem.  I then went back to my original use of SQL from when I created 
 the report with the wizard, rather than using a query for the data and 
 timed it: 49 minutes!  No matter what I do, it takes about the same 
 excruciatingly long time to build my report.  What is really frustrating 
 is that there is no status popup to inform me of what it is doing.  It 
 just goes out to lunch.  Actually, it seems to initially create 128 
 pages with header and footer, but no data, at the end of the first 
 sleep.  When the page status at the bottom of the writer window drops 
 to 94 pages, I know it is done.  Every so many pages, it does come back 
 alive for a second or two and then goes out to lunch again for several 
 minutes.  Each time it returns, a few more pages are populated with data.
 Girvin
 
 
 



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

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

[drew jensen]

On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote:
 
 drew jensen wrote:
 8...
 
  Hi Tom
 
  Really - you seem to know a lot, are you writing a manual?
 
  @Girvin - there is no place that I've seen the report builder be that
  slow and not have an installation problem - not saying it is impossible
  but sounds really odd. 1500 records in a tabular report, 49 seconds is a
  long time for that actually. There is one exception to that, graphics -
  is your report including graphics stored in data fields?
 
  On the other hand Calc, as has been pointed out, might be your preferred
  path.
 
  Best,
 
  //drew
 

 8...
 
 Hello Drew,
 I understand what you are saying, but I installed the LO 3.5.2 binary 
 (RPM) packages from the LO website.  I repackaged them for Slackware, 
 but that does not change the 1s and 0s, just unpacks the RPMs and 
 re-packages the files into a Slackware package for installation.  
 Therefore, if there is an installation problem, it seems to be in the LO 
 packages.  Note that I am using the Report Builder bundled into LO, not 
 the version from the extensions website.  I do believe the newest is 
 1.2.1 rev 2, and the one in LO is still 1.0-something.  I have not tried 
 to replace the bundled version with the 1.2 version.
 
 I could live with 49 _seconds_.  However, it is taking 49 _minutes_ 
 for my report.  My database is nothing special, just text and integer 
 values.  Nine elements plus the key per record.  No graphics.  So, yes, 
 this problem does sound unusual.  However, I have not been able to pin 
 down the problem yet.  In the meantime, I am looking into using Calc to 
 print my data.  It looks good and will do until I can get RB working.
 
 BTW: The report is a simple text page header, Detail, and page footer, 
 no graphics there either.  I do have the date and time fields in the 
 header, but that shouldn't bring it down.  Actually, I do have some 
 separator lines inserted at the bottom of the header and the bottom of 
 each Detail line.  Page number at the bottom of the footer.  That's it.
 Thanks for the help.
Hi Girvin

Sounds like it aught to run lickity-split...hmm

Anyway - looks like you are off to use Cacl.

You might want to do this.

When you open the data window under Calc, instead of copy/paste from the
data grid - grad, drag and drop the actual query name from the left side
of the data window. This will create a named range, you can set options
on the range to _not_ save the data in the spreadsheet, jut the
connection information...then when you open the spreadsheet again it
will re-run the query and update the data anew..

Best wishes,

//drew


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

Re: [libreoffice-users] Re: Wanted: Macro for removing Page Breaks in MailMerge docs

[drew jensen]

On Wed, 2012-05-02 at 00:01 +0200, Nino Novak wrote:
 Am Dienstag, 1. Mai 2012, 23:44:21 schrieb Andreas Säger:
  Am 01.05.2012 23:19, Nino Novak wrote:
   I do not see how to achieve the desired result by mere dragging.
  
   E.g. with the included database Biblio, I can create the following 
 Template:
  Well, you drag the desired row set into the new document.
 
 ? 
 
 As said, I want a formatted output, and this cannot be achieved by mere 
 dragging as there is text in between and different font styles are used.
 
  http://extensions.services.openoffice.org/project/AltSearch can search
  page breaks.
 
 Just tried. It says, 29 page breaks replaced but they are still there, and 
 you can rerun the search with the same result over and over. 
 
 Any other ideas?
 
Hi Nino

I haven't tried this, but from reading the earlier email - the page
break is injected with the use of a style, yes? Can't you just edit the
style P4 I think it was, so it doesn't create a page break?

Like I said, I didn't try, but that is what I would do first.

//drew



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

Re: [libreoffice-users] Re: launching app from within base

[drew jensen]

On Tue, 2012-04-24 at 09:07 +0100, Tom Davies wrote:
 Hi :)
 Hopefully one of the guides here might help
 http://wiki.documentfoundation.org/Documentation/Publications#Programmers
 Good luck and regards from
Hi Tom

Actually a google search for libreoffice shell command brings up:
http://help.libreoffice.org/Basic/Shell_Function_Runtime

Which is pretty good starting point.

//drew

 
 --- On Tue, 24/4/12, drew jensen drewjensen.in...@gmail.com wrote:
 
 From: drew jensen drewjensen.in...@gmail.com
 Subject: Re: [libreoffice-users] Re: launching app from within base
 To: users@global.libreoffice.org
 Date: Tuesday, 24 April, 2012, 2:21
 
 On Mon, 2012-04-23 at 16:37 +0200, Alexander Thurgood wrote:
  Le 23/04/12 16:17, brainflakes a écrit :
  
  Hi,
  
   For instance, If one had a database of images, at various locations,  a
   click of the mouse (say on an icon provided in the search result form next
   to the image name) could launch photoshop with the path/filename of the
   image file and photoshop would load the image ready for editing. LO base
   provides the search mechanism, photoshop provides the editing features.
   
   I don't know why someone wouldn't want this feature. I've used this in
   filemaker and it has been a great time saver.
   
  
  Ah, you mean clickable links in Base that might actually do something
  useful ;-)
  
  Well, you won't find anything out of the box, you would have to code it
  using a script, e.g. LO Basic. use cURL to take the name of the file
  then pass it to the shell command - I had read somewhere a while ago
  though that this didn't actually work anymore. Anyway you're going to
  have to experiment with Basic or some other supported scripting language
  if you want to do that.
  
  
 Hi Alex
 
 Right - that is the answer and it is very very simple.
 
 //drew
 
 
 
 -- 
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems? 
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be deleted
 



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

Re: [libreoffice-users] Re: launching app from within base

[drew jensen]

On Mon, 2012-04-23 at 09:24 -0700, brainflakes wrote:
 Nino wrote
  
  
  Sorry, I don't know anything about Base - but in Writer you just insert a 
  Hyperlink, chose Document and enter a Document URL. If the document
  has a 
  extension/MIMEtype/whatever which is known to the system, the default app
  will 
  open the document. That's at least how it works here.
  
 
 As I said, I don't see a type for URL other than text. But, it looks like
 I could implement a macro or I also see there is some sort of python link in
 OL. I don't know much about how to write OL macros, but on briefly looking,
 it looks like it is too hard.
 
 Anyone know if python integration is supported well?
 
 Thanks for your help. I appreciate it.

Hello rainflakes,

Sure, python is supported as a scripting language in LibreOffice.

I put together an example file from some questions on the list regarding
storing relative paths for images along with some a basic script,
embedded in an odb file just the other day.

https://wiki.documentfoundation.org/File:Linkme.odb

So - I went back into that and added a button on the form there, lower
right of the image control.

And added two procedures to the basic library embedded in the odb file,
one which is called for button execute (click or keyboard shortcut [if I
had set one]) and this calls a doEdit procedure.

Also added a new table called config, which has a field GraphicEditor,
in which I store the value currently of gimp this works for me under
linux and windows but perhaps others under windows would want to edit
that to mspaint or whatever is appropriate.

Anyway - I choose in that script to store URLs so the script, you will
if you look, uses the convertFromURL to grab the file name passed. If
you wanted to add options to the command you would that also in the
config.GraphicEditor field - or at least that is how I would do it.

HTH,

//drew

 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/launching-app-from-within-base-tp3931371p3932954.html
 Sent from the Users mailing list archive at Nabble.com.
 



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

Re: [libreoffice-users] Re: [Announce] HyperSQL 2.2.8 Released

[drew jensen]

On Sat, 2012-04-14 at 12:34 +0200, Andreas Säger wrote:
 Am 14.04.2012 04:22, avamk wrote:
  Thank you for all of your replies, the information is very helpful, and I
  will continue to explore.
 
  Just one more question: Would migrating to other databases (like MySQL or
  PostgreSQL) be similar to how I would migrate from an *.odb file to a HSQL
  database? If not, are there instructions for transitioning to MySQL or
  PostgreSQL?
 
 
 No, because you start with a working database structure before you 
 connect your Base document to it. Even if you can edit tables, fields 
 and relations of a foreign database, you can't create such a database 
 newly from scratch and you should abstain from editing tables, fields, 
 indices and relations of a foreign database. Always use dedicated 
 software for the respective type of database engine.
 Having some Base connection to some source database (including 
 spreadsheets, text etc) and another connection to a target database, you 
 can always copy the raw data from source database to the 
 _prepared_tables_ of the target database. Spreadsheet ranges can be 
 copied directly.
 But you should abstain from the feature which allows you to create 
 clipboard tables from scratch. This is another big trouble maker among 
 all the useless Base features. The copypaste between databases is very 
 useful but you should always append new rows to prepared tables.
 There are a lot more obsolete Base features which cause more trouble 
 than convenience. Most of the Base component which had been added to OOo 
 v2 could be removed without losing the capability to connect, query, 
 report and use input forms.

Hi Andreas,

Sorry, I can't agree with your advice to avamk on this one.

Sure you can edit tables on 'your' database, as long as he is the one
doing the work the fact that it is a server based system is meaningless
in this regard

As for Base features, the problem is that there just aren't enough of
them, or they are half done, not too many.

//drew



 
 



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

Re: [libreoffice-users] Base 3.5.2.2 hangs

[drew jensen]

On Sat, 2012-04-14 at 07:46 -0700, clehmann wrote:
 Hello everybody,
 
 I have installed LibreOffice 3.5.2.2 with base on Win 7 Home Premium (both
 French). I have Java 6 update 31 also installed.
 
 I am able to start LibreOffice without any problem. I am also able to open
 any text, spreadsheet, ... document without any problem. However, once in a
 while, when opening any of my *.odb database, LibreOffice goes into the No
 response status. After having killed it and restarted from scratch, I am
 able to open my database.
 
 I have tried to change the setting in tools-options-Java to select a
 different JRE (I have 1.6.0_22 and 1.6.0_31 installed) without success.
 
 Any suggestion?
 
Hi Charles

This sounds similar to an issue with Base in the past, though it has
been gone for a while I thought. The cause as I recall was the JRE not
fully exiting out between closing and opening of two ODB files (using a
java based database of course). IIRC it was most prominent when using
the quickstarter feature under windows.

So - if your problem happens when opening an ODB file for the first time
in a session it would be different. 

But if the problem only happens when opening a second (or subsequent)
ODB file during the session:

If you are running quickstarter disable it and see if the problem goes
away.

Let us know if that helps.

Thanks,

//drew


 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Base-3-5-2-2-hangs-tp3910280p3910280.html
 Sent from the Users mailing list archive at Nabble.com.
 



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

Re: [libreoffice-users] Re: Connecting to HSQLDB with Base

[drew jensen]

On Fri, 2012-04-13 at 16:35 +0200, Andreas Säger wrote:
 Am 13.04.2012 15:50, Dan Lewis wrote:
  On Fri, 2012-04-13 at 09:38 -0400, Dan Lewis wrote:
  I have hsqldb installed and running. But I don't find the
  information that I need to connect Base to it. I have read I can use
  either ODBC  or JDBC to do this. JDBC requires: Data source URL  jdbc::
  and JDBC driver class. What belongs in these two boxes?
If ODBC can be used, what goes in the Name of the ODBC data source
  on your system? (I don't even know what they are asking for.)
 
  --Dan
 
   Added question: What goes in /tools/options/LibreOfficeJavaDriver
  Class path?
 
 
 
 On my system that is:
 1) /usr/local/lib/hsqldb/lib/hsqldb.jar
 2a) hsqldb:hsql://192.168.0.2/chargen;default_schema=true
 2b)  
 hsqldb:file:/home/andreas/hsqldb_databases/Praxis/hsqldbdata/db0/chargen;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false
  
 
 
 2a) connects to a HSQL server, where a configuration file controls which 
 database directory is served under which alias name.
 
 2b) connects to a local development version of the database (cached mode 
 analog to the embedded thing). 
 /home/andreas/hsqldb_databases/Praxis/hsqldbdata/db0/ contains the 3 
 database files chargen.script, chargen.data, chargen.properties.
 
 /usr/local/lib/hsqldb/index.html is the entry point to the excellent 
 documentation (313 pages of PDF).
 
 

Right - and once the jar has been added into the system you can also
connect to a HSQLdb server running in FILE mode - meaning that the
server will not need to be started before the connection is established,
instead in the connection string you designate the file directory to be
used and as part of establishing the connection it starts an instance of
the server in your process space and uses the directory listed to store
the work files.

//drew


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

Re: [libreoffice-users] Re: How to format data entry in base table to UPPERCASE only

[drew jensen]

On Fri, 2012-04-13 at 17:49 +0200, Andreas Säger wrote:
 Am 13.04.2012 17:42, leon244 wrote:
  I am trying to find a way to format the text fields in my small data base to
  be uppercase only. Is there a way to do it at the table field level with the
  'format', or can it only be done at the form level through a pattern field
  using 'X'?
 
  --
  View this message in context: 
  http://nabble.documentfoundation.org/How-to-format-data-entry-in-base-table-to-UPPERCASE-only-tp3908311p3908311.html
  Sent from the Users mailing list archive at Nabble.com.
 
 
 Since 'x' and 'X' are different characters, this has nothing to do with 
 formatting.
 Set the field type to VARCHAR_IGNORECASE so 'x' and 'X' are considered 
 as equivalent. In queries you can use the UCASE or UPPER function in 
 order to display the upper case version of the text.
 

Howdy,

Right - well the VARCHAR_IGNORECASE is fairly specific to HSQLdb, but it
works well.

You may also create an update trigger, using an SQL command via the SQL
window, to cast all input to upper case before it is written into the
data field - for any relational database engine used by Base, including
the embedded HSQLdb engine, the syntax varies a bit from engine to
engine however.

//drew


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

Re: [libreoffice-users] Re: How to download?

[drew jensen]

On Fri, 2012-04-13 at 18:05 -0400, Darren Govoni wrote:
 That's it. But the rate from that site is like 62k per second for me.
 I'm near Washington, DC. This is the speed coming from the server.
 
 Are there mirrors I can choose from, closer to me or not throttled?
 I couldn't find any download mirrors.

WOW - me too-  I'm in Maryland, the download usually takes is less the 5
minutes, now reporting 57 minutes...something isn't right.

Sent this to the website ML also - where folks might be able to help.

//drew

 
 On Fri, 2012-04-13 at 14:45 +0200, Andreas Säger wrote:
  Am 13.04.2012 03:14, Darren Govoni wrote:
   Hi,
  I've been trying to download the latest LibreOffice. No luck.
   It gets about 5%. Its slow then gets interrupted and stops. The
   torrent does not work. It stays at 0%. Never seen this from a download
   site before.
  
   Is there a mirror list?
  
   I tested my connection speed. Its fast.
  
   thanks.
  
  
  
  Where do you try to download from? Should be 
  http://www.libreoffice.org/download/ and nothing else. The [Info] link 
  leads to alternative locations (torrents and mirrors).
  
  
  
 
 
 



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

Re: [libreoffice-users] Re: How to download?

[drew jensen]

On Fri, 2012-04-13 at 19:10 -0400, drew jensen wrote:
 On Fri, 2012-04-13 at 18:05 -0400, Darren Govoni wrote:
  That's it. But the rate from that site is like 62k per second for me.
  I'm near Washington, DC. This is the speed coming from the server.
  
  Are there mirrors I can choose from, closer to me or not throttled?
  I couldn't find any download mirrors.
 
 WOW - me too-  I'm in Maryland, the download usually takes is less the 5
 minutes, now reporting 57 minutes...something isn't right.
 
 Sent this to the website ML also - where folks might be able to help.

Ok - it is a particular mirror which is being slow:
http://ibiblio.org

Pick any of the others in the US and the download speed goes right back
to normal.

//drew

 
 //drew
 
  
  On Fri, 2012-04-13 at 14:45 +0200, Andreas Säger wrote:
   Am 13.04.2012 03:14, Darren Govoni wrote:
Hi,
   I've been trying to download the latest LibreOffice. No luck.
It gets about 5%. Its slow then gets interrupted and stops. The
torrent does not work. It stays at 0%. Never seen this from a download
site before.
   
Is there a mirror list?
   
I tested my connection speed. Its fast.
   
thanks.
   
   
   
   Where do you try to download from? Should be 
   http://www.libreoffice.org/download/ and nothing else. The [Info] link 
   leads to alternative locations (torrents and mirrors).
   
   
   
  
  
  
 



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

Re: [libreoffice-users] Re: How to download?

[drew jensen]

On Fri, 2012-04-13 at 20:00 -0400, Don Myers wrote:
 Hi,
 
 Question.? When I am in the download section of LibreOffice, 
 http://www.libreoffice.org/download/  , how do I find the options of 
 where to download it from. I'm missing something somewhere.

What you don't know the secret handshake ;)

On the download page, the green download button, click on the link,
lower right hand, Info.

This will give you a page with, amongst other items, direct links to the
mirrors, those in your region listed first.

//drew

 
 Thank you.
 
 don
 
 On 04/13/2012 07:40 PM, drew jensen wrote:
  On Fri, 2012-04-13 at 19:10 -0400, drew jensen wrote:
  On Fri, 2012-04-13 at 18:05 -0400, Darren Govoni wrote:
  That's it. But the rate from that site is like 62k per second for me.
  I'm near Washington, DC. This is the speed coming from the server.
 
  Are there mirrors I can choose from, closer to me or not throttled?
  I couldn't find any download mirrors.
  WOW - me too-  I'm in Maryland, the download usually takes is less the 5
  minutes, now reporting 57 minutes...something isn't right.
 
  Sent this to the website ML also - where folks might be able to help.
  Ok - it is a particular mirror which is being slow:
  http://ibiblio.org
 
  Pick any of the others in the US and the download speed goes right back
  to normal.
 
  //drew
 
  //drew
 
  On Fri, 2012-04-13 at 14:45 +0200, Andreas Säger wrote:
  Am 13.04.2012 03:14, Darren Govoni wrote:
  Hi,
  I've been trying to download the latest LibreOffice. No luck.
  It gets about 5%. Its slow then gets interrupted and stops. The
  torrent does not work. It stays at 0%. Never seen this from a download
  site before.
 
  Is there a mirror list?
 
  I tested my connection speed. Its fast.
 
  thanks.
 
 
  Where do you try to download from? Should be
  http://www.libreoffice.org/download/ and nothing else. The [Info] link
  leads to alternative locations (torrents and mirrors).
 
 
 
 
 
 
 
 
 -- 
 
 *~~*
 Don C. Myers
 e-PRO Certified by the National Association of Realtors
 Manager, Farm and Rural Property Division
 *Coldwell Banker University Realty
 *126 East Foster Avenue, State College, PA 16801
 Phone: 814-237-6543 Fax: 814-237-6502
 Visit the Farm and Rural Property Division Website at 
 www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_
 _View Don's farm website: www.myersfarm.com http://www.myersfarm.com/
 *~~*
 
 



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

Re: [libreoffice-users] Removing Themes box

[drew jensen]

On Fri, 2012-04-13 at 13:22 -0700, 20rdj04 wrote:
 I don't know how I opened the themes box, but now I can't get rid of it.  The
 damn thing takes about 3 inches off the top of my desktop/page.  As I am
 writing a letter, the page is already short enough.

hmm - I believe you are referring to the Gallery.

The menu item:
ToolsGallery

Toggles the feature on and off.

HTH

//drew


 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Removing-Themes-box-tp3908902p3908902.html
 Sent from the Users mailing list archive at Nabble.com.
 



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

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

[drew jensen]

On Tue, 2012-04-10 at 23:12 -0700, avamk wrote:
 Hi Drew,
 
 It looks amazing now, and the functionality is great. I am especially glad
 that it will work in Linux, Mac, and Windows!
 
 Were you going to write an explanation for the code, or just the form?
 Either way, if you can start a draft, I can help word smith it (probably by
 asking you questions about it).
 
 I think this is so useful, perhaps it can be integrated into the standard
 LibreOffice Base macro set???

Not likely - it's too specific to a particular use case.

Ok - so I put a little time into this today, the updated ODB file once
again at:
https://wiki.documentfoundation.org/File:Linkme.odb

In the basic script did a little refactoring, so it is not quite as ugly
as it was and added the ability to save the image control display
settings into the database record, per image link, and then decode that
and set the image control appropriately as you move through the record
set.

Three things are left un-done and maybe they should be, as something to
be added by the final user:

1 - when a new record is created, if the user clicks on an image control
setting (scale mode / bckground color) the values are encoded and
written to the record in memory, since the image link is not a required
field the user could store this, which doesn't really make a lot of
sense. 

2 - When the saved image control settings are read back the image
control is updated, but not the displayed value for the three scale mode
checkbox controls or the background color list box.

3 - Setting the image control background to Transparent just doesn't
work - don't now why, setting the value to EMPTY should equal 'Default'
and that should be Transparent, IIRC... but maybe someone can figure
that out.

Also - changed the UI of the form a little. 
- The datacontrol (textbox) for the stored image link is again
displayed, but as read only. You still use the File Selector to update
the value.

Guess that's it really then for the basic script stuff.

So the hard part, for me at least, is left which is explaining how this
works.

I've got a fair bit of time today, so can work on that - any help with
that is always welcome.

Last but not least - Drag n Drop - you know we could add that to the
form. It requires diving a bit deeper into the API, as one needs to
create runtime listeners for events (not the same as filling in slots no
the control property editor at design time), not today - but it is
something that can be done with scripting also.

//drew

 
 Thanks!
 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Make-a-form-that-allows-user-to-drag-and-drop-in-an-image-tp3890657p3901695.html
 Sent from the Users mailing list archive at Nabble.com.
 



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

Re: [libreoffice-users] How to change document author in existing document

[drew jensen]

On Wed, 2012-04-11 at 11:33 -0700, Russ Mannex wrote:
 Using LibreOffice Writer 3.4.4 on Mint 12 KDE. If I create a document, then 
 export to PDF, the author is set to the user info as defined in the 
 OptionsUser Data section. In FileProperties, I can deselect Apply user 
 data and the author info will no longer be exported to a PDF. However, if I 
 subsequently change the OptionsUser Data information, the new information 
 will not be exported to PDF, even if a reapply the FilePropertiesApply user 
 data. Is there another way to change the author info in an existing document 
 so that I can export it to a PDF?
 
 -- 
Hi Russ,

Well it works for me.

I have to do the following:

With the document open,

ToolsOptionsUser 
Change user name information

Close the options dialog

FileProperties

With the checkbox 'Apply User Data' ticked,
click the RESET button

Close the properties editor

FileExport to PDF
I'm exporting as PDF 1.5, picks the name change up 
every time.

-Using LibO 3.5.2 / Ubuntu BTW

//drew


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

Re: [libreoffice-users] [BASE] New to Base - Program stops

[drew jensen]

On Wed, 2012-04-11 at 16:48 -0300, Preston Smith wrote:
 Hi,
 
 I am trying to learn Base in LO 3.5.2.2 under Vista with all latest updates
 
 I start Base - then I follow the steps shown at 
 http://sheepdogguides.com/fdb/fdb1tableone.htm
 
 The Base wizard starts; I click 'Create a new database' then 'Next'
 
 I say Yes, please register database for me,  Open for editing and 
 Create tables using the table wizardthen click the Finish button.
 
 I get a Save as dialogue and select /Data Base Projects/FDB004 Phone 
 Book/FDB004.odb
 
 And I get the Windows window that says
 
 LibreOffice 3.5 has stopped working
 
 I tried this process 3 times and each time I get the same message
 
 Help!!
 
 Thanks,
Howdy Preston

Well, I run that version under Vista without any problem.

Given your description, and assuming that the rest of the suite
functions properly for you, I'd guess it's a missing java configuration.

Start LibO - not Base, select
ToolsOptionJava
ensure that you have a java engine selected.

If there was not one selected, do so - close the options dialog and exit
the application - next startup you should be good to go.

HTH

//drew



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

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

[drew jensen]

Howdy Avamk, Tom

alright well, got a little ugly in that I should create a constant or
two, but the script works on both Windows and Linux now and will on Mac
I'm sure (he says with a grin)..

https://wiki.documentfoundation.org/File:Linkme.odb

was updated just a minute or two ago - Haven't finished with the save
for the display settings to the database field, should get that tonight.

Anyway - I'm glad I versioned this, as it might be a good example for
working with URL's vs OS specific paths also - which btw was my mistake,
I started out deciding to save URLs, meaning I used the converttoURL
function here and there, but then turned around an used the function
getPathSeparator also, well, the getPathSeparator returns the system (or
OS) character, which on Linux is the same as what is used in a URL, but
not so on windows..once I stopped trying to have it both ways in the
basic code :-) it all worked..surprise.

anyway - let me know if any of this makes sense, and if you it mostly
does, what is the best way to help reinforce it - I will try to write a
decent explanation, but always need help with that, I'm no word smith.

//drew

On Tue, 2012-04-10 at 17:26 -0400, drew jensen wrote:
 On Mon, 2012-04-09 at 14:09 -0700, avamk wrote:
  Yes, I just looked at sheepdogs explanation, it is so well written! Even
  though it uses relative paths, they need to be typed in manually. So the
  File Picker control still needs to be used.
 
 Well, if the example there is working then it is likely a cut above what
 I have here - cause, I added some eye candy - had to, and then tried
 this file under MS Windows, to a dis-satisfactory outcome.
 
 But if you are using Linux, all seems to work well - though I could
 likely clean it up still.
 
 So - why is it failing under Windows, and how to fix that today (over
 the next hour or so) is the call.
 
 BTW, I'm guessing it runs as written on a Mac also, but do not have one
 to try that on.
 
 anyway - I updated the odb file on the wiki (not the zip file, if you
 grabbed that great, just download the latest odb into your working
 direcotry)
 
 Added a couple things for kicks, as I say.
 
 Made it pretty.
 
 Added runtime controls to adjust some properties on the image control:
 - Display Scaling (none, stretched keep ratio, stretched fill)
 - Adjust background color (Black, White and Transparent [to come])
 
 Added a couple of fields in the table, comments and one for storing a
 custom property (just a string) for the selected display settings.
 Hooking that up to single column vs data aware controls to two columns
 just cause, already handling our own record change event so why not.
 
 AGAIN - if you are running windows this file, the basic script, doesn't
 work.. will update this again later today with a correction on that
 hopefully.
 
 but to check it out under Linux (Mac maybe) the updated file is at
 https://wiki.documentfoundation.org/File:Linkme.odb
 
 back in a bit,
 
 //drew
 
 
  
  --
  View this message in context: 
  http://nabble.documentfoundation.org/Make-a-form-that-allows-user-to-drag-and-drop-in-an-image-tp3890657p3898027.html
  Sent from the Users mailing list archive at Nabble.com.
  
 



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

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

[drew jensen]

On Sat, 2012-04-07 at 21:11 -0700, avamk wrote:
 Thanks for the link! Looks like the Base Guide is still in its very early
 stages of development, are there comparable guides/books out that that I can
 start studying now??
 
 Also, I've downloaded the example database and have been able to add new
 images to it, and am trying to play around with it now. 

Hi Avamk,

Wonderful, I was hoping you had done so.

Didn't make it back to this yesterday, having a quite coffee after the
Easter bustle here now and a good time to do so.

I noted in the first mail that I'll just stub in the code to handle
relative path from the perspective of the directory the ORB is stored
in, meaning that I'm flaking out on you ;) and only handling sub-dirs as
relative. 

Everything you need to handle more is of course there, it would just
take a bit more time - also, basic isn't the only scripting tool
available with LibreOffice, you could use python, javascript, rexx even.

Anyhow, I digress - off to add another half dozen lines of basic and
I'll update the example file.

Happy Easter and Shalom,

//drew

 If you could provide
 any tips on making the form enter relative paths (relative to the database
 file) that would be great!!
 
 Thank you so much.
 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Make-a-form-that-allows-user-to-drag-and-drop-in-an-image-tp3890657p3893861.html
 Sent from the Users mailing list archive at Nabble.com.
 



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

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

[drew jensen]

On Sun, 2012-04-08 at 11:34 +0100, Tom Davies wrote:
 Hi :)
 A google search gave me these for OpenOffice.org's Base which is almost 
 exactly the same
 http://wiki.services.openoffice.org/wiki/Database
 http://www.oooforum.org/forum/viewtopic.phtml?t=82025
 http://sheepdogguides.com/fdb/fdb1main.htm

hi Tom,

Thanks for that - I hadn't looked over the stuff at sheedogguides in a
while, that's gotten better over time.

I noticed an example db's about birds, wouldn't be surprised if that
handles images, did you by chance check to see if it, or any of the
others there do what Avamk is looking for?

Also - I'd be nice to have a link to the sheepdog site somewhere on the
wiki perhaps, what do you think?

Best wishes,

//drew

snip


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

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

[drew jensen]

Howdy avamk,

Alright updated the file and added it as new file, (different URL on the
wiki) this is a zip file now.
https://wiki.documentfoundation.org/File:Linkme.zip

It will extract to a sub-dir named, linkme whith:
linkme.odb
lo-client-libo-wallpaper.jpg
images/basicorganizer.png

In the database the first two records should display a graphic from the
remote server, as before. The next two will display using the relative
path from the perspective of the odb file. 

You can use the file picker (which I wish would just start in the last
dir..arrgh) to select files from anywhere on the disk, if they are in
the directory of the odb or a sub-dir then a relative path, where the
base file directory is root

Off to a supper, I'll come back and try to write a decent explanation of
the basic lines, tonight.

//drew

On Sat, 2012-04-07 at 21:11 -0700, avamk wrote:
 Thanks for the link! Looks like the Base Guide is still in its very early
 stages of development, are there comparable guides/books out that that I can
 start studying now??
 
 Also, I've downloaded the example database and have been able to add new
 images to it, and am trying to play around with it now. If you could provide
 any tips on making the form enter relative paths (relative to the database
 file) that would be great!!
 
 Thank you so much.
 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Make-a-form-that-allows-user-to-drag-and-drop-in-an-image-tp3890657p3893861.html
 Sent from the Users mailing list archive at Nabble.com.
 



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

Re: [libreoffice-users] Remove Macro from spreadsheet

[drew jensen]

On Sun, 2012-04-08 at 13:06 +0100, Gordon Burgess-Parker wrote:
 LO 3.5.2.2.
 I tried setting a Macro in a particular spreadsheet that didn't work.
 I have deleted everything I can find in Tools-Macros-Organise 
 Macros-Libre Office Basic but there are still two entries of Standard 
 under My Macros and the name of the spreadsheet that have no Delete 
 option when selected.
 Every time the sheet opens I get a message about either allowing or 
 disabling Macros.
 How do I delete this macro completely so there is no message on opening 
 the sheet?

The items are modules.

Open the Organize macors dialog again
Select the Module tab
Hightlight and delete each module
close the dialog
Save the file

Now the library 'Standard' is still part of the document, but with zero
modules the security message will not trigger.

best wishes,

//drew


 



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

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

[drew jensen]

On Fri, 2012-04-06 at 16:00 -0700, avamk wrote:
 I am actually quite new to Base, and didn't realise I could use the File
 Picker control. When I try to change its reaction to the Mouse Pressed
 event, it asked me for a macro.
 
 Do I need to write a macro to get the relative path of my desired image??? I
 actually have no macro coding skills to do that...
 
 And how do I tie the selected file's relative path to the field I desire?
 
 Sorry I am so new to this, but I would really appreciate any guidance you
 can give me...

Well, I feel stupid - you already asked on ask.libreoffice didn't you..
http://ask.libreoffice.org/question/1715/make-a-form-that-allows-drag-and-drop-of-images-in
... the other day.

OK- well, I haven't added the part to generate the relative path, but
for the basics of syncing the control with a data column I did put
together a little database.

It's only a few lines of basic, but if you only have a starting
knowledge of the basic scripting in the package it likely makes sense to
let you have this first.

To use the odb (embedded HSQL) database you will need to do two things
interactively first.

1 - you must enable macro execution. I really suggest going for the
highest setting, which requires you to designate what directories files
with macros will be allowed to execute from - I more highly suggest you
do not use your default download or document directory.. for myself I
create a sub-directory under my Documents directory for such.
Anyway - to do this open the Otpions dialog (FileOptions), select
Security and then Macro Security. The information on the dialog should
be reasonably clear to follow.

2 - you must load the 'Tools' basic library before it can used. When
macros are embedded in and ODB, as they are in this example file this
must be done outside of the file. (don't ask me why, I think its a bug)

Now - there is a nice way to handle that. The example odb file has the
document level event 'Open Oocument' set to call the Main procedure in
the LibreOffice standard basic library. Every install of LibreOffice has
this User specific standard library - by default, empty save a stubbed
out Main procedure.

So - what you need to do is:
Start Libreoffice
Select ToolsMacrosOrganize Dialogs
On the dialog select the 'Modules' tab.
You will see in the list of libraries the category:
My Macros
Under this - Standard
If you double click this, a single module - Module 1
Select that and click the Edit button.

Now you have the Basic IDE open.
There is a Main Procedure, with no actual basic commands.

Add this line between the opening
Sub Main and End Sub Lines
BasicLibraries.LoadLibrary(Tools)

Save the library and close the IDE you are done with this.

Now - if you have authorized Macro execution at some level you can load
the example file 'linkme.odb', you will find a single table and form.

The form uses a hidden text control and two macros and two events to
transfer the URL selected from the file picker (File Selector) control
into two data columns in the table. One of the macros also uses the link
data column in the table to display the referenced image in an Image
Control on the form. 

For kicks I've preloaded 3 records in the table - the first two will
display a graphic from the internet and the third will display no image,
as it has a file path (URL) to an image on my local disk.

So - you can find the example file here for the moment - 
https://wiki.documentfoundation.org/File:Linkme.odb

After I finish up the PATH massaging will move that over to the ask LibO
site.

Also - I need to do a few things here this Saturday morning, but I'll
get back to it later this afernoon - if you check out the macros you
will likely say HUH - but I'll also explain the constructs when I get
back to this. 

//drew


 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Make-a-form-that-allows-user-to-drag-and-drop-in-an-image-tp3890657p3891586.html
 Sent from the Users mailing list archive at Nabble.com.
 



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

Re: [libreoffice-users] Make a form that allows user to drag and drop in an image

[drew jensen]

On Fri, 2012-04-06 at 14:35 -0400, Dan Lewis wrote:
 On Fri, 2012-04-06 at 08:52 -0700, avamk wrote:
  Hello
  
  Thanks to the great instructions 
  http://sheepdogguides.com/fdb/fdb1imagbp.htm here , I learned how to link a
  VARCHAR field to images in my filesystem, and display them in a form.
  
  However, when I add new entries, I have to manually type in the relative
  path of an image into that field. This is cumbersome when I need to add lots
  of entries, e.g. making a catalouge of things with images for each.
  
  Therefore, is it possible to create a form so that when adding a new entry,
  there is a box in the form where the user can just drag and drop in the
  desired image, and the appropriate relative path to the image will be added
  to the field???
  
  Thank you very much!
 
  No. How would the form know where the image had been located? When
 pictures are linked in a Writer document, you have to browse to the
 picture's location before inserting it in the document. It is the
 browsing that tells Writer the proper link for it. Base does not have
 this ability (to browse to different other locations).

Hi Dan,

Wow - what timing - I was literally fiddling with an idea on this when
your email hit.

First- sure Base can browse to a file, just use the File Picker control.

Second - so far nothing I've tried will give you a drag/drop way to yank
the URL from an image driopped onto a form.

But as I say the file picker works just fine for this.

Avamk, have you used the file picker control and then if you need
relative paths, that would be easily done also.

//drew




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

Re: [libreoffice-users] Problems importing an OO database into LO

[drew jensen]

On Fri, 2012-04-06 at 14:43 -0400, Dan Lewis wrote:
 On Fri, 2012-04-06 at 09:54 -0700, ptoye wrote:
  I have an OO database, and am trying out LO, and am having at least one
  problem. There is a form which is based on a query whose results are
  displayed in a grid, and various fields are copied into subform fields to
  allow me to update them. In OO everything is fine. The attached screenshots
  show what I mean.
  http://nabble.documentfoundation.org/file/n3890826/LOBaseBug.zip
  LOBaseBug.zip 
 
  --
  View this message in context: 
  http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3890826.html
  Sent from the Users mailing list archive at Nabble.com.
 
  What LO version are you using?
 
 What OS (operating system) are you using?
 
 Does LO show the same table contents as OOo does?
 
 Using Design View for the query is question: What differences do you see
 for OOo vs LO?

Also  what version of OO.o is the file coming from?
 
 --Dan
 
 



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

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

[drew jensen]

On Fri, 2012-04-06 at 16:00 -0700, avamk wrote:
 I am actually quite new to Base, and didn't realise I could use the File
 Picker control. When I try to change its reaction to the Mouse Pressed
 event, it asked me for a macro.
 
 Do I need to write a macro to get the relative path of my desired image??? I
 actually have no macro coding skills to do that...

Right you are, the control is not 'data aware', not bound to a data
column, so you will need to use a macro to transfer the file path
returned from browsing to the data column. In the default installation
of LibreOffice is a basic macro library, Tools, which contains a number
of file path manipulation macros, these should make conversion to a
relative path (note here - relative to current directory of the ODB
file, yes?) 

Anyway, I don't have an example snippet of basic on the disk at the
moment, pretty sure there are some examples at different forums already
- but I would really like to see this as an answer at
ask.libreoffice.org - so if you don't mind I'll put an example there.
It's kind of late tonight, but maybe before I turn in. You won't need to
have a logon account there to retrieve it. 

The actual move to a data column is all of 2-3 lines, I don't think the
conversion to relative path should be too much more.. :-) I don't
think..

What I'll do then is post back here, with a link to the entry there..or
if feel like check out the site and open the question and send that here
- then I'll post to that entry - either way is good.

Best wishes,

//drew

 
 And how do I tie the selected file's relative path to the field I desire?
 
 Sorry I am so new to this, but I would really appreciate any guidance you
 can give me...
 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Make-a-form-that-allows-user-to-drag-and-drop-in-an-image-tp3890657p3891586.html
 Sent from the Users mailing list archive at Nabble.com.
 



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

Re: [libreoffice-users] Can't register for the Nabble interface, CAPTCHA not working?

[drew jensen]

On Wed, 2012-03-28 at 20:32 +0200, Stephan Petersen wrote:
 Hi guys,
 
 I'm trying to register for the Nabble interface 
 (http://www.libreoffice.org/get-help/nabble-mailing-list-interface/), 
 but I always get The validation code did not match the picture., 
 although I think I'm not blind and I can type :-).
 
 Is that just me or does anyone else have this problem too?
 
 Thanks in advance for any pointers,

Ah, it's faster for everyone just to handle it..

Is this the email address you want used?

//drew


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

Re: [libreoffice-users] CVE-2012-0337

[drew jensen]

On Fri, 2012-03-23 at 07:55 -0400, Dan Lewis wrote:
 Using both LO and OOo, I'm aware of the need to patch this
 vulnerability for both. What I don't know is what is the status of this
 with respect to LO. I presently have 3.5.1-102 and 3.4.5.502. I did not
 see anything mentioned about this on the LO main page. It would be nice
 to have a statement on the home page when it was fixed for 3.4.x and
 3.5.x. It would be nice to have something on this mailing list.
 
Hi Dan

3.4.6 for the patch. It was in the release announcement. 

Not sure but it maybe that 3.5.1 also has the fix - 3.5.2 surely will.

//drew


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

Re: [libreoffice-users] CVE-2012-0337

[drew jensen]

On Fri, 2012-03-23 at 08:53 -0400, Dan Lewis wrote:
 On Fri, 2012-03-23 at 08:10 -0400, drew jensen wrote:
  On Fri, 2012-03-23 at 07:55 -0400, Dan Lewis wrote:
   Using both LO and OOo, I'm aware of the need to patch this
   vulnerability for both. What I don't know is what is the status of this
   with respect to LO. I presently have 3.5.1-102 and 3.4.5.502. I did not
   see anything mentioned about this on the LO main page. It would be nice
   to have a statement on the home page when it was fixed for 3.4.x and
   3.5.x. It would be nice to have something on this mailing list.
   
  Hi Dan
  
  3.4.6 for the patch. It was in the release announcement. 
  
  Not sure but it maybe that 3.5.1 also has the fix - 3.5.2 surely will.
  
  //drew
 
  I have now read the release announcement, and it contains
 announcements for both 3.4.6 and 3.5.1. Both of these are rather vague.
  The 3.4.6 announcement mentions fixing a potential security issue.
 The 3.5.1 states: LibreOffice contains all the security fixes from
 OpenOffice.org in 3.3.0, and perhaps more as a side-effect of the code
 clean-ups.
  What security issues? I'm not sure I know from what I read.
  Another thing that comes from trying to find this information: What
 is a link that I can use to list my concerns or other comments about the
 layout of the LO website?

Hi Dan,

Try website at global.libreoffice.org 

//drew


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

Re: [libreoffice-users] Re: Address Books

[drew jensen]

Sure why not

So you want to build this tutorial over this weekend.

Is it to be multi-user?

//drew

On Fri, 2012-03-16 at 14:29 +0100, Nino Novak wrote:
 On Friday 16 March 2012, 12:57:24 Andreas Säger wrote:
  Am 16.03.2012 11:09, Nino Novak wrote:
   On Thursday 15 March 2012, 21:49:10 Andreas Säger wrote:
   First you need some database up and running. The creation of a
   database
   requires expert skills and appropriate software tools for the database
   type in question.
   
   IMHO, we should offer a really *short* tutorial on how to create a
   simple
   address book with LibreOffice.
   
   It could be used as reference on how to use Base.
   
   Don't you think, that this would help much more than saying, that it
   requires expert skills?
   
   Nino
  
  Again, this is *impossible*.
 
 Would you mind - sorry for the assault - would   you mind to *show* me that 
 that's impossible instead of telling me? 
 
 (Note: I'm not talking about a tutorial of how to become a database expert, 
 but only of how to create a simple address book)
 
  You can not describe how to do that by
  means  of features. You have to describe the process by means of data.
 
 I don't understand what you want to say here. 
 
 As for the tutorial, I meant: implementing one possible concretion of an 
 address book. Step by step. No further knowledge needed (though of course, 
 helpful if available). 
 
 
  There are plenty of references on how to use Base.
 
 Unfortunately most of them start with theory. Though, there is one tutorial-
 like Howto which I really appreciate. But it's about a calendar/scheduler, so 
 not applicable here.
 
 
  There are thousands
  of resources on relational database design in general.
 
 As said before: I did not mean to learn how to become a database specialist. 
 The tutorial should be aimed at simple (or say, a little bit advanced) users, 
 who just want to build a simple database. 
 
 
  This is not a
  problem. The problem is that too many people try to learn this by doing.
 
 I always encounter too many people trying to understand theory and 
 capitulating because of the too high level of abstraction needed to 
 understand 
 theory. 
 
  But this is something where you need to know some basics before you can
  do anything.
 
 What if we just try it? 
 
 Nino
 



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

[libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

[drew jensen]

On Wed, 2012-03-14 at 11:59 +, Tom Davies wrote:
 Hi :)
 Ok, so when migrating from Access to Base would it be best to first export 
 the Access tables into a different database program and then get Access to 
 read those tables?  

No. I referred to situations where Base is updating ms-jet or accdb (MS
Access data engines) directly. 

 
 Would that mean re-writing Access's Reports and Forms that are based on the 
 tables?
 Regards from

Correct - there is no way to re-use any of those.


 Tom :)
 
 
 --- On Wed, 14/3/12, drew jensen drewjensen.in...@gmail.com wrote:
 
 From: drew jensen drewjensen.in...@gmail.com
 Subject: Re: [libreoffice-documentation] Chapter 2 of Base Guide progress
 To: documentat...@global.libreoffice.org
 Date: Wednesday, 14 March, 2012, 2:18
 
 On Tue, 2012-03-13 at 09:16 -0300, Lailah wrote:
  Tom:
  I agree with you but I can't see what is the of mentioning 
  Access. I mean, we know that Access works in an specific way and Base work 
  in others, but I don't we have to mention it in the documentation.
  I think that saying  is a replacement for others database front-ends is 
  enough.  No need of mentioning any other name.  And no need of saying that 
  is ugly and that other is pretty.
  We only have to describe our application, that's all.
  What do is important is to say is  this is better because...  and 
  describe why is flexible, easy to use, etc.
 
 Well, the ability to work with MS Access is a highly important question and 
 one that if you are being truthful is not really possible with Base.
 
 You can connect to an Access Database as a data source, but you are not able 
 to make much if any use of major parts of the data (beyond the tables) held 
 in the MS Access file.
 
 There are also a number of very difficult situations with MS Access that are 
 commonly the downfall of attempting actual interoperability.
 
 Some of the things that the manual should point out, IMO, queries will be 
 viewed in Base as either tables or views - this means that users are often 
 befuddled as to why some Access table will not take updates - cause they 
 aren't tables, kids.
 
 Queries in MS Access support features for which there are NO equivalents in 
 Base, without resorting to scripting.
 
 Forms in MS Access support features for which there are NO equivalents in 
 Base, and you likely would need C++ code to duplicate those, forget the 
 scripting.
 
 The same can be said for reports.
 
 MS Access supports the ability to connect to multiple data sources,
 another 'feature' for which there is NO equivalent in Base or LibreOffice for 
 that matter. (Two data sources on a stand alone form are not the same thing)
 
 [However, this actually does have a work around - you simply must use a DB 
 backend that can do this instead]
 
 
 Anyway - I would, if I where actually doing this and so I it's my call,
 include some information about the issue with queries being picked up as 
 'views' as this bites a lot of people..beyond that, it's likely FAQ type 
 stuff, IMO.
 
 Best wishes
 
 //drew
 
 
 



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

Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

[drew jensen]

On Wed, 2012-03-14 at 12:49 +, Tom Davies wrote:
 Hi :)
 So Base can't update Accesses internal tables?

That is NOT what I said.

What I said was, that when connecting to an MS Access file the users
need to be mindful of the fact that queries in the Access file will
appear to them to be tables or views in the Base interface.

//drew




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