MathGroup Archive 2009

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Re: Re: undocumented feature: TableView

  • To: mathgroup at smc.vnet.net
  • Subject: [mg103909] Re: [mg103871] Re: [mg103843] Re: undocumented feature: TableView
  • From: Ariel Sepúlveda <sepulveda.cuevas at gmail.com>
  • Date: Mon, 12 Oct 2009 06:37:07 -0400 (EDT)

I use SpreadsheetViewMXL for viewing and editing tabular data
(http://www.prontoanalytics.com/products/mxlplus/documentation.htm).  With
SpreadsheetViewMXL you can dynamically resize the window size, edit values,
assign data (complete dataset or only data in window) to a variable and
export to different formats.  You can also sort by one or more columns, find
values and do some other useful things like printing data and freezing
columns, inserting/deleting rows or columns etc.  The documentation for
OutputViewMXL shows that SpreadsheetViewMXL can also be used with nested
data.

Right now TableView is very limited in its ability to display large
datasets.  I tested with 10,000 rows in TableView and it couldn't handle it.
SpreadsheetViewMXL can manage much larger datasets.  This seems to be based
on the need of TableView to create an image for the complete dataset and
then use Pane to display only part of that big image.  On the other hand,
SpreadsheetViewMXL only creates an image of the data in the dynamically
defined window dimensions.  If my assumptions are right the design of
TableView will make it more suitable for small datasets. 

It seems like there will be space for the effective co-existence of both
solutions.


-----Original Message-----
From: Murray Eisenberg [mailto:murray at math.umass.edu] 
Sent: Saturday, October 10, 2009 7:08 AM
To: mathgroup at smc.vnet.net
Subject: [mg103909] [mg103871] Re: [mg103843] Re: undocumented feature: TableView

TableView does allow a nice display of tabular data. And right-clicking 
rows or columns provides useful possibilities.

Perhaps a more interesting question is how the display functionality 
might be extended (unless already there!) so that one can retrieve the 
table currently displayed in the TableView output.  Of course it's 
unclear how this could/should be done: the result of TableView is 
already the table you see

Right now, of course, one can use the menu item Insert > Table/Matrix to 
input tabular data, but I've always found using that a bit clunky: 
unless you start in the top left placeholder and carefully tab from each 
placeholder to the next, it's too easy to find the cursor outside any 
placeholder.

With TableView, it's really easy to just click anywhere within one of 
the spreadsheet-like cells and type, delete, etc.

Moreover, if the added functionality were there, then TableView would be 
a really nice way to gather tabular input interactively, with minimal 
programming compared with what would now be required.

Right now, one can almost get the functionality with TableView that I'd 
like, but it's awkward. For example, suppose first you evaluate:

   TableView[Table[0, {3}, {2}]]

Then you go ahead and change some of the entries so that you see in the 
display, e.g.:

   2      -5
   hello  1+1
   2/3    Plot[x^2,{x,0,1}]

The new values are not yet assigned to anything.  But the changed table 
is a result -- still in an output cell -- and the content of an output 
cell can be used as input:

   data = List@@First[%];
   data // InputForm
{{2, "-5"}, {"hello", "1+1"}, {"2/3", "2+3I"}}
    ToExpression[data]  (* evaluates the cell contents *)

Perhaps there's some way, using Dynamic, that one does not need to do 
things as I've just shown, so that TableView could in fact be used for 
interactive data input, under program control.

Let's hope that WRI brings TableView into more public view and enhances 
it in future releases.

David Reiss wrote:
> By the way, it is pretty easy to drill down in something like this to
> fine new undocumented functions in interesting Contexts by using the
> trick in my previous post as well as simple things like
> 
> Names["TableView `*"]
> 
> It seems like TableView is in a somewhat advanced state of
> development.  And one could use it to create a pretty sophisticated
> spreadsheet application with multiple sheets and so on.  With a parser
> for Excel functions one could import Excel sheets with their
> associated functionality...  (now, do I have time to do this?  No,
> but...)
> 
> Here is an example of TableView's use for multiple sheets...
> 
> 
> TabView[{40 ->
>    TableView[40 IdentityMatrix[40], ContentSize -> {400, 300}],
>   20 -> TableView[20 IdentityMatrix[20], ContentSize -> {400, 300}],
>   10 -> TableView[10 IdentityMatrix[10], ContentSize -> {400, 300}]}]
> 
> 
> 
> 
> 
>  Oct 8, 7:49 am, Guido Tripaldi <gu... at gtripaldi.it> wrote:
>> Hello,
>>
>> today I typed by accident "TableView" instead of "TableForm" writing a =
>  
>> notebook, so I discovered a function apparently not documented in  
>> Mathematica 7 / Mac version. "TableView" displays a list in a  
>> spreadsheet-like format.  I tried to search the DocumentationCenter  
>> without finding any information, neither Google nor Wolfram search  
>> engine gave better results. The only documentation I found was using  
>> the "Information -  (??)" command. It show the options that TableView =
>  
>> accepts.
>>
>> It appears to be very useful, as it introduces a more flexible way to  
>> observing the data. There are infact some data editing features  
>> accessible through a popup menu (a "+" icon on the top left of the  
>> view) and others ctrl-clicking the view (ctrl-click on Mac; right-
>> click on Windows).
>>
>> Perhaps it is a new feature being finalized that will be included in  
>> next version. Someone maybe knows something more about this function?
>>
>> In[1]:=  mylist = Table[ Subscript[a, i, j], {i, 5}, {j, 3}  ] =
>      
>> (*   a little matrix   *)
>>
>> In[2]:=  mylist // TableView     (*   show it as a small spread=
> sheet    
>> *)
>>
>> In[3]:=  ?? TableView
>>     System`TableView
>>     Attributes[TableView] = {Protected, ReadProtected}
>>
>>     Options[TableView] := {Background -> None, BaseStyle -> {},
>>        DefaultBaseStyle -> "TableView", DefaultLabelStyle ->  
>> "TableViewLabel",
>>        FrameStyle -> GrayLevel[0.85], ContentSize -> Automatic, =
>  
>> ItemSize -> 10,
>>        LabelStyle -> {}, RotateLabel -> False, Spacings -> Automa=
> tic,
>>        TableHeadings -> {Automatic, Automatic}}
>>
>> Guido
> 
> 

-- 
Murray Eisenberg                     murray at math.umass.edu
Mathematics & Statistics Dept.
Lederle Graduate Research Tower      phone 413 549-1020 (H)
University of Massachusetts                413 545-2859 (W)
710 North Pleasant Street            fax   413 545-1801
Amherst, MA 01003-9305



  • Prev by Date: Re: Re: Re: undocumented feature: TableView
  • Next by Date: Re: Re: Re: How to find which variable caused
  • Previous by thread: Re: Re: Re: undocumented feature: TableView
  • Next by thread: For interest: oil prices with FX for comparison