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

You might try this:
Tools > Options > Calc > View then Under "Display" set X = Formulas
Now perform the copy and paste.

Or you can save the Calc sheet as a CSV with formulas.
File > Save As (select Text CSV) and set X = Edit filter settings
In the next pop-up set X = Save cell formulas instead of calculated values


On Mon, Jul 10, 2017 at 9:02 PM, Brian Barker <b.m.barker@btinternet.com>
wrote:

> At 23:52 10/07/2017 +0200, Wiebe van der Worp wrote:
>
> > I was watching this video: https://blog.bricsys.com/tutor
> > ials/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+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> 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+unsubscribe@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