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 <[email protected]> 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: [email protected] > 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: [email protected] 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
