Ideally, there would be some formatting available in each cell, for example in Markdown, and multiple rows. But I need it to be big. And I'd very much appreciate an option to display only certain columns at will.
I looked into:
- Word processors:
they would be ideal for this task but the number of columns is too big and it creates problems. MS Word on a document on A1 paper could be good but '.doc' format is a bit heavyweight and difficult to manipulate outside of Word. Anyways, for my needs it can be 6/10. EDIT: The great majority does not handle well big pages, with the exception of Pages (see below)
- Spreadsheets: they don't like multiple rows or too much formatting in the cells. Still it can be useful 5/10
- Markdown editors: I know Joplin and Macdown but tables become a mess without the GUI and the GUI itself is buggy 4/10
- Make my own software based on some database. This can answer all my needs but it takes time. I'd like to know if there is something ready to use.
I also looked into FileMaker and it seems ideal for this task. But it is a bit overkill and really expensive.
EDIT: So, I tried for now LibreOffice, OpenOffice, MS Word, ONLYOFFICE and Scribus. Spreadsheets would probably be good for some people but I don't like the interface and I have not explored the option thoroughly so bear with me. Anyways, there wasn't a single word processor that was not very buggy.
MS Word won't accept a page width of more than roughly 50 cm. LibreOffice will lose the formatting of the columns of the table if the page is too wide. OpenOffice is very primitive and crashes often, ONLYOFFICE will write wide pages in '.docx' files that will be unreadable by Word, or alternatively in '.odt' files that will lose the width property when they are read by itself (but interestingly they can be read fine by LibreOffice). Scribus is difficult to work with and copy/paste of tables doesn't work. Pages works fine but it is not compatible with the non-Mac world.
So for now I wrote off most word processors and I am gearing towards a HTML-oriented solution, but Pages seems also a good option for only-Mac users and spreadsheets may also have potential.
I am still very open to suggestions