libera/#clasp - IRC Chatlog
Search
15:20:31
drmeister
Are all the bytecode defcallback and foreign-funcall changes in the main branch now?
15:22:26
drmeister
I apologize for my freakout last night. Writing a ($5M) proposal is stressful and in the last hours a bug in the xlsx library and my ham fisted fix for that bug resulted in the generation of mangled tables in the proposal.
15:24:16
drmeister
Back story: I wrote a Common Lisp program to help me write proposals. It reads a master plan from an Excel spreadsheet and builds tables that go into the proposal. In the final hours of putting the proposal together for submission I noticed that the tables had some errors and I freaked out and fell back to manually checking everything.
15:26:16
drmeister
The xlsx file format uses a unique string table and the spreadsheets have indices into that table. Sometimes the unique string table has empty entries and the Common Lisp xlsx system fails. I wrote a patch that skipped those entries and that dropped entries in the unique string tables and some indices into that table pointed to the wrong strings.
15:37:09
drmeister
splittist: I read from an xlsx, write to a csv and then copy that into a spreadsheet that does further formatting.
15:45:31
splittist
drmeister: so meister.human creates/edits a spreadsheet with a master plan, saving it as an xlsx. meister.bot then extracts information from the xlsx, slicing and dicing, and saves the resulting tables as one or move csv files. meister.human then loads the csv(s) into a spreadsheet programme for topping and tailing and prettifyin', and then cuts-n-pastes into the wordprocessor for integration with the rest of the proposal, which is
21:05:08
drmeister
I ran the static analyzer and merged and pushed all my changes to main for cando and clasp.
21:05:53
drmeister
It saves me a lot of stress making sure multiple tables are consistent with each other.