Hi Paul,
Have a look at
> "Ions-IM"."Select" = TRUE
Did the migrationtool set the field "Select" to a BOOLEAN-field?
> "Equipment"."Series" = 134
Did the migrationtool import the field as a INTEGER field?
There is no function in the query, only 4 tables connected ...
The only possibility to
Hi Paul,
as Dan wrote:
Post the code of the query (opening SQL-view and copy).
There are functions, which will work in HSQLDB, but won't work, with the
same name, in Firebird.
Regrads
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community:
Hi Pertti,
>
> I have some old database-projects that I (very nicely) have built on
> MSAccess2003 and want now to rebuild them onto LO-Base.
> One of them has three tables (a main form and two subforms with about a
> hundred records by 15-25 cols each) that I now have successfully
>
Hi Dan,
>
> Styles > Edit Style > Area is the correct path to take. (I forgot
> about "Area", sorry.)
You are right. But who will search for a special defined color in
paragraph styles?
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community:
Hi Jonny,
> Sorry for bothering everyone again, but I can't find how to add colours to
> the background colour palette. In older LibreOffice versions, or maybe it
> was even Apache OpenOffice, I could add colours in Tools → Options… →
> somewhere, but it seems to be removed.
Hi Johnny,
> Am I the only one who can't edit styles?
> I right click on and click Edit, but no dialogue shows up. Just want to
> make sure this is a real bug before reporting it. Creating new styles works
> fine.
I could right click and click "Modify" - no "Edit" there. And "Modify"
will show
Hi Michael,
>
> What I'm convinced they want to do (I know, not right tool for the right
> job) is have a form doc that can be opened on demand, filled in by the
> operator then printed. I'm being led to believe that they don't even want
> to save it to disk.
So could be the XML-Formdocuments
Hi Michael,
>
> Has anyone seen an example that is a form for taking simple input and then
> outputs the form data in one of two manners, either as a simple text file
> of the values of each field or as a "finished" or "print ready" page.
>
> Has anyone seen anything on the LO web pages like
Hi Harvey,
>
> Multiplying 2048.28*.146 yields correctly 295.54488, but when rounding
> down to 2 decimal places, 295.55 is displayed (instead of
> 295.54)(either using ROUND(2048.28*.146,2) or with field format.
Please have a look at the values you have written. Gives 299.04888 here
on Calc and
Hi Gary,
the image has "Anchor > To Paragraph". There will no possibility for the
following text to wrap around the image.
Mark the image with right mousebutton, open the kontextmenu and look for
"Anchor > As Character".
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice
Hi Patrick,
please post the script here or upload an example-file with the script.
Could test it here wit 64bit rpm Linux.
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
--
To unsubscribe e-mail to:
Hi Keith,
>
> Version: 6.1.2.1
> Build ID: 1:6.1.2-0ubuntu1
> CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: gtk3;
> Locale: en-AU (en_AU.UTF-8); Calc: group threaded
You are using the LO-version from Ubuntu, not directly from LO. So it
could be LO is missing some packages.
But:
Hi Adam,
>
> I can only get this to work (with a list box) if there is only one
> project for each client. If I have two separate project records with
> the same client id I get an error.
There must be something wrong in your database-construction. Please load
up an example with some dummy-data
Hi Adam,
> I have a Client form with ClientID, FirstName and LastName fields and
> a Project form with ClientID and FullName fields. In Filemaker I was
> able to type in a client id into the Project form and it would insert
> the first name and last name from the Client form into the FullName
>
Hi Mike,
>
> I'm still 'all at sea', I'm afraid. I can't for the life of me see how
> to create a new section, never mind how to make it disappear conditionally.
When starting to edit a report you could see Pageheader, Details and
Pagefooter.
This are 3 sections of the report. You could add
Hi Peggy,
you could install bith versions of Java without any problem on the same
machine. If your LO is 64bit you need 64bit-Java for this one; if the
browser is 32bit you need 32bit for the browser.
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community:
Hi Peggy,
is your system a Windows-system? You have a 64bit-system? Did you
install Java and LibreOffice for the same 64bit or one for 32bit and the
other for 64bit?
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
Hi Mike,
>
> I can do a simple-minded report using report builder, which looks at the
> moment to fulfil the need, except for one problem. When a database field
> is empty (eg, no email or no 2nd address line), is there any way of
> completely suppressing that line of output? I don't want
Hi Alex, lunixbox,
>
> OK, so as I now understand it, you want a running total of all items
> with a given Item-ID (hence the inventory aspect).
I haven't answered to this because I have problems to understand ...
Hope you are right.
>
> I would recommend that you read Robert Grosskopf's Base
Hi toodr,
this is https://bugs.documentfoundation.org/show_bug.cgi?id=118112
Hope it will be fixed. Not everybody is able to change the content.xml.
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
--
To
Hi Klaus,
have tried it a little bit more. URL was wrong the first time.
I get the object oBitmaps.getByName( "OOoLilyPond" )
... but you will create a string of this. This coudn't work. What do you
wan't to get from the object?
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
Hi Klaus,
> ' Load the image into the internal bitmap table:
> oBitmaps.insertByName( "OOoLilyPond", ConvertToURL(sFile) ) ' Up to
> here,
> everything works fine.
> sNewURL = oBitmaps.getByName( "OOoLilyPond" ) ' This line causes the
> error.
So the error is one row above.
Hi Klaus,
no macro could be seen here. Attachements aren't allowed.
You know there is a German mailinglist? (us...@de.libreoffice.org)
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
--
To unsubscribe e-mail to:
Hi Paddy,
> Hi,
>I am developing an LO database and I want to open a PDF document from a
> button on a Base Form. I want a button on the form that will open a
> specific, different PDF document for each record. I want it to open the
> document in the default PDF reader? I have not been able
Hi Albrecht,
could be it is this bug:
https://bugs.documentfoundation.org/show_bug.cgi?id=105463
... but it has been fixed a year ago ...
Try to set the style of the box to 3D.
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community:
Hi Albrecht,
>
> 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”
Hi David,
it isn't the online-help, which is shown there. Have a look at the
addressbar. The address begins with file:/// ...
Now have a look at opt/libreoffice6.1/help.
All the files there are html, css, js, xsl - the help is now created for
webbrowser, but it is a offline-help.
Regards
Robert
Hi Michael,
> Wow! Where'd you find that referenced?
Have written this down in German Base-Handbuch, but it isn't translated
yet to English.
Have also found it here:
https://wiki.documentfoundation.org/Faq/Base/004
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice
Hi Michael,
> Here's the SQL statement (reformatted) I got in the trace of the ODBC
> library call:
> SELECT
> "SystemModels"."SystemModel" AS "SystemModel",
> "SystemModels"."SystemMfg" AS "SystemMfg",
> "SystemModels"."SystemMfgName" AS "SystemMfgName"
> FROM
> "SystemModels"
Hi Patrick,
>
> But it looks strange to call "UndoRecordChanges" form operation after my
> own "YourInsertFunction", it look like this call undo my own insert ...
> then, undo the operation of the form is not really no operation of the
> form ...
This should stop the prozess. I have had a look
Hi Patrick,
>
> 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 ...
You will need "Before
Hi Michael,
>
> I "linked" the two fields for the subform and when I execute the form, I
> get the error message:
>
> SQL Status: HY000
> Error code: 1
>
> parameter marker count incorrect
Could be you have written 2 fields for the mainform and one field for
the subform?
Other possibility:
Hi michael,
at first: Why do you answer to the list, some other persons and my
private mail-address? I am reading and writing the the list and doens#T
need the same message twice.
>>
>> I have tried it with German date-time-values and have set only
>> =A2 - A1
>> ... and it returns 06:50:00
>>
>>
Hi Krunose,
>
> just a quick question: if A1 holds 1.7.18. 15:30 and if A2 holds 1.7.18.
> 22:20, why then
Did you type it right here? Point after 18? Dont know if this is a right
format for a date/time-value.
I have tried it with German date-time-values and have set only
=A2 - A1
... and it
Hi Charles,
>
> A friend emailed me a .csv file created and saved in Excel 10 exported in
> the .csv format but no matter how I try opening it – Western Europe
> (ASCII/US) or (ISO-8859-1) or (Windows – 1252/Win Latin 1) it just opens to
> gibberish.
Could you open the file in a texeditor? Don't
Hi Peggy,
> Someone told me to use "reply all". I found an option under settings to set
> it that way. Either has to be one of the other. I guess I'll have to
> remember to uncheck it when I don't want to use it. Some groups don't want
> to be bothered with everyone's reply.
"Reply all" will
Hi bunk3m,
>
> The document goes from paragraph 1 to 11 and then should have 11.1 to
> 11.9 but I end up with paragraph 1 to 20.
Go to paragraph, which shows '12'
Right Mouseclick > Demote One Level
... and so on for all following paragraphs ...
Could be you have to change the numbering:
Right
Hi bunk3m,
> How do I manually change the starting page number for the legal
> document? What's the secret to get this to work?
>
Go to the first paragraph of the first page of your document.
Right mouseclick > Paragraph > Text Flow > Breaks
Choose "Instert"
Choose "With page style"
Choose
Hi Tom,
> Is anyone here in the MariaDb or MySql communities? Is there any chance of
> attracting some of their devs to work on an Open Source connector or better
> yet to work with our devs to create native support?
There is a native connector available for MySQL/MariaDB:
Hi Girvin,
>
> To create the relationships, I use the "Queries" "Database" option of
> Base and the "Tasks" options. I prefer to start with the "Create Query
> in Design View" to do most of the work.
Seems you create the relation between tables in queries. That is not the
way to create
Hi *,
I 'm using the internal database for deveopement of databases, with
pupils in scool and for some little projects, which only need a
standalone-database. For "normal" use I also prefer MariaDB. The native
driver had some (little) problems here so I switched to JDBC. I am using
Hello Girvin,
>
> I remember a while back, LO was making an effort to remove Java
> requirements. Some progress to that end has been made over the years,
> but I suspect there are still some threads connecting LO to Java,
> besides Base.
It is only the internal HSQLDB-database (Java), which will
Hi Zarah,
> i read somewhere that libreoffice 64 bit and 32 bit both supports java
> 32 bit version.
This is a wrong information. We have a lot of trouble with
Windows-users, who didn't realize 64bit Java is needed for 64bit LO.
There are many people in mailinglists, also in bugtracker reporting
Hi Thomas,
> The Java website allows you download the newest version, but does NOT
> ask about 32/64-bit installation.
> (I presume it detects that automatically)
No, it seems it doesn't. I haven't any Windows running here, but heard a
lot of wrong Java for LO, because 64bit and 32bit problem.
Hi Thomas,
which version of LO do you use? 64bit or 32bit? You need Java 32bit for
LO 32bit and Java 64bit for LO 64bit.
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
--
To unsubscribe e-mail to:
Hi T.R.,
Am 21.05.2018 um 16:46 schrieb T. R. Valentine:
> Why not use the default of +<;> (that's a semicolon)?
>
> Add the to insert current time.
This is the default for Calc. There isn't any default for date ore time
in Writer. But the combination is free for using in Writer also. So you
Hi Howard,
>
> Now, how would I change the result to -MM-DD?
Dubbelclick on the date. You get the dialog for changing the format.
I don't know how to change the standard - except to change the language
of the text to, for example, Englisch(Canadian).
Regards
Robert
--
Homepage:
Hi Peggy,
there is no macro needed.
Open a Writer-document
Go to
Tools > Customize > Keyboard
Type in "Functions": 'Date'
Now look for a free Shortcut-Key, for example Ctrl+7.
Click "Modify" on the right.
Click "Save".
Now you could insert the current date with Ctrl+7.
Regards
Robert
--
Hi Peggy,
> I am just learning to use Writer and started a document. I added footnotes
> and then changed things around and the footnotes need to be deleted so I
> can start over. But I can't find any way to delete them. They won't
> highlight. What am I missing?
You have to delete the number
Hi Steve,
tested a little bit more. Seems it is displayed a field like
View → Field Shadings
Could be it works with
Insert → Field → More Fields
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
--
To unsubscribe
Hi Steve,
> None of the form controls I see there are like in the document, they
> also don't seem to act like the form controls.
You have been asked for checkboxes. This checkboxes are at
View > Toolbars > Form Controls
You could start from this Toolbar another Toolbar for formcontrols like
Hi Steve,
>
> I am wanting to insert more of these but can't seem to locate the item
> within LO and would appreciate a hit as to the location in the menus.
> I suppose, while I am asking, which menu has the check boxes.
Are you looking for
View > Toolbars > Form Controls ?
Regards
Robert
--
Hi all,
have put the content of the mail I wrote to a bug-report:
https://bugs.documentfoundation.org/show_bug.cgi?id=116944
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
--
To unsubscribe e-mail to:
Hi *,
have tested this kind of migration:
Downloaded the daily build of 2018-04-11, 6.1.0.0.alpha0+
Opened the database, which is part of the Base Handbook:
"Media_without_Macros".
No comment like "Internal HSQLB" apperas at the bottom of the window.
Tried to open the tablecontainer.
No table
Hi Anne,
>
> I don't want to use absolute addressing, in order to keep the database
> portable, but I seem to have got the relative addressing wrong. The
> attached image shows the structure as it stands at the moment. The URL
> I'm giving is in the format ..\Images\someImage.jpg - btw,
Hi Anne,
>
> Just to clarify - I gather I need to add a field where I have at
> the moment only the text/URL field. I then try to set up the control
> for the image so that it reads the url and displays the image. Have I
> got that right? Test time, tomorrow.
Yes, it's the right way.
Hi Anne,
the Base-Handbook you are using is very old. Just some days ago the new
German Base-Handbuch for LO 6.0 has been published - nearly 600 pages.
The Base-Handbook conbtains a chapter for changing an internal database
to an external database. It is a part of the attachment.
It is better
Hi Eric,
> I want to enter the date 3/4 into a cell formatted for date. How do I keep it
> from changing my entry to three-quarters?
>
Open LO, goto
Tools > Options > Lanuage Settings > Languages > Date acceptance patterns
Here you could enter all you want. But better wuld be the input 3/4/
Hi Paul,
>
> Has anyone been able to use Base Reports and turn off the Header after
> the first page?
It is impossible at this moment to show something dependent on pagecount
in ReportBuilder:
https://bugs.documentfoundation.org/show_bug.cgi?id=52486
Pageheader couldn't be hidden by changing
Hi Tim,
>
> Robert The custom install as you stated seems to come up in Windows, not
> DEB based Linux install, unless you install through the repository, and
> package managers like Synaptic.
I have never installed LibreOffice on a Windows-system. You could choose
the packages under OpenSUSE,
Hi Henri,
>
> Surprised to hear that the Ubuntu respositories don't provide a complete LO
> package - I install via the PPA on my Linux Mint machine, which is an
> Ubuntu fork, and get everything, including Math and Base. What gives ?...
Every Linux-distribution does allow to install only parts
Hi Robert,
> At least under Ubuntu Gnome this tool is awfully small, unreadable. How to
> enlarge it ? I tried using gnome_color chooser (suggested by the French
> forum), to no avail.
Could you please explain where to find "base table navigation tool"?
Doens't know what you mean. I have read
Hi Peter,
here the macro for saving data while opening or running Base:
SUB DatabaseBackup(inMax AS INTEGER)
REM A copy of the databasefile *.odb would be created in the
Backup-folder.
REM The amount is limited to 5 copies. After it has reached 5 copies,
the
Hi Remy,
seems you haven't read the first mail of this thread:
"If I try opening it in a Zip file reader I'm told it's not a valid Zip
file."
The way to repair a *.odb-file is described in the Base-Handbook in
detail. But if you can't extract anything there you couldn't get data
out of a
Hi Peter,
>
> Both LO and Java are 64-bit versions. Is it a good idea to revert to 32-bit
> versions? I'm not sure how LO decides which Java to use if given the choice;
> I assume it picks up the same bit-version. Bugzilla doesn't show any obvious
> connection between 64-bit and database
Hi Peter,
Am 07.01.2018 um 13:23 schrieb ptoye:
> Since upgrading to LO 5.7.3 a database of mine keeps getting corrupted. When
> I try to open it it opens in Writer with the text Ó×r6ÒÒ#v If I try
> opening it in a Zip file reader I'm told it's not a valid Zip file. It's not
> consistent
Hi Marco,
>
> Imagine I want to draw 12 curves (months) all in the same graphic, one
> for each month with different x and y:
> month,x,y
> Jan,10,20
> Jan,15,30
> Jan,20,20
> Feb,5,10
> Feb,10,15
> Feb,30,30
> etc.
>
> How can I do it in Calc?
I have tried this, but I 'm not a Calc-expert:
Hi Patrick, Alexander,
>
> Sounds similar to bug 91828.
>
> Also, you might want to read bug reports 91879 and 107839 to see if they
> are related to your problem.
And also this one for opening a database-document:
https://bugs.documentfoundation.org/show_bug.cgi?id=96625
Regards
Robert
--
Hi Harvey,
>
> I've got it. The hsqldb driver pool had to be enabled in the Base
> options settings.
Have never touched there anything. The conneection-pool is disabled here.
Do you use the LO-version from OpenSUSE or do you use LO downloded
directly from LO-website?
I prefer the version from
Hi Harvey,
>>
>> here is a little example-database for executing SQL by a macro.
>> http://robert.familiegrosskopf.de/download/Example_InsertUpdateDelete
>> _SQL.odb
>> Open the form and try. Could be constructed a little bit better, but
>> works when code is right.
>>
>> Regards
>>
>> Robert
>
>
Hi Harvey,
here is a little example-database for executing SQL by a macro.
http://robert.familiegrosskopf.de/download/Example_InsertUpdateDelete_SQL.odb
Open the form and try. Could be constructed a little bit better, but
works when code is right.
Regards
Robert
--
Homepage:
Hi Dave,
> I need to use different computers belonging to other people to work on
> documents. I normally use LO Writer and would prefer to be able to use
> it in a browser without installing anything on the computers I'm using.
> I have access to a server and could do a server-side install to
Hi Harvey,
>
> Obviously, I found this behaviour (by accident) because I was looking
> for it, and because I needed it. Also obviously, my feeling is that
> LOBase is not doing itself a favour by restricting usage of SQL in this
> way. I would prefer a feature that allowed data manipulation via
>
Hi Harvey,
>
> I am accessing a backend Mariadb V10 on a backend server via
> MySQL(Native).
>
> The Base query contains only the following statement:
> UPDATE Family.Adressen SET Print_flag = FALSE;
>
> LO Version 5.3.5.2 from OpenSuse on Linux.
>
Have tested this with nearly the same
Hi Harvey,
>
> The UPDATE query is allowed (i.e. stored in the queries list) if you
> 'edit in SQL view' and then set the 'Run SQL Command directly' in the
> SQL editor. If you don't do it this way only SELECT queries are
> permitted.
If I try this the message appears:
Statement does not
Hi Peter,
> Definitly a hard crash. When restarted it goes into a recovery process.
> If I install Open Office will it work with the Lire Base data bases or
> would I need to export the data and recreate new data bases?
If you are using the internal HSQLDB (and not Firebird!) it will be no
Hi Peter,
install all what begins with libreoffice-report . This will install the
report-builder. I haven't installed any Ubuntu-version here, only SUSE.
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
--
To
Hi Peter,
> Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2
>
> Ubuntu 16.4
>
> When I first found the problem I removed LibreBase and reinstalled it
> but the problem with reportsremained the same.
This is a special Ubuntu-version of LO. Have a look into your
packagemanager. Did you install all
Hi James,
>>> Hasn't any icon, so it would appear with text in the standard toolbar.
You could also add an icon to "Request". Choose the added "Request" and
change the icon. There would appear a dialog with icons.
>> That appears to work, but it's Insert>Request. Now to find
Hi Jonny,
>
> This works, but what about oDlg and oCtl? Are there special data types for
> them too? The documentation I've found so far doesn't give any hints at
> all. I tried this:
> Dim Dlg As com.sun.star.awt.XDialog ' No error here,
> ' but next line throws an error:
> oDlg =
Hi James,
> I occasionally scan documents into LibreOffice with a single sheet
> scanner. This means for each page I have to click on
> Insert>Media>Scan>Request. Is it possible to create an icon to run
> those steps?
Haven't tested, but:
Tools > Customize > Toolbars > Add Command
there:
Hi Joe,
>
> ttf-mscorefonts-installer
Never heard LO will install ttf-mscorefonts. On my system (OpenSUSE) is
a special script to download ttf-mscorefonts. It has nothing to do with
LO. Could be there is the same script for Ubuntu. So start this script
with your installer.
Regards
Robert
--
Hi Kolbjørn,
> In Writer I have a table with 2 rows and 2 columns.
> In row 2 column 2 I have a formula adding the value in row 1 column 2 to
> the value in row 2 column 1 together showing the result in row 2 column 2.
> When changing one of the input values row 2 col 2 is not updated unless
> I
Hi Harvey,
>
> But shouldn't the CONCAT( ' & ', [Partnervorname] ), '' ) actually
> return a NULL due to the '' (i.e. not a space, zero length)?
NULL: There is nothing inside, no string, no number, no data ...
Empty: Could only be for strings - nothing to see, but its a string with
zero length.
Hi Harvey,
>
> I have a backend Mariadb 10 which I access directly using the using the
> MySQL connector.
All right. With MariaDB (and MySQL) the two pipes (||) dont work.
But something like
SELECT CONCAT("Vorname, ' ',IFNULL("Partnervorname",' '),"Nachname") AS
"Name" FROM "Table"
should
Hi Harvey,
> Hi Robert,
> Thanks for answering.
> Your suggestion, however, do not work on my Opensuse Leap 42.3 /
> LibreOffice 5.3.3.2 configuration. >
> I use the Query design feature to enter
>
> "Vorname" || IFNULL( ' & ' || "Partnervorname", ' ' ) || "Nachname"
> or
>
> "Nachname" ||
Hey Harvey,
> I wanted to use the CONCAT function in a Base query. However, it seems
> that if ONE of the elements of the list to be concatenated is NULL then
> the CONCAT function returns a NULL. Am I right? Is it a bug or a
> feature?
feature, because anythin, which is connected with NULL
Hi Noel,
> I am transferring an H2 database from a Windows PC to a late model Apple
> Mac, (Capitan 10.11.6). On the main Base window, the Tables are all
> displaying normally, but nothing shows up under Queries, Forms or Reports.
Did you create queries, forms and reports for the database in a
Hi Peter,
> I have a query which works fine. But when I edited it in the graphical query>
> editor LO refused to save it saying that there was an SQL error. The>
detailed message was "syntax error, unexpected $end, expecting BETWEEN
or IN> or SQL_TOKEN_LIKE". Even if I try to save the unedited
Hi Gordon,
> Trying to edit a master (.odm) document. Write protection is locked on.
>
> Ctrl+Shift+M removes the 'Read Only' note at head of page, but edit
> access is still barred. Suggestions?
Could the document be write-protected by the system, not by LO?
If protection of LO is disabled
Hi H. Stoellinger,
you could try this one:
https://extensions.libreoffice.org/extensions/mysql-native-connector
Works here with LO 5.4.1.2 on OpenSUSE.
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
--
To
Hello Dennis,
>
> I don't come clear with LibreOffice. No matter what I try, I end in a
> paragraph - as paragraphs are kind of swiss-knives in LibreOffice.
> However, the rules to the paragraph element are classic and not helpful.
> For example, I inserted a line-break into a list entry. The
Hi Chaim,
>
> I have an old computer (32 not 64) running Fedora. I updated to Fedora 26
> and office 5. I cannot open the office at all. I tried re-installing and it
> didn't solve the problem.
Where have you downloaded LO from? Is it x86, not x86/64
Hi Pieter,
> I need a printed (paper or PDF) report from a small selection of my DB. I
> am puzzled what is the best way to achieve that.
> Filter?
> Query?
> other?
> I am new to Base (but no PC dummy!)
Best way to get a report is:
Create a table "filter", which will only be needed for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Dave,
>
> I'm involved in a project that will produce a dataset as its
> product. I'm considering using LO base so as to avoid vendor
> lock-in. I've found a base document from 2014 that seems promising,
> is there a more up-to-date place to start
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi John,
> Thank you for your reply. I am using Libreoffice on Microsoft
> Windows 10 and always update Libreoffice when one becomes
> available. I have seen comments that say Java can be a problem, if
> you moved over to Firebird does this remove
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Greg,
mark the row and choose
Sheet > Insert Page Break > Row Break
Regards
Robert
- --
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Helo Vytas,
>
> I have a spreadsheet containing timing results which are displayed
> using the a Format code of MM:SS.00 (02:58.03).
>
> What I require is the number of seconds the cell represents as a
> decimal number of seconds (178.03) for the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Andre,
> I use OpenSUSE Tumbleweed. In the new version of LibreOffice is a
> shortage of fonts. I can choose 104 fonts from the 171 available of
> my system fonts. So I missed - of course - my favorate Classical
> Garamond. ´the asked font is not
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Martin,
>
> I now have two challenges:
>
> a. I'd like to include the outline numbering in the paragraph
> numbers, i.e. instead of
>
>
> 3. Some Chapter
>
> 1. First 2. Second
>
>
> I want/need:
>
>
> 3. Some Chapter
>
> 3.1. First 3.2.
201 - 300 of 354 matches
Mail list logo
