[tw] Re: How to adjust the style of a spreadsheet (plugin: $:/plugins/ebalster/formula)?
Hello @all,
I found out now a little bit how to adjust it.
But only a little bit...
I can now adjust the first column: Not anymore grey blackground and the
font is very small- almost invisible (in that way, I can see the content
for calculating by Ctrl + scrolling up, but in normal view mode it is
almost invisible).
I also can now adjust the background from the cells, where I write the main
content. I don't need that possibility at the moment, but nice to know the
how-to.
But still I don't know how to adjust the width of the first column.
And I don't know how to adjust the background-colour, the font-size and the
height of the header.
And I don't know how to make one certain cell invisible (or better one
column).
That is what I wrote into the Spreadsheet Prototype:
\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">
Click on cells to pop up an editor. Formulas currently need to be written
in `(= =)` but cells may be referred to by their names, such as `a2`.
Ranges aren't supported yet.
<$vars popupState=<> popupCell=<> >
<$reveal type="popup" state=<> >
<$set name="cell" filter="[titleget[text]]">
''<>'': <$edit-text tag=input index=<> size=230 />
<$button
class="tc-btn-invisible">{{$:/core/images/save-button}}<$action-setfield
$tiddler=<> text=""/>
<$list variable=c filter=<>
><>
<$list variable=r filter=<> >
<>
<$list variable=c filter=<> >
<$button popup=<>
style="width:100%;margin:0;padding:6px;display:block;background:none;border:none;cursor:pointer;"><$action-setfield
$tiddler=<> text=<>/> <$formula formula=<>/>
Could someone of you please help me with that?
Thanks a lot in advance! 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 tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
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/e3af3810-1e8c-4216-aaa4-84a77ff44eb5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[tw] Re: How to adjust the style of a spreadsheet (plugin: $:/plugins/ebalster/formula)?
On Sunday, February 4, 2018 at 3:21:39 PM UTC-6, Surya wrote:
>
>
> \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">
>
> Click on cells to pop up an editor. Formulas currently need to be
> written in `(= =)` but cells may be referred to by their names, such as
> `a2`. Ranges aren't supported yet.
>
>
> <$vars popupState=<>
> popupCell=<> >
>
> <$reveal type="popup" state=<> >
>
>
> <$set name="cell" filter="[titleget[text]]">
> ''<>'': <$edit-text tag=input index=<> size=230 />
> <$button
> class="tc-btn-invisible">{{$:/core/images/save-button}}<$action-setfield
> $tiddler=<> text=""/>
>
>
>
>
>
>
I would use CSS nth-child, targeting the THs and TDs. But first, to help
the cascade better, give this table a class:
>
>
you can change that name to anything that makes sense to you.
Then in your css, to hide all the cells in column 2, write something like
this:
.my-ss-table th:nth-child(2),
.my-ss-table td:nth-child(2) {
display:none;
}
The above assumes you will have NO INNER nested TABLES with more THs and
TDs. If you DO have nested tables, change it to this:
.my-ss-table > th:nth-child(2),
.my-ss-table > td:nth-child(2) {
display:none;
}
I have not tested this... and my ability to parse other people's code is
limited, so I hope this is what you're asking for.
You can read about nth-child here:
https://developer.mozilla.org/en-US/docs/Web/CSS/:nth-child
Coda
--
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 tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
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/15fdec0e-070f-4e64-8472-aa7b308277b2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[tw] Re: How to adjust the style of a spreadsheet (plugin: $:/plugins/ebalster/formula)?
Hi Coda,
thanks for your answer :-)
I tried now to insert
and
to insert
.my-ss-table th:nth-child(2),
.my-ss-table td:nth-child(2) {
display:none;
}
at different places, but with no success at all.
Where do have to insert it in this:??
\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">
Click on cells to pop up an editor. Formulas currently need to be written
in `(= =)` but cells may be referred to by their names, such as `a2`.
Ranges aren't supported yet.
<$vars popupState=<> popupCell=<> >
<$reveal type="popup" state=<> >
<$set name="cell" filter="[titleget[text]]">
''<>'': <$edit-text tag=input index=<> size=230 />
<$button
class="tc-btn-invisible">{{$:/core/images/save-button}}<$action-setfield
$tiddler=<> text=""/>
<$list variable=c filter=<>
><>
<$list variable=r filter=<> >
<>
<$list variable=c filter=<> >
<$button popup=<>
style="width:100%;margin:0;padding:6px;display:block;background:none;border:none;cursor:pointer;"><$action-setfield
$tiddler=<> text=<>/> <$formula formula=<>/>
The above assumes you will have NO INNER nested TABLES with more THs and
> TDs. If you DO have nested tables, change it to this:
>
>>>I don't kno what inner nested tables are, so I think, I don't have such.
This what I wrote above, IS the table with calculating possibilities.
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 tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
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/5fb50b5d-4a81-4d6d-a0c1-1f785b27fc49%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[tw] Re: How to adjust the style of a spreadsheet (plugin: $:/plugins/ebalster/formula)?
On Sunday, February 4, 2018 at 4:12:45 PM UTC-6, Surya wrote:
>
> Hi Coda,
>
> thanks for your answer :-)
>
Create a spreadsheet tiddler called spreadsheet-css and give it the tag
$:/tags/Stylesheet.
Pl
Place this code in the spreadsheet tiddler:
.
> .my-ss-table th:nth-child(2),
> .my-ss-table td:nth-child(2) {
> display:none;
> }
>
--
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 tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
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/ac34188b-a963-4b03-8984-0b093e5ff97b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[tw] Re: How to adjust the style of a spreadsheet (plugin: $:/plugins/ebalster/formula)?
And, of course, if you want to hide column 6, just change the 2 to a 6.
On Sunday, February 4, 2018 at 4:19:06 PM UTC-6, coda coder wrote:
>
>
>
> On Sunday, February 4, 2018 at 4:12:45 PM UTC-6, Surya wrote:
>>
>> Hi Coda,
>>
>> thanks for your answer :-)
>>
>
> Create a spreadsheet tiddler called spreadsheet-css and give it the tag
> $:/tags/Stylesheet
>
> Place this code in the spreadsheet tiddler:
>
>
>> .my-ss-table th:nth-child(2),
>> .my-ss-table td:nth-child(2) {
>> display:none;
>> }
>>
>
>
>
--
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 tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
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/9497b00d-23a2-44fd-ade8-11ed3da14f01%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[tw] Re: How to adjust the style of a spreadsheet (plugin: $:/plugins/ebalster/formula)?
Hi Coda,
hmmm, I almost reached that goal.
The header (the first row) is now almost invisible (white background,
font-size very very small. The same with the first column.
And I made the one cell almost invisible.
But there are some strange behaviours. It seems to me, that it counts the
cells & rows different than I would count them:
The first row (header) seems to be td:nth-child(1), there I had to count
every cell (th:nth-child) from 1-9, two give the whole head-row the same
style. Okay fine, I understood.
So, in my logic the style-command for the cell "h1" should be .my-ss-table
th:nth-child(9), .my-ss-table td:nth-child(2) {
background-color:white;font-size:0.2em; }.
But it is: .my-ss-table th:nth-child(1), .my-ss-table td:nth-child(9) {
background-color:white;font-size:0.2em; }.
Okay, maybe, I don't have to understand everything. Just like almost always
in TW: "Try & error" to reach my goal ;-)
But also it made some other strange things:
It made a additional row above the table, the "" is now visible
under the table in view mode and it build a frame around the table and the
rest of the tiddler-text.
And: I can make the width of a column wider than now, but *not* smaller
than it is now.
Maybe, I should build a new wiki on tiddlyspot for testing-purposes- so
that you could better see, what I mean and see my mistakes better?
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 tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
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/d73f172f-cf16-4474-b4cf-1004cc1b0c40%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[tw] Re: How to adjust the style of a spreadsheet (plugin: $:/plugins/ebalster/formula)?
On Monday, February 5, 2018 at 5:43:00 PM UTC-6, Surya wrote: > > > It made a additional row above the table, the "" is now visible > under the table in view mode and it build a frame around the table and the > rest of the tiddler-text. > Then you have structural errors in your html. > > Maybe, I should build a new wiki on tiddlyspot for testing-purposes- so > that you could better see, what I mean and see my mistakes better? > Yes, please. :) I'm sorry I couldn't follow your description -- an example online would be better and tell us which columns you would like to hide/change with CSS. -- 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 tiddlywiki+unsubscr...@googlegroups.com. To post to this group, send email to tiddlywiki@googlegroups.com. 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/d5f6de5e-b720-4dbb-8917-ff16542310ba%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[tw] Re: How to adjust the style of a spreadsheet (plugin: $:/plugins/ebalster/formula)?
Does this help? Put it all in one tiddler...
.my-ss-table th:nth-child(1) {
background-color:yellow;
}
.my-ss-table th:nth-child(2),
.my-ss-table td:nth-child(2) {
display:none;
}
onetwothreefourfive
12345
12345
12345
--
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 tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
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/d9af43e9-311c-4569-9c32-b1d35a808e5c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[tw] Re: How to adjust the style of a spreadsheet (plugin: $:/plugins/ebalster/formula)?
Hello Coda,
Am Dienstag, 6. Februar 2018 04:21:44 UTC+1 schrieb coda coder:
>
> Does this help? Put it all in one tiddler...
>
>
>
>
> .my-ss-table th:nth-child(1) {
> background-color:yellow;
> }
> .my-ss-table th:nth-child(2),
> .my-ss-table td:nth-child(2) {
> display:none;
> }
>
>
>
>
> onetwothreefourfive
>
>
> 12345
>
>
> 12345
>
>
> 12345
>
>
>
>
>
Yes, that did it without strange behaviour :-)
Now: How to adjust the column-width of the first column (1-6) to very
narrow and how to adjust the row-height of the first row (header: a-g) to
very low? So that both are much more almost invisible (but still readable
for me, if I need them).
And how could I make the cell c6 (where "24" is written) with red
background-color or with the number 24 bold written?
And how could I make the cell f6 (where "1" is written) with very small
font-size?
All tiddlers related to this thread are pinned at the moment. And the wiki
is on http://suryas-testwiki.tiddlyspot.com/.
Thanks, 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 tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
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/08267213-09f4-4c6a-bd52-a216a56dd638%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[tw] Re: How to adjust the style of a spreadsheet (plugin: $:/plugins/ebalster/formula)?
Sorry, I forgot to write, that the last one (fitting my wishes best) adjusted with your last advice is called "Spreadsheet Prototype 2". -- 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 tiddlywiki+unsubscr...@googlegroups.com. To post to this group, send email to tiddlywiki@googlegroups.com. 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/1f78db5f-97de-4cbd-991e-2ed7167de19e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
