[libreoffice-users] Q: configure “Remote Files” to access a SMB share on a Fritzbox

[Albrecht Dreß]

Hi all,

I try to access files on the SMB share of a Fritzbox router using the “Remote 
Files” in Libreoffice, but unfortunately without success.

From the Linux command line, the following command opens the connection to the 
share:

   smbclient -U shareuser --password ** -W WORKGROUP -D Storage 
//fritz.nas/my.nas

In Libreoffice, I enter the following data in the “Remote Files” dialogue using 
“Add service”:
* Type: Windows share
* Host: fritz.nas
* Share: my.nas
* user and password: as above; enable Remember password
* Root: Storage

Selecting the “Service” entry, the “Remote Files” dialogue is still greyed out, 
no folders or LO files are displayed, and all I can do is to click “Cancel”.  
No error message or other information is displayed.

My Libreoffice version (installed from Debian Bookworm backports, but I have 
the same issue with the official macOS build):
  Version: 24.2.4.2 (X86_64) / LibreOffice Community
  Build ID: 420(Build:2)
  CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3
  Locale: en-US (C); UI: en-US
  Debian package version: 4:24.2.4-1~bpo12+1
  Calc: threaded

How should the Service be configured to access the files on the share?  Any 
help will be highly appreciated!

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

[libreoffice-users] Graphics transparency in Writer

[Albrecht Dreß]

Hi all,

I run LibreOffice 7.0.4.2 on a /very/ old (2009) 32-bit MacBook Pro using 
Debian Buster (Libreoffice DEB packages from Debian Buster backports).

Importing a semi-transparent SVG graphics in Writer, the transparent area is 
display non-transparent (solid colour), which is really confusing, as it is 
displayed correctly in Writer on a newer Linux box.  In the print preview the 
transparency /is/ displayed, it is printed properly, and a PDF export works as 
expected.

I guess the “wrong” display is caused by the old graphics card (NVIDIA 9400, 
using the free nouveau driver), and I observe the same effect in Virtualbox 
VM's running Buster (both 32 and 64 bit).  Is this assumption correct?  And 
would it be possible to get transparency working even on such old or 
virtualised systems?

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

[libreoffice-users] LO 6.4.1 on macOS: (temporarily) no native file dialogs?

[Albrecht Dreß]

I today installed the latest LibreOffice 6.4.1 plus the German locale from 
libreoffice.org on my wife's MacBook Air running macOS Catalina (10.15).

She opened a document by double-clicking it – fine.  Tried to say “save as” – 
the spinning rainbow wheel appears for ~2 seconds, but *no* file dialogue 
opens.  Tried to “open” an other document – spinning wheel again, no dialogue.

I then changed the preferences to use the LibreOffice dialogues instead of the 
natives ones.  Now all file operations worked again (but these dialogues are 
somewhat clumsy compared to the macOS native ones).  Changed the preferences 
back to the native dialogues – same effect as above, no file dialogues, just 
the spinning wheel.

I then /restarted/ LibreOffice, changed the prefs to use the native dialogues – 
and they are working again!

Any idea what happened here?  Is this a known bug?

Thanks,
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

[libreoffice-users] Draw: page numbering

[Albrecht Dreß]

Hi all,

I want to create a rather huge document in LO Draw (actually a photo 
collection) with numbered pages.  Thus, I want to split the document into 
multiple parts, export them separately as PDF, and glue the resulting PDF 
together.

Adding the page/slide number in the master is of course simple, but it starts with "1" 
for each document.  Is it possible to change the start number somehow, i.e. to print e.g. 
"20" on the 1st page of the 2nd document part?

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

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

[Albrecht Dreß]

Thanks for the pointer, looking forward to the new version!

Best, Albrecht.

Am 08.10.18 20:03 schrieb(en) 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.

--
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] [Base] PostgreSQL column w/ default value & Forms: broken in 6.1.2

[Albrecht Dreß]

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

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

[Albrecht Dreß]

Am 09.08.18 19:26 schrieb(en) Robert Großkopf:

You are using a special Debian-build of LO, made from a
release-candidate of LO. The released version of de.libreoffice.org is
6.1.0.3


Ok. I made a quick test with a freshly installed Stretch vm:
* The package 6.1.0.2 / build-ID 1:6.1.0~rc2-3~bpo9+1 (actually coming from 
stretch-backports) is definitely broken, i.e. doesn't show the check box forms 
(also broken in writer), but
* the “official” tarball of deb's from de.libreoffice.org *does* work as 
expected.

So it's time to file a Debian bug report!

Thanks a lot for your help,
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

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

[Albrecht Dreß]

Am 09.08.18 19:03 schrieb(en) Drew Jensen:

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)


Ooops – it's here: , 
showing the toolbar, and the effect after adding the check box (“Markierfeld”): it 
appears, with the default title, but /without/ the actual check box control.


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.


The effect also appears for a bigger project for accessing a PostgreSQL data 
base.  The forms document has been created with an older Libreoffice version 
(5.2, iirc), but it worked just fine (apart from bug #115619) with 6.0, too.  
With 6.1, the check box controls are gone, with only the titles remaining.  
Apparently still operational if I click on it (the field in the database 
changes), but no visible control.


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,


O.k., will try that version (at work, i.e. tomorrow).


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


I use XFCE on both the Debian and the Ubuntu boxes, with both Gtk+-2.0 and 
Gtk+-3.0 being available.

Thanks,
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

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

[Albrecht Dreß]

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

[libreoffice-users] Base: opening from with macro requires delay?

[Albrecht Dreß]

Hi all,

I run LibreOffice 6.0.2.1.0+ (Build-ID: 1:6.0.2-1~bpo9+1) on Debian stretch.  
In a base document, connected to a PostgreSQL data base, I ran into a really 
confusing behaviour of forms.

The task: I have two forms.  In the first, when the user clicks a button, the 
second form (managing a list of contacts) shall be opened for entering a new 
item.  Following the manual, I wrote this macro and connected it to the 
“Execute action” of the button in the first form:

---8<
Sub newContact
oDstForm = thisDatabaseDocument.FormDocuments.getByName("Kontakte 
verwalten")
oDstForm.open()
oMainForm = oDstForm.component.getDrawPage.getForms.getByName("ContactForm")
oMainForm.load()
oMainForm.afterLast()
oMainForm.moveToInsertRow()
End Sub
---8<

This opens the form, but still displays the first entry, which should not 
happen.

Now for the /really/ puzzling part:  In the macro editor add a breakpoint at 
any statement in the macro.  Now step (shift-F8) through the remaining 
statements until “End Sub” is reached, and the form jumps to a new entry with 
all fields empty, i.e. does what I expect it to do.

When I place a ”wait 100” statement after “oDstForm.open()”, the form /also/ 
behaves properly, but I think this is not the correct solution.  Any idea what 
goes wrong at this point, and what would be the correct approach?

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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] LibreOffice base: fix form dialogue size

[Albrecht Dreß]

Hi all:

I use LibreOffice 6.0.1 on Ubuntu/Debian to access a PostgreSQL database.  The 
document contains several forms, which shall have a different (optimised 
according to the elements in them) size.

However, when I resize one form the a convenient size, all other forms open 
with the same (typically wrong) size.  Needless to mention that this is a 
really annoying behaviour…

Is it possible to auto-adjust the size of a form to the optimum proportions 
(i.e. the size of the area containing all items, plus maybe some border 
region)?  Or, as an alternative, to save the /individual/ size of each form 
separately, so resizing one form will not modify the size of all others?

Thanks in advance for any insight,
Cheers,
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: [Base] Access PostgreSQL ARRAY types in forms

[Albrecht Dreß]

Hi Alex:

Thanks a lot for your fast response and for your input!

Am 08.09.17 14:44 schrieb(en) Alexander Thurgood:

How are you connecting to your pg database ?
Via a JDBC driver or using the native postgres driver provided within 
LibreOffice ?

Depending on which one you are using, support for a given data type, in this 
case, an array, might be different (I don't know off-hand, I haven't tested).


I use the native connector, on a Debian 9 aka stretch Linux boxe; sorry for 
omitting this information in my first post…

It can actually deal properly with array data afaict; in the table view, it is 
displayed in the “usual” Postgres style (i.e. in braces).


Using a macro that takes your form control text and inserts it into a 
preparedStatement object, it would/should probably be possible. I doubt that 
the Form GUI supports this kind of thing directly though (but I'm far from 
being an expert with postgres data type support in LibreOffice).

As you mention, it might be more efficient to do this via a stored procedure in 
the backend rather than fudging something in the frontend.


Hmmm, thinking again about it, if I have to write a stored procedure anyway, it 
is probably easier to change the data base model and replace the array of 
single-line texts by a single multiline text.  All the validation work would be 
performed in a post-insert or -update trigger function in Postgres.  And it 
saves me the time to learn coding macros in Libreoffice (lazy me).  For the 
data consumer (not Libreoffice), it doesn't make a big difference; to keep the 
API as it is now, I just write an other stored procedure splitting the 
multilines into arrays.


> Or is there an other "standard" way for dealing with array data types?
>

Not without using macros, that I know of, but I would love to be proven wrong.


The ability to deal with arrays would be a cool extension for Libreoffice 
(IIRC, arrays are part of the SQL standard).

Thanks again,
cheers,
Albrecht.
--
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] [Base] Access PostgreSQL ARRAY types in forms

[Albrecht Dreß]

Hi all,

I am new to the list, so please excuse me if this is the wrong place or a dumb 
question...

I have a PostgreSQL data base and want to use LibreOffice Base as nice frontend 
for adding and modifying data.  The Postgres tables contain data arrays, like

CREATE TABLE contact (
  [...]
  email text[]
)

My problem: how can I create a form to fill in such arrays?  A simple 
(multiline) text field will try to insert its content as text, of course 
leading to a SQL error.

A simple solution would be using the Postgres function string_to_array() or 
regexp_split_to_array() (or even a more sophisticated Stored Procedure) in the 
INSERT statement, splitting the multiline text into array items.  However, I 
didn't find a way to tweak the SQL statement like this.  If this even possible?

Or is there an other "standard" way for dealing with array data types?

Any help will be highly appreciated!

Thanks in advance,
Albrecht.

-- 
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