Ask Your Question

kiloran's profile - activity

2019-03-26 10:12:40 +0200 answered a question Can I save a spreadsheet file without compression, if it reduces the loading/saving time of the file?

15 minutes to save seems way too long. I have spreadsheets with lots of formulas and opening/saving is just a matter of

2018-09-16 04:20:42 +0200 received badge  Famous Question (source)
2018-09-16 04:20:42 +0200 received badge  Notable Question (source)
2018-08-08 11:04:05 +0200 answered a question I have Libreoffice 4.3 on windows 10. My files saved w/Libre will not open. Any suggestions?

Deleting LibreOffice 4 will have no effect whatever on the files you have created. There should be no problem at all i

2018-05-02 11:03:42 +0200 answered a question Unable to run Macros on Libreoffice 5.4.3.2

You don't need Java to run most macros. Have you checked TOOLS/OPTIONS/LIBREOFFICE/SECURITY/MACRO SECURITY What is you

2018-03-09 14:02:50 +0200 commented answer Opening tab-delimited file in Calc on Windows

And I should emphasise that using OpenOffice on Windows or LibreOffice on Linux, I can open a tab-delimited file in Calc

2018-03-09 13:58:31 +0200 commented answer Opening tab-delimited file in Calc on Windows

The file extension should only matter if I am double-clicking on the file to open it in Windows using the default applic

2018-03-09 13:51:15 +0200 commented answer Opening tab-delimited file in Calc on Windows

The files will not open in Calc regardless of extension. When I open a .txt file in Calc, I am given no opportunity to s

2018-03-08 20:08:39 +0200 received badge  Popular Question (source)
2018-03-08 11:06:22 +0200 asked a question Opening tab-delimited file in Calc on Windows

Opening tab-delimited file in Calc Windows 7 and LO 6.0.1.1 64 bit I have a number of tab-delimited files, with a file

2017-12-06 08:07:56 +0200 marked best answer Libreoffice Python https problem

I'm having problems web scraping https sites using LibreOffice python. I have Libreoffice 5.3.4.2 on Windows 7, and can demonstrate the problem with this simple script:

try:
    import urllib.request
    myUrl = 'https://ask.libreoffice.org/en/questions/'
    hdr = {'User-Agent': 'Mozilla/5.0'}
    req = urllib.request.Request(url=myUrl, headers=hdr)
    response = urllib.request.urlopen(req)
except Exception as e:
    print(e)

This fails immediately with "urlopen error unknown url type: https". It works fine with an http url, but fails with any https url.

I tried the above in a LibreOffice Calc document with this embedded script and it failed. It also failed when I tried running it in a terminal window from C:\Program Files (x86)\LibreOffice 5\program\python-core-3.3.0\bin\python.exe

The script works fine with my standalone Python 3.3.2 running from a terminal window.

I've also tried various LibreOffice Portable installations I have:

4.0.2.2: Works OK
5.3.1.2: Fails
5.3.2.2: Fails

I've tried uninstalling and reinstalling 5.3.4.2 more times than I can count and cannot get it to work. Yet installing it on Windows 10 on the same PC using a VM machine, it works fine.

Any idea what is going on?

=================================

Further news 19Jul17: I tried the Safe Mode in LibreOffice 5 and the script works fine. Went back to normal mode and it failed again. Uninstalled LibreOffice 5.4.3.2 and then deleted everything I could find relating to LibreOffice. Reinstalled 5.4.3.2 x86 and the behaviour is unchanged... works OK in Safe Mode and fails in normal mode

2017-11-12 12:52:25 +0200 received badge  Famous Question (source)
2017-09-20 00:52:18 +0200 received badge  Enthusiast
2017-07-21 01:11:41 +0200 received badge  Teacher (source)
2017-07-21 01:11:41 +0200 received badge  Self-Learner (source)
2017-07-21 00:01:22 +0200 received badge  Notable Question (source)
2017-07-20 20:42:03 +0200 edited question Libreoffice Python https problem

Libreoffice Python https problem I'm having problems web scraping https sites using LibreOffice python. I have Libreoffi

2017-07-20 20:41:49 +0200 edited question Libreoffice Python https problem

Libreoffice Python https problem [Closed] I'm having problems web scraping https sites using LibreOffice python. I have

2017-07-20 20:32:07 +0200 edited question Libreoffice Python https problem

Libreoffice Python https problem I'm having problems web scraping https sites using LibreOffice python. I have Libreoffi

2017-07-20 20:32:07 +0200 received badge  Editor (source)
2017-07-20 20:29:16 +0200 answered a question Libreoffice Python https problem

Solved! Or at least I've found a work-around. This pointed me in the right direction: https://www.reddit.com/r/learnpyth

2017-07-19 20:16:19 +0200 received badge  Popular Question (source)
2017-07-19 20:08:27 +0200 edited question Libreoffice Python https problem

Libreoffice Python https problem I'm having problems web scraping https sites using LibreOffice python. I have Libreoffi

2017-07-18 11:16:22 +0200 asked a question Libreoffice Python https problem

Libreoffice Python https problem I'm having problems web scraping https sites using LibreOffice python. I have Libreoffi