I have just done my labels too - only using Avery 8165 (I just happened to
have some in the drawer) It worked find, but I too found the printing
started right on the edge - and I couldn't see any way to change this other
than adding spaces manually. I had to add a blank line at the top for the
Try Tools Customise Keyboard from within Writer. Watch for the radio
buttons top right that change the scope between just Writer and all of LO.
John
On 14 January 2013 08:37, Jaap Bosman j...@xs4all.nl wrote:
I need to change keys because function keys do not work on my keyboard.
Want ctrl
This was a thread from 5th November which I answered to the group. He
thanked me but got fooled by the stupid group reply settings.
On 11 November 2012 16:24, Dan Lewis elderdanle...@gmail.com wrote:
On 11/11/2012 11:03 AM, dave_ wrote:
Thanks for the solution.
--
View this message in
3.0.0-13-generic (i686)
LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302)
---
--
*From:* John Clegg john.cl...@nailsea.net
*To:* Dan Lewis elderdanle...@gmail.com
The way I extracted my data was to right-click on each table and copy, and
then open a new spreadsheet and paste. Once in the spreadsheet you can then
save as CSV for easy importing into MYSQL.
On 6 November 2012 10:10, Ian Whitfield whitfi...@telkomsa.net wrote:
On 11/06/2012 11:34 AM, Pertti
Nice easy one that! You were nearly there:
=Number of errors are(SUM(A1:A3) .)
On 5 November 2012 06:06, dave_ dave.wagne...@gmail.com wrote:
Is it possble to do the following:
Lets say a1 =5, a2=3 and a3=7, now in cell c1 I would like a message to say
Number of errors are +
wrote:
Perhaps a Windows environment issue? See this thread (and similar) at
StackOverflow on the SE:
http://stackoverflow.com/questions/2259718/mysql-environment-variable-on-windows
Stuart
From: John Clegg [mailto:john.cl...@nailsea.net]
Sent: Fri 10
PM, John Clegg wrote:
Hi John,
Update - I have now tried connecting with ODBC (MySQL 3.5.1, Win7) rather
than JDBC. The table now becomes editable, but when I make a change I
can't
save because I get a message that nothing has changed!
Shot in the dark - the ODB file isn't on a SMB/CIFS
I am a small organisation using 3.6.2 and I find it pretty well bug free in
the bits we use!
On 19 October 2012 10:17, Mirosław Zalewski mini...@poczta.onet.pl wrote:
On 19/10/2012 at 10:30, Tom Davies tomdavie...@yahoo.co.uk wrote:
Luckily you can't really go wrong now that the
3.6.3 is
October 2012 13:16, Alexander Thurgood alex.thurg...@gmail.comwrote:
Hi John,
Le 19/10/12 11:09, John Clegg a écrit :
The problem with the ODBC version is that Base can't download the
table structure from the server for some reason. The JDBC version can
but can't r/w. Which all suggests
Hm It isn't quite that simple in Windows (no command line mysql client)
but I tried HeidiSQL and I can connect and amend data with no problems
On 19 October 2012 13:44, Alexander Thurgood alex.thurg...@gmail.comwrote:
Hi John,
Le 19/10/12 14:25, John Clegg a écrit :
OK, thanks
line ready to
go.
John
On Fri, Oct 19, 2012 at 9:23 AM, John Clegg john.cl...@nailsea.netwrote:
Hm It isn't quite that simple in Windows (no command line mysql
client)
but I tried HeidiSQL and I can connect and amend data with no problems
On 19 October 2012 13:44, Alexander Thurgood
OK, a supplementary if I may!
I am accessing the remote MySQL database using com.mysql.jdbc.Driver.
When I access the data by opening the table or using the form it is
read-only. Any ideas again?
John
On 17 October 2012 20:25, John Clegg john.cl...@nailsea.net wrote:
I have a base file
That's pretty comprehensive, thanks! I will work through those.
Regards
john
On 18 October 2012 08:22, Alex Thurgood alex.thurg...@gmail.com wrote:
On 10/18/2012 08:02 AM, John Clegg wrote:
Hi John,
I am accessing the remote MySQL database using com.mysql.jdbc.Driver.
When I access
Thanks. This is a fairly new connection, so I can't be sure it has ever had
read/write. I know it's read-only because if I open the table and click
Edit everything is greyed out except Copy. And if I access data via the
form I can't change anything.
I can access the data via phpMyAdmin and make
It's a single field, integer and unique. And having been out and in again
base can see the index now, but I still can't edit.
On 18 October 2012 13:47, Alexander Thurgood alex.thurg...@gmail.comwrote:
Le 18/10/12 11:46, John Clegg a écrit :
Hi John,
I can access the data via phpMyAdmin
No, same user!
On 18 October 2012 14:18, Alexander Thurgood alex.thurg...@gmail.comwrote:
Le 18/10/12 15:10, John Clegg a écrit :
It's a single field, integer and unique. And having been out and in
again base can see the index now, but I still can't edit.
Dumb question perhaps
The structure is very simple - one integer field, indexed unique and 33
fields text(varchar) of varying lengths all unindexed.
On 18 October 2012 14:22, Alexander Thurgood alex.thurg...@gmail.comwrote:
Le 18/10/12 15:10, John Clegg a écrit :
It's a single field, integer and unique
Update - I have now tried connecting with ODBC (MySQL 3.5.1, Win7) rather
than JDBC. The table now becomes editable, but when I make a change I can't
save because I get a message that nothing has changed!
Am I jinxed??
On 18 October 2012 14:28, John Clegg john.cl...@nailsea.net wrote
I have a base file attached to a MySQL database on a remote server. I have
a form that I use to view and edit the data in one table.
Others also access the database, and I need to experiment with the data in
that table without molesting the master copy.
One solution would be to make a complete
That's exactly what I wanted and couldn't find anywhere! I'm very grateful
John
On 17 October 2012 21:14, Girvin R. Herr girvin.h...@sbcglobal.net wrote:
John Clegg wrote:
I have a base file attached to a MySQL database on a remote server. I have
a form that I use to view and edit
Indeed. Which is why your last answer is also wrong!
On 15 October 2012 15:08, Andreas Säger ville...@t-online.de wrote:
Am 15.10.2012 10:45, Brian Barker wrote:
At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote:
On 14.10.2012 12:20, Gilles SICHE wrote:
could anyone tell me which formula I
+1 to that. And I believe he may be referring to a watermark - but I have
no idea how to do it!
On 10 October 2012 09:08, Tom Davies tomdavie...@yahoo.co.uk wrote:
Hi :)
I often grumble so this time i wanted to draw attention to some excellent
behaviour on the users list. Most times, in most
, Andreas Säger ville...@t-online.de wrote:
Am 09.10.2012 09:14, Marcello Romani wrote:
Il 08/10/2012 14:13, John Clegg ha scritto:
OK, if I accept everything that has been said, then why wouldn't
opening an
in-memory r/w copy be the sensible default action?
So that when the user would try
scritto:
On 10/05/2012 10:10 AM, Marcello Romani wrote:
Il 05/10/2012 11:07, John Clegg ha scritto:
One feature I miss isn't actually a feature in MSO as such, but LO
behaves
differently. If I open a spreadsheet from an email or the web it
places a
copy in the download folder/directory
Whilst a condom is always wise I still prefer to put it on for
myself
On 6 October 2012 18:13, Jay Lozier jsloz...@gmail.com wrote:
On 10/06/2012 11:37 AM, Spencer Graves wrote:
On 10/6/2012 6:13 AM, Andreas Säger wrote:
Am 05.10.2012 14:09, John Clegg wrote:
I thought LO
One feature I miss isn't actually a feature in MSO as such, but LO behaves
differently. If I open a spreadsheet from an email or the web it places a
copy in the download folder/directory and Calc always opens it read-only
whereas Excel opens it as read-write. I would like at least an option to
get
I thought LO was emulating MSO 97??
On 5 October 2012 13:00, Gordon Burgess-Parker gbpli...@gmail.com wrote:
On 05/10/12 10:07, John Clegg wrote:
whereas Excel opens it as read-write.
That behaviour has changed in MS Office 2010 - email attachments are
opened as read-only by default
I am going to stick my head above the parapet and say it should have an
embedded database functionality that is secure and reliable. That is an
essential requirement for entry-level users that have only ever used Access.
On 5 October 2012 13:34, Pertti Rönnberg p...@elisanet.fi wrote:
Hi
That button, according to the help file, toggles whether the SQL is passed
directly to the database engine or handled by Base first. I'm not quite
sure what that means in effect!
On 5 October 2012 18:12, David S. Crampton david_cramp...@ie2b.com wrote:
John and the others who responded,
It
I did exactly what it says - ie downloaded it, then ran LO and did File
Open and selected the downloaded file. It opened in Draw and was all there
and legible. LO 3.6.1 on Win7
On 4 October 2012 15:02, Gordon Burgess-Parker gbpli...@gmail.com wrote:
I downloaded the hybrid pdf from here
I have just discovered that applying the PROPER function to st george's in
Calc gives St George'S
Now would that be considered to be a bug, or just a rather annoying
feature??
LO3.6.1 on Windows 7 and 3.5.4.2 on Ubuntu 12.04
--
For unsubscribe instructions e-mail to:
.
Regards,
Joel
On Wed, Oct 3, 2012 at 8:16 AM, John Clegg john.cl...@nailsea.net wrote:
I have just discovered that applying the PROPER function to st george's in
Calc gives St George'S
Now would that be considered to be a bug, or just a rather annoying
feature??
LO3.6.1 on Windows 7
Base will only run SELECT statements that way. If you want to use other
than SELECT the only way IIRC is to use Tools-SQL which opens Execute SQL
statement but can only handle typed stuff, not stored queries. It is
useful for one-off tasks such as merging two tables into one or doing a
field
But it's so easy!
In Google Docs open the spreadsheet and select File, Download as, ODS.
That's it!
John
On 27 September 2012 20:57, Tom Davies tomdavie...@yahoo.co.uk wrote:
Hi :)
Ok, this is probably not what you are looking for but just to clear the
idea out of the way ... Can you just
Andreas - why are you always so grumpy?? Chill !
On 24 September 2012 08:16, Andreas Säger ville...@t-online.de wrote:
Instead of running tests, how about debugging your program and reading
some
documentation?
--
View this message in context:
American Spelling Dictionary for LO.
On 09/19/2012 01:11 PM, John Clegg wrote:
Which is why I started migrating 3 months ago! I haven't had to go back
once.
On Sep 19, 2012 4:57 PM, webmaster-Kracked_P_P
webmas...@krackedpress.com
mailto:webmaster@**krackedpress.comwebmas
How about:
T2 = 4 * (F2 AND (L2=3))
On 21 September 2012 06:34, Paul Anderson panders...@gmail.com wrote:
Thanks to all for the previous help,
Also, sorry if you have addressed this already, Brian. But, I know only
basic functions within the spreadsheet and will request a more explanatory
There is a great little programme in Windows called Affixa. Just need
something similar for Linux really...
On 17 September 2012 17:07, anne-ology lagin...@gmail.com wrote:
yes, I agree - that is a great idea.
The only way, I know, is to allow LO to open whatever, then save
Thank you, that's very useful. However it has confirmed to me that I
shouldn't use MySQL in this instance! All that packing and unpacking looks
rather like your description of Embedded HSQL.
I have made some progress with SQLite3, and I think this is the answer for
me.
On 15 September 2012
I am using LO 3.5.6 on Windows 7 and also recently on Ubuntu 12.04
I have been eagerly migrating all my usage from Microsoft Office to LO, and
I would appreciate some advice on converting from Access.
I have one project which consists of a fairly modest flat file (896 records
of 33 fields), but
of the
cognoscenti suggest avoiding java, so I shall!
On 14 September 2012 16:27, Andreas Säger ville...@t-online.de wrote:
Am 14.09.2012 16:41, John Clegg wrote:
where I wouldn't be able to get at it without Internet access? (Dropbox of
course keeps local copies which it synchronises). Or is this one use
Could you just not exclude this directory from the backup?
On 13 September 2012 15:29, Enda enda...@yahoo.com wrote:
When I backup all the files, I like to see which files are being backed
up, if the folder has changed (by having a file created and deleted) I see
this folder I when I backup.
43 matches
Mail list logo