Stel uw vraag

xenon1's profiel - activiteit

2019-07-09 15:02:35 +0200 beantwoorde een vraag LibreOffice 6.0 unzip - zip open document file?

Just found the solution: Rename file: a) replace *.ods with *.zip. Or, even easier: b) add .zip to file name. Now the

2019-04-05 16:09:59 +0200 badge ontvangen  Beroemde vraag (bron)
2019-03-10 00:28:34 +0200 reageerde op een antwoord Base not decoding Western charset correctly with sdbc:firebird

No, this does not work.

2019-03-10 00:24:22 +0200 badge ontvangen  Beroemde vraag (bron)
2019-03-09 01:43:47 +0200 reageerde op een antwoord Base not decoding Western charset correctly with sdbc:firebird

Thanks riosv and petermau. However, that was not the question. My Firebird database is already configured as ISO-8859-1.

2019-03-09 01:40:50 +0200 reageerde op een vraag Base not decoding Western charset correctly with sdbc:firebird

Mike, with LibreOffice 6.0 or maybe 6.1 you can connect directly: Open a new instance of LibreOffice Base: Choose Connec

2019-03-08 04:08:41 +0200 badge ontvangen  Opvallende Vraag (bron)
2019-03-07 23:47:12 +0200 badge ontvangen  Opvallende Vraag (bron)
2019-03-07 10:23:12 +0200 badge ontvangen  Populaire Vraag (bron)
2019-03-07 09:12:48 +0200 reageerde op een antwoord LibreOffice 6.0 unzip - zip open document file?

"When (re)zipping an ODF document you must ensure that the mimetype file is the very first file in the archive and not c

2019-03-07 05:13:04 +0200 badge ontvangen  Populaire Vraag (bron)
2019-03-06 23:52:16 +0200 bewerkte een vraag LibreOffice 6.0 unzip - zip open document file?

LibreOffice 6.0 unzip - zip open document file? In LibreOffice 5.0 I used to be able to open an Open Document file (e.g.

2019-03-06 23:51:12 +0200 stelde een vraag LibreOffice 6.0 unzip - zip open document file?

LibreOffice 6.0 unzip - zip open document file? In LibreOffice 5.0 I used to be able to open an Open Document file (e.g.

2019-03-06 22:42:29 +0200 bewerkte een vraag Base not decoding Western charset correctly with sdbc:firebird

Base not decoding Western charset correctly with sdbc:firebird I am working with LibreOffice 6.0.7.3. [Details: Libre

2019-03-06 22:40:24 +0200 bewerkte een vraag Base not decoding Western charset correctly with sdbc:firebird

Base not decoding Western charset correctly with sdbc:firebird I am working with LibreOffice 6.0.7.3. [Details: Libre

2019-03-06 22:39:36 +0200 bewerkte een vraag Base not decoding Western charset correctly with sdbc:firebird

Base not decoding Western charset correctly with sdbc:firebird I am working with LibreOffice 6.0.7.3. [Details: Libre

2019-03-06 22:38:14 +0200 bewerkte een vraag Base not decoding Western charset correctly with sdbc:firebird

Base not decoding Western charset correctly with sdbc:firebird I am working with LibreOffice 6.0.7.3. [Details: Libre

2019-03-06 22:37:32 +0200 bewerkte een vraag Base not decoding Western charset correctly with sdbc:firebird

Base not decoding Western charset correctly with sdbc:firebird I am working with LibreOffice 6.0.7.3. [Details: Libre

2019-03-06 22:36:38 +0200 stelde een vraag Base not decoding Western charset correctly with sdbc:firebird

Base not decoding Western charset correctly with sdbc:firebird I am working with LibreOffice 6.0.7.3. [Details: Libre

2018-02-07 21:28:33 +0200 bewerkte een vraag How to change Pivottable datasource when datasource is registered database?

How to change Pivottable datasource when datasource is registered database? In LibreOffice Calc: I cannot change the Piv

2018-02-07 21:27:03 +0200 bewerkte een antwoord How to change Pivottable datasource when datasource is registered database?

Meanwhile, I found the solution. This solution should work on any operating system, i.e., on Windows, Linux, or any othe

2018-02-07 21:21:48 +0200 beantwoorde een vraag How to change Pivottable datasource when datasource is registered database?

Meanwhile, I found the solution: The coding for the source of the Pivottable is (of course) contained in the file of the

2018-02-07 20:46:59 +0200 badge ontvangen  Beroemde vraag (bron)
2018-02-07 20:46:59 +0200 badge ontvangen  Opvallende Vraag (bron)
2018-02-05 20:32:44 +0200 badge ontvangen  Beroemde vraag (bron)
2018-02-05 20:32:44 +0200 badge ontvangen  Opvallende Vraag (bron)
2017-06-14 21:09:26 +0200 badge ontvangen  Populaire Vraag (bron)
2017-06-13 12:43:40 +0200 bewerkte een vraag How to change Pivottable datasource when datasource is registered database?

How to change Pivottable datasource when datasource is registered database? In LibreOffice Calc: I cannot change the Piv

2017-06-13 12:42:37 +0200 bewerkte een vraag How to change Pivottable datasource when datasource is registered database?

How to change Pivottable datasource when datasource is registered database? In LibreOffice Calc: I cannot change the Piv

2017-06-13 12:39:55 +0200 stelde een vraag How to change Pivottable datasource when datasource is registered database?

How to change Pivottable datasource when datasource is registered database? In LibreOffice Calc: I cannot change the Piv

2016-09-22 17:09:17 +0200 badge ontvangen  Beroemde vraag (bron)
2016-08-19 11:10:23 +0200 reageerde op een vraag Calc introduces unbreakable, non-existing links in my sheet

I have the same main problem, with differences: When I click Yes on the dialog that asks me to update the links, the dialog just disappears and the Edit > Links menu is greyed out (there are no links, obviously).

2016-08-03 21:38:55 +0200 badge ontvangen  enthousiast
2016-08-01 15:35:16 +0200 badge ontvangen  Opvallende Vraag (bron)
2016-08-01 15:30:41 +0200 badge ontvangen  Populaire Vraag (bron)
2016-07-31 23:27:13 +0200 beantwoorde een vraag Base: Uncheck Password required has no effect. Is there a workaround?

Workaround: Know that the *.odb-file is really a *.zip-Archive that contains all the settings. Open and edit it:

  1. Rightclick on *.odb - file
  2. Open With File-Roller (German: Archivverwaltung) or any application that opens *.zip files; you should see a datastructure now with folder "Configurations2, folder "forms"... until file "settings.xml". In the middle you see file "content.xml".
  3. Open file "content.xml" with any simple text editor (in my case: xed).
  4. Search for db:is-password-required.
  5. You'll find: db:is-password-required="true".
  6. Change this to db:is-password-required="false".
  7. Save and close file "content.xml".
  8. Close file-roller or whatever you unpacked the *odb-file.

That's it. Now you can open your database without entering a password and, if you want to check, the field "Password required" in the configuration window Connection settings (Get there by: Menu | Edit | Database | Properties) is unchecked. But beware: if you check "Password required" it does change the settings, and you may have to go through the above steps again.

This answer is for a Linux system. But, according to another user the problem and the solution is the same for a Windows computer.

(This is already filed as bug 97416, so it does not have to be filed again.)

2016-07-31 23:24:20 +0200 stelde een vraag Base: Uncheck Password required has no effect. Is there a workaround?

Setting up database connections in Base using window "Database properties - Connection settings" (I did it to connect to firebird using a jdbc connection) but another user had the same problem with a postgre database (and I do not know which kind of connection):

Unchecking the box "Password required" has no effect: Base still asks you for a password when logging in to your database (just hit enter, if you database does not require a passphrase), and the next time you open the window "Database properties - Connection settings" "Password required" is checked again.

Is there a workaround?

2016-07-31 23:10:40 +0200 reageerde op een antwoord LibreOffice 5.1.4. cannot find firebird sdbc connection

Thank you, m.a.riosv.! But I do and did have experimental features checked when I tried the above sdbc connection. This alone does not change the inability to connect natively to firebird.

2016-07-31 22:41:59 +0200 badge ontvangen  Populaire Vraag (bron)
2016-07-31 20:49:44 +0200 badge ontvangen  Organisator (bron)
2016-07-31 20:35:18 +0200 badge ontvangen  Redacteur (bron)
2016-07-30 10:09:17 +0200 stelde een vraag LibreOffice 5.1.4. cannot find firebird sdbc connection

Trying to connect LibreOffice Base natively to database Firebird through an sdbc connection. Although I installed the Rirebird SDBC driver for LibreOffice (libreoffice-sdbc-firebird), I could not find a way.

Configuration: OS: Linux Mint 18. / LibreOffice 5.1.4.2 (Build ID: 1:5.1.4-0ubuntu1). / Firebird 3.0. / Installed libreoffice-sdbc-firebird version (1:)5.1.4(-0ubuntu1).

How I tried to connect: Start LibreOffice Base | Opens on page Database Wizard | 1. Select Database | Check: Connect to an Existing Database, Dropdown: No entry for Firebird. The SDBC driver also does not show up in LibreOffice | Menu | Tools | Options | LibreOffice Base | Connections in the Window "Drivers known in LibreOffice".

Is there another way (workaround?) to connect to an external (meaning: not embedded in a Base file) Firebird database natively?

(I did connect via JDBC and it works, but it was tedious to set up and I would like to find a faster way.)