Re: [libreoffice-users] Pasting data from LO Calc to BricsCAD

[Brian Barker]

At 23:52 10/07/2017 +0200, Wiebe van der Worp wrote:
I was watching this video: 
https://blog.bricsys.com/tutorials/bricscad-spreadsheet-import/ It 
describes two methods to get data from a spreadsheet to a CAD table 
entity. The first method uses csv from Calc, imported to CAD. The 
second method is a paste special procedure with Excel (viewer) with 
preservation of (a limited set of) formulas. The question concerns 
the second method: Is there an easy way to achieve this with Calc 
without an Excel viewer?


Surely the answer is just to suck it and see? You can copy a range of 
a spreadsheet sheet from Calc just as you could from Microsoft Excel 
or the Excel Viewer. The question then is what your other product 
makes of that in pasting it in. Try Paste and try Paste Special, and 
try whatever options that offers. The copy from Calc will carry 
formulae; the only question is whether your other product can use 
this properly. I'd guess it probably would, but I don't have it to try.


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Fwd: + session of Calc: everything scares frightfully.

[Steve Edmonds]

On 11/07/17 09:16, Paolo Del Romano wrote:

2017-07-10 23:03 GMT+02:00 Steve Edmonds :

Hi.
What version of Libreoffice do you have, also how much RAM in your PC.
Steve



LibreOffice Versione: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2
Thread CPU: 4; Versione SO: Linux 4.4; Resa interfaccia: predefinito;
Versione locale: it-IT (it_IT.UTF-8); Calc: group

RAM 14GB

AMD A8-7600 Radeon R7, 10 Compute Cores 4C+6G × 4

Paolo
There are some memory consumption bugs with LO but it might take some 
time to notice it with 14GB RAM.

I have 32GB and it is usually a few weeks before I start noticing.

There is this older thread similar. 
http://nabble.documentfoundation.org/Slow-response-time-with-Calc-td4202227.html

You could try updateing to LO 5.2
steve

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Pasting data from LO Calc to BricsCAD

[Wiebe van der Worp]

Hello everyone, I was watching this video:
https://blog.bricsys.com/tutorials/bricscad-spreadsheet-import/

It describes two methods to get data from a spreadsheet to a CAD table
entity. The first method uses csv from Calc, imported to CAD. The second
method is a paste special procedure with Excel (viewer) with
preservation of (a limited set of) formulas.

The question concerns the second method: Is there an easy way to achieve
this with Calc without an Excel viewer?

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Fwd: + session of Calc: everything scares frightfully.

[Steve Edmonds]

Hi.
What version of Libreoffice do you have, also how much RAM in your PC.
Steve

On 11/07/17 07:39, Bruce Hohl wrote:

By "rebuild" I mean that the worksheet is manually recreated starting with
a blank worksheet.  As much as practical enter again formulas.  Data can be
copied from the original worksheet but use "Edit > Paste Special as Text,
Numbers or Date & time".  Add needed formatting to the new worksheet (do
not copy formatting from the old worksheet).   There is no guarantee this
will solve the problem.  Consider this to be a test.  Be happy if this
works!

On Mon, Jul 10, 2017 at 1:46 PM, Paolo Del Romano 
wrote:


Try to explain me better.

If I open two or three sheets of calc at the same time, everything slows
down

Paolo

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Fwd: + session of Calc: everything scares frightfully.

[Bruce Hohl]

By "rebuild" I mean that the worksheet is manually recreated starting with
a blank worksheet.  As much as practical enter again formulas.  Data can be
copied from the original worksheet but use "Edit > Paste Special as Text,
Numbers or Date & time".  Add needed formatting to the new worksheet (do
not copy formatting from the old worksheet).   There is no guarantee this
will solve the problem.  Consider this to be a test.  Be happy if this
works!

On Mon, Jul 10, 2017 at 1:46 PM, Paolo Del Romano 
wrote:

> Try to explain me better.
>
> If I open two or three sheets of calc at the same time, everything slows
> down
>
> Paolo
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Fwd: + session of Calc: everything scares frightfully.

[Bruce Hohl]

Just a few general comments:

LibreOffice is a relative large desktop application so if you have a low
resource computer (old or very low cost) performance will be slower with
more open worksheets.

Performance is affected by the "size" of each worksheet.  "Size" somewhat
difficult to measure but more cells used, more formulas used and more
formatting used affect performance.

I have a few large worksheets for which I uncheck "Menu > Data >
AutoCalculate".  I must then press F9 to update the formulas.

Several times on this mailing list people have reported slow performance
related to cell formatting.  Some worksheets converted from Excel include
formatting "baggage" which can slow performance.  Sometimes I rebuild these
worksheets in LibreOffice to leave this "baggage" behind.

On Mon, Jul 10, 2017 at 1:46 PM, Paolo Del Romano 
wrote:

> Try to explain me better.
>
> If I open two or three sheets of calc at the same time, everything slows
> down
>
> Paolo
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Fwd: + session of Calc: everything scares frightfully.

[Paolo Del Romano]

Try to explain me better.

If I open two or three sheets of calc at the same time, everything slows down

Paolo

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: + session of Calc: everything scares frightfully.

[Paolo Del Romano]

Try to explain me better. If I open two or three sheets of calc at the
same time, everything slows down

2017-07-10 12:02 GMT+02:00 Paolo Del Romano :
> users@global.libreoffice.org
>
>
>
> I have the following problem.
> When launching more Libreoffice scales at the same time, everything
> scares frightfully.
>
> I use linux and then paste my software versions.
>
> Greetings
> Paolo
>
>
>
>
> ***
>
> Versione: 5.1.6.2
> Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2
> Thread CPU: 4; Versione SO: Linux 4.4; Resa interfaccia: predefinito;
> Versione locale: it-IT (it_IT.UTF-8); Calc: group
>
> **
>
>
> paolo@paolo-PC686:~$ uname -a
> Linux paolo-PC686 4.4.0-83-generic #106-Ubuntu SMP Mon Jun 26 17:54:43
> UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
>
>
> 
>
> paolo@paolo-PC686:~$ cat /etc/*release
> DISTRIB_ID=Ubuntu
> DISTRIB_RELEASE=16.04
> DISTRIB_CODENAME=xenial
> DISTRIB_DESCRIPTION="Ubuntu 16.04.2 LTS"
> NAME="Ubuntu"
> VERSION="16.04.2 LTS (Xenial Xerus)"
> ID=ubuntu
> ID_LIKE=debian
> PRETTY_NAME="Ubuntu 16.04.2 LTS"
> VERSION_ID="16.04"
> HOME_URL="http://www.ubuntu.com/;
> SUPPORT_URL="http://help.ubuntu.com/;
> BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/;
> VERSION_CODENAME=xenial
> UBUNTU_CODENAME=xenial
>
>
> **
>
> --
> Paolo Del Romano
> delrom...@gmail.com
> PEC: paolo.delrom...@pec.commercialisti.it
> cell. 327-3504844



-- 
Paolo Del Romano
delrom...@gmail.com
PEC: paolo.delrom...@pec.commercialisti.it
cell. 327-3504844

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] + session of Calc: everything scares frightfully.

[Bruce Hohl]

Paolo,  Regarding your problem, please provide more information.

On Mon, Jul 10, 2017 at 6:02 AM, Paolo Del Romano 
wrote:

> users@global.libreoffice.org
>
>
>
> I have the following problem.
> When launching more Libreoffice scales at the same time, everything
> scares frightfully.
>
> I use linux and then paste my software versions.
>
> Greetings
> Paolo
>
>
>
>
> ***
>
> Versione: 5.1.6.2
> Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2
> Thread CPU: 4; Versione SO: Linux 4.4; Resa interfaccia: predefinito;
> Versione locale: it-IT (it_IT.UTF-8); Calc: group
>
> **
>
>
> paolo@paolo-PC686:~$ uname -a
> Linux paolo-PC686 4.4.0-83-generic #106-Ubuntu SMP Mon Jun 26 17:54:43
> UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
>
>
> 
>
> paolo@paolo-PC686:~$ cat /etc/*release
> DISTRIB_ID=Ubuntu
> DISTRIB_RELEASE=16.04
> DISTRIB_CODENAME=xenial
> DISTRIB_DESCRIPTION="Ubuntu 16.04.2 LTS"
> NAME="Ubuntu"
> VERSION="16.04.2 LTS (Xenial Xerus)"
> ID=ubuntu
> ID_LIKE=debian
> PRETTY_NAME="Ubuntu 16.04.2 LTS"
> VERSION_ID="16.04"
> HOME_URL="http://www.ubuntu.com/;
> SUPPORT_URL="http://help.ubuntu.com/;
> BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/;
> VERSION_CODENAME=xenial
> UBUNTU_CODENAME=xenial
>
>
> **
>
> --
> Paolo Del Romano
> delrom...@gmail.com
> PEC: paolo.delrom...@pec.commercialisti.it
> cell. 327-3504844
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Problem with LibreOffice 5

[Tom Williams]

On 07/09/2017 02:33 PM, Tom Davies wrote:
> Hi :) 
> There was a Win 10 update that messed up the permissions in one of the
> places i volunteer at. 
>
> I have no idea how to fix it.  I think we went through each individual
> folder to reset the permissions but that sounds like a very
> inefficient and highly error-prone way of trying to fix it generally. 
> Still, 'everyone' loves Windows. 
>
> Regards from
> Tom :) 

Wow. Craziness.   :)

Peace...

"The Other" Tom
>
>
>
> On 9 July 2017 at 17:46, Tom Williams  > wrote:
>
> On 07/08/2017 02:56 AM, MICHAEL HELY wrote:
> > I am having trouble with this suite.   Normally I have been able
> to open, amend, and save a document without any problem.   
> However, in the last week or so I can only open a document in
> read-only form.   To change the contents I have to open a copy for
> editing, save that under a different name, delete the original,
> and then rename the new document to fit in with my filing system. 
>This is time consuming, and very inconvenient.
> > The only event that I can identify as a possible cause is that
> about the same time there was an automatic update to Windows 10,
> and there might be some incompatablity between the updated Windows
> and LibreOffice.(I have since installed the latest update to
> LibreOffice5, but to no avail;  the problem is still there).   
> However that is only a wild guess! I would be grateful for
> your advice and a remedy
> > regards
> > M. Hely
> >
> I have two basic questions:
>
>  1. Have you confirmed the original file wasn't already "read-only"
> before attempting to open it?
>  2. Are you opening files from the file system or directly from an
> email
> attachment?
>
>
> These are things you have probably already thought of but I want
> to ask
> anyway.  :)   I've run LibreOffice 5 on a couple of Windows 10 systems
> and have been able to open, edit, and save documents without issue.
>
> Peace...
>
> "The Other" Tom
>
> --
> /When we dance, you have a way with me,
> Stay with me... Sway with me.../
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> 
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> 
> Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
> 
> List archive: http://listarchives.libreoffice.org/global/users/
> 
> All messages sent to this list will be publicly archived and
> cannot be deleted
>
>


-- 
/When we dance, you have a way with me,
Stay with me... Sway with me.../

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] + session of Calc: everything scares frightfully.

[Paolo Del Romano]

users@global.libreoffice.org



I have the following problem.
When launching more Libreoffice scales at the same time, everything
scares frightfully.

I use linux and then paste my software versions.

Greetings
Paolo




***

Versione: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2
Thread CPU: 4; Versione SO: Linux 4.4; Resa interfaccia: predefinito;
Versione locale: it-IT (it_IT.UTF-8); Calc: group

**


paolo@paolo-PC686:~$ uname -a
Linux paolo-PC686 4.4.0-83-generic #106-Ubuntu SMP Mon Jun 26 17:54:43
UTC 2017 x86_64 x86_64 x86_64 GNU/Linux




paolo@paolo-PC686:~$ cat /etc/*release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=16.04
DISTRIB_CODENAME=xenial
DISTRIB_DESCRIPTION="Ubuntu 16.04.2 LTS"
NAME="Ubuntu"
VERSION="16.04.2 LTS (Xenial Xerus)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 16.04.2 LTS"
VERSION_ID="16.04"
HOME_URL="http://www.ubuntu.com/;
SUPPORT_URL="http://help.ubuntu.com/;
BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/;
VERSION_CODENAME=xenial
UBUNTU_CODENAME=xenial


**

-- 
Paolo Del Romano
delrom...@gmail.com
PEC: paolo.delrom...@pec.commercialisti.it
cell. 327-3504844

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Problems with Libre Office base on Ubuntuoffice.org

[Alexander Thurgood]

Le 10/07/2017 à 06:58, Peter a écrit :

Hi Peter,

> I have an existing data base with a number of reports. These were
> working last year at tax time. Now The existing reports do not run and I
> cannot create new reports. Each time I create a new report or run an
> exiisting report the data base crashes and I have to do a recovery. The
> data base was created from within Libre base.
> 
> Where do I look for error reports and has anyone else had this problem.
> I am running the software with Ubuntu on a laptop.
> 

If you are using the Ubuntu provided version of LibreOffice, then you
should look at the Ubuntu Launchpad bug tracker to see if this has
already been reported.


Alex


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Can LO build a TOC from a PDF file?

[Gilles]

Thanks much everyone. I naively thought it could simply be done by converting
the PDF into text in LO, and run a few regexes to build a TOC :-/



--
View this message in context: 
http://nabble.documentfoundation.org/Can-LO-build-a-TOC-from-a-PDF-file-tp4217910p4217934.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted