v0.8.3
New stuff
**Added Multi Sheet support
added :newsheet, :nextsheet, :prevsheet :delsheet COMMAND_MODE commands
gt and gT commands in NORMAL_MODE are now used for moving between sheets
added new colors types SHEET, CURRENT_SHEET and FILENM
.sc file saving with multiple sheets
loading xlsx with multiple sheet
saving xlsx with multiple sheets
add :renamesheet COMMAND_MODE command
created movetosheet command in gram.y, to be used internally or in scripts when saving
and loading files.
reeval in multiple sheets: graph now should keep track of the different sheets
reference cells from different sheets in formulas: ={"Sheet2"}!A2
Save triggers in files
** Added automated tests
C command in EDIT MODE
- Added ignore_hidden configuration variable to address
#674 #653
With this hidden rows can be ignored when exporting spreasheets.
Useful when exporting the result of a filter.
This will also be honored when copy/pasting a range that have hidden rows in it.
PR 725: added 'default_open_file_under_cursor_cmd' configuration value that can be set at runtime
Changes
- added more detailed error in gram.y:yyerror
- Adapt string and number search for multisheet
- marks now considers sheet. We could have mark A in Sheet 1, and mark B on Sheet 2..
modified tick() and fix_marks()
Renamed auto_justify to auto_fit
gtcommand of NORMAL_MODE renamed togo
Removed --sheet and --filename_with_mode configuration variables
UNDO now saves reference to the sheet where the action took place. - copy_to_undostruct() now keep in added/removed list struct ent_ptr *
(that knows of sheets), rather than struct ent *.
Copy alignment of strings when doingPf.
undo: save maxrow, maxcol, modflg values before and after changes, so they can be restored after undo/redo actions
Modified yanklist to be struct ent_ptr list, rather thant struct ent list.
Ents_that_depends_on_list now takes ent_ptr rather than struct ent * as parameter
Backslash double quotes in cpaste. Issue 574.
Do not free ents of sheets when deleting a sheet manually (only at exit). just mark them as deleted.
Inform old value and new value when changing configuration variable
UI optimizations
Store offscr_sc values when saving sc files. Restore them when loading sc files
Simplify clipboard code
xlsx.c: Convert to uppercase before replacing functions
Added D command on EDIT mode.
ESC in EDIT_MODE also confirm changes.
Reeval when pasting from clipboard and autocalc is set
Adjust Makefile to have logic for clipboard commands on MacOS
Fixes
** fixed building warnings
** fix in calc_mobile_cols()
** fix not updating graph correctly after yanking cells with references -> Pc -> undo.
It could also segfault on ocassions as well. Added test5 and test6 for this.
Issue #568: handle '>' and '<' on mappings.
Issue #569: fix invalid read/write/segfault when deleting column.
Added test8 and test9 for this.
fix horizontal scroll when editing cells with long strings (wider than screen)
Avoid reading passed maxcols maxrows when shifting left or up over last sheet column/row.
fix in Pv when pasting over same place where data was yanked.
fix in paste_yanked_ents: calloc didnt count that yanked cells could share dependencies.
fix a bug when refreshing grid when autowrap operates. Issue 578.
Avoid segfault in autobackup when no current file is set.
fix in cw dw c$ d$ commands of EDIT_MODE
fix leak in del_selected_cells
fix when using C-r in INSERT_MODE
fix arguments reversed on sc.colrow2a
fix in delete_filters that caused SEGFAULT. Issue 637.
fix in unformat. call to copy_to_undostruct with wrong parameters.
fix swapped arguments on lsetform
added string functions to dep graph
Issue #697: do not allow to override nocurses config variable
fix #694: csv import and export / LaTex export
fix #700: '{' '}' normal mode commands reset cmd_multiplier