Re: [libreoffice-users] Re: question about the best version of libreoffice:

Hi Andreas and Tom, It was good to see that someone actually responded to the question that was asked about LO. I don't make much use of Writer so I have little but civility to contribute. I have *reflowed* your messages as quoted below my signature. I would think that for the casual user of

Re: [libreoffice-users] Re: question about the best version of libreoffice:

+1 On 2016-01-21 13:42, Tom Davies wrote: Hi :) Many people on this mailing list have had signatures that include Bible quotes or such-like without anyone grumbling or anything. I thought it was nice to see something similar from a different religion for a change. Regards from Tom :) On

Re: [libreoffice-users] footnotes numbering problem

At 14:17 20/01/2016 +0100, Wojciech Górnas wrote: In this example document, ... The document is a .docx file. It might be more sensible to save this in .odt format. ... each footnote number was inserted manually in LibreOffice Writer. Now, is there a way to convert them all to

Re: [libreoffice-users] footnotes numbering problem

If this is the correct URL, then hopefully someone else will be able to open it, view your example, then supply an answer to your problem. For some reason, all I see is a blank page ??? From: Wojciech Górnaś Date: Wed, Jan 20, 2016 at 12:20 PM

[libreoffice-users] Re: LibreOffice Base and MySQL

When using HSQL (which is less powerful than MySQL) command CREATE TEXT TABLE "Foo"(...) prepares a table "Foo" with fields and indices just like a regular data table. A second command SET TABLE "Foo"... links the text table "Foo" to a particular text file. If the linked text table and the

Re: [libreoffice-users] footnotes numbering problem

Did you mean to insert a URL to show an example?; or did you attach an example? (if so, attachments are not allowed so was deleted before arriving on this list) Oh, I forgot about it. Please, download the file from here:

Re: [libreoffice-users] footnotes numbering problem

Did you mean to insert a URL to show an example?; or did you attach an example? (if so, attachments are not allowed so was deleted before arriving on this list) So without seeing the example, I'm making a couple assumptions - which may or may not apply ;-) (1) Did

Re: Fwd: Re: [libreoffice-users] LibreOffice Base and MySQL

Maybe this a really stupid question: but - have you defined the table before trying to upload the csv-file ? The LOAD DATA procedure I mentioned before assumes that a correctly defined table (CREATE TABLE tablename (col1,col2,...)) with the correct data types of your columns exists in the DB.

Re: [libreoffice-users] LibreOffice Base and MySQL

On Wednesday, 20 January 2016, Ian "Witty" Whitfield < edi...@federalsaints.net> wrote: > Hi All > > I have been trying to import a CSV file from Calc into MySQL to run with Base for over a week now and can not believe this is so difficult to do so I'm hoping some other Base users might have

Re: Fwd: Re: [libreoffice-users] LibreOffice Base and MySQL

Hello, Maybe I don't understand your problem, but... LO lets you store your calc-spreadsheet as a csv-file. I have just tried that out. The format is just fine for then loading into a table as I described earlier. Regards H.S. On Wed, 20 Jan 2016 17:38:12 +0100, Heinrich Stoellinger

Fwd: Re: [libreoffice-users] LibreOffice Base and MySQL

Hello again, Ian, FIELDS ENCLOSED BY '"' does of course only apply to character type fields (CHAR, DATE,...), not to numeric values. mysql command client should read mysql command line client... Regards H.S. -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- To

Re: [libreoffice-users] LibreOffice Base and MySQL

Hello again, Can you use the LOAD DATA command under the mysql command client? You should be able to fire this command also under phpmyadmin. like so... - LOAD DATA INFILE "/directory/.../filename.csv" REPLACE INTO TABLE table1 FIELDS ENCLOSED BY

Re: [libreoffice-users] LibreOffice Base and MySQL

Hello It doesn't really look like you are importing into Base as much as MySQL. Have you tried this... In phpMyAdmin, click the table, and then click the Import tab at the top of the page. Browse and open the csv file. Leave the charset as-is. Uncheck partial import unless you have a HUGE

[libreoffice-users] Re: LibreOffice Base and MySQL

How can anybody solve any csv related problem without knowing anything about the actual content? 4 different lines of perfectly valid and commonly used csv data: 1234.98;2014-12-22 1.234,98;22 Dez 2014 1234.98;12/22/14 1234.98;22/12/14 Each line carries the exact same information. I could add a

[libreoffice-users] use calc rows as fooier

Good morning All It's been a while. I am trying to use 4 rows on a calc sheet as a footer, in addition to a header row. Can only see how to use rows as a header. Any hints please? Thanks -- Keith Bainbridge keithrbaugro...@gmail.com +61 (0)447 667 468 -- To unsubscribe e-mail

Re: [libreoffice-users] Re: question about the best version of libreoffice:

Hi :) +1 errr, at least wrt 3.5 - i'm not sure about trolls. I think as a general rule the later versions of a branch tend to be more reliable in terms of their functionality and probably more stable too (although i've never had LO out-right crash or anything). So for the 3.5 branch the 3.5.4

Re: [libreoffice-users] Re: question about the best version of libreoffice:

Hi :) Many people on this mailing list have had signatures that include Bible quotes or such-like without anyone grumbling or anything. I thought it was nice to see something similar from a different religion for a change. Regards from Tom :) On 20 January 2016 at 12:08, James Knott

[libreoffice-users] Re: question about the best version of libreoffice:

Philip Rhoades schreef op 20-01-16 om 09:15: nasrin, On 2016-01-20 19:05, nasrin khaksar wrote: hi every one. i tested many versions of libreoffice since version 4.2.5 all versions have there advantages and in cases there bugs and limitations. whats the best version of libreoffice since

[libreoffice-users] question about the best version of libreoffice:

hi every one. i tested many versions of libreoffice since version 4.2.5 all versions have there advantages and in cases there bugs and limitations. whats the best version of libreoffice since version 4.3.0.4 according to your experience? whats the best version with more stability, reliability and

Re: [libreoffice-users] question about the best version of libreoffice:

nasrin, On 2016-01-20 19:05, nasrin khaksar wrote: hi every one. i tested many versions of libreoffice since version 4.2.5 all versions have there advantages and in cases there bugs and limitations. whats the best version of libreoffice since version 4.3.0.4 according to your experience?

Re: [libreoffice-users] R1C1 reference style with LibreOffice

Le 19/01/2016 18:37, pacopyc pacopyc a écrit : > Hi, I have to convert a macro from Excel to LibreOffice. The Excel macro > contains many formulas in R1C1 reference style. > > How can I rewrite the formulas in R1C1 reference style with LibreOffice? Is > it possible? Yes: menu Tools > Options >

Re: [libreoffice-users] R1C1 reference style with LibreOffice

Ok, but the problem is that I must do it from LibreOffice basic code. pacopyc 2016-01-20 9:46 GMT+01:00 Jean-Baptiste Faure : > Le 19/01/2016 18:37, pacopyc pacopyc a écrit : > > Hi, I have to convert a macro from Excel to LibreOffice. The Excel macro > > contains many

[libreoffice-users] Re: R1C1 reference style with LibreOffice

Am 20.01.2016 um 10:17 schrieb pacopyc pacopyc: > Ok, but the problem is that I must do it from LibreOffice basic code. > If you would spend more than an hour or two with this matter, you would not have to wait days for the answer. >

Re: [libreoffice-users] Calc- don't show the decimal point

Hi Spencer, My comment paragraphs begin with "[" and each, possibly extended, comment ends with "-- jl]". -- Jim -Original Message- From: Spencer Graves To: users@global.libreoffice.org Sent: Tue, 19 Jan 2016 8:37 Subject: Re: [libreoffice-users] Calc-

Re: [libreoffice-users] LibreOffice Base and MySQL

On Wed, 2016-01-20 at 12:05 +0200, Ian Whitfield wrote: > Hi All > > I have been trying to import a CSV file from Calc into MySQL to run > with > Base for over a week now and can not believe this is so difficult to > do > so I'm hoping some other Base users might have cracked this one!! > > My

Re: [libreoffice-users] Re: R1C1 reference style with LibreOffice

Excuse me, I don't understand. Can I rewrite the formulas in R1C1 reference style with LibreOffice basic code? How? 2016-01-20 11:14 GMT+01:00 Andreas Säger : > Am 20.01.2016 um 10:17 schrieb pacopyc pacopyc: > > Ok, but the problem is that I must do it from LibreOffice

Re: [libreoffice-users] LibreOffice Base and MySQL

Hello Ian, I am somewhat puzzled by the error message you get: It seems to me that you are defining multiple columns with the name `NULL`. To MY knowledge column names should be unique withing one table. Also NULL is used to specify whether the value of a column may be NULL (i.e. "unknown") or

Re: [libreoffice-users] Re: question about the best version of libreoffice:

Thanks Philip, very instructive! -- Guy 2016-01-20 11:02 GMT+01:00 Philip Rhoades : > Erik, > > > > On 2016-01-20 19:49, Erik Jan wrote: > >> Philip Rhoades schreef op 20-01-16 om 09:15: >> >>> nasrin, >>> >>> >>> On 2016-01-20 19:05, nasrin khaksar wrote: >>> hi every

[libreoffice-users] LibreOffice Base and MySQL

Hi All I have been trying to import a CSV file from Calc into MySQL to run with Base for over a week now and can not believe this is so difficult to do so I'm hoping some other Base users might have cracked this one!! My OpSys is PClinuxOS - 32-bit and MySQL is ver 5.1.73. Everything is

Re: [libreoffice-users] Re: R1C1 reference style with LibreOffice

If it's only a matter of rewriting R1C1 in A1 notations, a simple function could read the Rx and put the appropriate letter, then remove the C. If you want to reference cells from the basic code, functions alreay exist to get cells from their numeric coordinates, as said by others. I think this

Re: [libreoffice-users] Calc- don't show the decimal point

At 15:15 19/01/2016 -0500, Alek Solzhenitsyn wrote: On 01/19/2016 11:36 AM, Spencer Graves wrote: You need Format > Cells > Numbers: Format code = With this, 0.1 appears as "" and 0.6 as "0001". That isn't what I want- the wrong answer. No, it *is* what you want. Once you have

Re: [libreoffice-users] Calc- don't show the decimal point

At 23:20 19/01/2016 +, Tom Davies wrote: I think the first cunning answer, to multiply by 1000, ... Oh, the first answer was more cunning than that: it was to multiply by 1 (which works), not 1000 (which doesn't). Brian Barker -- To unsubscribe e-mail to:

Re: [libreoffice-users] Re: question about the best version of libreoffice:

Erik, On 2016-01-20 19:49, Erik Jan wrote: Philip Rhoades schreef op 20-01-16 om 09:15: nasrin, On 2016-01-20 19:05, nasrin khaksar wrote: hi every one. i tested many versions of libreoffice since version 4.2.5 all versions have there advantages and in cases there bugs and limitations.

[libreoffice-users] Re: R1C1 reference style with LibreOffice

You can select it for the spreadsheet in: Menu/Tools/Options/LibreOffice calc/Formula - Formula Options - Formula syntax Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/R1C1-reference-style-with-LibreOffice-tp4172305p4172334.html Sent from the Users

Re: [libreoffice-users] question about the best version of libreoffice:

On 01/20/2016 03:15 AM, Philip Rhoades wrote: > Please leave superstitious nonsense (like the stuff below) out of > posts to lists that are about real-world technology. +1 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: question about the best version of libreoffice:

On 01/20/2016 03:49 AM, Erik Jan wrote: > > The beauty of the free world is that everyone is free to speak their > mind. You are free to think and proclaim that religion is > superstition, and others are free to think and proclaim God's mercy. As history and recent events have proven, those who

[libreoffice-users] LibreOffice Base and MySQL

Hi All I have been trying to import a CSV file from Calc into MySQL to run with Base for over a week now and can not believe this is so difficult to do so I'm hoping some other Base users might have cracked this one!! My OpSys is PClinuxOS - 32-bit and MySQL is ver 5.1.73. Everything is

[libreoffice-users] Re: question about the best version of libreoffice:

Am 20.01.2016 um 13:36 schrieb Andreas Säger: > > I used 3.5 for many years with no problems. > > Oh, shit. Did I feed a troll? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

[libreoffice-users] footnotes numbering problem

Hi, In this example document, each footnote number was inserted manually in LibreOffice Writer. Now, is there a way to convert them all to automatically, sequentially numbered footnotes? I tried to do this in MS Word (2007), but to no avail. For some reason Word doesn't even recognize the

[libreoffice-users] Re: LibreOffice Base and MySQL

Am 20.01.2016 um 11:05 schrieb Ian Whitfield: > Hi All > > I have been trying to import a CSV file from Calc into MySQL to run with > Base for over a week now and can not believe this is so difficult to do > so I'm hoping some other Base users might have cracked this one!! > > My OpSys is

[libreoffice-users] Re: LibreOffice Base and MySQL

Le 20/01/2016 11:05, Ian Whitfield a écrit : Ian, I would suggest opening up your Calc created CSV in a normal text editor, to see what it "really" looks like. Only in this way will you be able to choose the right options to import the data into mysql. As Andreas has rightly said, you don't