[pmwiki-users] Spreadsheet style calculations

[DaveG]

If you want the ability to easily paste Excel content into PMWiki, try 
the ExcelPaste cookbook (http://pmwiki.org/wiki/Cookbook/ExcelPaste).

In the meantime, it occured to me to try and link in to Google 
spreadsheets. So the data and calculations could be stored over on the 
spreadsheet, and results could be displayed in PM. Additionally it might 
be possible to update the data from PM. I'll be looking at this over the 
next few weeks.

  ~ ~ Dave


Dr Fred C wrote:
>   It would seem that somewhere Open Office Calc should contain some 
> commonly used parsing spreadsheet code options one might develop from.  
> Ideally, it would seem one would want a spreadsheet code that is 
> portable to and from commonly available systems. 
> 
>   The fine print is, at least with my poking around in Windows, you 
> can't copy and paste from Open Office Calc or Excel or Quattro Pro into 
> a text document (or wiki text) and get the spreadsheet code to be pasted 
> -- only the results get pasted...  You can copy and paste to and from 
> Open Office or Quattro and the code is properly ported between them.  
> Excel seems typically "MS anal" about porting spreadsheet clipboards 
> from Excel, but imports OK.   Going in and out of MS appears sort of 
> like a Bible sharing Christian some how smuggling some Bibles into Iran 
> and expecting to be able to freely leave without burning their Bibles 
> before leaving...
> 
>   Perhaps there's a work around to get some commonly used spreadsheet 
> code properly copy and pasted (ported) into a wiki spreadsheet page....  
> It would seem to be very sweet power, as a start, to be able to port 
> (even simple) spreadsheet code to (and from) a wikisheet and have it 
> work.  From there, who knows... 
> 
> DaveG wrote:
>> I'll take a look at the snipit you provided. Do you have the original 
>> code handy somewhere, and some time to dig it out for me?
>>
>>   ~ ~ Dave
>>
>> J. Meijer wrote:
>>   
>>> Dave,
>>>
>>> I have a script that sums row and sums columns putting in a markup in 
>>> the summing row/column and quite a bit smarter then the code below. 
>>> Haven't looked at it in a while.
>>>
>>> Your problem is similar and could be solved using 'relative' addressing. 
>>> Recognize cells which have the sequence you need and modify them, 
>>> something like (for simple tables):
>>>
>>>   Markup('celldiv','>{$var}'
>>>     ,'/([|][|] *(\d+(?:[.,]\d+)) *[|][|] *(\d+(?:[.,]\d+)) *[|][|] 
>>> *)[(][(](+|-|/*)[)][)]/e'
>>>     ,"'$1'.($2$4$3)");
>>>
>>> This recognizes 2 numeric cells leading up to a third containing the 
>>> ((/)) markup.
>>>
>>> The same markup would allow ((+)), ((-)) and ((*)) also.
>>>
>>> It will only perform its magic on numeric inputs, it won't cascade into 
>>> formulas.
>>>
>>> /jm
>>>
>>>
>>>
>>>
>>>
>>> On 12/27/06, *DaveG* <pmwiki at solidgone.com> wrote:
>>>
>>>     Is there any way to do basic computations in PMWiki? I have an excel
>>>     spreadsheet that I'd like to move onto the wiki. The sheet has the
>>>     following columns (actually a few more, but these are the core):
>>>
>>>     Gallons - Miles - Miles/Gallon
>>>
>>>     I'd like to be able to enter the first two cols and have PM calculate
>>>     the third. Additionally I'd like to maintain a "Average of Miles/Gallon"
>>>     number as well.
>>>
>>>     Is the built-in functionaity to do this, or a Recipe somewhere?
>>>
>>>
>>>       ~ ~ Dave
>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>> Try amazing new 3D maps Check it out! <http://maps.live.com/?wip=51>
>>>     
>>
>> _______________________________________________
>> pmwiki-users mailing list
>> pmwiki-users at pmichaud.com
>> http://www.pmichaud.com/mailman/listinfo/pmwiki-users
>>
>>
>>   
> 
> -- 
> 
> Always, Dr Fred C
> drfredc at drfredc.com
>