Re: [pmwiki-users] Spreadsheet style calculations

Dr Fred C Sun, 31 Dec 2006 19:23:15 -0800

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* <[EMAIL PROTECTED]> 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
[email protected]
http://www.pmichaud.com/mailman/listinfo/pmwiki-users

-- 

Always, Dr Fred C
[EMAIL PROTECTED]

_______________________________________________
pmwiki-users mailing list
[email protected]
http://www.pmichaud.com/mailman/listinfo/pmwiki-users

Re: [pmwiki-users] Spreadsheet style calculations

Reply via email to