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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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-
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
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
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
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
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
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
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
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()
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
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
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
36 matches
Mail list logo