Pergunte aqui

Perfil de Libre Lyrae - atividade

2018-11-06 10:42:00 +0200 Medalha recebida  Pergunta boa (fonte)
2017-08-25 01:48:05 +0200 Marcada como a melhor resposta Landscape view and print not working in Calc

I have a spreadsheet whose page properties are set to landscape view yet in page preview it shows it as portrait. When you print it it will print in portrait. I even tried to get it to print landscape by going through the print properties and it printed on 2 pages instead of 1 with cells all cut off on the top and bottom. Am I missing something? Why is the landscape preview not working? I first noticed the problem with LibreOffice 3.5 and 3.6, on computers both running Ubuntu 12.4. I switched to LibreOffice 4.0 and I still can't print in landscape. So far I have been working around the issue by printing in Gnumeric, which prints the exact same file automatically from the file's page settings. I would rather not have to switch back and forth, and I have been trying to promote LibreOffice as a full office suite for small business customers.

2017-08-25 01:48:05 +0200 Medalha recebida  Autodidata (fonte)
2017-01-24 19:47:49 +0200 Medalha recebida  Resposta legal (fonte)
2016-03-07 01:42:06 +0200 Marcada como a melhor resposta How do I get base to display 0 value instead of NULL?

I have tried many different ways using SQL in the queries and using formulas in the report builder and have had no success getting it to insert 0 in place of NULL values.

For example I tried: IF(ISBLANK([OrderAdjustments]);0;[OrderAdjustments]) in the reports

In the Base Guide in chapter 6 it says to use IF([numericfield];[numericfield];0) which I tried also without success.

I tried a CASE WHEN ELSE END statement in my SQL queries without success.

How do I get the database to replace Null values with zero?

2016-02-22 16:41:31 +0200 Medalha recebida  Iluminado (fonte)
2016-02-20 18:57:38 +0200 Marcada como a melhor resposta Is there a way to create Indexes that will actually speed up record searches in LibreOffice Base?

Is there a way to create an index in LibreOffice base that will actually speed up the searches. I used:

CREATE INDEX IDX_FName ON "Contacts"("FirstName")

which was executed successfully (though required a re-start of Base due to an error message saying I was out of memory). However upon doing the exact same search as without the index the search took the exact same amount of time (A full 12 seconds, which will only increase as the database gets used more and acquires more records).

I have written queries which are faster but I had problems with that approach as well due to client-specific considerations (my client doesn't know SQL, nor can he spell well enough for the exact match necessary for a parameter input query) See my other question here:

As always any input is greatly appreciated!

2016-02-20 18:51:02 +0200 Marcada como a melhor resposta Need a DATE_ADD function or alternative for calculating dates in BASE.

I need a DATE_ADD function or alternative for calculating dates in Base. I have tried DATE_ADD(StartDate,INTERVAL). I have tried the syntax many different ways, normally I get SQL errors saying its expecting a BETWEEN or IN.

If I try DATE_ADD(StartDate, 'y') instead of errors I get "The data content could not be loaded.... Access is denied DATE_ADD in statement....)

All I want to do is generate a query that will tell me when things are coming due again so I can do a report monthly, weekly, yearly, etc where it will calculate what is due based on its start date or last complete date.

Is there any way to do this in base using SQL, or even in the report builder? Any suggestions would be greatly appreciated. Thanks!

2016-02-20 07:40:51 +0200 Marcada como a melhor resposta Is it possible to put a wildcard search into a parameter input query in Base?

I am using Base in LibreOffice 4.0 (still using the HSQL that comes with Base but looking at moving to HSQL 2.2.8) and I would like to do a query that asks for parameter input like:

SELECT * FROM "Contacts" WHERE "FirstName" LIKE :FirstName and when you run the query a window pops up asking for your parameter input for 'FirstName'

The problem with this one is that my current client is, well, a terrible speller, and the Parameter input requires an exact match, including capitals.

I tried multiple ways to add the wildcard % symbol to the parameter search and it will not work.

I used SQL to make a wildcard query ( eg SELECT * FROM "Contacts" WHERE "FirstName" LIKE 'W%' ) but unfortunately it requires this client going into the SQL for that query and changing the letters he is searching for, and again this is not an option for my client who is also not proficient in SQL, databases, or computers for that matter.

Is there any way to put a wild card search into a query that produces a parameter input? OR is there some macro I can program (help please!) that will do this for me?

Note: While the search record box does search for the match anywhere in the field this is a very slow search method due to the large number of contacts. My attempt to use an INDEX to speed the search was also unsuccessful (see my other question regarding this here:

2016-02-19 09:36:46 +0200 Marcada como a melhor resposta Issues converting to Split Database in Base using HSQL 2.2.8, Class Path works but connection is not?

I am trying to install a split database (starting with a file copy) using an upgrade to HSQL 2.2.8. I got HSQL 2.2.8, and have followed the instructions from another post on Super User ( ) to get the Class Path working fine when I pointed it to the correct location for my HSQL 2.2.8 and restarted LibreOffice. In Edit > Database > Properties I used Test Class and it successfully connected to the JDBC driver. That part worked fine. But then when I test the connection it keeps saying that the file is not found. I checked the file path again and again, tried moving it to different locations but its not working. I first had tried it with the mydb.file.odb that I found on a LibreOffice/OpenOffice forum and that connection would not work. So I copied the Data Class URL from the other post mentioned above changing the file path as needed pointing it to where I had saved the extracted and renamed files and it still says that it does not exist.

The error message I get is: SQL Status: S1000 Error code: -451

Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@d016958c[file =/Home/Databases/ManualDB/ManualDB.lck, exists=false, locked=false, valid=false, ] method: openRAF reason: /Home/Databases/ManualDB/ManualDB.lck (No such file or directory)

I saw something somewhere that a wildcard (~) can be used with HSQL 2.x to find the current user, but I am not sure how to do this or if this is in fact the issue.

I am running LibreOffice 4.0 on Ubuntu 12.04 LTS.

Any suggestions?

2015-11-15 07:41:55 +0200 Marcada como a melhor resposta not opening files over network

Help! I want to switch my office from LO to because the reports, macros and SQL work better in the newer version but when I tried to open files over the network they show the LO splash screen then nothing - I can get nothing to open over the network, which sadly is a deal breaker for this office. Has anyone else had this problem? Any suggestions?

2015-11-15 07:35:36 +0200 Marcada como a melhor resposta Why is my Base report builder replacing my default zeros (from query) with NULL?

I have an expense database I created for a client where on the form I set tax fields to default to zero so that I don't end up with NULL values when I try to do my calculations. I created a query to pull together all the information - it all looks great in the query - all my zeros are in the tax columns where they should be and all my calculations within the queries work fine. But then I create a report with that query and the report replaces all of my zeros with NULL and now none of my calculations are working.

I have already posted questions about how to get the report builder to insert a zero where there is a NULL and have not come up with any solution for that either.

Any help would be greatly appreciated. Lyrae

2015-11-08 08:41:43 +0200 Marcada como a melhor resposta How do I create spreadsheet layouts in Base report builder?

I went to create Report using design view and changed the Report Output format to ODF spreadsheet but I cannot get the spreadsheet to fill with values, all it does is list employee names for me but will not list any of the values tied to those names even though I put those fields under "Details" along with the employee name fields.

The query this is based on looks for a date parameter input - this seems to be what is also preventing me from creating the query as a view which I could then drag and drop into a spreadsheet (please correct me if I am wrong - when I do this and I look at my view table the field names are there but the data is blank). I would rather have the report do the spreadsheet but I am willing to try any angle...

Am I missing something? Or is this another one of those things that just doesn't work in Report Builder even though it looks like it is an available option?

2015-11-07 12:48:07 +0200 Marcada como a melhor resposta When a user opens a base file it becomes locked as read only for other users, how do I prevent this?

I have a few LibreOffice Base .odb files I created for someone and we are having problems where when one user opens and edits the file, and closes it, then it is now read-only for other users. I then have to create a copy and trash the locked file so they can use it, but then again it becomes locked to anyone else and they too end up having to make a copy. I have set permissions accordingly in the folder and file properties yet it still gets locked as soon as anyone makes a change, now only they can edit it further. It's turning out to be a major pain in the butt. The files are stored on a desktop and accessed via network by 3 other computers. We are running Ubuntu 12.04 and LibreOffice (I cannot update to 4.0.4 due to a bug in the report builder causing it to crash). I also tested it at home with Ubuntu 13.04 and LO and got the exact same results from my computers. I found this in ReadMe:

"File locking is enabled by default in LibreOffice. On a network that uses the Network File System protocol (NFS), the locking daemon for NFS clients must be active. To disable file locking, edit the soffice script and change the line "export SAL_ENABLE_FILE_LOCKING" to "# export SAL_ENABLE_FILE_LOCKING". If you disable file locking, the write access of a document is not restricted to the user who first opens the document. Warning: The activated file locking feature can cause problems with Solaris 2.5.1 and 2.7 used in conjunction with Linux NFS 2.0. If your system environment has these parameters, we strongly recommend that you avoid using the file locking feature. Otherwise, LibreOffice will hang when you try to open a file from a NFS mounted directory from a Linux computer."

I could not find SAL_ENABLE_FILE_LOCKING where described but I found it in etc/libreoffice and changed FILE LOCKING=auto to =no on both computers and it did not work, not only that it got an error and would not even open the forms, let alone edit anything in it.

2015-10-26 21:20:58 +0200 Marcada como a melhor resposta Can I set tab order between forms and subforms?

Can I not somehow set the tab order so that it goes through my main form AND my subforms without having to go to the mouse to go to a subform?

2015-10-22 23:26:16 +0200 Marcada como a melhor resposta Why is report footer forcing a new page in base?

I am using LO 4.0 Report Builder and my report footer is forcing a new page.... despite checking all the settings to be sure that no properties are saying to force a new page. The report footer holds my invoice total, I cannot have this on a separate page. Any suggestions anyone?

2015-08-25 15:34:13 +0200 Marcada como a melhor resposta LibreOffice Base is not giving me the option to add vertical scrollbar to a memo field?

I have several "Note" fields in a database I am building for a client and I am still a bit new to Base. In the past I was able to add vertical scrollbars quite easily so the text wraps in the box rather than displaying as one long line. Now when I try to add a scrollbar through Properties its greyed out and won't let me select it. If I select my Note field box and choose "Replace" it gives me a gigantic scrollbar in the box with no room for text. Any help would be greatly appreciated. I am in the process of developing business databases in Base to allow more people to make the switch away from Windows....

2015-06-19 00:55:28 +0200 Medalha recebida  Pergunta popular (fonte)
2015-06-19 00:55:28 +0200 Medalha recebida  Pergunta notável (fonte)
2015-06-19 00:55:28 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-08-19 19:06:59 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-06-07 00:32:54 +0200 Marcada como a melhor resposta Can I use a CASE WHEN statement in LO Base?

I am trying to get my database to show a zero when its NULL (I know in formulas you can use the IF NULL("ColumnName", '0' but this does not work in a stand alone select statement without a formula). I was told I should try a CASE WHEN but I could not get it to work. I tried

CASE ("ColumnName") IS NULL THEN '0' ELSE "ColumnName"

And I got SQL error so I am obviously missing something - or can I not use CASE WHEN in LO Base? I am running LO Base on Ubuntu 13.4

2014-05-15 09:55:35 +0200 Medalha recebida  Resposta boa (fonte)
2014-04-27 20:07:19 +0200 Medalha recebida  Taxonomista
2014-03-22 00:21:50 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-03-22 00:21:50 +0200 Medalha recebida  Pergunta notável (fonte)
2014-03-20 13:52:58 +0200 Medalha recebida  Resposta legal (fonte)
2014-03-09 03:30:55 +0200 Medalha recebida  Pergunta notável (fonte)
2014-03-05 15:07:59 +0200 Medalha recebida  Pergunta popular (fonte)
2014-03-05 15:07:32 +0200 Resposta comentada How do I make a "Date Modified" field in Base?

I tried the following Trigger but got the error "Unexepected Token ON": CREATE TRIGGER TrgDateModified ON "TableName" AFTER UPDATE AS UPDATE "TableName" SET "DateModified" =GETDATE() WHERE ID IN (SELECT DISTINCT ID FROM Inserted)

  • Note I am using the split HSQLDB v2.3x not HSQLDB v1.8
2014-03-03 20:02:03 +0200 Perguntou How do I make a "Date Modified" field in Base?

I have tried the following SQL to make a DATE field in Base that will update when the record has been modified to show the date it was last updated.

"DateModified" DATE DEFAULT CURRENT_DATE --- this gives me the date that the record was created, but will not update when modified... so I searched online and found someone suggested to instead set my field like this: "DateModified" DATE DEFAULT CURRENT_TIMESTAMP --- again this is a set timestamp for the date the field was created. I cannot seem to get it to update when the record is modified.

Is there a way using SQL to get a field to update the date when the record has been modified?

2014-03-01 12:57:10 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-02-10 00:30:04 +0200 Respondeu uma pergunta Issues converting to Split Database in Base using HSQL 2.2.8, Class Path works but connection is not?

This isn't exactly an answer to my particular question above as much as it is a very good workaround that achieves the same end - a split database. I just found this yesterday on the internet: (If you can't find it for some reason just google HSQL split database wizard) It contains macros that set up the split database for you automatically, very simple, easy to follow instructions, you'll have a usuable split database in minutes.

FYI: When making the change to a split database I encountered problems with changed field data types - just view your table field's properties by editing in table view - BUT you cannot change them there and have to use simple SQL instead. (ALTER TABLE "TableName" ALTER "FieldName" VARCHAR(60) for example). Once you alter your field properties your queries should all work properly again.
And so far so good - my most complex Invoice Database that I first tested it on is working great, after a bit of tweaking, but I have far more advanced SQL avialable to me now and most importantly it is no longer prone to data loss. :)

2014-02-02 12:16:32 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-01-16 18:49:29 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-01-16 18:49:29 +0200 Medalha recebida  Pergunta notável (fonte)
2014-01-05 23:08:23 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-01-05 15:21:07 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-01-05 15:21:07 +0200 Medalha recebida  Pergunta notável (fonte)
2013-12-31 16:34:19 +0200 Medalha recebida  Pergunta famosa (fonte)
2013-12-05 17:14:50 +0200 Respondeu uma pergunta Unable to open odt file on a network share

This is a common problem that's come up with LO I have no idea if the workaround I found will work on a windows machine as I stopped using those years ago, but check out my answer here:

and follow the link at the bottom that I gave to where I found the workaround - if the workaround I found doesn't work then that link may lead you to more information that will help you with your particular operating system.

Hope this helps, good luck!

2013-12-04 22:05:25 +0200 Medalha recebida  Autodidata (fonte)
2013-12-04 22:02:32 +0200 Medalha recebida  Pergunta notável (fonte)
2013-12-03 23:18:36 +0200 Respondeu uma pergunta 4.1.3 won't open files over the network

I had the same problem and found a fix, for nautilis users: Open the .desktop file (such as /usr/share/applications/libreoffice4.1-writer.desktop for LO Writer) and comment the following line: X-GIO-NoFuse=true The workaround works fine but I had to figure out how to open the .desktop, this is how: open the applications folder in the terminal and use gksu gedit libreoffice4.1-base.desktop and that is how you can edit the desktop file to comment out the line X-GIO-NoFuse=true Repeat this process for writer, calc, draw, empress & math and then all your LO files will open just fine over the network.

If you want to read more, or you use dolphin for your file browsing instead then check out the page where I got the fix: