Hi,
I'd like to implement calculating with a spreadsheet with the plugin: $:/
plugins/ebalster/formula.
But the style of it is for my purpose of writing recipes not really nice. I
already adjusted it a little bit.
I wrote in the tiddler:
\define ss_cols() a b c d e f g
\define ss_rows() 1 2 3 4 5 6
\define ss_cell() $(c)$$(r)$
<$tiddler tiddler="Spreadsheet/Data">
<$vars popupState=<<qualify "$:/temp/spreadsheet/pop">> popupCell=<<qualify
"$:/temp/spreadsheet/popcell">> >
<$reveal type="popup" state=<<popupState>> >
<div class="tc-drop-down tc-popup-keep">
<$set name="cell" filter="[title<popupCell>get[text]]">
''<<cell>>'': <$edit-text tag=input index=<<cell>> size=100 />
<$button
class="tc-btn-invisible">{{$:/core/images/save-button}}<$action-setfield
$tiddler=<<popupState>> text=""/></$button>
</$set>
</div>
</$reveal>
<table>
<tr><th></th><$list variable=c filter=<<ss_cols>>
><th><<c>></th></$list></tr>
<$list variable=r filter=<<ss_rows>> >
<tr>
<th style="padding:0;"><<r>></th>
<$list variable=c filter=<<ss_cols>> ><td style="padding:0;">
<$button popup=<<popupState>>
style="width:100%;margin:0;padding:6px;display:block;background:none;border:none;cursor:pointer;"><$action-setfield
$tiddler=<<popupCell>> text=<<ss_cell>>/> <$formula formula=<<ss_cell>>/>
</$button>
</td>
</$list>
</tr>
</$list>
</table>
</$vars>
<!-- <table>
<tr><th></th><$list variable=c filter=<<ss_cols>>
><th><<c>></th></$list></tr>
<$list variable=r filter=<<ss_rows>> >
<tr><th><<r>></th><$list variable=c filter=<<ss_cols>> ><td><$edit-text
tag=input index=<<ss_cell>> size=10/></td></$list></tr>
</$list>
</table> -->
</$tiddler>
*But how could I adjust the following:*
The first row (called header, right??) and the first column (don't know how
it's called) should be invisible- or even better only visible when hovering
over it.
And maybe, it would be possible to wrap cells together, if in cells is no
content?
And I'd like to hide the content of a specific cell.
Would be great, if you could help me with that :-)
THANKS for this great helping community!
Surya
--
You received this message because you are subscribed to the Google Groups
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/5a35ddbf-14b5-47b4-b4d8-fee51b4dbae1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
