Re: [libreoffice-users] treatment of blank cells

2013-08-19 Thread greg.a.sm...@oracle.com
So the cells are the result of opening a .csv file where the string has nothing between commas such as 5,4,,,3,,2,1 between the consecutive commas is nothing, so the cell should be made totally empty. gs On 8/19/2013 8:22 PM, Steve Edmonds wrote: On 2013-08-20 13:02, Virgil Arrington wrote

Re: [libreoffice-users] Impress: Sound Links

2013-08-19 Thread Brian Barker
At 22:37 19/08/2013 -0700, Dave Liesse wrote: Well, it was a kick in the teeth to learn that sounds are only linked instead of being imbedded in the presentation, but at least that'll keep the size down. My question, though, is whether the links use absolute or relative paths. It's a simple

[libreoffice-users] Re: treatment of blank cells

2013-08-19 Thread mariosv
Maybe this option can help: Menu/Tools/Options/LibreOffice calc/Formula/Detailed calculation settings/Custom/Treat empty string as zero -- View this message in context: http://nabble.documentfoundation.org/treatment-of-blank-cells-tp4070670p4070674.html Sent from the Users mailing list archive

[libreoffice-users] Impress: Sound Links

2013-08-19 Thread Dave Liesse
Well, it was a kick in the teeth to learn that sounds are only linked instead of being imbedded in the presentation, but at least that'll keep the size down. My question, though, is whether the links use absolute or relative paths. I put together a presentation that's for distribution via DVD

[libreoffice-users] Re: SQLException when using ADO driver and prepared statements

2013-08-19 Thread mhaverin
Hello! Alexander Thurgood: > So the question is not whether you can use prepared statements, but > whether you can use parameterized queries in prepared statements ? Well, yeah, actually :-) Alexander Thurgood: > I guess I would start with whether the simple parameterized SQL > statement actuall

[libreoffice-users] Re: Can't find setting

2013-08-19 Thread Ken Springer
On 8/19/13 7:00 PM, Virgil Arrington wrote: On 08/19/2013 08:44 AM, Denis J Navas wrote: LaTeX which is known as a standard with typography of technical and mathematical documents, use a wider space after the end of sentence point, than the space between words. Even more, the inter word space i

Re: [libreoffice-users] Calc =MONTH problem

2013-08-19 Thread Brian Barker
At 16:20 19/08/2013 -0700, Graham Lovatt wrote: Not sure if I'm doing something wrong, if there's a setting I haven't set or I've found a bug I fear you are doing something wrong! Libreoffice Calc Program settings are >>Options>>Language Settings>>Languages User interface 'English (uk)' Date

Re: [libreoffice-users] treatment of blank cells

2013-08-19 Thread Steve Edmonds
On 2013-08-20 13:02, Virgil Arrington wrote: On 08/19/2013 03:10 PM, Gregory Smith - Oracle Sparc Verification wrote: I am disappointed that Libre Office does not treat blank cells as a zero in math calculations. I have a dozen spreadsheets from Excel and Open Office that take advantage of t

Re: [libreoffice-users] treatment of blank cells

2013-08-19 Thread Virgil Arrington
On 08/19/2013 03:10 PM, Gregory Smith - Oracle Sparc Verification wrote: I am disappointed that Libre Office does not treat blank cells as a zero in math calculations. I have a dozen spreadsheets from Excel and Open Office that take advantage of this fact. Now I get errors with Libre Office.

Re: [libreoffice-users] Re: Can't find setting

2013-08-19 Thread Virgil Arrington
On 08/19/2013 08:44 AM, Denis J Navas wrote: LaTeX which is known as a standard with typography of technical and mathematical documents, use a wider space after the end of sentence point, than the space between words. Even more, the inter word space is dependent of the main font size (the opti

Re: [libreoffice-users] Calc =MONTH problem

2013-08-19 Thread Steve Edmonds
On 2013-08-20 11:20, IGraham wrote: Hello Not sure if I'm doing something wrong, if theres a setting I haven't set or I've found a bug Libreoffice Calc Program settings are >>Options>>Language Settings>>Languages User interface 'English (uk)' Date acceptance patterns 'D/M/Y;D/M;D-M' And the p

[libreoffice-users] Calc =MONTH problem

2013-08-19 Thread IGraham
Hello Not sure if I'm doing something wrong, if theres a setting I haven't set or I've found a bug Libreoffice Calc Program settings are >>Options>>Language Settings>>Languages User interface 'English (uk)' Date acceptance patterns 'D/M/Y;D/M;D-M' And the problem is In a cell (CF3) I have the da

[libreoffice-users] print drivers?

2013-08-19 Thread Robert Holtzm
Just installed Debian 7.1 which comes with LO. Previously I used 7.0 which has some version of OOo. 7.0 printed out of the box with my HP 69xx and hplip. LO on the other hand only supports PostScript printers/drivers. A cursory search turned up little in the way of Debian drivers. Anyone have a dir

[libreoffice-users] treatment of blank cells

2013-08-19 Thread Gregory Smith - Oracle Sparc Verification
I am disappointed that Libre Office does not treat blank cells as a zero in math calculations. I have a dozen spreadsheets from Excel and Open Office that take advantage of this fact. Now I get errors with Libre Office. Going back and retrofitting n(cell reference) to achieve the translatio

Re: [libreoffice-users] Re: Battle of the Office Suites: Microsoft Office and LibreOffice Compared

2013-08-19 Thread Mirosław Zalewski
On 19/08/2013 at 20:46, Brian Barker wrote: > Otherwise, you can create a custom dictionary, as you ask: > o Go to Tools | Options... | Language Settings | Writing Aids | > User-defined dictionaries. > o Click New... and give your new dictionary a name ("Novel"?). > o Tick the box next to your n

Re: [libreoffice-users] LO Calc crashes

2013-08-19 Thread Dave Barton
Kunwar Shivpal Singh wrote: > Hi ALL > > I am just a user & ardent fan of LO. > > I came across a problem in LO - cant say whether its with my computer or > LO. Version i have is the latest 4.1. > > Spelled check in Calc & the moment opted for the suggested correction > Calc crashed. > > The fi

Re: [libreoffice-users] Re: Battle of the Office Suites: Microsoft Office and LibreOffice Compared

2013-08-19 Thread Brian Barker
At 10:02 19/08/2013 +0200, Miroslaw Zalewski wrote: On 19/08/2013 at 02:04, Brian Barker wrote: You seem to be disappointed that LibreOffice cannot do something which it actually achieves very well. Please do not confuse me with Urmas. Oh, I didn't, I didn't! I was answering the paragraph I

Re: [Solved] Re: [libreoffice-users] Bibliography entry system and word/character counting

2013-08-19 Thread Krunoslav Šebetić
On 08/19/2013 01:09 AM, Mirosław Zalewski wrote: On 18/08/2013 at 18:01, Krunoslav Šebetić wrote: what happens when I send "zotero odt" to some one who doesn't have it installed? Does bibliography shows as it should? Yes. Citations are just fields (each field in LO has plain-text fallback val

Re: [libreoffice-users] Re: Can't find setting

2013-08-19 Thread Brian Barker
At 06:53 19/08/2013 -0600, Denis J Navas wrote: LO does not replace [.][ ] with [.][another kind of space]. Probably because regular expressions only detect 'space' without any qualification. Do you mean "does not"? (In which case I don't see where regular expressions come into it.) We'd p

[libreoffice-users] LO Calc crashes

2013-08-19 Thread Kunwar Shivpal Singh
Hi ALL I am just a user & ardent fan of LO. I came across a problem in LO - cant say whether its with my computer or LO. Version i have is the latest 4.1. Spelled check in Calc & the moment opted for the suggested correction Calc crashed. The file was recovered, tried the same thing again

Re: [libreoffice-users] Re: SQLException when using ADO driver and prepared statements

2013-08-19 Thread Fernand Vanrie
hei, did some test in the past and found only troubles using ADO, for a MS SQL server ODBC is the best option Replying to myself to add that this is with LibreOffice 4.1.0.4 on Windows XP. -- View this message in context: http://nabble.documentfoundation.org/SQLException-when-using-ADO-drive

[libreoffice-users] Re: SQLException when using ADO driver and prepared statements

2013-08-19 Thread Alexander Thurgood
Le 19/08/13 14:30, mhaverin a écrit : Hi, > DatabaseContext = createUnoService("com.sun.star.comp.sdbc.ado.ODriver") > Connection = DatabaseContext.connect("sdbc:ado:PROVIDER=sqloledb;DATA > SOURCE=myserver;INITIAL CATALOG=mydb;USER ID=user;PASSWORD=pwd", flatProp()) > Statement = Connection.pre

[libreoffice-users] Re: Can't find setting

2013-08-19 Thread Denis J Navas
I repeated the experiment. LibreOffice 4.1.0.4 Linux Libertine G, 12 pt. I wrote a name with a initial, with and without a dot. The space between words is highlighted to make clear its width. To aling the two paragraphs, used a dot at the start of the first group of words. Both paragraphs

[libreoffice-users] Re: Can't find setting

2013-08-19 Thread Denis J Navas
LO does not replace [.][ ] with [.][another kind of space]. Probably because regular expressions only detect 'space' without any qualification. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

[libreoffice-users] Re: Can't find setting

2013-08-19 Thread Denis J Navas
I tried with autocorrect to insert a wider space from the corresponding unicode character, but autocorrect does not replace '. ' (dot space). So its useless. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-

[libreoffice-users] Re: Can't find setting

2013-08-19 Thread Denis J Navas
LaTeX which is known as a standard with typography of technical and mathematical documents, use a wider space after the end of sentence point, than the space between words. Even more, the inter word space is dependent of the main font size (the optical size) and is stretchable. That's why I d

[libreoffice-users] Re: SQLException when using ADO driver and prepared statements

2013-08-19 Thread mhaverin
Replying to myself to add that this is with LibreOffice 4.1.0.4 on Windows XP. -- View this message in context: http://nabble.documentfoundation.org/SQLException-when-using-ADO-driver-and-prepared-statements-tp4070605p4070606.html Sent from the Users mailing list archive at Nabble.com. -- To

[libreoffice-users] SQLException when using ADO driver and prepared statements

2013-08-19 Thread mhaverin
Hello! Does the ADO driver support prepared statements at all, or am I doing something wrong? I'm experimenting with LibreOffice Basic and MS SQL Server 2008 R2, trying to read rows from a database with the ADO driver and a prepared statement. I have old ODBC code that works against MSSQL, but for

Re: [libreoffice-users] Fwd: [libreoffice-documentation] Ichitaro filter

2013-08-19 Thread Makoto Takizawa
Hi Have you ever try this extension? You can convert your file if it is work. http://extensions.openoffice.org/en/project/ichitaro-document-filter (13/08/18 5:29), Jean Weber wrote: Perhaps someone here can help this person? -- Forwarded message -- From: Spidey-Westland Dat

Re: [libreoffice-users] LO WRITER BASIC: insert an image, put a drawing-text on top and jump to next page

2013-08-19 Thread Alain Van Utterbeeck
Hello Niklas, thanks for your help, adding the escape line effectively solved my problem. Do you know where possiblities such as the uno:Escape are documented, or where the possibilities can be found? Greetings, Alain On 19-08-13 12:14, Niklas Johansson wrote: Your observation that the imag

Re: [libreoffice-users] LO WRITER BASIC: insert an image, put a drawing-text on top and jump to next page

2013-08-19 Thread Niklas Johansson
Your observation that the image is still selected, is correct. You can deselect an object (image) by pressing the Esc-button. In other words I would add the following line before Wend: dispatcher.executeDispatch(document, ".uno:Escape", "", 0, Array()) That will probably solve your problem, you m

[libreoffice-users] Re: Converting Access 2003 DB w/Security

2013-08-19 Thread Alex Thurgood
Le 14/08/2013 21:36, dfrerichs a écrit : Hi Dave, The problem arises when I have to add or delete a new user or change an existing user's rights. It seems that the only way I can modify the workgroup settings is by opening the DB up in Access, changing the security settings there and then savin

Re: [libreoffice-users] LO WRITER BASIC: insert an image, put a drawing-text on top and jump to next page

2013-08-19 Thread Alain Van Utterbeeck
Hello Andrew, Thanks for your help. I tried this: document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") mDoc = ThisComponent mCurs = mDoc.currentController.getViewCursor()

[libreoffice-users] Re: Mail merge manual field entry

2013-08-19 Thread Alex Thurgood
Le 12/08/2013 22:12, Carl Paulsen a écrit : Hi Carl, 1) Create a Writer document template with the size of the label you require or use one of the pre-supplied label formats provided with LO. 2) In order to be able to include Database Field Names, you will need to (a) be able to either conne

Re: [libreoffice-users] Re: Battle of the Office Suites: Microsoft Office and LibreOffice Compared

2013-08-19 Thread Mirosław Zalewski
On 19/08/2013 at 02:04, Brian Barker wrote: > You seem to be disappointed that LibreOffice cannot do something > which it actually achieves very well. Please do not confuse me with Urmas. I, personally, am not disappointed with LO; at least not in the fields we are talking about right now. I ha

[libreoffice-users] Problems with line color in Writer

2013-08-19 Thread jnrigg
I have an older document that has worked well for years. It is a listing of Library book titles of authors that I am interested in. As I check out a book I use the "line" function to draw a line through the book title. The line (in a sense I am using it as an "overstrike") has always been black. M