From mboxrd@z Thu Jan 1 00:00:00 1970 From: Steven Adrian Subject: Insert calc vector directly into spreadsheet cells? Date: Sat, 17 May 2014 21:40:29 +0000 (UTC) Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:58046) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WlmPp-0006AV-Gt for emacs-orgmode@gnu.org; Sat, 17 May 2014 17:45:21 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WlmPi-0006qR-1b for emacs-orgmode@gnu.org; Sat, 17 May 2014 17:45:13 -0400 Received: from plane.gmane.org ([80.91.229.3]:42284) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WlmPh-0006mx-Rh for emacs-orgmode@gnu.org; Sat, 17 May 2014 17:45:05 -0400 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1WlmPg-0003LA-E9 for emacs-orgmode@gnu.org; Sat, 17 May 2014 23:45:04 +0200 Received: from pool-72-66-109-185.washdc.fios.verizon.net ([72.66.109.185]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 17 May 2014 23:45:04 +0200 Received: from sadrian by pool-72-66-109-185.washdc.fios.verizon.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 17 May 2014 23:45:04 +0200 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org I would like to insert a calc vector directly into a range of spreadsheet cells from a function. As a specific example, consider the calc index function, which returns a calc vector of integers from 1 to n. Once calc has started within an emacs session, the index function can be accessed from within the scratch buffer as: (calcFunc-index 10) If the above function is evaluated, the echo area will display the calc vector returned by the function: (vec 1 2 3 4 5 6 7 8 9 10) I would like to put these values into a range of cells with a table formula like: #+TBLFM: @1$1..@1$10=index(10) But the formula above just puts the whole vector in each cell. Can anyone tell me how to put the vector values in individual cells?