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

2021-05-20 Thread Drew Jensen
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 want

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

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

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

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

Re: [libreoffice-users] Collabora experience?

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

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

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

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

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

Re: [libreoffice-users] Libo Extensions & Templates

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

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

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

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

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

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

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

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

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

Re: [libreoffice-users] Libreoffice office cloud version

2020-03-06 Thread 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

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

2020-03-03 Thread 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

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

2020-03-01 Thread Drew Jensen
he 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 s

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

2020-03-01 Thread 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,

Re: [libreoffice-users] Redaction

2020-01-21 Thread Drew Jensen
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 review

Re: [libreoffice-users] Redaction

2020-01-21 Thread 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 fina

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

2019-06-14 Thread Drew Jensen
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

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

2019-06-14 Thread 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

Re: [libreoffice-users] Base Firebird reserved words

2019-05-22 Thread 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

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

2019-05-15 Thread 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 defa

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

2019-04-23 Thread 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) loc

Re: [libreoffice-users] Transparency in Write

2019-04-13 Thread 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 a

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-02 Thread 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

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

2019-01-16 Thread Drew Jensen
x27;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 clicke

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

2019-01-16 Thread Drew Jensen
nal 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 suggest

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

2019-01-16 Thread 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 >

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

2019-01-16 Thread Drew Jensen
27;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 th

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

2019-01-16 Thread 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

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

2019-01-16 Thread Drew Jensen
at 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

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

2019-01-16 Thread 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

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

2019-01-06 Thread 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 a

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

2018-12-30 Thread 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 Displa

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

2018-12-30 Thread Drew Jensen
PLAY' 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 &

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

2018-12-30 Thread 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 searc

Re: [libreoffice-users] Scripting LO

2018-12-23 Thread 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 s

Re: [libreoffice-users] Calc week number problem

2018-12-22 Thread 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 lis

Re: [libreoffice-users] lobase and postgresql views

2018-12-04 Thread 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 rea

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

2018-10-27 Thread 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 t

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

2018-10-08 Thread 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

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

2018-10-01 Thread Drew Jensen
herwise, 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 &

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

2018-10-01 Thread 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:

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

2018-10-01 Thread 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 su

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

2018-10-01 Thread Drew Jensen
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

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

2018-09-22 Thread 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

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

2018-08-21 Thread 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 usi

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

2018-08-09 Thread 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 whe

Re: [libreoffice-users] Strange Macro folder behavior

2018-07-22 Thread 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&t=80579#p371390 How it helps, Drew On Sun, Jul 22, 2018 at 5:49 PM Peggy <33mar...@gmail.com> wrote: > I

Re: [libreoffice-users] Strange Macro folder behavior

2018-07-22 Thread 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&t=42324 but that is back

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

2018-07-22 Thread 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 ow

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

2018-07-22 Thread 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,

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

2018-07-09 Thread 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 >&

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

2018-07-09 Thread 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 lo

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

2018-07-08 Thread Drew Jensen
; > 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 :) > > >

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

2018-07-08 Thread 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

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

2017-09-20 Thread 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.l

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

2017-01-28 Thread 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 p

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

2017-01-27 Thread 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 paramete

[libreoffice-users] Fwd:

2013-02-12 Thread 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 Lis

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

2013-01-17 Thread 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 da

Re: [libreoffice-users] Libreoffice 3.6

2012-08-08 Thread drew jensen
On Wed, 2012-08-08 at 21:22 +0200, Johnny Rosenberg wrote: > 2012/8/8 Jeff Hahn : > > > > > > > > > > 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

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

2012-07-28 Thread 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 >

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

2012-07-28 Thread 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 remove

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

2012-07-27 Thread 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

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

2012-07-21 Thread 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=box&version=3.5.5 > If you do not have broadband connection, there should be a way for you > to get a copy from

Re: [libreoffice-users] Base and SQL statement

2012-07-20 Thread 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

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

2012-07-13 Thread 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 Easthope wrote: > &

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

2012-07-13 Thread 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 wrote: > > > >> I thought most debian releases had unity or at least GNOME 3 as their > >> GUI and they all feature a Dock. > > There is n

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

2012-06-25 Thread 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 t

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

2012-05-26 Thread 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

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

2012-05-25 Thread 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 build

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

2012-05-25 Thread 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_nodes&user=254826&i=80 > > > > I found t

Re: [libreoffice-users] My story

2012-05-09 Thread drew jensen
On Wed, 2012-05-09 at 14:12 +0100, Tony Sumner wrote: > On May 09, 2012, Dan Lewis wrote: > > > Likely, the first > > person has the version that should be used in a Windows OS, and the > > second person has the version that should be used in a Linux OS. > > Oh, come on. It is obvious which vers

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

2012-05-01 Thread 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 foll

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

2012-04-24 Thread drew jensen
" brings up: http://help.libreoffice.org/Basic/Shell_Function_Runtime Which is pretty good starting point. //drew > > --- On Tue, 24/4/12, drew jensen wrote: > > From: drew jensen > Subject: Re: [libreoffice-users] Re: launching app from within base > To: users@global.libreof

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

2012-04-23 Thread 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 sy

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

2012-04-23 Thread drew jensen
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

Re: [libreoffice-users] Base 3.5.2.2 hangs

2012-04-14 Thread 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, spread

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

2012-04-14 Thread 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) b

Re: [libreoffice-users] Removing Themes box

2012-04-13 Thread 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 th

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

2012-04-13 Thread drew jensen
on'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

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

2012-04-13 Thread 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. > > >

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

2012-04-13 Thread 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 downloa

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

2012-04-13 Thread 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

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

2012-04-13 Thread 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 > >> eithe

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

2012-04-12 Thread 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 dra

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

2012-04-11 Thread 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 da

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

2012-04-11 Thread 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 > Options>User Data section. In File>Properties, I can deselect "Apply user > data" and the au

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

2012-04-10 Thread drew jensen
ys 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

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

2012-04-10 Thread drew jensen
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 likel

Re: [libreoffice-users] Remove Macro from spreadsheet

2012-04-08 Thread 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

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

2012-04-08 Thread 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 datab

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

2012-04-08 Thread 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/fdb1

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

2012-04-08 Thread 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

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

2012-04-07 Thread 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 desire

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

2012-04-06 Thread 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 desire

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

2012-04-06 Thread 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

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

2012-04-06 Thread 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 i

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

2012-03-28 Thread 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

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

2012-03-23 Thread 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

  1   2   >