Ask Your Question

Andy's profile - activity

2020-02-12 06:02:48 +0100 received badge  Student (source)
2018-05-17 15:48:10 +0100 received badge  Famous Question (source)
2017-12-16 14:10:55 +0100 received badge  Famous Question (source)
2017-07-27 14:16:14 +0100 received badge  Notable Question (source)
2017-05-10 12:31:10 +0100 received badge  Notable Question (source)
2017-03-25 08:56:11 +0100 received badge  Popular Question (source)
2017-03-09 16:27:59 +0100 commented question Force all quotes on CSV export, which Filter Option?

After some more testing it seems that with 8=false the numbers will be written to CSV as they are formatted in Libre Office, but without text delimiters – maybe it's a bug?

2017-03-09 16:17:18 +0100 received badge  Editor (source)
2017-03-09 16:10:12 +0100 received badge  Popular Question (source)
2017-03-09 16:09:58 +0100 asked a question Force all quotes on CSV export, which Filter Option?

I want to programmatically (Libre Office Basic) export a sheet to csv, while having all cells wrapped in quotes, also numbers.

According to Open Office's Documentation on Filter Options the 8th parameter will achieve that:

If false, the numbers are stored as text, with text delimiters.

Right now I tried the following:

Dim FilterOptions(1 to 9) as String
FilterOptions(1) = Asc(",") ' Field Separator
FilterOptions(2) = Asc("""") ' Text Delimiter
FilterOptions(3) = "0" ' Character Set
FilterOptions(4) = "1" ' Number of First Line
FilterOptions(5) = "1" ' Cell Format
FilterOptions(6) = "" ' Language
FilterOptions(7) = "true" ' Quote all texts
FilterOptions(8) = "false" ' Store numbers as such (or text)
FilterOptions(9) = "true" ' Save cell contents as shown

document.StoreToURL(FileURL, Join(FilterOptions(), ","))

This doesn't seem to work. Somehow the 8th option controls whether the numbers are stored as number or as shown.

I also have the feeling that these Filter Options should actually influence each other: _Save cell contents as shown_ should contradict _Store numbers as such_.

Is there any documentation on the actual behaviour of these filters? I tried to find the corresponding code on Github, but so far I wasn't lucky.

2017-03-03 13:41:44 +0100 received badge  Scholar (source)
2017-03-03 13:41:34 +0100 commented answer Why does SEARCH with regular expression (regex) fail with #VALUE!

You don't need to be offensive, man – don't you think I googled and read several help pages? It's an easy to miss detail.

2017-03-03 10:30:53 +0100 commented question Why does SEARCH with regular expression (regex) fail with #VALUE!

Enable regular expressions option is activated.

2017-03-03 10:28:28 +0100 asked a question Why does SEARCH with regular expression (regex) fail with #VALUE!

I just don't get it /:

I'm trying a very very simple SEARCH (formula) for numbers:

=SEARCH(A1;"[0-9]")

and it fails, no matter if the A1 is empty, contains text, or numbers.

It gives me #VALUE! as an error.

Why is that?

2017-03-03 10:04:41 +0100 commented answer [Calc] An way to use english formula in another language

Full path:

Extras > Options > Libre Office Calc / Formule

2015-02-06 17:47:50 +0100 commented answer [Solved] Open ods or odt files from a smb share throws damaged file error

When opening files from nautilus then, I get the following error: "error when accessing /run/user/1001/gvfs/dav:host=…,ssl=true,prefix=…"

2014-01-27 17:24:20 +0100 commented answer transferring charts from calc to writer

Actually in 4.1.3 even this messes with my formats: values on the horizontal axis are not in % anymore

2013-10-29 12:06:16 +0100 commented answer Calc cells shows only formula and not product/output

Change it to what?