Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

[John Clegg]

Could you just not exclude this directory from the backup?

On 13 September 2012 15:29, Enda  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. I would rather not see folders that have not
> really changed.
>
>
> (I am not trying to open the file more than once.)
>
>
> - Enda
>
>
> - Original Message -
> From: Dan Lewis 
> To: users@global.libreoffice.org
> Cc:
> Sent: Thursday, September 13, 2012 3:11 PM
> Subject: Re: [libreoffice-users] Re: not create a dot file in same folder
> as document when opening it for viewing
>
> What does it prevent you from doing? Are you trying to open this file
> more than once? You see, I'm confused why you need to override this
> function of LO. Since the dot files are hidden anyway, I don't see what
> difference the existence of these files make. The answer to my questions
> might enlighten me.
>
> --Dan
>
> On 09/13/2012 10:00 AM, Enda wrote:
> > I am the only user on the system. When I view a file, a dot file (like
> .~lock.file.doc#) is created. How can I override (stop) this in LibreOffice?
> >
> >
> > - Enda
> >
> >
> >
> > - Original Message -
> > From: Jay Lozier 
> > To: users@global.libreoffice.org
> > Cc:
> > Sent: Wednesday, September 12, 2012 3:33 PM
> > Subject: Re: [libreoffice-users] Re: not create a dot file in same
> folder as document when opening it for viewing
> >
> > On 09/12/2012 09:23 AM, Enda wrote:
> >> OS: Ubuntu
> >>
> >> Calligra does not create a dot file when viewing files, is there an
> option to turn this off in LibreOffice?
> >>
> >>
> >> - Enda
> > Do you want multiple users to be able to edit the file at the same time?
> > I think this is causing confusion on the list.
> >
> > Often a program will create a lock file to prevent other users from
> > modifying a file while someone is editing the file. This is a fairly
> > common procedure and in some programs can be over ridden.
> >
> > A "dot" file can also refer to the MSO XP Word template with *.dot
> > extension.
> >>
> >>
> >> - Original Message -
> >> From: Andreas Säger 
> >> To: users@global.libreoffice.org
> >> Cc:
> >> Sent: Tuesday, September 11, 2012 8:41 PM
> >> Subject: [libreoffice-users] Re: not create a dot file in same folder
> as document when opening it for viewing
>  Am 11.09.2012 18:01, Enda Noname wrote:
> > Can Libreoffice not create a dot file in same folder as document when
> > opening it for viewing?
> > .~lock.file.doc#
> >> Is it really that difficult to tell us exactly about the situation? We
> >> don't even know the operating system.
> >> Is it really that difficult to copy some documents into a test
> >> directory, display hidden files and open them read-only?
> >>
> >> 4 tests on Linux:
> >> 1) libreoffice -view blah.odt [no lock file]
> >> 2) chmod -w blah.odt
> >> libreoffice blah.odt [no lock file]
> >> 3) menu:File>Open... [X] Read Only [no lock file]
> >> 4) menu:Save As... [X]Password blah2.odt with a read-only password
> >> close, re-open blah2.odt [creates a lock file]
> >>
> >>
> >
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Where to store a simple database?

[John Clegg]

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 I have a number of well established queries that I use
with it and once a year I link the data to an imported direct debit
accounts table and export a CSV file which I convert to XML (using a python
script) for sending to the direct debit company. So SQL access to the data
is vital. The data is stored in Dropbox so it can be accessed from Windows
or Ubuntu easily - but never simultaneously. I do have access to a MySQL
server as part of my web hosting but I would rather not bother with setting
one up locally for just this application.

My original approach was to just use embedded HSQL, but I have got the
message that this is a BAD IDEA, although it does work well with storing
the data in Dropbox.

I tried storing the data as an ods file (in Dropbox) and attaching my Base
file to that, but the SQL functionality is too restricted.

So, where should I store the data? Can I use SQLite to store the data in
Dropbox? Or should I bite the bullet and store it in the SQL server
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 use
where embedded HSQL really is the right answer??

All views appreciated!

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Where to store a simple database?

[John Clegg]

Whilst your answer is no doubt rigorous it lacks a little in the
helpfulness class!

You have explained many times before that base is not a database and
embedded hsql is evil. You haven't really explained why in either case, but
then I am much the same in declaiming Apple as the evil empire.

You focussed on "cloud" as if I had my head in it, I don't. Let me state it
again in less inflammatory ways - I want the database held in a single file
with no need for an engine - hence SQLite seemed ideal. So that is the way
I am pursuing but I am hitting snags (like ODBCConfig resolutely refusing
to install) so I was rather hoping somebody might come up with an
alternative or some help.

In the meantime, unless somebody can really convince me that embedded HSQL
is a disastrous approach I shall have to stick with that.

Incidentally stand alone HSQL seems to rely on java, and most of the
cognoscenti suggest avoiding java, so I shall!


On 14 September 2012 16:27, Andreas Säger  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 use
>> where embedded HSQL really is the right answer??
>>
>> All views appreciated!
>>
>>
> Of course you can not access cloud content without internet access. This
> office suite is a most conservative *desktop* application and Base is NOT a
> database program. Just like MS Access it lets you connect to various types
> of databases so you can access your data in this office suite. The whole
> thing does not know anything about a so called "cloud".
> No, the *embedded* HSQLDB is not an option. It is even much worse than the
> JET database embedded in MS Access.
> A stand-alone HSQLDB server may be a very good database solution if it
> fits your needs. You can run the same tiny Java program on all platforms as
> server, as client and in cached mode. But again, all this has nothing to do
> with any cloud computing. It just works with client-server connections or
> with plain single-user file access. If you are able to backup your files,
> the medium should not matter.
> If you need to access the same database from various places, it is about
> nothing but database servers.
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Where to store a simple database?

[John Clegg]

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 11:31, Andreas Säger  wrote:

> Someone found his way to share a database on Dropbox:
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=41238
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=54988
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=44131
>
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Where-to-store-a-simple-database-tp4007504p4007661.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Can't send document as e-mail attachment to Opera Mail

[John Clegg]

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  wrote:

>yes, I agree - that is a great idea.
>
>The only way, I know, is to allow LO to open whatever, then save the
> attachment, then add this attachment to the correct e-mail.
>
>
>
> On Sun, Sep 16, 2012 at 6:15 AM, M Henri Day  wrote:
>
> 2012/9/16 Anthony Easthope 
> >
> > > Thats a tricky one. I don't exactly have a solution to the opera
> problem
> > > but it might be best to associate the email client (Thunderbird maybe?)
> > > as the default. From the best of my knowledge the opera browser can not
> > > become associated with the *.eml format which Thunderbird & Evolution
> > > use? -- As an aside what is the reason your using the M2 Client? from
> my
> > > own experience it has loads of issues and is not as half as good as
> > > thunderbird or evolution for that matter
> > >
> > > I almost feel like I am talking through a hole in my head.
> > > On Sun, 16 Sep 2012, at 12:10 AM, wpost wrote:
> > > > I use LibreOffice 3.4.5, and Opera 12.02 as a mail client, running
> > Linux
> > > > Mint
> > > > Debian Edition 201204. LibreOffice has a "send document as email"
> > > > command.
> > > > Searching the web, I see it works fine with some other mail clients
> > > > (Thunderbird, etc.) on Linux. But when I try it, I get the error
> > message:
> > > >
> > > > "LibreOffice was unable to find a working e-mail configuration.
> Please
> > > > save
> > > > this document locally instead and attach it from within your e-mail
> > > > client."
> > > >
> > > > The relevant configuration appears to be found at Tools - Options -
> > > > Internet
> > > > - Email. I've tried "opera", "/usr/bin/opera", and  "/usr/bin/opera
> > > > --remote
> > > > 'openComposer(new-window)'" (all without the double quotes). All of
> the
> > > > above work from the terminal, and the latter (taken from Opera's
> > > > documentation) opens a new message composition window, but none make
> > > > LibreOffice's error go away.
> > > >
> > > > Searching the web, this list, and LibreOffice's Get Help references
> > turns
> > > > up
> > > > nothing relevant.
> > > >
> > > > I'm out of ideas. Does anyone know how to make LibreOffice and Opera
> > Mail
> > > > play together?
> > >
> >
> > A feature I should greatly like to see in LibreOffice is one allowing a
> > user to choose a webmail service, e g, Gmail, as the default, rather than
> > an email client like Thunderbird or Evolution. This is easily done on,
> say,
> > Ubuntu, by installing the Gnome Gmail package ; it would be wonderful if
> > one of the LibreOffice developers could modify this package or create a
> > different one which would resolve this problem for LibreOffice users
> >
> > Henri
> >
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

[John Clegg]

I think this is a very fair point. Versions of Ubuntu have an LTS version
without stopping the development chain progress. It would be really useful
to have a really mature and settled LTS version of LO that businesses could
use with confidence.

On 20 September 2012 12:06, Pertti Rönnberg  wrote:

> Dear mr Webmaster,
> I agree with you about the risks with Microsoft's possible actions in the
> future -- let us hope we are wrong.
>
> I am afraid you got me wrong -- my fault.
> What I meant by the "break" in developing LibO, was that the LibO's
> developers for a while should stop proceeding.
> They must take one specific version of LibO (especially for Windows as the
> main OS) and make it absolutely free of bugs and failures -- and plus that
> make the documentations complete and understandable (and thus usable) for
> ordinary non-expert computer users.
> And then - after that - continue again.
>
> Why? Because I have been a Windows user since early -80 and installed
> OpenO decades ago.
> Last January this year I downloaded LibO (3.4.5) with the main intention
> to use Base -- but experienced that much problems - first with the
> installing & JRE and then with many basic functions and especially with the
> embedded HDBSQL and especially with the quite horrible unlogical
> documentations -- that I have given up. I am quite sure that I am not alone!
>
> Since January I have followed the discussions on this list and am getting
> even more convinced that LibO is not really meant for ordinary people as an
> alternative to MSO. It seems mainly to be a playground for a group of
> open-source enthusiasts with a language of their own.
>
> Whom are the new features and finesses meant for, when there is no general
> info about them and no guiding documentation until 3-4 version generations
> later? Meanwhile they have only caused problems.
>
> When I download a what-ever program for my needs, I want it to work and to
> work stable and smoothly.
> I have no need nor time to struggle with different problems, to
> investigate and test different workarounds -- nor asking for help and
> waiting perhaps days for an answer that might help if I only happen to
> understand the advice.
>
> Frustration can easily be limited by paying to Microsoft.
> Best regards
> Pertti Rönnberg
>
>
> On 19.9.2012 21:48, webmaster-Kracked_P_P wrote:
>
>>
>> I have not bought any MSO past MSO-2003.  I moved to OpenOffice.org [as
>> soon as it read/saved .doc files] till LO 3.3.0 came out.  Then I moved to
>> LO for all my systems, Windows and Linux.
>>
>> Now I create/update the NA-DVD [http://libreoffice-na.us/**
>> English-3.5-installs/index.**html<http://libreoffice-na.us/English-3.5-installs/index.html>]
>> project and a 773,000 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.com>>
>>> wrote:
>>>
>>>
>>> No, it is not a good idea to take a break.
>>>
>>> But it is time to tell those people who do use MSO that they are
>>> changing their pricing policy and almost forcing their users to
>>> rent their products in the near future.
>>>
>>> It is time that the users start thinking about their long term use
>>> of MS's Office and other business software.  You no longer will be
>>> able to buy their products in any reasonable price, for MS that
>>> is, and not know if you rent it for X dollars for the first year,
>>> it will not go up to 150% of X dollars in year two.  You will then
>>> have to pay their "ransom" or you loose the ability to use the
>>> software on your computer.
>>>
>>> Then there is the multi-license discount - or should it be the end
>>> of the multi-license discount.  Businesses with 50 or 100
>>> computers will be required to but a single user license for every
>>> computer at $150+ per license.  The rental agreement plan is not
>>> that much better of an option.
>>>
>>> So now you can say that every computer they own can have a copy of
>>> LO for free.  Every updated or new version of LO will be free,
>>> unlike MSO's policy.  No need to rent or buy anything office suite
>>> package anymore.  FREE now and FRE

Re: [libreoffice-users] Help with Scoring Bi-nominal Responses

[John Clegg]

How about:

T2 = 4 * (F2 AND (L2=3))

On 21 September 2012 06:34, Paul Anderson  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
> example.
> The file was delivered in xlsx format. I would like to maintain the format
> (using LibreOffice!), but I may have to look to other software.
>
> Here is an example of my first two rows of data, cells F2&3 through S2&3,
> with F1-S1 containing variable names
>
> *F* *G* *H* *I* *J* *K* *L* *M* *N*
> *O* *P* *Q* *R* *S*
> 0   1   0   1   0   0   1   0   0   0
>   0   0   0   0
> 1   0   1   1   0   0   1   0   0   0
>   1   0   0   0
>
>
> Using a simple example with only two cells (F2&L2), I want T2 to equal a
> 'score' based on a weighted index, like this:
>
> IF F2=0 then T2=0; else T2=T2+1;
> (Where F2 can only take on a value of 0 or 1)
> AND
> IF L2=0 OR L2=1 OR L2=2 then T2=T2+0; else T2=T2+3
> (Where L2 can take on a value of 0,1,2,or 3)
>
> So that:
>
> T2 = 0 (if F2=0 and L2=0,1,or 2)
> OR
> T2 = 4 (if F2=1 and L2=3)
>
> I haven't been able to create the proper syntax for this simple two cell
> scoring.
> How can I not only score an individual cell but also link it with another
> cell in the same row?
> A simple demonstration will be adequate so that I can create my specific
> and more complicated function.
>
> I hope I have stated my needs in a clearer fashion this time around, and
> thanks to everyone for the previous help.
>
> Regards,
> -Paul
>
> On 9/19/2012 11:58 AM, Jean-Francois Nifenecker wrote:
>
>> Le 19/09/2012 07:03, Paul Anderson a écrit :
>>
>>> Hello all,
>>>
>>> I have a simple question for which I cannot find the answer.
>>>
>>> I have a LibreCalc spreadsheet containing binomial data for which I
>>> would like to create a final summed "score" (in Column T) based upon a
>>> manually specified score index.
>>>
>>> Columns F, G, H, J, K, M, N, O, P, O, and R contain pure binomial
>>> information (0 or 1)
>>> Columns I, L, and S contain multiple numbered responses:
>>> I = 0,1,3
>>> L = 0,1,2,3
>>> S = 0,1,2
>>>
>>> I want to create a final score (Column T) based upon numerical responses
>>> (in Columns F-S)
>>>
>>>
>> All this makes me think of binary data, hence to have columns F..R
>> (except I, L & S) set to hold either 0 or a power of 2.
>> F would hold 0 or 1
>> G0 or 2
>> H0 or 4
>> J0 or 8
>> and so forth.
>>
>> Then, adding any group of columns would then give a unique meaningful
>> value:
>> -- if you add F+G+H and get 3, you know that only F and G are set
>> -- if you AND F+G+H with, say, 2, you may check if G (value 2) is set :
>> if G AND 2 = 2 then G is set (in Calc use the BITAND function)
>>
>> As I don't know exactly what you're looking to achieve, perhaps my idea
>> is useless.
>>
>> Anyway, just my two euro-cents,
>>
>
>
>
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette 
> List archive: 
> http://listarchives.**libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: python reading calc

[John Clegg]

Andreas - why are you always so grumpy?? Chill !

On 24 September 2012 08:16, Andreas Säger  wrote:

> Instead of running "tests", how about debugging your program and reading
> some
> documentation?
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/python-reading-calc-tp4008804p4008939.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Can Calc read/import data from Google Docs?

[John Clegg]

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  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 open the google-docs spreadsheet and
> save it onto your computer?  Then just double-clicking on it should open it
> in Calc.
>
> Google-docs uses the same native format as LO but both can save as .xls or
> .xlsX (MS formats) and Google-docs might do that by default.  If
> Google-docs does that instead of saving in native .odS then you can
> probably choose "OpenDocument Format" from Google-doc's "Save As ... "
> menu.  Double-clicking on the .ods almost definitely opens the file in Calc.
>
> Alternatively if it has saved as .xls or .xlsX then right-click the file
> and choose "Open With" and then try to find Calc or LibreOffice in that
> menu.  This approach is slightly different in different OSes but is roughly
> the same in all except Apples.
>
> A similar alternative is to open Calc (or just LibreOffice) and then
> drag&drop the file onto it.  This approach will definitely work whatever
> format it's in unless something really weird is going on in which case
> tells us and we might be able to figure it out.
>
>
> However i have a feeling that you don't want to download the file at all
> and just want LO to dynamically read the Google-docs spreadsheet while
> other people are editing the google-docs spreadsheet.  If so then i think
> there is a far better answer but it involves using Base at your end and
> having a proper database on a server somewhere.
>
> So, the question is do you want to do this with static data (as in my
> first 4 paragraphs), or dynamically changing data?
> Regards from
> Tom :)
>
>
>
>
>
>
> >
> > From: Michael Reich 
> >To: users@global.libreoffice.org
> >Sent: Thursday, 27 September 2012, 18:24
> >Subject: [libreoffice-users] Can Calc read/import data from Google Docs?
> >
> >I'm trying to figure out if I can have a Calc (OpenOffice or LibreOffice)
> spreadsheet "import" data from a Google Docs spreadsheet. The online
> assistance via google search is very confusing and seems mostly oriented
> toward importing data to Google Docs.  What I want is a local sheet that
> can pull several cells of info (like names and addresses) from a Google
> Docs spreadsheet, but I can't figure out what function and syntax, if any,
> can do this in OO or LO.  Is this possible to do?  If so, I apparently need
> the "idiot's instructions."
> >
> >
> >
> >-- For unsubscribe instructions e-mail to:
> users+h...@global.libreoffice.org
> >Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> >List archive: http://listarchives.libreoffice.org/global/users/
> >All messages sent to this list will be publicly archived and cannot be
> deleted
> >
> >
> >
> >
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] PROPER function in Calc

[John Clegg]

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: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] PROPER function in Calc

[John Clegg]

Sorry, I should have checked. It is 53146

On 3 October 2012 16:19, Joel Madero  wrote:

> That would be a bug, and I've confirmed it. Might already be on bugzilla.
>
> bugs.freedesktop.org
>
> If it's not there, go ahead and report it, definitely a relatively easy
> thing to fix.
>
> Regards,
> Joel
>
> On Wed, Oct 3, 2012 at 8:16 AM, John Clegg  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 and 3.5.4.2 on Ubuntu 12.04
>>
>> --
>> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>> Problems?
>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be
>> deleted
>>
>>
>
>
> --
> *Joel Madero*
> LibO QA Volunteer
> jmadero@gmail.com
>
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

[John Clegg]

I have had a number of occasions recently to do
multi-person collaboration usually live during a conference call, and I
have to say that if you want to do that Google Docs is the tool of choice
and MSO doesn't come up to the mark.

On 3 October 2012 21:24, Jay Lozier  wrote:

> On 10/03/2012 02:23 PM, Doug wrote:
> > On 10/03/2012 01:20 PM, Jay Lozier wrote:
> >
> > /snip/
> >> One commenter noted that most SOHO users do not need the
> >> collaboration features in MSO (or any office suite). Also, I am not
> >> sure that many of the collaboration features are used extensively in
> >> large organizations.sides.
> > I guess I don't understand something here. Almost 20 years ago, I
> > wrote user manuals for equipment I designed, and had the software
> > engineer modify them as required for the user programming
> > requirements. (This was for burglar-alarm systems.)  there was no problem
> > using the MS software that existed then--it would mark modifications
> > with red underlines or something similar.  I'd just send the copy over
> > the network to my software person, and she would do whatever was
> > necessary, and send the copy back for me to check it and release it.
> > No special "collaboration" software, but we certainly collaborated.
> > What's the big deal?
> >
> > --doug (Retired RF Engineer)
> >
>
> Doug,
>
> MSO has some tools designed for real-time collaborative document
> production that allow distributed groups to work on the same document
> and track each person's edits, etc. I have not used these features;
> primarily because I never needed to use them. Thus I do not know how
> well they work. The implicit assumption is that all users can have
> simultaneous access to the same document version.
>
> Some the editing features such as track all changes are sometimes useful
> for a large document. What you are describing is not what MS is trying
> to push. Often what is needed for collaboration is what you are
> describing: create, edit, revise, (edit, revise), release.
>
> --
> Jay Lozier
> jsloz...@gmail.com
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Update SQL does nothing using "Run SQL directly" button

[John Clegg]

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 update as you describe.

On 4 October 2012 00:27, David S. Crampton  wrote:

> Register1a is a table with field "Trans-Date" of type TIMESTAMP. Field
> "Trans-Date-Year" is either TIMESTAMP or INTERGER. I have tried with both.
>
> Update "Register1a" Set "Register1a.Trans-Date-Year" =
> YEAR("Register1a.Trans-Date");
>
> Looks like is should be a very simple SQL statement. It does absolutely
> nothing.
>
> The statement won't run with the F5 key (the "run" button). It gives "The
> given command is not a SELECT statement".
>
> I'm trying to apply SQL learned elsewhere, mostly in MicroBloat Access, and
> I'm getting nowhere.
>
> Help will be appreciated.
>
> David
>
>
>
> -
> --
> David S. Crampton
> --
> View this message in context:
> http://nabble.documentfoundation.org/Update-SQL-does-nothing-using-Run-SQL-directly-button-tp4010902.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Opening hybrid pdf in LO 3.6.0.2 results in gibberish

[John Clegg]

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  wrote:

> I downloaded the hybrid pdf from here http://blog.**
> documentfoundation.org/2012/**07/17/libreoffice-**infographics/and
>  tried to open in LO as it said at the bottom of the page. All I get is
> a load of gibberish.
> The hybrid pdf opens OK in a PDF reader
> --
>
> Registered Linux User no 240308
> GBP's alternative 
> computing:http://gbplinuxfoss.**blogspot.com/
>  Say No to OOXMLhttp://
> www.linuxjournal.**com/article/9594#mpart8
> I only accept odf or pdf documents by email
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette 
> List archive: 
> http://listarchives.**libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

[John Clegg]

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 Calc to open it as read-write. To do so I have to save a copy
before I start, and as I do this around 100 times a day it becomes quite an
irritant.

On 5 October 2012 10:00, Mirosław Zalewski  wrote:

> On 04/10/2012 at 12:54, rost52  wrote:
>
> > I am missing (compared to MSO) a few features
> > in IMPRESS badly
>
> Could you tell which features do you mean, exactly?
> I am always interested in such comparisons. People all over the web say
> "LO is
> missing some features", but such statements tend to not be supported by
> descriptions of features in question.
> --
> Best regards
> Mirosław Zalewski
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

[John Clegg]

I thought LO was emulating MSO 97??

On 5 October 2012 13:00, Gordon Burgess-Parker  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..
> --
>
> Registered Linux User no 240308
> GBP's alternative 
> computing:http://gbplinuxfoss.**blogspot.com/<http://gbplinuxfoss.blogspot.com/>
>  Say No to OOXMLhttp://
> www.linuxjournal.**com/article/9594#mpart8<http://www.linuxjournal.com/article/9594#mpart8>
> I only accept odf or pdf documents by email
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] documentation for LO base

[John Clegg]

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  wrote:

> Hi everybody,
>
> I agree with Mark.
>
> The question itself is interesting but an answer does not explain anything
> relevant.
>
> Let us turn the question around:how many people should use LO-Base if
> there was a LibO-version available that is ready to use, reliable, and free
> of problems (bugs).
>
> If
>
>  its installing instructions should be complete, consequent, and placed
>>>
>> in one easy to find place
>
>  the program's every single detail should work  -- functions, features,
>>>
>> processes at a level (e.g.) similar to MSAccess (2003) --the ability to
> build decent reports included (and the embedded db-engine and its guides
> up-dated and supported)
>
>  the guiding documentation (& help) should be logic, understandable and
>>>
>> in every detail correlating with the program
>
> With the exception of heavy industrial systems the need and possibilities
> of up to medium complex databases in everyday life at home are unlimited --
> only limited by the decision to start creating.
>
> There are really nothing difficult in creating such "home databases"-- no
> need to be an "Einstein", if only good guidings are available. Creating
> database applications is also a very interesting form of brain training --
> and the feeling when succeeding is a "yippee". If you know how to use
> Writer/Word and Calc/Excel (esp. as "databases") you are almost half way.
> What you still has to do is to study and learn some few basic theories
> about and how to create the tables and the queries(experiment manually, not
> with wizards, if you want to learn and understand);creating the forms and
> the reports is just a matter of following instructions.
>
> If you want LibO to be a popular competitor to MSO (& MSAccess), then the
> rest is only a question of marketing.
>
>
> As far as I have experienced LibO-Base (v. 3.4.5), there are only a few
> details left to fixed before LibO should be almost perfect.
>
> About contributing
>
> A basic rule in quality systems (ISO9000) is that if you want improvement
> you must first identify the problems (faults, weaknesses) -- and then
> follow up by a plan and an improving activity.
>
> LibO might be a very fine and usable suit -- especially if also its Base
> module (docs included) should work properly, at least as promised in
> introductions.
>
> Mr Dan Lewis is doing a good and valuable work when updating and
> completing the Base's documentation and it is obvious that without any help
> his project will take a long time.
>
> Last winter I started to read and follow up experimenting Dan's docs with
> the intension to send my comments as points of views. And hadquite a lot
> already done.
>
> At this list I several times also mentioned some quite basic
> problems/faults both in Base's docs and especially in the modules's
> features.
>
> I never got any kind of response, I don' t know if my proposals were
> noticed, nor do I know if the mentioned things have been fixed.
>
> So I skipped working any further on experimenting LibO-Base and its docs.
> (I am now back to OO and tries to learn MySQL)
>
> You may take this as some sort of a contribution too.
>
> Best regards
>
> Pertti Rönnberg
>
>
>
> On 4.10.2012 18:04, Mark Stanton wrote:
>
>> Question:  How many people do you know use Base, or have tried to use
>>> Base?
>>>
>> Whilst there is some quite valid criticism of Base, I don't think
>> answering
>> this question says as much about Base as it does about the general usage
>> of databases.  They are less familiar than word processors, spreadsheets
>> or
>> drawing packages.
>>
>> Mark
>>
>>
>>
>>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette 
> List archive: 
> http://listarchives.**libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Update SQL does nothing using "Run SQL directly" button

[John Clegg]

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  wrote:

> John and the others who responded,
>
> It took me a while to realize that the useful SQL menu is available only on
> the main / opening window of the db. The SQL button in the Query Design
> view
> still appears to do nothing.
>
> I'm finally getting some traction. I acknowledge and appreciate the
> "stylistic" suggestions. This year and month data is very unlikely to
> change
> once the transaction record is accurately entered.
>
> Thank you, all,
> David
>
>
>
> -
> --
> David S. Crampton
> --
> View this message in context:
> http://nabble.documentfoundation.org/Update-SQL-does-nothing-using-Run-SQL-directly-button-tp4010902p4011374.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] MS problems

[John Clegg]

I have seen many specific instances of hardware items that will not work
together even though they are both well known branded products and there is
no indication that they shouldn't work together. Life just isn't that
predictable.

On 6 October 2012 16:36, Jay Lozier  wrote:

> On 10/06/2012 03:57 AM, Dr. R. O Stapf wrote:
> > I think the market share of MSO has nothing to do with the users being
> > idiots or not. The 90% share is caused by 3 things
> > 1 - When you buy a PC you often get the MSO already pre-installed
> > 2 - Not many people know about alternatives. I only learned about OO
> > and LO from my brother who is a IT wizard. While talking to people
> > about me utilization of LO I am always experiecing that almost  all
> > people do not know about OO or LO or other packages.
> > 3 - Many IT departments in companies choose MSO because it is easily
> > available and they consider the support as good. Keep in mind that
> > introduction of an alternative suit requires a lot of testing in an IT
> > department. The suit must be stable and keep productivity high.
> Some of the IT departments I had to work with  convinced me the average
> tech person in the department knew less about computers in general than
> I did. Not that I necessarily know that much. I can remember trying to
> solve a networking problem according to my then employer's IT staff and
> nothing worked. Eventually, they found that the hardware and software
> they had specified did work well together. My sarcastic engineering
> comment was to ask if they had bothered to read both spec sheets; I was
> working in chemical process engineering then and reading spec sheets was
> a mandatory practice for us to avoid killing innocent people.
>
> Another problem is that it is often easier in many companies to get
> approval to buy/install from a "name brand" than from someone who is not
> a "name brand". MS, Apple, Dell, HP,  and Intel are "name brands" and it
> is presumed safe to buy from them. A superior product may not get
> installed/bought because of this mindset. In the 70's and 80's the joke
> was "no one got fired for buying IBM" even if their product was the
> worst in the market segment because of the brand image of IBM.
> >
> > If my above statements are wrong, then I am happy because I converted
> > from MSO to LO, thus from an idiot to something else...
> >
> >
> > On 2012-10-06 01:12, Wolfgang Keller wrote:
> >> If MSO is a 90% market leader all its users cannot be complete idiots.
> >
> >
>
>
> --
> Jay Lozier
> jsloz...@gmail.com
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

[John Clegg]

Whilst a condom is always wise I still prefer to put it on for
myself

On 6 October 2012 18:13, Jay Lozier  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 was emulating MSO 97??
> >>>
> >> Read-only is the only sensible way to open other people's files (web
> >> downloads, mail attachments).
> >
> >
> >   Why?
> >
> >
> >   What if I want to edit it?  Are you outlawing collaborative
> > work?  I'm confused.
> >
> >
> >   Spencer
> >
> Spencer
>
> Usually "Save As" 'will allow you to create an editable version.
>
> The issue is security and balancing usefulness and safety. If you are
> only allowed to open with limited privileges (no macro execution or
> editing) the possibility of infecting your computer unintentionally with
> malware is lessened considerably. This gives the users a chance to
> verify before granting full privileges on their computers.
>
> Having cleaned serious malware infections on friends and coworkers
> computers; the inconvenience is worth the protection. It is not perfect
> but puts another step in the way of disaster.
>
> --
> Jay Lozier
> jsloz...@gmail.com
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

[John Clegg]

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?

On 8 October 2012 13:08, Marcello Romani  wrote:

> Il 05/10/2012 17:18, Marcello Romani ha scritto:
>
>> Il 05/10/2012 16:31, webmaster-Kracked_P_P ha 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 and Calc always opens it
>>>>> read-only
>>>>> whereas Excel opens it as read-write. I would like at least an
>>>>> option to
>>>>> get Calc to open it as read-write. To do so I have to save a copy
>>>>> before I start, and as I do this around 100 times a day it becomes
>>>>> quite an
>>>>> irritant.
>>>>>
>>>>
>>>> It's just a "modify document" button click away. But I guess it's more
>>>> a "problem" of the web browser or e-mail client rather than OOo/LibO
>>>> as such.
>>>>
>>>> The browser / e-mail client puts a read-only file in the user temp
>>>> folder, then passes its full path to OOo/LibO for reading. OOo/LibO
>>>> will just notice it's a readonly file and will behave accordingly.
>>>>
>>>> Hopefully someone with more technicall indsight into this can confirm
>>>> or correct me ?
>>>>
>>>>
>>> This open as a read only is a "security feature" from before LO came
>>> out.  I remembering it doing the same with OpenOffice.org and MSO-2003.
>>>
>>> The file, at least with Thunderbird, that come in an email attachment is
>>> stored in a TEMP folder.  Those files are, by nature, read-only till
>>> they get saved outside the TEMP [/tmp for Linux] folder.
>>>
>>> I know it is a hassle for people but I really do not want to have any
>>> email attachments placed in a "normal" data folder without me saving it
>>> there.  That way I control what gets saved from the email and then all
>>> the other stuff is removed with the deletion cycle of the email client's
>>> TEMP folder content.
>>>
>>> We must think safety first and deal with the hassles like this, or could
>>> suffer a email that places their attachment file anywhere it wants to be
>>> and may be overwrite a working file with the same name or worse a system
>>> file.
>>>
>>>
>>>
>>>
>> If those files weren't read only there would be other, more serious
>> complaints from users (I had one).
>> The user would doubleclick on an attachment and have it open r/w in
>> OOo/LibO/MSO. He would start modifying it right away (no hassle!), then
>> save it. Then close the word processor and forget about it.
>> Then after a little while go to the IT guy asking where the hell is that
>> document that he just "saved".
>>
>> Being readonly, instead, forces the user to click on that damned icon,
>> so the program produces an in-memory r/w copy of the document that will
>> trigger a "save as" procedure when the user would click "save".
>>
>>
>
> There was a missing bit in my description: if the attachment would be
> opened R/W, the file would be saved in the user's temp folder. So it would
> be lost at best, or in worst case scenario deleted as temp folders gets
> cleaned.
>
> --
> Marcello Romani
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

[John Clegg]

Forgive me, but I thought one of the aims of LO was improvements to
usability. I open emails mailed to me dozens of times a day. Doing Save-As,
or clicking the edit button takes little time I agree, but why is it so
wrong to desire that as the default to save me time?

On 9 October 2012 10:18, Andreas Säger  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 to save it a Save As dialog would appear
> ?
> >
> > Sounds good to me.
> >
>
> Again, it is not the office program which creates read-only files. In
> most cases some other application calls the office to *view* some
> document. In most cases the office is called by a browser, mail client
> or cloud application to view online content or mail attachments.
>
> There are many reasons why this application has a viewing mode. It must
> not open some document in unsaved template mode just because the file is
> read-only. That would be extremely annoying for many users.
> Most of our ODF documents (documentations, print-outs, database forms,
> reports) are strictly read-only because only one person (me, the file
> owner) is supposed to modify these. The co-workers can work with the
> contained material (read, print, mail as PDF, edit databases through
> forms).
>
> All you've got to do is hitting the edit button in order to get an
> editable new and unsaved document.
> All you've got to do is saving the same document in your own file system
> in order to get your own editable copy of the document.
>
> Some Microsoft "feature" carries over the read-only flag when an
> application saves a document under another name. I'd call this a bug. No
> other file system behaves that silly. You need to turn it off in the
> file properties (right-click file in Win Explorer>Properties...).
>
> There is also an internal read-only mode implemented in the office
> program (File>Save As... save with password, open read-only with
> password). But that is another story. The internal flag within the
> document does not protect the file from being manipulated by other
> applications and the read-only status is carried with every copy of the
> file.
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] pcl overlay

[John Clegg]

+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  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 projects, a question
> written in anything other than English on an 'International' list illicits
> a lot of telling-off from various people.
>
> I think this time the response was unusually excellent.
> 1.  There is a direct link so the person can copy&paste their question to
> the right list easily
> 2.  That message is translated so the list understands the action taken
> 3.  There is a neat translation of the question so the list can understand.
> So, now if someone does know the answer to the question they can answer in
> English (or French) and we can take it from there.
>
> This raises the bar significant;y.  It makes our list look like an
> extremely professional customer support list.
> Regards from
> Tom :)
>
>
> --- On Wed, 10/10/12, Jean-Francois Nifenecker <
> jean-francois.nifenec...@laposte.net> wrote:
>
> From: Jean-Francois Nifenecker 
> Subject: Re: [libreoffice-users] pcl overlay
> To: users@global.libreoffice.org
> Date: Wednesday, 10 October, 2012, 8:53
>
> Hello Hervé,
>
> [EN version follows]
>
> Le 10/10/2012 09:24, hs...@villeneuvedascq.fr a écrit :
> >
> > je souhaite avoir un fond de page en overlay
> > avec word on peut utiliser un champ "imprimer" et y mettre une sequence
> > PCL
> > comment faire avec LibreOffice
>
> cette liste est anglophone. Les questions doivent donc y être posées en
> anglais. Il existe également une liste francophone :
> us...@fr.libreoffice.org
>
> [EN]
>
> This list is english-speaking, thus you should ask questions here in
> English. There exists a francophone list: us...@fr.libreoffice.org
>
>
> Here's a translation of Hervé's question (which I don't understand ;)
> 8< -
> I wish to get an overlaid page background.
> With Word one may use a "print" field and set a PCL sequence there.
> How can I do this using LibO?
> - >8
>
> Best regards,
> -- Jean-Francois Nifenecker, Bordeaux
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Integer part of a number

[John Clegg]

Indeed. Which is why your last answer is also wrong!

On 15 October 2012 15:08, Andreas Säger  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 should use for the integer part
> >>> of a cell to be shown in another cell, ...
> >>
> >> The answer could be:
> >> =IF(C3<1;0;INT(C3))
> >
> > You are overthinking the problem: if C3 is positive, that's no different
> > from
> > =INT(C3)
> >
> > Brian Barker
> >
> >
>
> Reportedly, negative numbers do exist.
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Base - need to re-point a form

[John Clegg]

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 copy of the database, but as I
want to make copies of the main table many times a day that would be a
laborious solution

It is easy to make a duplicate of the main table within the database, and
also easy to make a copy of the form in the base file, but what I need to
do now is point the copy of the form at the copy of the table.

I thought it might be possible to open the odb file as a zip file and find
the form data containing the table name somewhere in it, and edit it to the
copy table name, but I haven't succeeded yet.

Does anybody know if this is possible - or even if there is a much easier
way?

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base - need to re-point a form

[John Clegg]

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  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 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 copy of the database, but as I
>> want to make copies of the main table many times a day that would be a
>> laborious solution
>>
>> It is easy to make a duplicate of the main table within the database, and
>> also easy to make a copy of the form in the base file, but what I need to
>> do now is point the copy of the form at the copy of the table.
>>
>> I thought it might be possible to open the odb file as a zip file and find
>> the form data containing the table name somewhere in it, and edit it to
>> the
>> copy table name, but I haven't succeeded yet.
>>
>> Does anybody know if this is possible - or even if there is a much easier
>> way?
>>
>>
>>
> John,
> I am assuming you need to change the table that your form points to.  You
> can do this by:
>
>   1. Bring up your form in edit mode (right click on form name and
>  select "Edit".)
>   2. Select the "Form Properties" window (this is the icon that looks
>  like a window with 2 buttons with an arrow pointing to it, and
>  with a help balloon that says "Form".
>   3. In the popup window, select the "Data" tab.
>   4. Change the "Content" box to the table you want to use from the list.
>
> If the new table's column (control) names are different, you will have to
> change those too in the form editor.  You do that by Ctrl-left-clicking on
> the form's control box and selecting its "Data" tab and selecting the new
> name from the list derived from your new table.  Do that for each control
> that has a different name from your old table.
> Hope this helps.
> Girvin Herr
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Base - need to re-point a form

[John Clegg]

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  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 copy of the database, but as I
> want to make copies of the main table many times a day that would be a
> laborious solution
>
> It is easy to make a duplicate of the main table within the database, and
> also easy to make a copy of the form in the base file, but what I need to
> do now is point the copy of the form at the copy of the table.
>
> I thought it might be possible to open the odb file as a zip file and find
> the form data containing the table name somewhere in it, and edit it to the
> copy table name, but I haven't succeeded yet.
>
> Does anybody know if this is possible - or even if there is a much easier
> way?
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base - need to re-point a form

[John Clegg]

That's pretty comprehensive, thanks! I will work through those.

Regards

john

On 18 October 2012 08:22, Alex Thurgood  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 the data by opening the table or using the form it is
> > read-only. Any ideas again?
> >
>
> Several possible reasons :
>
> - no primary key field defined in your table, but I guess you would have
> noticed that before, with your previous attempts to edit the data from
> within LO Base ;
>
> - a field in your table that LO can not parse - unfortunately, some data
> types, whilst in theory recognised by the driver in other circumstances,
> i.e. with other software, are not recognised by LO's data type parser,
> for the lack of them being defined in the handling code. One such
> example are certain binary objects. At present CLOB support is limited
> to images in LO ;
>
> - a corrupt or misconfigured ODB file : it may be that changing your
> table source has confused LO's database registration code and caused it
> mark the table as read only, or alternatively, if it points to a
> separated database, then the ODB configuration needs to be reset to
> correspond to the new database in addition to the new table (this is
> just speculation on my part) ;
>
> - a bug in the version of LO you are using.
>
>
>
> Alex
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base - need to re-point a form

[John Clegg]

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 changes. I have added a
primary key this way, but I'm not sure that Base is seeing that - there is
no sign of it if I edit the table structure in Base.


On 18 October 2012 08:53, Mark Stanton  wrote:

> Is this after you've switched to using a different copy?
> It sounds like you have had read/write access in the past, is that
> right?  If so, what changed?
>
> How do you know it's read only?
> If your form won't let you change the data it's a local issue, if you
> can save but it makes no difference presumably thems who are
> administering the MySQL have set something.
>
> Often the reason for having read only access through Base is that the
> table in question doesn't have a primary key defined, but if you've
> had write access before and nothing else has changed that would be
> unlikely.
>
> Regards
> Mark Stanton
>
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base - need to re-point a form

[John Clegg]

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 wrote:

> Le 18/10/12 11:46, John Clegg a écrit :
>
> Hi John,
>
> >
> > I can access the data via phpMyAdmin and make changes. I have added a
> > primary key this way, but I'm not sure that Base is seeing that - there
> is
> > no sign of it if I edit the table structure in Base.
> >
>
> How is your primary key defined ? - single or multiple field ?
>
> Additionally, you might have to quit LO completely, and then reload the
> ODB file.
>
>
> Alex
>
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base - need to re-point a form

[John Clegg]

No, same user!

On 18 October 2012 14:18, Alexander Thurgood wrote:

>
> 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, but : user privileges ? Any difference between
> Base user and phpmyadmin user ?
>
>
> Alex
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base - need to re-point a form

[John Clegg]

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 wrote:

> 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.
> >
>
> Can you post the table structure ?
>
> Alex
>
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base - need to re-point a form

[John Clegg]

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  wrote:

> 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 wrote:
>
>> 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.
>> >
>>
>> Can you post the table structure ?
>>
>> Alex
>>
>>
>>
>> --
>> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>> Problems?
>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be
>> deleted
>>
>>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base - need to re-point a form

[John Clegg]

No, the ODB is on a local NTFS volume

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 to me some dodgy MySQL connectors

To check that I set up another MySQL server elsewhere and had exactly the
same problem with the JDBC connector.

I suppose I could set up a local MySQL server but I don't want it local!
And I suspect I might hit the same problem anyway.

Very frustrating!

On 19 October 2012 09:46, Alex Thurgood  wrote:

> On 10/18/2012 03:49 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 or NFS server or
> network storage ?
>
> Unfortunately, I can't reproduce your problem from a general point of
> view - yesterday I managed to set up a JDBC ConnectorJ connection to a
> locally hosted mysql db on WIndows XP and LO 3.6.1 and can edit the data
> and have it saved no problem.
>
> So, it must be something specific to your setup, or the ODB file itself.
>
>
> Alex
>
>
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Suitability of Lo in Small organisations

[John Clegg]

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  wrote:

> On 19/10/2012 at 10:30, Tom Davies  wrote:
>
> > Luckily you can't really go wrong now that the
> > 3.6.3 is out.
>
> 3.6.3 has not been released yet. It's only rc1 that is available. LO
> website
> clearly state that this version is not meant for production use.
> --
> Best regards
> Mirosław Zalewski
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base - need to re-point a form

[John Clegg]

OK, thanks for that.

Using LO 3.6.2 on Windows 7SP1 (also linux, but let's get it working here
first!). Connecting to a database on xeround.com (actually hosted on Amazon
EC2 servers, using port 18993. JDBC driver class com.mysql.jdbc.Driver
using mysql-connector-java-5.1.22-bin.jar

John

On 19 October 2012 13:16, Alexander Thurgood wrote:

> 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 to me some dodgy MySQL connectors
> >
> There are some known issues with ODBC connectors, some of which cause
> crashes, or data access problems, depending on which version of LO you
> are using and which version of the MySQL ODBC Connector. Remember, LO is
> 32bit, even on Windows 64bit OS, so it requires a 32bit ODBC connector.
>
> This is also a major problem on OSX, where :
> - current versions of the OS are 64bit only as are the included mysql
> servers ;
> - LO is only 32bit ;
> - OSX can't manage a 32bit and 64bit mysql connector at the same time
> (or at least if it can, I've found no way to get it to behave properly),
> so users are stuffed when it comes to MyODBC on Mac OSX unless they are
> using a 32bit OS, i.e. Leopard or older..., or Snow Leopard in 32bit
> kernel mode...
>
> On Linux, the ODBC connector and LO are available in 32 and 64 bit
> incarnations, so it is possible to get something up and running.
>
> All versions of LO have had problems accessing remote database instances
> via ODBC, especially if your db server is on the internet.
>
>
>
> > To check that I set up another MySQL server elsewhere and had exactly
> > the same problem with the JDBC connector.
> >
> > I suppose I could set up a local MySQL server but I don't want it
> > local! And I suspect I might hit the same problem anyway.
>
> No, I suspect that your problem is precisely because your mysql server
> is not local, or at least, not on the local lan (if I have understood
> your implied setup correctly).
>
> I don't have any problem accessing a LAN hosted mysql server instance
> over the mysql JDBC connector. Trying that over the internet is a whole
> other ballgame though. You need to have remote user access to your mysql
> server instance other than through port 80, which is not always (rarely,
> other than by SSH) provided for by hosting services. On top of that, DNS
> resolution issues can cause timeouts.
>
> It might be helpful if you gave us the exact setup you are trying to put
> into place, with version numbers for the different components.
>
>
> Alex
>
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base - need to re-point a form

[John Clegg]

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 wrote:

>  Hi John,
>
>
> Le 19/10/12 14:25, John Clegg a écrit :
>
> OK, thanks for that.
>
>  Using LO 3.6.2 on Windows 7SP1 (also linux, but let's get it working
> here first!). Connecting to a database on xeround.com (actually hosted on
> Amazon EC2 servers, using port 18993. JDBC driver
> class com.mysql.jdbc.Driver using mysql-connector-java-5.1.22-bin.jar
>
>
> Can you connect to that instance via the mysql client program from the
> command line interface and edit data in your tables on the remote instance ?
>
> mysql -h myhost -P myport -d mydb -u myuser -p mypassword
>
>
> Alex
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base - need to re-point a form

[John Clegg]

Really? Mine doesn't

On 19 October 2012 15:55, jomali  wrote:

> What are you talking about? Of course there is a command line interface to
> MySQL in Windows. I use it all the time. Just go to Run and type mysql in
> the Open: box. You'll get a Command prompt with mysql command line ready to
> go.
>
> John
>
> On Fri, Oct 19, 2012 at 9:23 AM, John Clegg wrote:
>
>> 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 > >wrote:
>>
>> >  Hi John,
>> >
>> >
>> > Le 19/10/12 14:25, John Clegg a écrit :
>> >
>> > OK, thanks for that.
>> >
>> >  Using LO 3.6.2 on Windows 7SP1 (also linux, but let's get it working
>> > here first!). Connecting to a database on xeround.com (actually hosted
>> on
>> > Amazon EC2 servers, using port 18993. JDBC driver
>> > class com.mysql.jdbc.Driver using mysql-connector-java-5.1.22-bin.jar
>> >
>> >
>> > Can you connect to that instance via the mysql client program from the
>> > command line interface and edit data in your tables on the remote
>> instance ?
>> >
>> > mysql -h myhost -P myport -d mydb -u myuser -p mypassword
>> >
>> >
>> > Alex
>> >
>>
>> --
>> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
>> Problems?
>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be
>> deleted
>>
>>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base - need to re-point a form

[John Clegg]

OK, all fixed at last - by a clunky method, but hey - it worked!

I had the data in a CSV so I loaded that into an ODS sheet, then pasted
from there into a new table via Base, creating a new primary index in the
process. That worked!

On 19 October 2012 16:52, V Stuart Foote  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/19/2012 10:04 AM
> To: jomali
> Cc: Alexander Thurgood; users@global.libreoffice.org
> Subject: Re: [libreoffice-users] Re: Base - need to re-point a form
>
>
>
> Really? Mine doesn't
>
> On 19 October 2012 15:55, jomali  wrote:
>
> > What are you talking about? Of course there is a command line interface
> to
> > MySQL in Windows. I use it all the time. Just go to Run and type mysql in
> > the Open: box. You'll get a Command prompt with mysql command line ready
> to
> > go.
> >
> > John
> >
> > On Fri, Oct 19, 2012 at 9:23 AM, John Clegg  >wrote:
> >
> >> 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
> >>
>
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Is it possible to show cell value with text

[John Clegg]

Nice easy one that! You were nearly there:

="Number of errors are " &  (SUM(A1:A3) &".")

On 5 November 2012 06:06, dave_  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 " +  (=sum(a1:a3) +"."
> Number of errors are 15.
>
> Is this even possible?
>
>
> Thanks ahead for any suggestions.
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Connecting LO Base to an SQL DB [SOLVED]

[John Clegg]

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  wrote:

> On 11/06/2012 11:34 AM, Pertti Rönnberg wrote:
>
>> Hello LibO experts,
>> and congratulations IanW!
>>
>> It has been very interesting to follow this discussion getting Base
>> working with MySQL.
>> Unfortunately -- if I got it right - is Ian's OS a Linux (Ubuntu?)
>>
>> Would it be possible to get the same proceeding described as a
>> step-by-step instruction for Windows7 (64bit)?
>> >in plain english  (no IT-jargong)
>> >starting from the very beginning defining the different programs
>> (versions) and components (ODBC, JDBC, JRE, etc when needed, included) to
>> be installed
>>
>
> Hi Pertti
>
> Noted on your comments!! Unfortunately I'm running PCLinuxOS here and NOT
> Windows!! (I'm sure you will be told to move by someone!!). So I don't
> think it's any use me sending you the steps I went through. I did however
> have the same situation here and over the past 8 months or so this was the
> fourth attempt at getting it working.
>
> In the past I gave up after several days of "thrashing" about and went
> back to Base/HSQL until it crashed on me again and so on and so on
>
> This time I decided to hold out and work it through to the very end!!
> There were many things to learn and lots of Hoops to jump through but we
> got there in the end thanks to the aforementioned Members of the Forum
> (thanks again Guys!!)
>
> I'm sure somebody WILL pop up and try and help you out - just stay with
> it, one step at a time, and you'll get there in the end.
>
> VERY early days here but so far it looks good and I have a good feeling
> about Base/MySQL. I'm stuck at the moment though trying to extract my data
> from the old DB!!! Whatever I try it just crashes on me. (Grrr).
>
> The saga continues and I will be VERY glad to be shot of Base/HSQL!!!
>
> All the best
>
> IanW
> Pretoria RSA.
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette 
> List archive: 
> http://listarchives.**libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Is it possible to show cell value with text

[John Clegg]

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  wrote:

> On 11/11/2012 11:03 AM, dave_ wrote:
>
>> Thanks for the solution.
>>
>>
>>
>> --
>> View this message in context: http://nabble.**
>> documentfoundation.org/Is-it-**possible-to-show-cell-value-**
>> with-text-tp4016842p4018036.**html
>> Sent from the Users mailing list archive at Nabble.com.
>>
>  How can we give you a solution when you have not yet given us the
> problem? It appears that you are using Calc. But what to you mean by show
> cell value"? Where is the text located? Are you referring to a cell
> containing twenty-seven rather than 27 for example? Or perhaps ten november
> two thousand twelve instead of 10 Nov 2012  or Nov 10, 2012?
>  Please be more specific.
>
> --Dan
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette 
> List archive: 
> http://listarchives.**libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Is it possible to show cell value with text

[John Clegg]

The & concatenates text strings whereas + tries to add them and fails!


On 12 November 2012 04:28, Viral Orpe  wrote:

> Hi John,
>
> Checked your reply on list-archives :)
> Somehow must have missed on 6th Nov when it first appeared.
>
> Please, what is the & stand for?
> Dave_ had asked the question with a +
>
> So, I guess this is some standard way of doing things(name?) with slightly
> diff syntax.
>
> I have never known it can be done that way - text and formula together in
> a cell.
> I have always used adjacent cells - one with the text part and another
> with the formula.
>
> Any pointers would be great.
>
> Thanks,
> Regards,
> Viral Orpe :)
> ---
>
> Processor  : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz
> Memory : 4GB, DDR3
> OS: Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686)
>
> LibreOffice : LibreOffice 3.4.3  OOO340m1 (Build:302)
>
> ---
>
>   --
> *From:* John Clegg 
> *To:* Dan Lewis 
> *Cc:* "users@global.libreoffice.org" 
> *Sent:* Sunday, November 11, 2012 9:59 PM
> *Subject:* Re: [libreoffice-users] Re: Is it possible to show cell value
> with text
>
> 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  wrote:
>
> > On 11/11/2012 11:03 AM, dave_ wrote:
> >
> >> Thanks for the solution.
> >>
> >>
> >>
> >> --
> >> View this message in context: http://nabble.**
> >> documentfoundation.org/Is-it-**possible-to-show-cell-value-**
> >> with-text-tp4016842p4018036.**html<
> http://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842p4018036.html
> >
>
> >> Sent from the Users mailing list archive at Nabble.com<http://nabble.com/>
> .
> >>
> >  How can we give you a solution when you have not yet given us the
> > problem? It appears that you are using Calc. But what to you mean by show
> > cell value"? Where is the text located? Are you referring to a cell
> > containing twenty-seven rather than 27 for example? Or perhaps ten
> november
> > two thousand twelve instead of 10 Nov 2012  or Nov 10, 2012?
> >  Please be more specific.
> >
> > --Dan
> >
> > --
> > For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> > org 
> > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> > unsubscribe/<
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> > Posting guidelines + more: http://wiki.**documentfoundation.org/**
> > Netiquette <http://wiki.documentfoundation.org/Netiquette>
> > List archive: http://listarchives.**libreoffice.org/global/users/<
> http://listarchives.libreoffice.org/global/users/>
>
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
> >
> >
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Change key

[John Clegg]

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  wrote:

> I need to change keys because function keys do not work on my keyboard.
> Want ctrl F to be the key to open Navigator.
> Did change this in Extra>Change>Keyboard, but this does not work.
> Question: How to change keys in Writer?
>
> (OSX 10.7.5, Libreoffice Versie 3.6.4.3 (Bouw-id: 2ef5aff)
>
>
> thanks Jaap
> --
>
> /
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette 
> List archive: 
> http://listarchives.**libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Mail Merge and Labels

[John Clegg]

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
same reason. Or is there a way that I have missed?


On 5 December 2013 23:37, Jeff Hahn  wrote:

> I use LO 4.1.3 and Windows 7.  I should repeat that in my case the first 2
> columns print properly (although the print starts right at the edge of the
> label).  It is only the third (right) column that is off.
>
> Jeff Hahn
>
> > From: cuyfa...@hotmail.com
> > To: users@global.libreoffice.org
> > Subject: Re: [libreoffice-users] Mail Merge and Labels
> > Date: Thu, 5 Dec 2013 12:31:46 -0500
> >
> > I just noticed this thread, and I have to chime in that, the last time I
> > tried to create labels, I too noticed that the LO Avery 5160 template
> > alignment was off. I had to adjust the contents of every cell. At that
> time,
> > I was still using LO 3.5.x. I have not yet tried since upgrading to the
> > 4.x.x range.
> >
> > At the time, I just installed Apache OO, as its template worked properly.
> >
> > If I recall correctly, I think there may have been other label templates
> > online as extensions that worked better than LO's label template.
> >
> > Virgil
> >
> > -Original Message-
> > From: Niklas Johansson
> > Sent: Thursday, December 05, 2013 12:20 PM
> > To: Jeff Hahn ; users@global.libreoffice.org
> > Subject: Re: [libreoffice-users] Mail Merge and Labels
> >
> > So I looked at the configuration in LibreOffice 4.0.6 and LibreOffice
> > 4.2 beta-version and the configuration seems to be correct. I even
> > compared it to the result that I get in Word 2013 for the same label
> > (sorry for not thinking about doing that earlier). So before I put
> > anymore time into this it would be good to know what version of
> > LibreOffice you used when you created the labels?
> >
> > Niklas Johansson
> >
> > Jeff Hahn skrev 2013-12-05 17:22:
> > > I think the configuration in the wizard may be wrong.  The Avery 5160
> has
> > > 30 labels on a 8.5" x 11" sheet each measuring 1" x 2 5/8".  It is
> > > probably one of the most common labels used so I am surprised the issue
> > > hasn't previously been raised.  As I indicated in my email, I didn't
> have
> > > any problem when I switched to Word so I am reasonably confident the
> issue
> > > is not related to my printer.
> > >
> > > Jeff Hahn
> > >
> > >
> > > > Date: Thu, 5 Dec 2013 17:04:24 +0100
> > > > From: sleeping.pil...@gmail.com
> > > > To: users@global.libreoffice.org
> > > > Subject: Re: [libreoffice-users] Mail Merge and Labels
> > > >
> > > > Hi Jeff
> > > >
> > > > Is the issue that you used lable sheets of the type Avery 5160 and
> that
> > > > the preconfiguration for these lables were wrong?
> > > > I think that I remember reading some issues with the label
> > > functionality
> > > > (File -> New -> Label) in an earlier version of LibreOffice that
> might
> > > > or might not be fixed in newer versions. What version of LibreOffice
> > > did
> > > > you use?
> > > >
> > > > Do you have any specifications for the measurements of these specific
> > > > labels so I can do a quick review if there seems to be any issues
> there?
> > > >
> > > > Note also that you can tweak the measurements under the Format tab of
> > > > the Labels-dialog. Not that you should need to if you use labels that
> > > > has a preset configuration.
> > > >
> > > > Kind regards,
> > > > Niklas Johansson
> > > >
> > > > Jeff Hahn wrote 2013-12-04 16:41:
> > > > >
> > > > >
> > > > >
> > > > > I tried to do my labels for Christmas
> > > > > cards using LO's mail merge. I was able to create the data base and
> > > > > print without difficulty. Unfortunately, the entire third column
> > > was not
> > > > > properly spaced and printed outside of the label, a couple of
> > > spaces to the left. The first two columns were they were supposed to
> be. I
> > > was using standard
> > > > > configuration for Avery 5160. I finally gave up created the labels
> > > > > with Excel and Word.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > I am not sure where to send an email to
> > > > > suggest that the matter be looked into so I am sending this
> > > > > information to this list with the hope the matter will be picked
> for
> > > > > investigation. Also, although I suspect it has been suggested
> > > > > before, it would be nice to be able to do a mail merge directly
> from
> > > > > the spreadsheet without creating a database file.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Jeff Hahn
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > > > Problems?
> > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > > Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
> > > > L