Hi *,
only copied from LO hel:
Choose Tools - Options - LibreOffice - Security and, in the Certificate
Path area, click Certificate.
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.
Hi Harvey,
tested this:
SELECT COALESCE ( `User`, 'Empty' ) AS `User`, COUNT( `ID` ) FROM
`test`.`User` AS `User` GROUP BY `User`
You don't need to change the alias for `Location` to `Loc`.
I could save this, open this to edit in GUI, execute it - no Problem
with direct connection on MariaDB
Hi Harvey,
SELECT `Location`, COUNT( `Location` ) FROM `Item_Management`.`Items`
`Items` GROUP BY `Location`
The result is correct for all LOCATIONS that are not empty, but
surpisingly the blank field for the empty locations is accompanied by
the value 0. How can I get the right count for the
Hi John,
...
MySQL/MariaDB with different drivers will be a new thread - or
shouldn't we try it per private mail?
...
Robert, I have only been following this thread as a lurker, not
contributor, but if I may offer a view on that question: I'm surely not
the only person finding this thread e
Hi Harvey,
MySQL/MariaDB with different drivers will be a new thread - or shouldn't
we try it per private mail?
Which connector do you use? (MySQL or MariaDB? If MySQL: which version?)
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsu
Hi Harvey,
OK. Thanks, Robert. That is more or less the conclusion that I had come
to. Not very user-friendly, but it works.
Reason for this behavior might be you are using a server database for
many users. Have had a look with PHPMyAdmin. Couldn't edit the view
there also.
Regards
Robert
Hi Harvey,
I cannot confirm the Firebird icon. My database backend is MySQL(JDBC),
(actually Mariadb). I prefer to continue for the time being with the
OpenSUSE packages delivered with my Linux Leap 15.4.
Editing views with external databases won't work. It's the same behavior
for every other
Hi Harvey,
LO won't be installed without internal HSQLDB. But with that behavior
you reported you are using internal Firebird. Will be shown at the
bottom of the window in statusbar.
You are using packages from your distribution, not from LO directly.
Have tested the same version you are usi
Hi Harvey,
I'm unsure of the practical implications of the difference between Base
implementation of Views and Queries. Perhaps someone can enlighten me.
One thing, however, does hit me.
Views will be executed in the database. The content will look for Base
like a non-writable table. You coul
Hi Harvey,
The Base Guide answers my question precisely, listing as it does the
built-in functions together with a remark in each case "[Works in the
GUI]" - or not (e.g. CASE)
Great stuff!!
And all this translated from German Base Handbuch into English. I take
this as special compliment.
Hi Harvey,
most SQL code I create direcly without using GUI, so I don't know if all
of this could also be created through GUI.
Have a look at the Base Guide
https://nextcloud.documentfoundation.org/s/qjFkGwpEEkNrt6f.
The GUI has been created to work perfect with internal HSQLDB (very
old…), b
Hi Harvey,
For example, I would like to extract a text string from a field in each
record and display it in an extra view and/or query field, or multiply
two field values and record the result in an extra field.
A little example will help: What is the content of the field in tehe
table, whot
Hi Harvey,
mark the content. Copy it to clipboard.
Go to the database file and open the tables pane.
Right mousclick → insert.
Choose the table where to append the data to, choose the column in the
wizard and it will be done.
You won't need a *.csv-file and phpMyAdmin to do this the same wa
Hi Séamas,
(Strangely, there’s an option within the style definition of “Don’t add
space between paragraphs of the same style.” Why there should be an
option of *not* doing something so unorthodox is another mystery;
however, it also has no effect.)
I use exactly this option to document code t
Hi Vani,
last action for bug 131512 was: You have set yourself to cc and have
written some comments. You won't get a mail for your own comments. If
there will anybody add a comment you will get a mail with the content.
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To
Hi vani,
why i am not receiving emails for my comments and adding of
attachments on bugzilla. i could not find mailing list also.
You have subscribed to bugzilla with a mail address. You will get all
comments to a bug if you reported the bug or set yourself to cc.
Could you post the bug num
Hi Chris,
For master documents:
File → Export
could give a *.odt-Document
Save the file this way, reopen it and save it again in *.docx.
I would prefer to export to *.pdf. No problems here since a long time
with German Base Handbuch: 13 chapters, all the same styles. Export this
very often w
Thanks Robert. Obviously you are more skilled at searching Bugzilla than
I am.
Have only had a look at Bugs reported in last 7 days (after searching
for menue …). So a little bit luck …
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+uns
Seems to be this bug:
https://bugs.documentfoundation.org/show_bug.cgi?id=149537
with many duplicates,
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-u
Hi *,
Is anyone else experiencing this issue or have I missed something?
Version: 7.4.0.0.beta1 (x64) / LibreOffice Community
Build ID: cec1fe9b57a55c032f9f118c907f34e22a63d040
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan;
VCL: win
Locale: en-US (en_US); UI: en-GB
Calc:
Hi Walther,
Why is "(web)" added to the writer title like "foo (web) - LibreOffice Writer"
?
Have tried it here with the same old version you are using, but packages
from LO directly (not from Linux distribution).
Don't get '(web)' there.
Did you open the file from a server?
Regards
Rob
Hi Keith,
I am having a problem with a form for a database that I constructed
without the help of the form wizard, many years ago. I know that I have
to link or connect the form to the database but I can't find out how to
do it.
It is a standalone form, isn't it?
Database is an internal dat
Hy Harvey,
I see that the rpm Version on the LO site is up to 7.2.7, or even
7.3.3. Can I take either as is?
I'm working with LO 7.3.3.2 here, but have also installed many older
versions. LO 7.2.7 will do the same. If you have created reports, which
will use charts, the next version LO 7.4 w
Hi Harvey,
I am using LO on OpenSUSE Linux Leap 15.3
Version: 7.2.5.1 / LibreOffice Community
Build ID: 20(Build:1)
CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: threaded
This is a special bug of OpenSUSE build:
https://bugs.documentf
Hi Min Di,
I found a vulnerability and I want to know if I should send you the
vulnerability report through the website or through a special bug bounty
platform?
I would prefer to write a bug description at
https://bugs.documentfoundation.org/
Regards
Robert
--
Homepage: https://www.familieg
Hi Joe,
file:///opt/libreoffice7.3/help/en-GB/text/shared/05/new_help.html?System=UNIX&DbPAR=WRITER&HID=.uno:HelpIndex#bm_id3806162
My guess is that you installed LibreOffice from an Ubuntu
repository, rather than the original libreoffice download site.
/tmp is a particularly stupid location
Hi Paolo,
Hi. Yes, I can confirm.
I have LO 7.3.0.3 on ubuntu 20.04. When I press F1, it opens a browser
with address:
file:///tmp/lu18302293odos5.tmp/NewHelp0.html
and says 'file not found'.
This is a totally wron path. Have a look for your LibreOffice program
installation.
here
Hi Joe,
could be you didn't see it is the offline help you are using. The
browser will be opened and there should appear as address something
beginning with "file:///…" This is the current offline help.
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-m
Hi Dan,
PERFORM IMPORT SCRIPT DATA FROM 'Main-subform.cvs' STOP ON ERROR;
CHECKPOINT;
This seems to be the right path:
"You can specify the ACL file path with an absolute or relative
path. If you use a relative path, it must be relative to the .properties
file." (p 310 of User Guide HSQLDB 2
Hi Anna,
I am looking to replace our Access Database.
How is your security at LibreOffice?
The internal databases of LibreOffice are not protected. You could use
the database file if the system allows to use this file. And if you use
the file you could also do anything with the database.
I
Hi Harvey,
try it with Shift and left mouse click.
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
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
Hi Thomas,
as I wrote in this list on 2022-02-09 12:22
it seems to be a known bug:
See special this comment in the bug description:
https://bugs.documentfoundation.org/show_bug.cgi?id=145963#c16
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: u
Hi Thomas,
could be something like this:
https://ask.libreoffice.org/t/slow-typing-with-writer-in-windows-11/71028/15
but you are using WIN10, not WIN11.
There are bugs reported for this problem:
https://bugs.documentfoundation.org/show_bug.cgi?id=145963
Many duplicates there.
Regards
Robert
-
Hi Thomas,
did you try to disable Skia? (Options → LO → View → Graphics Output)
See also:
https://ask.libreoffice.org/t/version-7-1-6-2-crashes-on-windows-10/67946
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoff
Hi Michael,
One of the messages talks about a version 7.3.0.3 that
works, but I can't seem to find it on any of the links.
Perhaps it fixed this issue, but caused others??
Have a look here: https://dev-builds.libreoffice.org/pre-releases/
or here: https://www.libreoffice.org/download/download
Hi Ken,
I know that the first step is to select Format -> Page style ... ->
Footnote, which opens a window with several options for the footnote
properties. One of the options is 'Style'. Selection of 'None' for
'style' means no separator line. If a separator line is wanted some
other selectio
Hi emril,
>
> The LibreOffice icon style is Sifr. When I select another one and click
> Apply, it returns to Sifr. What's wrong?
I could choose between different iconstyles:
Breeze, Colibre, Elementary, Karasa Jaga, Sifr and Sukapura.
Which LO-version on wich system do you use?
I have installed
Hi Adam,
did you run Tools → Update → Update All before exporting the whole
content to the *.pdf-document?
I have created the German Base Handbuch with a Master Document, contains
12 diffent *.odt-files. Works right here without problems with nearly
650 pages.
Regards
Robert
--
Homepage: https
Hi Michael,
>
> But for anyone else following, here's the slightly amended suggestion:
> 1. Open the Base file used by the Writer merge file
> 2. (With Base still open, but not as an action from within Base, just using
> a file manager) Open the source Calc file, Make your edits and save.
You don
Hi Michael,
> Is there a way to dynamically set up a Calc->Base->Writer mail merge so
> that changes in Calc can be pushed through to Writer? I don't see how to do
> it.
Not dynamically, but some hints:
You have to open the Base file before opening Calc.
Wehen opening Calc you see it is write pro
Hi Gary,
> I have a document in writer in which it would be helpful to refer
> to the same footnote from different parts of the text (to avoid
> multiple copies of the footnote) but i cant seem to find how to do
> it. Is it even possible?
Don't think it would be possible, because you could also cl
Hi Suzie,
> Can anybody
> tell me how to insert mail merge fields one at a time, and not just
> the standard address block that’s in the mail merge wizard?
In Writer try
Insert → Field → More Fields → Database →
Type → Mail Merge Fields
and select the field from the table of your database.
Reg
Hi Dave,
> Has anyone tried to use LO to create a smart form that does
> calculations? I'm thinking of an order form that calculates sales tax
> based on the location and shipping cost based on the destination.
> Some areas have no sales tax, others a little, etc.
>
You couldn't export any code li
Hi Moebius,
here the simple solution:
Put away the table "codes".
Edit table "Personnens"
→ add the field "Villes_ID" to "Personnes" (should be INTEGER;
foreignkey from table "Villes")
→ delete the fields "Codepost" and "Ville" from this table. You will get
this information from "Villes".
You wi
Hi Moebius,
I wanted to load down the example, but I don't know what buttons should
be pressed (all in French). Could you please send me the exmaple
database per provate mail?
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsubscr...@gl
Hi Thomas,
>>
> Well, **IF** I get to the Collabora full screen, I am still presented with:
> "Do you want to open a read-only file / Do you want to open/edit a copy".
> And this is not only with pCloud but also with Airsend the case.
This is the same you get if you open any document, which couldn
Hi Thomas,
could be the same here with LibreOffice Online for scools:
Set the mobile-phone Collabora to fullscreen. A blue pen appears. Press
on the blue pen. All must be writable now.
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsub
Hi zed,
you have to set the filter in subquery.
Could be this is what you want to get:
SELECT SUM( "No" ) FROM (SELECT * FROM "Reactor_Videos Table 1" WHERE
"First" >= '2020-12-01' AND "Last" <= '2020-12-31' )
You have to set the dates SQL-like in format '-MM-DD'
Regards
Robert
--
Homepag
Hi,
>
>
> SELECT ID, t1, t2, t2 - t1 AS duration FROM time_measurements1
You are looking for the function DATEDIFF(string, datetime1, datetime2)
Could be this works, if you have choosen a datetime field, not only a
time field.
SELECT ID, t1, t2, DATEDIFF('hour', t1, t2) AS duration FROM
time_mea
Hi Mark,
is there any entry in
Tools → Options → LibreOffcie → User Data → First Name / Last Name?
The cursor will set to the position the user endet to work with thge
document. If there is no user defined it will always be set at the start
of the document.
Regards
Robert
--
Homepage: https://
Hi Richard,
> Is there a way to use LO Base connected to a spreadsheet to insert a
> new row in the spreadsheet via Base?
No chance to do this directly. Base will load the Calc table when
starting Base. All tables are write protected for Base.
You could only change the content in Calc directly.
Hi aln,
> When I send a spreadsheet (xxx.ods) as an attachment in an email (I use
> Thunderbird), it is received as a "Read-Only" file. The only Options that I
> know of don't appear to force it to be Read-Only (see attached). So how do I
> disable this restriction?
Could it be you are trying to
Hi giova,
Writer doesn't know how to break the links. Go to
Insert → Formatting Mark → Insert soft Hypen
to set a break.
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.
Hi Dan,
must be something like
[<3.5][BLUE]0.#;[>5.2][RED]0.#;[Black]0.#
It is depending on the language and the decimalseparator. In German I
have to write comma instead of point.
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsubscr
Hi Charles,
>
> Havet you actually *used *(not just Googled a list or found a list or
> suggestions on Wiki) other free, open source applications which will do
> most of what Publisher does?
Did you try it with Scribus? We created newsletters in school mit
Scribus a long time ...
Regards
Robert
Hi Dave,
> I am trying to create a Writer document with a number of links to files
> in the same directory as the odt file itself. Using absolute paths
> everything works perfectly, but relative links (eg. file://abc.xyz)
> always fail with a "not an *absolute* URL" error.
The links will be saved
Hi Zed,
>
> My first thought was to have the entire database in one Table,
> differentiating the sectors by using different titles for the ID field,
> e.g. ID as an Integer (for the Reactor), IDArtist for the artist as an
> Integer etc. I created the IDArtist as an Integer but when I tried to
>
Hi Willy,
>
> I installed libreoffice 7.0.0.3 dutch version on a Windows 10 64 bit
> system. I noticed that, after putting a control on a form and opening
> the control properties window, all options are lacking. What's
> happend (a bug)? Any suggestions?
Couldn't reproduce the behavior with Open
Hi Brian, Vince, *
I have written a bug-description for this behavior:
https://bugs.documentfoundation.org/show_bug.cgi?id=135540
Could someone confirm this bug?
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoff
Hi Vince,
>
>
> I am having the same type of problem with another Calc sheet conversion
> to a Base table. This time, data within each field have an underline
> present.?? How do I remove the underscores/underlining?
>
> The Font Effects | Text Description | Underling: control box option
> indic
Hi Vince,
>
> Doing a left mouse click on Table1, I see the field names, but do not
> see the record data. If I select a field, at the top, the record data is
> visible only as white text on a dark blue background.
The data are part of the database. This is good. But the format of the
table is th
Hi Zed,
>
> The Table has one field named "Gender" and the gender is indicated by F,
> or M or M/F where a family is involved.
>
> What I was trying to achieve was a query which extracted the total
> numbers for each gender (e.g. 50, M25, M/F13) between a particular time
> period. In this case th
Hi zed,
>
> Thank you for your very prompt reply. I followed your instructions and
> it returned the sum of entries on the date entered. I obviously didn't
> phrase my questions clearly enough, for what I wanted was the sum of all
> entries for the period 01/07/2020 to 31/07/2020. I cannot find h
Hi Mike,
>
> Issues arise when attempting to create a new database within Libreoffice.
Do you try to create a MySQL/MariaDB database from LO Base?
You could only connect to a database with LO Base, not create a new
database. You need a MySQL or MariaDB database and could create tables
in this dat
Hi Uwe,
>
> The following works
> soffice --convert-to odt
> GQ_Course_guide_Applied_Statistics_and_Numerical_Methods_2020_FINAL.docx
> but I have also seen
>
> soffice --convert-to odt
> GQ_Course_guide_Applied_Statistics_and_Numerical_Methods_2020_FINAL.docx
> --headless
>
> It seems to ge
Hi Zed,
>
> Warning. Wrong data type:java.lang.IllegalArgumentException.
This only says: You will input, for example, a text in a field for dates.
Are there field-descriptions in the first row you wanted to import? Then
you have to chose "First row with fieldnames".
I see the fields in the Calc
Hi Pete,
most of the problems are in the user-folder. Hope you haven't used much
there. You could do this:
Close LO.
Look for .config/libreoffice/4
(Your system is a Linux system - I'm also working with KDE here and hope
it is the same folder ...)
It is a hidden folder in your home directory.
Ren
Hi John,
one hint:
Tools → Options → LibreOffice Writer → Basic Fonts
will set the size of the Default Character Style (and some other styles)
I have tried it with Character Style Emphasis. Set it to 150% - it was
set to 150% of the Default Character Style and sets all to 18pt. Then I
changed the
Hi John,
> All
> percentages seem to be based on a 12pt font, regardless of the font size
> specified in the Paragraph style.
12pt is the defined font size of the paragraph "Default Style". You have
to look in the style dialog in tab "Organizer" → "Inherit from". You
could change "Default Style"
Hi John,
>
> Also: can someone explain "text-to-text alignment" (Paragraph style
> Alignment tab)?
Try this:
Write some Text with Default Style. Copy it for getting some paragraphs.
Now set the paragraph
Text to Text → Alignment → Top.
Mark a word in the paragraph and switch the size of this to 1
Hi John,
newbies will create all content in one document. So it is no problem to set
Level 1 ~ Heading 1
Level 2 ~ Heading 2
Level 3 ~ Heading 3
But if there are separate document for each chapter of a guide you
couldn't get a well formed Master Document for a guide. Heading 1 must
be there in L
Hi John,
>
> Also, in poking around I note that there is a new version of LO
> available. I hate programs that come out with new versions every couple
> of months. Instead of installing it I think I'm going to uninstall this
> 6.3.4.2 and install LO from the Ubuntu repositories. That won't get
> u
Hi John,
one hint: *.jpg can't contain transparent background. The contur is
mostly set to this transparent background. I would prefer to change the
background in the *.png to transparaent background to see how contur
should work automatically.
You are using LO 6.3.4.2. LO 6.3 has had end of life
Hi John,
>
> I have a graphic on a page in Writer. The graphic is about 4cm wide and
> about 10cm high, so I have aligned it left and set contour to wrap
> right so that the text will flow down on the right of the graphic. This
> works, but the text is smashed into the side of the graphic. To fix
Hi Dan,
> Yes, I am. Actually I do not think this can be done in an formatted
> field in an individual control. I know that negative currency is not
> red even when that property is selected. It does work for a table
> control though. I think I will try this a little later today.
Works as expect
Hi Dan,
> I have a form with the results of medical test that are run each time I
> see the doctor. Each one of them has a "good" range. What I want to do
> is to have one color for those which are lower than the range, one in
> the range, and one which is above the range.
>
> I have seen this do
Hi Ian,
> Thanks Robert. That allowed me to insert a page break but the new
> page had a background colour the same as the TOC and changing the
> style from "Contents Heading" to Default Style" wouldn't remove it.
Did you really press Alt + Enter two times?
The first break will be part of the TO
Hi Ian,
>>
>> you could try this:
>> Change the TOC. It is protected against manual changes.
> How do you change it if its protected other than update it? I couldn't find
> how to "unprotect it"
Right click with mouse on the TOC → Edit Index
Type → Type and Title → Protected against manual change
Hi Ian,
you could try this:
Change the TOC. It is protected against manual changes.
Set the cursor at the start of the TOC.
Press Alt + Enter two times.
The first break will be part of the TOC, the second break will be out of
the TOC.
Set the TOC back to protection against manual changes.
Regards
Hi William,
> I have a spreadsheet downloaded from my bank. I changed the first col
> to format date MM/DD/ but when I sort the sheet it is still sorting
> the first col as if it were text, starting with 01/01/2020 and ending
> with 12/31/2019 (in ascending order).
Seems it is inserted as te
Hi David,
Only one some hints for the tables and the relations between the tables:
>
> A. ID
> B. Name
> C. Gender
> D. Number of reactions done
> E. First reaction
> F. Last reaction this is the most recent reaction
> G. Days - Formula =NOW()
> H. Weeks - =
> I. Months =
> This has wo
Hi John Jason,
>>
>> did you try to reset the user-profile?
>> (home/user/.config/libreoffice/4)
>
> Yes I did. Made no difference.
>
.. and it is the right user-profile for the Ubuntu-version of LO? I
could remember in SUSE there was a different profile, but it changed
sometimes ago to the same
Hi John Jason,
did you try to reset the user-profile?
(home/user/.config/libreoffice/4)
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to
Hi Ken,
> I added a screenshot of the "about" screen.
>
> you can see it at
> https://imgur.com/fVbdT2S
>
> It is V. 6.2.8.2 (x64)
Sorry, I can't help here any more. Listed all I know like
https://wiki.documentfoundation.org/Faq/General/InstallJava
I have no Windows here, no bug is reported for
Hi Ken,
What I could see there:
>
> Please look at third and fourth images this album.
> https://imgur.com/a/TOx0jWv
Seems Java in a path with (x86) says it is x86_64.
What I don't see: Did you install LO for x86 or for x86_64?
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robe
Hei ken,
most of the problem with JRE appear beacause LO hasent the same
bit-version like JRE:
If you install LO 64bit you also have to install 64bit JRE
>
> I've linked my findings to this reply:
>
> https://ask.libreoffice.org/en/question/193607/how-do-i-install-jre-for-librebase-62/?answer=2
Hi Peter,
> Years ago when I first used Libre Base it had a built in reporting
> software. Yhe later versions do not include this. Is this software still
> available and if so how do I get it and install it?
The old report software is included in LO. You could run all reports,
whcih have been cre
Hi Harvey
>
> I was just about to answer that I had tried that and it did not work,
> until I noticed your square brackets []. That did the trick!! You are
> wonderful.
>
> But where is that documented?
Don't know wher I found it, when I created the Base-Handbook. But have a
lokk for the English
Hi Harvey,
try this:
Write into Data > Data field
IF([NameOfBoolField];"y";"n")
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubs
Hi Alex,
>
> One suggestion might be to see whether you can embed a JS script in your
> PDF form for that control that does this for you, see for example, this
> thread :
>
> https://answers.acrobatusers.com/how-make-form-field-caps-q38840.aspx
>
> I honestly don't know whether this is possible
Hi Maurice,
>
>> There is no form-field in LO which changes the input from lower case to
>> upper case
>
> You mean other than Format/Text/Uppercase?
Look at a form-field. Right click on the field > Control properties >
Font. There is one button "Features". No possibility to set the whole
cont
Hi Rod,
>
> One of the fields should be upper case. Is there a form control that
> will convert entered text to upper case?
There is no form-field in LO which changes the input from lower case to
upper case.
Special for *.pdf-forms: The fields in *.pdf-forms will be textfields
without any speci
Hi,
>
> LibreOffice 6.0.7.3 00m0(Build:3)
You are using a special build for your distribution. Could be the
package there is a special package, which contains the toolbar. I would
prefer to install the versions directly from LO. Versions like 6.3.1.2
with Build-ID like b79626edf0065ac373bd1df5c28
Hi Harvey,
>
> I am using Mariadb10 as backend from a Base client via JDBC. I have
> created the function within a Base Query (GUI).
So it isn't a LO-problem. WEEK gives (in MariaDB/MySQL) 0 - 53, if you
start the week with Sunday.
WEEK('2019-01-01',1) gives 1, because it returns values from 1 -
Hi Harvey,
> Does anyone know why the function WEEK returns a zero for Tuesday, Jan
> 1st, 2019? i.e. WEEK('19-01-01')
Must be WEEK('2019-01-01'), if you are using the internal HSQLDB. Gives
'1' here.
Must be EXTRACT(WEEK FROM CAST('2019-01-01' AS TIMESTAMP)), if you are
using internal Firebird.
... and there is no problem to use the *.rpm directly from LibreOffice.
I have installed more than 15 different LO-versions for testing parallel
in a folder here - also LO 6.3.0.2 ...
My System: OpenSUSE 15 64bit rpm Linux.
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffi
Hi Harvey,
>
> I remember using VBA from my days with MSAccess, but our LO/Linux world
> has such an 'embarrassment of riches' I don't quite know where to
> start. You could say I'm a bit intimidated by the idea. Any suggestions
> where I might start?
I see your mailaccount is from *.de (Germany)
Hi Harvey,
>
> I am not using macros (yet...hmm). I create the queries with the GUI in
> SQL view.
> I execute using the 'Run Query (F5)' function from the editor. The SQL
> text is not allowed to be stored with the syntax error in the one case.
> In the case of the shorter command, the SQL text i
Hi Harvey,
>
> I'm getting "Can not issue data manipulation statements with
> executeQuery()."
Where do you start the update?
Tools > SQL?
Or is there a macro working? Then you have to run executeUpdate() instead.
Which database-connection do you use?
Regards
Robert
--
Homepage: http://rob
Hi Harvey,
>
> The SQL editor is rejecting this UPDATE query that, I believe, obeys
> the standard SQL syntax.
>
> UPDATE 'Adressensammlung'.'Adressen' SET 'Adressen'.'Print_flag' = TRUE
> WHERE 'Adressen'.`Xmas` = TRUE;
>
> I'm no SQL expert but I cannot for the life of me understand what is
>
101 - 200 of 382 matches
Mail list logo