<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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. <br>
<br>
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... <br>
<br>
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... <br>
<br>
DaveG wrote:
<blockquote cite="mid45973F20.4010501@solidgone.com" type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">
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* <a class="moz-txt-link-rfc2396E" href="mailto:pmwiki@solidgone.com"><pmwiki@solidgone.com></a> 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! <a class="moz-txt-link-rfc2396E" href="http://maps.live.com/?wip=51"><http://maps.live.com/?wip=51></a>
</pre>
</blockquote>
<pre wrap=""><!---->
_______________________________________________
pmwiki-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pmwiki-users@pmichaud.com">pmwiki-users@pmichaud.com</a>
<a class="moz-txt-link-freetext" href="http://www.pmichaud.com/mailman/listinfo/pmwiki-users">http://www.pmichaud.com/mailman/listinfo/pmwiki-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Always, Dr Fred C
<a class="moz-txt-link-abbreviated" href="mailto:drfredc@drfredc.com">drfredc@drfredc.com</a></pre>
</body>
</html>