[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.