On Tue, 2024-09-17 at 16:09 +, Jesse Kassab wrote:
> Could you happen to help me in any way please 🙏
>
>
> Sent from Yahoo Mail for iPhone
>
>
> On Sunday, September 15, 2024, 12:16 PM, Jesse Kassab
> wrote:
>
>
> Yes hello I am trying to combine multiple excel sheets in
> libre office i
On Thu, 2024-08-08 at 14:58 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> > One aspect of working with LOBase is the error proneness of keeping
> > track of, beyond the use of intelligent names, what individual
> > Queries/Views/Tables are used for. Was it ever considered (and
> > rejected?) to e
One aspect of working with LOBase is the error proneness of keeping
track of, beyond the use of intelligent names, what individual
Queries/Views/Tables are used for. Was it ever considered (and
rejected?) to extend the 'Document Information' feature to Queries and
Tables, similar to that for Forms
On Fri, 2024-07-26 at 09:57 +1000, Peter Goggin wrote:
> I have a lenova T400 with two data bases. One is still available, but
> the second appears to have disappeared. I get the following messaes:
> The connection to the data source "Financial" couls not be made.
> The driver class "could not be
On Sat, 2024-07-20 at 17:28 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > what should I do to recover the missing index.html file?
> >
> Try to reinstall the Help of LO.
> There should be a comnplete help in
> /usr/share/libreoffice/help
> and it is linked to
> /usr/lib64/libreoffice/help
>
On Sat, 2024-07-20 at 12:25 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > Other files/directories are there. However. Are they complete?
> > Could
> > this be an integration error in the OpenSUSE Leap 156 repo?
> >
> > Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID:
> > 420(Bui
I am getting an error message (from Firefox) when I select the LO Help
function (F1). Apparently, says Firefox, that index.html is missing in
the /usr/lib64/libreoffice/help/ directory. This turns out to be true!!
Other files/directories are there. However. Are they complete? Could
this be an inte
On Sat, 2024-07-20 at 08:36 +0200, Robert Großkopf wrote:
> Am 20.07.24 um 08:16 schrieb Robert Großkopf:
> > Hi Harvey,
> > > >
> > > I don't have mariadb installed on my desktop (which is LOBase
> > > client
> > > connectect via ethernet (hone zone) to mariadb on NAS sever)
> >
> > There should
On Sat, 2024-07-20 at 08:16 +0200, Robert Großkopf wrote:
>
> There shouldn't be any difference between MariaDB on a Linux sytem
> connected through localhost or connected from another system in your
> local network.
>
> How did you create the connection to MariaDB to JDBC?
>
> I could reprodu
On Fri, 2024-07-19 at 21:48 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> tested with LO 24.2.5.2 and MariaDB on OpenSUSE 15.6 64bit rpm Linux.
>
> Works well with internal driver, also with JDBC (mariadb-java-client
> 3.1.3)
>
> Its the same behavior with special version LO 24.2.4.2 fronm Open
On Wed, 2024-07-17 at 09:02 -0400, Java Joe wrote:
> Different databases have different ways of implementing Auto-
> Increment
> or Serial numbers.
>
> I expect this to be related to the database you're using (Mariadb), a
> Base compatibility issue but not really a bug.
>
Until now, in the previ
ug.
>
It hasn't been a problem with my LOBase/Mariadb configuration until LO
version 24.2.4.2 and existing tables with autovalue work as they always
did. However, I will see what I can do to investigate this.
Harvey
> On 7/17/24 07:20, Harvey Nimmo wrote:
> > I wonder if anyone else
(en_GB.UTF-8); UI: en-GB
Calc: threaded
Cheers
Harvey
On Tue, 2024-07-16 at 16:21 +0200, Harvey Nimmo wrote:
> Greetings!
>
> I am running LO 24.2.4.2 on OpenSUSE Leap 156 with LOBase as desktop
> client to Mariadb backend on my home network. I wanted to create a
> new
> simple tabl
Greetings!
I am running LO 24.2.4.2 on OpenSUSE Leap 156 with LOBase as desktop
client to Mariadb backend on my home network. I wanted to create a new
simple table in LOBase Design View with two columns (logevent as
VARCHAR(100), ID as INT (primary key set)). The ID has AutoValue and
Entry require
>
> Search for "soffice". You should find 2 paths and, therefor, 2 files
> named "soffice"
>
> Run each "soffice" as program or executable.
>
> Click on menus to see which version.
>
> Hope this helps till a better answer comes along.
On Mon, 2024-06-24 at 21:04 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> download the three packages from LO: one for main program, one for
> language and one for help.
> Unzip this packages in a folder.
> Create a folder "my_rpms" in you home directory for the *.rpm-files.
> Move all rpm-files
On Mon, 2024-06-24 at 21:04 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> download the three packages from LO: one for main program, one for
> language and one for help.
> Unzip this packages in a folder.
> Create a folder "my_rpms" in you home directory for the *.rpm-files.
> Move all rpm-files
On Mon, 2024-06-24 at 16:11 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> > LibreOffice Version: 24.2.1.2 (X86_64) / LibreOffice Community
> > Build ID: 420(Build:2)
> > CPU threads: 2; OS: Linux 6.4; UI render: default; VCL: gtk3
> > Locale: en-GB (en_GB.UTF-8); UI: en-GB
> > Calc: threaded
>
>
On Mon, 2024-06-24 at 16:11 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> > LibreOffice Version: 24.2.1.2 (X86_64) / LibreOffice Community
> > Build ID: 420(Build:2)
> > CPU threads: 2; OS: Linux 6.4; UI render: default; VCL: gtk3
> > Locale: en-GB (en_GB.UTF-8); UI: en-GB
> > Calc: threaded
>
>
On OpenSUSE Leap 156, I am running
LibreOffice Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 2; OS: Linux 6.4; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: threaded
with LOBase connected by network to a mariadb as backend.
Hi Edwin,
On Wed, 2024-05-22 at 16:01 +1000, Edwin Humphries wrote:
> Hi all
>
> I need to copy the first word from an existing field and place it
> into a
> new field. Is there a way to do that autoagically?
This might work for you, assuming the field with the text is called
SELECT `YourTextF
Hi Robert,
On Sun, 2024-05-19 at 19:18 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > I can confirm that with my current LO 24.2.1.2 this is NOT the
> > behaviour. Removing ANY ONE table in the Table Filter followed by
> > Refresh Tables causes ALL Table to disappear, and the Table Filter
> >
Hi Robert,
On Sun, 2024-05-19 at 09:15 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> have tested with LO 24.2.3.2 on OpenSUSE (original packages from LO):
>
> Started
> Tools → Table Filter
> Marked "All views" → OK
> Started
> View → Refresh Tables
> All tables and view could be seen, special
The Table Filter in Base doesn't seem to work well in my configuration.
I am running Base as frontend to a network server with mysql/mariadb
containing several databases, connected via MySQL(JDBC)
Logging in to the mysql server causes Base to show ALL the tables of
these databases (including the
On Wed, 2024-05-15 at 09:15 +0200, Robert Großkopf wrote:
> Hi Thomas,
>
> > Probably I am a little stupid, but what is the difference between
> > "24.2.3" and "7.6.7" (in my case 7.6.6).
> > These number look VERY different.
>
> Version numbering had been changed.
> 24 → Year 2024
> 2 → Februar
Henschel wrote:
> Hi Harvey,
>
> Harvey Nimmo schrieb am 30.04.2024 um 09:34:
> > Each month I have to prepare a contribution to a presentation.
> > I write my contribution in LO-Impress as .odp, save it and send it
> > as
> > .pptx for a colleague to integrate it us
-2023-6185.patch
* CVE-2023-6186-1.patch
* CVE-2023-6186-2.patch
* CVE-2023-6186-3.patch
* CVE-2023-6186-4.patch
* CVE-2023-6186-5.patch
On Thu, 2024-05-02 at 13:39 +0200, Regina Henschel wrote:
> Hi Harvey,
>
> Harvey Nimmo schrieb am 30.04.2024 um 09:34:
> > Each month
not be repaired and is removed. I am trying
to find out which content may have been removed, as that would be the
potential culprit.
Cheers
Harvey
On Tue, 2024-04-30 at 10:48 +0200, Harvey Nimmo wrote:
> Thanks. One of the pictures is in wmf format (whatever that is!). All
> the others are
the pictures, I am sure there is one which creates the issue.
>
> On 30/04/24 10:13, Harvey Nimmo wrote:
> > Hallo Italo,
> >
> > Thank you very much for your offer. Unfortunately, the slides
> > contain
> > personal data, that I cannot really share.
> >
&g
To provide a more precise opinion, though, I should see the file.
>
> If you can send it to my address as attachment (the list doesn't
> accept
> attachments) I can double check.
>
> On 30/04/24 09:34, Harvey Nimmo wrote:
> > Each month I have to prepare a contribution
ntation as a ppt (the old
> powerpoint format). No complaints from my co-workers yet. Admittedly
> my presentations are very simple (text, some tables, PNG images); ppt
> may not work if you need more features.
>
> HTH,
>
> Peter
>
> On Tue, Apr 30, 2024 at 3:36 PM Harvey
)
CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: threaded
I expect an input from the colleague about his Office/Windows versions.
Best regards
Harvey Nimmo
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems
The phenomenon you describes suggests that the label size might be set
wrongly. Even if the label size is set to match the published values.
Maybe you should try reducing the label height by a millimeter or two,
(deviating a little from the published value)
Cheers
Harvey
On Fri, 2024-03-22 at 20:
Don't give up...Base is a powerful tool for managing all kinds of data.
and Robert Großkopf is an excellent advisor!
Happy new year to all!
Harvey
On Sun, 2023-12-31 at 13:43 -0500, Jonathan Ames wrote:
> In trying to reopen table I'd created, I cannot add records -- says
> ERROR
> "Attempt to
On Tue, 2023-11-21 at 08:54 +0100, Robert Großkopf wrote:
> Hey Harvey,
>
> > The next question, though, is how do I ensure that only complete
> > records are printed on a page? I.e. How do I prevent the records
> > being
> > split between the bottom of one page and the top of the next?
> > The 'F
ey
On Mon, 2023-11-20 at 18:08 +0100, Harvey Nimmo wrote:
> Sorry to trouble you. 'Auto grow' is the answer to my question. I
> failed to notice this improvement since I generated the report
> originally many years ago!
>
> Cheers
> Harvey
>
> On Mon, 2023-11-20
Sorry to trouble you. 'Auto grow' is the answer to my question. I
failed to notice this improvement since I generated the report
originally many years ago!
Cheers
Harvey
On Mon, 2023-11-20 at 17:54 +0100, Harvey Nimmo wrote:
> When creating a Base report consisting of a list of s
When creating a Base report consisting of a list of sddresses, for
example, some of the text fields occupy more than the fixed space
allowed by the Base report editor. The overlarge texts are highlighted
with red triangles and the field sizes can be edited with Writer. This
editing task is exceedin
On 2023-07-08 14:43, Harvey Nimmo wrote:
>
> > I had this problem with any email sent to a gmail account. ...
>
> I doubt it's so simple, Harvey. I have no such problem with my own
> gmail account (which has no outlook.com server in the mix).
> jk
>
--
To
Hello Budge,
I had this problem with any email sent to a gmail account. As indicated
by the email rejection message, the solution is to login to your email
account at your ISP and set the SPF parameters for your email domain. I
needed help from my ISP to make the right settings in my case.
Cheers
Hi Robert,
> Hi Harvey,
> >
> > I am running mariadb 10 on the backend. File mysql-connector-
> > java.jar
> > is registered under Options -> LibreOffice -> Advanced -> Class
> > Path at
> > /usr/share/java/
>
> For MariaDB I would use the JDBC-connector fro MariaDB, not from
> MySQL.
> You coul
In Writer, place your cursor at the place you want the page number to
appear. If you want it in the footer or header you will first have to
select the blue footer or header marker on your page. Click Insert ->
Page Number.
If you want "page of total page count", you will have to add e.g. the
word
On Tue, 2023-05-23 at 15:05 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > I connect daily to a MySQL database located on a network server
> > from
> > the LO-Base front-end on my desktop. The connection type is
> > MySQL(JDBC). However, today, the "driver class
> > 'com.mysql.jdbc.Driver'
> >
What can have gone wrong here?
I connect daily to a MySQL database located on a network server from
the LO-Base front-end on my desktop. The connection type is
MySQL(JDBC). However, today, the "driver class 'com.mysql.jdbc.Driver'
could not be loaded". There seems to be no way to make the connecti
I'm not a windows user, but perhaps the LibreOffice process is running
in the background and not able to access a foreground window. In that
case, you should try to kill the LibreOffice that is running in the
background by opening the process manager (what's its correct
name,anyone?) look for Libre
Hi Robert,
the thought occurs to me that the existing quotes within the SQL
statements may need their own treatment. The statements that work under
the LOBase Tools>SQL... function have different type of single
quotemarks for the column names (e.g. containing two separate words) or
the text to be
Hi Robert,
how would this work for me, where I only want to create a SQL statement
as a string and execute it. Can it be that the string is not recognised
as SQL? (In my MSAccess days it worked). Here the run-time error
indicates that the "Object variable is not set" although it is valid
SQL text
n/BG72/BG7209-Macros.html
>
> Sorry, not much help :-(
>
>
> On Tuesday, January 24, 2023 15:50 EST, Harvey Nimmo
> wrote:
> Thanks. Not sure I can understand how that should work...hmmm
>
> I based my syntax on the example here
>
> https://learn.microsoft.co
Thanks. Not sure I can understand how that should work...hmmm
I based my syntax on the example here
https://learn.microsoft.com/en-us/office/vba/api/access.docmd.runsql
On Tue, 2023-01-24 at 20:39 +, Dave Howorth wrote:
> On Tue, 24 Jan 2023 20:32:18 +0100
> Harvey Nimmo
led Random DB
> Ramblins, and yes that is spelled incorrectly).
>
>
> On Tuesday, January 24, 2023 14:32 EST, Harvey Nimmo
> wrote:
> Where can I find the syntax of the DoCmd.RunSQL command to be used
> with
> a LOBase Macro in Basic?
>
> My assumption was
> X
Where can I find the syntax of the DoCmd.RunSQL command to be used with
a LOBase Macro in Basic?
My assumption was
X = "SQL string"
DoCmD.RunSQL X
The SQL string runs correctly is correct when executed as SQL Command
in the Base Tools/SQL window.
The Basic Macro with the above statemsnt compi
registration (during OS/LO updates?)
Problem solved.
On Mon, 2022-12-12 at 20:44 +0100, Harvey Nimmo wrote:
> I need help to print address labels from my database. I have had it
> working e.g. a year ago, but now I am having trouble. My database
> Mariadb10 on a backend server and Base on my fronten
I need help to print address labels from my database. I have had it
working e.g. a year ago, but now I am having trouble. My database
Mariadb10 on a backend server and Base on my frontend desktop.
I have followed the following procedure (as last year)
1. From Base (adresslisten database) se
On Thu, 2022-09-01 at 17:39 +1000, Stephen Morris wrote:
> On 29/8/22 09:21, Regina Henschel wrote:
> > Hi Matthias,
> >
> > Matthias Lammer schrieb am 29.08.2022 um 00:24:
> > > Dear LibreOffice team,
> > >
> > > I want to file a very severe bug as follows:
> > >
> > > I create a simple functio
Yes that works, too. I notice that Base strips off the 'AS' keywords.
Cheers
Harvey
On Tue, 2022-08-16 at 16:02 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> tested this:
>
> SELECT COALESCE ( `User`, 'Empty' ) AS `User`, COUNT( `ID` ) FROM
> `test`.`User` AS `User` GROUP BY `User`
>
> You
Just one remark on this, though. The GUI and SQL Edit views seem not to
be consistent with each other. Just opening the Query to Edit GUI,
adjusting the pane size (say) and saving the result, destroys the
query.
Cheers
Harvey
On Tue, 2022-08-16 at 10:54 +0200, Harvey Nimmo wrote:
> Thank
Thank you, Robert! As always on target.
This is better than filling the Location fields with some unneeded
value. Great stuff. Man lernt nie aus!
Cheers
Harvey
On Tue, 2022-08-16 at 10:15 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > SELECT `Location`, COUNT( `Location` ) FROM
> > `Item
I have a table consisting of (unique) ITEMS and with a column LOCATION
for the land of origin of the ITEMS. Some LOCATION fields are still
empty.
A query counts the number entries in the LOCATION column for each
country present. Essentially the GUI just shows the functions LOCATION
'group' and LOC
Hi Robert,
I have chosen the configuration LO-Base front ent to Mariadb backend
becuase of the advantage of database server with Terrabytes of disk
space.
But I am wondering seriously whether I have made a good choice. There
seem to be serious compatibilty problems between them in spite of the
OK. Thanks, Robert. That is more or less the conclusion that I had come
to. Not very user-friendly, but it works.
Cheers
Harvey
On Fri, 2022-08-12 at 08:36 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > I cannot confirm the Firebird icon. My database backend is
> > MySQL(JDBC),
> > (actually
Hi Robert,
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.
Cheers
Harvey
On Thu, 2022-08-11 at 18:06 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
>
Hi Robert,
Thanks, so far...;-) I understand that a View would be more efficient
in execution than the equivalent query. And this seems to be more or
less the practical extent of justification for view over query.
My version:
Version: 7.3.4.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU thre
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.
Initial design of a View with the GUI, is done similar to a Query,
which is OK. However, when the View is stored, then fur
That is marvellous. Thank you, Robert!!
I must get used to visiting the Document Foundation website, as I tend
to stick with the help function and otherwise OpenSUSE. Excellent tip.
The Base Guide answers my question precisely, listing as it does the
built-in functions together with a remark in ea
Hi Robert,
I suppose my question could be reformulated: what version of SQL does
Base support? To what extent is that SQL supported in the BASE
query/view graphical interface?
I haven't been able to find an answer in the LO Help (yet).
Cheers
Harvey
On Wed, 2022-08-10 at 08:31 +0200, Robert Gr
I wonder if anyone knows a simple way in Base to calculate a value for
a view and/or query field entry from the contents of other data fields
of a record. (I know this feature from MSAccess)
For example, I would like to extract a text string from a field in each
record and display it in an extra v
Thanks for all the good tips. I have it working.
This last one from Robert works, too. I had tried it before but for
some reason only one record was imported that time. Anyway, good this
time, although patience was needed to import more than 7000 records
(felt like a minute, maybe only half).
Ch
Dear formum,
I believe my objective should be rather simple, but I need to be
pointed in the right direction.
I have a column of text data (unique values) in Calc that I want to
transfer to a Base table. The Base table has been set up with three
columns, two of which I expect to remain empty afte
I, as mere LO user, would like to understand the significance, actual
or surmised, of the closure of the LO Online repository. Does this
potentially signal the end of LO?
Cheers
Harvey
On Sun, 2022-07-10 at 19:42 -0300, Daniel A. Rodriguez wrote:
> I've sent a message to the BoD Discuss mailing
. Thanks.
Cheers
Harvey
On Sun, 2022-06-26 at 06:40 +0100, Brian Barker wrote:
> At 21:41 25/06/2022 +0200, Harvey Nimmo wrote:
> > I wanted to count the number of non-blank items in a list of items
> > using COUNTA. Cell A1 has the formula =COUNTA(A$2:A$1,
> > ISBLANK=
I wanted to count the number of non-blank items in a list of items
using COUNTA.
Cell A1 has the formula =COUNTA(A$2:A$1, ISBLANK=0) above an
otherwise empty column. It returns the value 1!
Is that supposed to mean something? Has anyone notice this?
It's obviously not a big problem, becau
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?
Cheers
Harvey
On Fri, 2022-05-20 at 18:04 +0200, Harvey Nimmo wrote:
> Thanks for the quick reply. Would this bug be picked up automatically
> by the OpenSUSE integrators?
>
> Rega
Thanks for the quick reply. Would this bug be picked up automatically
by the OpenSUSE integrators?
Regards
Harvey
On Fri, 2022-05-20 at 17:30 +0200, Robert Großkopf wrote:
> Hi Harvey,
> > I am using LO on OpenSUSE Linux Leap 15.3
> > Version: 7.2.5.1 / LibreOffice Community
> > Build ID: 20(Buil
I am using LO Base client to a backend MySQL database (on my local
network). I created a set of reports with Base that worked in the past.
For some reason now when opening a report an error message crops up and
the report cannot be generated.
"[jni_uno bridge error] UNO calling Java methode execut
Just guessing, Thomas, but I suspect the first questions the experts
will ask you next is: What LO version are you using on what operating
system.
you will find it under Help > AboutLibreOffice and click Version
Information and paste that to a mail. That way you might pre-empt the
experts' question
Hallo Robert,
this seems to work, but somewhat counter-intuitively, in the sense that
the selected objects appear to become grouped, prior to aligning them.
In other words, It becomes impossible to identify which objects have
been selected for alignment.
But thanks for the tip. It kinda helps to m
Yes, I did. Crtl-Shift groups the chosen elements
On Wed, 2022-02-23 at 08:42 -0500, Dan Lewis wrote:
> Have you tried Crtl+Shift to select separate elements?
>
> Dan
>
> On 2/23/22 6:52 AM, Harvey Nimmo wrote:
> > While trying to edit form elements for LO Base I am expect
While trying to edit form elements for LO Base I am expecting to be
able to select individual form elements, e.g. to align them, and size
them together. However, using the Ctrl button to select more than one
form element (e.g. text boxes) causes a second box, say, to be selected
and a previous box
I'm not quite sure how I understand this answer to sleepy's question.
Is it "No, macros are off by default" or "Yes...but..."?
"Excel VBA not likely to run..": I assume it is not designed to run
Excel VBA?
Cheers
Harvey
On Wed, 2021-10-06 at 09:05 -0400, Alan B wrote:
> Default in LO 7.1.5.2
>
>
lf Dunkel wrote:
> > A two-column TABLE seems to be a very smart solution for this.
> > Thank you, Harvey.
> >
> > - - - - -
> >
> > Am 15.04.21 um 12:09 schrieb Harvey Nimmo:
> > > Hi,
> > > I sometimes have to translate documents. So that I
Hi,
I sometimes have to translate documents. So that I can see the
relationship of the texts I put one language on the right and the other
left on the page. For that I use a two-column table which works quite
well. Not sure if that is the most elegant solution for what you want.
Of course you can f
blank pages.
Many thanks, again
Harvey
On Tue, 2020-12-15 at 09:42 -0800, Richard England wrote:
> Is there a page break inserted at the end of the template page?
>
> ~~R
>
>
> On 12/15/20 8:53 AM, Harvey Nimmo wrote:
> > and finally
> > It is not as bad
-15 at 17:39 +0100, Harvey Nimmo wrote:
> Sorry, I forgot to provide the LO version I am using:
> LO Version: 6.4.5.2Build ID: 40(Build:2)CPU threads: 2; OS: Linux
> 5.3; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); UI-
> Language: en-GBCalc: threaded
> And additionall
in the statistics at the foot of the window, but fails to show
the blank pages, i.e. only 7 pages are shown.
CheersHarvey
On Tue, 2020-12-15 at 17:30 +0100, Harvey Nimmo wrote:
> What could be going wrong here? Can anyone help?
> I am trying to print a set of address labels (3x5 per page) us
What could be going wrong here? Can anyone help?
I am trying to print a set of address labels (3x5 per page) using LO
Base connected to a remote MariaDB. The report facilities correctly
show the data I want to be printed.
The label procedure apparently produces the label report corresponding
to
eaders.
I was expecting some simple implementation but, to my surprise, did not
find such. In the meantime Remy has made a suggestion that show how
much more complex it could be, than expected.
Greetings
Harvey
On Sat, 2020-05-30 at 22:49 +0200, Regina Henschel wrote:
> Harvey Nimmo schr
k on a style and then New...)
> I hope this helps.
> Rémy.
>
>
> Le samedi 30 mai 2020 à 18:54 +0200, Harvey Nimmo a écrit :
> > My intention was to use the header function to describe each page
> > of a29 page document separately, with a couple of exceptions where
>
My intention was to use the header function to describe each page of a
29 page document separately, with a couple of exceptions where two
pages may have the same header.
I thought that it would just be a simple question of telling the header
of each page to copy (or not) the header of the previous
On Thu, 2019-12-12 at 20:28 +0100, Robert Großkopf wrote:
> 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 kno
On Thu, 2019-12-12 at 19:46 +0100, Robert Großkopf wrote:
> Hi Harvey,
>
> try this:
> Write into Data > Data field
>
> IF([NameOfBoolField];"y";"n")
>
> Regards
>
> Robert
> --
> Homepage: https://www.familiegrosskopf.de/robert
Hi Robert,
I was just about to answer that I had tried that and
I wonder if anyone knows how to solve this little problem?
I am trying to construct a report from a Table/Query in Base. Amongst
other data there are five boolean flags (Type Yes/No[BIT] to be printed
from each record.
Thinking that it would take up too much space on the paper together
with the l
On Sun, 2019-08-25 at 15:34 +0200, Robert Großkopf wrote:
> 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
On Sun, 2019-08-25 at 14:32 +0200, Harvey Nimmo wrote:
> On Sun, 2019-08-25 at 08:21 +0200, Robert Großkopf wrote:
> > Hi Harvey,
> >
> > > Does anyone know why the function WEEK returns a zero for
> > > Tuesday,
> > > Jan
> > > 1st, 2019? i.e.
On Sun, 2019-08-25 at 08:21 +0200, Robert Großkopf wrote:
> 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(
Does anyone know why the function WEEK returns a zero for Tuesday, Jan
1st, 2019? i.e. WEEK('19-01-01')
According to my calendar it should be week 1 and, in Calc, the WEEKNUM
and ISOWEEKNUM both return 1. (WEEKNUM starts the week on Sunday,
ISOWEEKNUM on Monday, but otherwise no difference)
Cheer
On Tue, 2019-07-23 at 21:02 +0200, Robert Großkopf wrote:
> 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
> > sugge
On Tue, 2019-07-23 at 19:03 +0200, Alexander Thurgood wrote:
> Le 23/07/2019 à 18:37, Harvey Nimmo a écrit :
>
> Hi Harvey,
>
> > A bit disappointing though. Is there no possibility for storing
> > those
> > kinds of SQL statements, so that they could be used again?
On Tue, 2019-07-23 at 18:08 +0200, Robert Großkopf wrote:
> 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 synt
On Tue, 2019-07-23 at 16:53 +0200, Robert Großkopf wrote:
> 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.
On Tue, 2019-07-23 at 16:21 +0200, Robert Großkopf wrote:
> 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` = TR
1 - 100 of 187 matches
Mail list logo