A bit messy but bugs I'm aware of and some ideas and thoughts:
Track time spend on the sheet in JS and via animation on the heart button. Jump to animation frame depending on JS and vice-versa
Maybe there is a way to link to a "hidden" credits page for noJS and terminal users when they click the heart? (exclude everything except chawan)
Display a different text than "JavaScript required" in chawan. Maybe "I love you, terminal-kun"
For testing reachability of sheets tabs, create ten sheets with different names
Make the buttons look the same in Chromium, no matter if JS is enabled or not
Center text on buttons in chawan
Try to reduce/deduplicate that code further
Use loose SVG elements to hide space in elinks
When a sheet is renamed, make it happen that a numeric sheet html is generated for it (and maybe update numeric sheet links)
Fix JavaScript code for commiting so that stuff won't be thrown away
Make sure PRs do actually add everything regarding zoom and light/dark mode
Fix tab highlight in general
After commiting to the remote static website the tab highlight does not work when JS is disabled
Can localstorage changes work even when JS is disabled? So maybe allow resizing of cells and text edits? Use more CSS to allow edits via buttons?
Add a second backlink after a table has been inserted at the end of the page
Since (hidden) no-user/anonymous PRs on the org repo are not possible & joining teams is not possible when not already part of org, forking becomes necessary: but what to do when people want to do multiple changes and maybe parent repo had changes reverted and sync can't be done... maybe try to sync fork branch and when not possible create -numbered fork. It could then be named e.g. orgname-repo-n (n is the number starting from 2).
And each commit creates a branch user-update-unixtimestamp.
Any way to load content of sheet 1 via CSS when index.html is opened directly (via iframe)?
When PR'ing the heart icon button is thrown away.
Mobile users should see the tab bar when browser URL bar and/or keyboard is visible.
(There are other elements than vh to determine height: https://lyra.horse/blog/2025/08/you-dont-need-js/)
Investigate if multi-sheet commit broken when title setting (title should be changed to be set for all sheets anyways – use iframe to display? or just store in index.html and display to browsers not using JS, lol)
Investigate redirect – shouldn't happen for terminal web browsers...
Probably need to adjust the default 1.html so that less changes are necessary on the first commit...
Allow adding more sheets (and remove them on middle click + confirmation pop-up; styling via right click)
Select which sheets to contribute (via checkboxes or something)
Default table title should use last part of URL
Easy switch to other table files (e.g. from below table title or also tab bar?)
Add a version switch for
Allow foldering (save space to side) and grouping (basically putting folders on top of each other for e.g. a version system) for tabs
Allow tags for table sheets
Tab colors
Sidebar to show comments of table (and comments for me)
Table title should work without JS. Same position might be doable via CSS and for text browser above? Or just above in all cases...
fix when whole row/column/table gets size change that the row heights don't adjust implicitely
when expanding for JS disabled show background formatting and highlight when text marked...
fix position for disabled JS
fix sidebar width, colors and font + font size for disabled JS
top bar below should not be an additional 2nd line and above is missing one
left sidebar should not be an additional 2nd line
then numbers and letters and fuji emoji are not correctly positioned and background for sidebar looks wrong
then at least comment emoji position needs to be fixed, potentially other cell content too
Let's say I write text in a cell, press a formatting button, then continue writing, press a formatting button again and then continue writing and then I click between chars that have different formatting THEN you should ALWAYS take the formatting that is left to the caret, no matter what was long ago pressed by the user.
What formatting button the user presses only has relevance while editing until the caret is moved in the cell by the user.
overflow needs to stop one pixel before border on right side befor align center (also fix that it is half transparent at 50% zoom at align left)
There are font height issues with shifting up.
Investigate if sudden height increases happen when below some cell is merged...
font size change should be on same y height as rest of text (also check LibreOffice calc if it is the same as Google Sheets here)
when trying to change font size while editing text then afterwards changing font size on cell does not work (well)
(either nothing visually happening or bugging up – latter in case of height-increased cells sometimes.)
maybe try to not cut off letters too soon, especially when italic then seem to be cut off on cell ends?
Looks like there are small visual formatting issues when partial formatting text in some rare cases:
- small pixels between chars being left for underlined/strike-through after color change
- maybe selection jumping to the right after misclick next to formatting
- maybe multiple formattings getting toggled when only one was pressed
Now minor issue I noticed regarding partial cell formatting.
Let's say I have a unformatted cell I added BRUDERWAS to.
Then I edit that text, select WAS and add bold formatting to that part. And while still in editing mode I select DERWA and press bold. This then gets bold formatting which is fine so far but it looks like it doesn't allow me to press the formatting button again to take it away. Please fix.
add more info on avatar picture (user name, org name, repo name; maybe some statistics like amount of contributions total and by user?)
and ofc online/offline/foreign status (aka explaining of the colors)
investigate why fuji emoji is outside the table when JS is disabled
mobile users: drag to select should be possible. In worst case add drag points in the corners.
Apparently adding format to cells without leaving editing mode is broken
use onerror to load local stylesheet & to load app.js instead of loader.js
https://help.libreoffice.org/latest/de/text/scalc/04/01020000.html
https://help.libreoffice.org/latest/en-US/text/scalc/04/01020000.html
https://support.google.com/docs/answer/181110?hl=de&co=GENIE.Platform%3DDesktop
https://support.google.com/docs/answer/181110?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cpc-shortcuts
Ctrl+arrow keys jumps to next text in row/column or last congurent text if already on text
Border preview, dotted looks more like segmented and double does not seem to work at all
I noticed when I added a formatting to a cell and then I edit the text and partially take away the formatting on the text that on
leaving suddenly the complete text gets the cell formatting again. But why? The part where I removed the formatting should have no formatting then!
in general it looks like they are way too separated maybe?
some kind of programming language support (investigate if Google Sheets or LibreOffice supports any; default to M$ JS or VBA I guess)
some way for language change? (Probably do it via CSS and a language.css file or multiple files named lang_de.css, lang_en.css, lang_ja.css. Maybe tooltips only?)
when a cell was completely formatted and then a part of the formatting is taken away, the
formatting button is still hightled. BUT NOT THE OTHER WAY AROUND
test if local changes survive browser restart
global search for everything that can be applied, maybe also highlighting where it is? (including context-menu bringup; maybe write in the context menu that it is a context menu)
table title
somehow transfer cell dimensions / batch apply
tabs with #page1 #page2?
... and maybe more dimensions like version?
make colored circle if local (gray), user (green) or foreign repo (red)
show info on hover instead of to the right to save space
implement comments via matrix
alignment is (sometimes?) fucked up when cell sizes are changed
Maybe try to include a inspect/blame option to see who did which changes on cells / whole table and when (timestamp)
When inserting a text and makeing cell too small and then making cell bigger, it might not update text until page refresh
Show cell properties on right click including cell dimensions
Option to find cells of properties / cells that are different dimensions and option to align?
show/copy last actions
deduplicate code
remove unecessary styles
type to enter without click as option from menu
Text format should not be whole cell when chars are selected.
Option to insert other color formats e.g. rgb(), hsv(), custom format and also option for alpha (switch between input fiels & to also switch the color picker gradient?)
Option to group colors
Option to freely layout tools
Option for custom shortcuts
sometimes submitting a (single?) cell change doesn't seem to update the page? Okay, maybe it just takes time?!!!
There are sometimes some errors in console
maybe option to have fake-rounded cells
try to keep local changes if PR failes. Maybe ask user if it has been succesfull?
Or show last local change history & re-apply button?
Split styles file so that the index.html contains the necessary styles to display the table?
Option to convert spreadsheets from Google Sheets to our format
Somehow allow saving edits to HTML and then display that on codeberg
Optionally save as JSON that contains domain name
Irgendwie mehrere Tabs, vielleicht aber auch einfahc einzelne URLs/Seiten; könnten aber trotzdem dann Links zu
sein unten bspw. wenn JS verfügbar
Markdown mode for editing cells
undo/redo with multiple timelines...
maybe git commit tree to jump to revisions (and try to allow that via URL params for no-JS environments)
sort table and filter options
option to display cell bigger/smaller in percantage
print tablet option
Read in from JSON; hud
Save as JSON
Plugin system on a third branch; e.g. standalone formatting options that can be added to the toolbar or context menu. You might want to expose hooks/API
Allow custom logo/background banner/theme/branding/pop-ups
Oh.. also could there be a different thing on the title of the website? Maybe a timestamp showing when the site was changed last.
when editing cell, text needs to stay in place and retain formatting
allow pasting of images
custom JS embed to have interactive cells?
global action history
Maybe try to save settings to Codeberg user account repo? Like filters and stuff
Collapse cells
Cell locks (e.g. password protected cells or whitelist of users)
Password protected tables (or maybe decrypt e.g. with OTP and save file locally)
Option to customize the sidebar labels/look
user settings should be in JSON e.g. position of toolbar, color scheme, etc. You might force roles for users.
maybe on mobile selection bring up a pop-up asking to temporarily save selection too add a second one?
maybe save editor name and timestamp in table cells as metadata... tho timestamp could also be gotten from revision... tho individual cell timestamp could be more precise
option to rotate text
option to line break text in cell to prevent overflowing
option to cut off text to prevent overflowing
maybe option for text bg and not cell bg?
cell background pattern options? Aka multiple colors per cell and shapes
blinking formatting and animations cause why not, lol.
custom html element input
maybe allow introducing custom formatting functions
maybe allow changing code of certain formatting functions
so basically vscode web, lol...
search and replace dialog
for table with multiple tabs maybe use subfolders (for individual URLs /documentation/tab1 /documentation/tab2)
and a HTML file containing the tabs and loading the respective tables via iframes?
alternative would be to use one repo per tab but ugh...
or css but problem with this would be everything below in some text web browser due to non-functioning tabs or straight up missing tables
test on new repo alongside different branch names + create README
Maybe try to make stuff load progressively... table first, viewing JS stuff afterwards and editing JS stuff last – maybe on click after first use of a function?
Maybe combine the favicon image with a spreadsheet and a mountain emoji U+1D11C
Comments should lead to notifications. If not possible to use somehow Codeberg infra then store in personal repo timestamp or hash as read confirmation
Allow markdown in comment
Better Markdown in the comments
Better changelog for table-wide changes (also maybe for row/column-wide changes?)
Export list of local changes as JSON or HTML or Markdown or whatever makes the most sense
Edited indicator * should only be added when the edit comment is actually not already existing on remote
Maybe option to save avatars to table and not fetch it – to provide an image to JS users and/or preserve history
Is there a way to automatically merge from trusted users without creating PR
Come up with something that helps in the case somebody tries to merge a modified version on top after somebody modified the same version (change overwrite-prevention)
Move pop-up when JS is disabled even more to the right
Maybe have something above the table when JS is disabled like text. Would also be neat to have the table start at the same y height
Maybe add multiple additional columns to allow reading the whole overflown text. Needs to be calculated beforehand.
Red bubble to show newer revisions need to periodically look
There might be a bug for row-wide changes for bg color where multiple cells still appear on changelog
Use git worktrees to load code and page locallyw?
git checkout pages
Schwerwiegend: 'pages' wird bereits von Arbeitsverzeichnis in '/home/duda/verbosecell-pages-worktree' verwendet
git worktree list
/home/duda/verbosecell 0dc7195 [spreadsheet]
/home/duda/verbosecell-pages-worktree a803f2d [pages]
Actually support nodejs for local testing? meh...
Revision history should allow loading for all sheets via checkmark selection of changed sheets
Storing table data entirely in a SVG would also be something... lol
(Might be worth it more than json?)
(And we may be able to just offer download of the existing table as json or SVG without using JS)
Implement something like kill.js to show some different (status?) text in iframe when unfocused.
Also maybe show a red circle/dot when there is an update on the remote branch and also in text
Is there some way to show random text with JS disabled? (Shown when hovered over heart button)
A bit messy but bugs I'm aware of and some ideas and thoughts:
```
Track time spend on the sheet in JS and via animation on the heart button. Jump to animation frame depending on JS and vice-versa
Maybe there is a way to link to a "hidden" credits page for noJS and terminal users when they click the heart? (exclude everything except chawan)
Display a different text than "JavaScript required" in chawan. Maybe "I love you, terminal-kun"
For testing reachability of sheets tabs, create ten sheets with different names
Make the buttons look the same in Chromium, no matter if JS is enabled or not
Center text on buttons in chawan
Try to reduce/deduplicate that code further
Use loose SVG elements to hide space in elinks
When a sheet is renamed, make it happen that a numeric sheet html is generated for it (and maybe update numeric sheet links)
Fix JavaScript code for commiting so that stuff won't be thrown away
Make sure PRs do actually add everything regarding zoom and light/dark mode
Fix tab highlight in general
After commiting to the remote static website the tab highlight does not work when JS is disabled
Can localstorage changes work even when JS is disabled? So maybe allow resizing of cells and text edits? Use more CSS to allow edits via buttons?
Add a second backlink after a table has been inserted at the end of the page
Since (hidden) no-user/anonymous PRs on the org repo are not possible & joining teams is not possible when not already part of org, forking becomes necessary: but what to do when people want to do multiple changes and maybe parent repo had changes reverted and sync can't be done... maybe try to sync fork branch and when not possible create -numbered fork. It could then be named e.g. orgname-repo-n (n is the number starting from 2).
And each commit creates a branch user-update-unixtimestamp.
Any way to load content of sheet 1 via CSS when index.html is opened directly (via iframe)?
When PR'ing the heart icon button is thrown away.
Mobile users should see the tab bar when browser URL bar and/or keyboard is visible.
(There are other elements than vh to determine height: https://lyra.horse/blog/2025/08/you-dont-need-js/)
Investigate if multi-sheet commit broken when title setting (title should be changed to be set for all sheets anyways – use iframe to display? or just store in index.html and display to browsers not using JS, lol)
Investigate redirect – shouldn't happen for terminal web browsers...
Probably need to adjust the default 1.html so that less changes are necessary on the first commit...
Allow adding more sheets (and remove them on middle click + confirmation pop-up; styling via right click)
Select which sheets to contribute (via checkboxes or something)
Default table title should use last part of URL
Easy switch to other table files (e.g. from below table title or also tab bar?)
Add a version switch for
Allow foldering (save space to side) and grouping (basically putting folders on top of each other for e.g. a version system) for tabs
Allow tags for table sheets
Tab colors
Sidebar to show comments of table (and comments for me)
Table title should work without JS. Same position might be doable via CSS and for text browser above? Or just above in all cases...
fix when whole row/column/table gets size change that the row heights don't adjust implicitely
when expanding for JS disabled show background formatting and highlight when text marked...
fix position for disabled JS
fix sidebar width, colors and font + font size for disabled JS
top bar below should not be an additional 2nd line and above is missing one
left sidebar should not be an additional 2nd line
then numbers and letters and fuji emoji are not correctly positioned and background for sidebar looks wrong
then at least comment emoji position needs to be fixed, potentially other cell content too
Let's say I write text in a cell, press a formatting button, then continue writing, press a formatting button again and then continue writing and then I click between chars that have different formatting THEN you should ALWAYS take the formatting that is left to the caret, no matter what was long ago pressed by the user.
What formatting button the user presses only has relevance while editing until the caret is moved in the cell by the user.
overflow needs to stop one pixel before border on right side befor align center (also fix that it is half transparent at 50% zoom at align left)
There are font height issues with shifting up.
Investigate if sudden height increases happen when below some cell is merged...
font size change should be on same y height as rest of text (also check LibreOffice calc if it is the same as Google Sheets here)
when trying to change font size while editing text then afterwards changing font size on cell does not work (well)
(either nothing visually happening or bugging up – latter in case of height-increased cells sometimes.)
maybe try to not cut off letters too soon, especially when italic then seem to be cut off on cell ends?
Looks like there are small visual formatting issues when partial formatting text in some rare cases:
- small pixels between chars being left for underlined/strike-through after color change
- maybe selection jumping to the right after misclick next to formatting
- maybe multiple formattings getting toggled when only one was pressed
Now minor issue I noticed regarding partial cell formatting.
Let's say I have a unformatted cell I added BRUDERWAS to.
Then I edit that text, select WAS and add bold formatting to that part. And while still in editing mode I select DERWA and press bold. This then gets bold formatting which is fine so far but it looks like it doesn't allow me to press the formatting button again to take it away. Please fix.
add more info on avatar picture (user name, org name, repo name; maybe some statistics like amount of contributions total and by user?)
and ofc online/offline/foreign status (aka explaining of the colors)
investigate why fuji emoji is outside the table when JS is disabled
mobile users: drag to select should be possible. In worst case add drag points in the corners.
Apparently adding format to cells without leaving editing mode is broken
use onerror to load local stylesheet & to load app.js instead of loader.js
https://help.libreoffice.org/latest/de/text/scalc/04/01020000.html
https://help.libreoffice.org/latest/en-US/text/scalc/04/01020000.html
https://support.google.com/docs/answer/181110?hl=de&co=GENIE.Platform%3DDesktop
https://support.google.com/docs/answer/181110?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cpc-shortcuts
Ctrl+arrow keys jumps to next text in row/column or last congurent text if already on text
Border preview, dotted looks more like segmented and double does not seem to work at all
I noticed when I added a formatting to a cell and then I edit the text and partially take away the formatting on the text that on
leaving suddenly the complete text gets the cell formatting again. But why? The part where I removed the formatting should have no formatting then!
in general it looks like they are way too separated maybe?
some kind of programming language support (investigate if Google Sheets or LibreOffice supports any; default to M$ JS or VBA I guess)
some way for language change? (Probably do it via CSS and a language.css file or multiple files named lang_de.css, lang_en.css, lang_ja.css. Maybe tooltips only?)
when a cell was completely formatted and then a part of the formatting is taken away, the
formatting button is still hightled. BUT NOT THE OTHER WAY AROUND
test if local changes survive browser restart
global search for everything that can be applied, maybe also highlighting where it is? (including context-menu bringup; maybe write in the context menu that it is a context menu)
table title
somehow transfer cell dimensions / batch apply
tabs with #page1 #page2?
... and maybe more dimensions like version?
make colored circle if local (gray), user (green) or foreign repo (red)
show info on hover instead of to the right to save space
implement comments via matrix
alignment is (sometimes?) fucked up when cell sizes are changed
Maybe try to include a inspect/blame option to see who did which changes on cells / whole table and when (timestamp)
When inserting a text and makeing cell too small and then making cell bigger, it might not update text until page refresh
Show cell properties on right click including cell dimensions
Option to find cells of properties / cells that are different dimensions and option to align?
show/copy last actions
deduplicate code
remove unecessary styles
type to enter without click as option from menu
Text format should not be whole cell when chars are selected.
Option to insert other color formats e.g. rgb(), hsv(), custom format and also option for alpha (switch between input fiels & to also switch the color picker gradient?)
Option to group colors
Option to freely layout tools
Option for custom shortcuts
sometimes submitting a (single?) cell change doesn't seem to update the page? Okay, maybe it just takes time?!!!
There are sometimes some errors in console
maybe option to have fake-rounded cells
try to keep local changes if PR failes. Maybe ask user if it has been succesfull?
Or show last local change history & re-apply button?
Split styles file so that the index.html contains the necessary styles to display the table?
Option to convert spreadsheets from Google Sheets to our format
Somehow allow saving edits to HTML and then display that on codeberg
Optionally save as JSON that contains domain name
Irgendwie mehrere Tabs, vielleicht aber auch einfahc einzelne URLs/Seiten; könnten aber trotzdem dann Links zu
sein unten bspw. wenn JS verfügbar
Markdown mode for editing cells
undo/redo with multiple timelines...
maybe git commit tree to jump to revisions (and try to allow that via URL params for no-JS environments)
sort table and filter options
option to display cell bigger/smaller in percantage
print tablet option
Read in from JSON; hud
Save as JSON
Plugin system on a third branch; e.g. standalone formatting options that can be added to the toolbar or context menu. You might want to expose hooks/API
Allow custom logo/background banner/theme/branding/pop-ups
Oh.. also could there be a different thing on the title of the website? Maybe a timestamp showing when the site was changed last.
when editing cell, text needs to stay in place and retain formatting
allow pasting of images
custom JS embed to have interactive cells?
global action history
Maybe try to save settings to Codeberg user account repo? Like filters and stuff
Collapse cells
Cell locks (e.g. password protected cells or whitelist of users)
Password protected tables (or maybe decrypt e.g. with OTP and save file locally)
Option to customize the sidebar labels/look
user settings should be in JSON e.g. position of toolbar, color scheme, etc. You might force roles for users.
maybe on mobile selection bring up a pop-up asking to temporarily save selection too add a second one?
maybe save editor name and timestamp in table cells as metadata... tho timestamp could also be gotten from revision... tho individual cell timestamp could be more precise
option to rotate text
option to line break text in cell to prevent overflowing
option to cut off text to prevent overflowing
maybe option for text bg and not cell bg?
cell background pattern options? Aka multiple colors per cell and shapes
blinking formatting and animations cause why not, lol.
custom html element input
maybe allow introducing custom formatting functions
maybe allow changing code of certain formatting functions
so basically vscode web, lol...
search and replace dialog
for table with multiple tabs maybe use subfolders (for individual URLs /documentation/tab1 /documentation/tab2)
and a HTML file containing the tabs and loading the respective tables via iframes?
alternative would be to use one repo per tab but ugh...
or css but problem with this would be everything below in some text web browser due to non-functioning tabs or straight up missing tables
test on new repo alongside different branch names + create README
Maybe try to make stuff load progressively... table first, viewing JS stuff afterwards and editing JS stuff last – maybe on click after first use of a function?
Maybe combine the favicon image with a spreadsheet and a mountain emoji U+1D11C
Comments should lead to notifications. If not possible to use somehow Codeberg infra then store in personal repo timestamp or hash as read confirmation
Allow markdown in comment
Better Markdown in the comments
Better changelog for table-wide changes (also maybe for row/column-wide changes?)
Export list of local changes as JSON or HTML or Markdown or whatever makes the most sense
Edited indicator * should only be added when the edit comment is actually not already existing on remote
Maybe option to save avatars to table and not fetch it – to provide an image to JS users and/or preserve history
Is there a way to automatically merge from trusted users without creating PR
Come up with something that helps in the case somebody tries to merge a modified version on top after somebody modified the same version (change overwrite-prevention)
Move pop-up when JS is disabled even more to the right
Maybe have something above the table when JS is disabled like text. Would also be neat to have the table start at the same y height
Maybe add multiple additional columns to allow reading the whole overflown text. Needs to be calculated beforehand.
Red bubble to show newer revisions need to periodically look
There might be a bug for row-wide changes for bg color where multiple cells still appear on changelog
Use git worktrees to load code and page locallyw?
git checkout pages
Schwerwiegend: 'pages' wird bereits von Arbeitsverzeichnis in '/home/duda/verbosecell-pages-worktree' verwendet
git worktree list
/home/duda/verbosecell 0dc7195 [spreadsheet]
/home/duda/verbosecell-pages-worktree a803f2d [pages]
Actually support nodejs for local testing? meh...
Revision history should allow loading for all sheets via checkmark selection of changed sheets
Storing table data entirely in a SVG would also be something... lol
(Might be worth it more than json?)
(And we may be able to just offer download of the existing table as json or SVG without using JS)
Implement something like kill.js to show some different (status?) text in iframe when unfocused.
Also maybe show a red circle/dot when there is an update on the remote branch and also in text
Is there some way to show random text with JS disabled? (Shown when hovered over heart button)
```