Comments (2)
Hello,
Thanks very much for bringing this to my attention,
There's a few things going on here,
After examining the code which deals with inserting columns and rows I found that it was indeed an issue that it wasn't inserting header/row index cells upon inserting columns/rows
After making the necessary modifications and testing them a bit I found other issues that needed fixing involving similar functionality
Edit 2: The error indicates I need to pass in a c (probably column) but even if I do so, nothing gets printed
If you saw an empty line when printing that is probably intended. if either the header (sheet.MT._headers
) wasn't long enough to cover the index you're printing or if it's an empty cell then in this case it would only print an empty string
To test this out you can do print(self.sheet.get_header_data(0, get_displayed=True))
which should print whatever the header is displaying instead of the underlying cell data
Of course there is the possibility that a silent error was being produced and blocking the printing, and you saw no new empty line, this may or may not be fixed now in 7.1.24
Anyway thanks again and here are the release notes:
Version 7.1.24
Fixed:
- Error on paste into empty sheet with
expand_sheet_if_paste_too_big
- Data shape not being correct upon inserting a single column or row into an empty sheet
- Potential for
insert_columns()
to cause issues if provided columns are longer than current number of sheet rows - 225 Insert columns and insert rows not inserting blank cells into header/row index, issue seen with either:
- Right clicking and using the in-built insert functionality
- Using the
Sheet()
functions with anint
for first parameter
- Wrong sheet dimensions caused by a paste which expands the sheet
- Wrong new selection box dimensions after paste which expands the sheet
set_options()
withtable_font=
not working
Changed:
expand_sheet_if_paste_too_big
replaced bypaste_can_expand_x
andpaste_can_expand_y
. To avoid compatibility issues usingexpand_sheet_if_paste_too_big
will set both new options
Improved:
- Additional protection against issue 224 but with
auto_resize_row_index="empty"
which is the default setting
from tksheet.
Works now, thanks!
from tksheet.
Related Issues (20)
- Partial Horizontal Scrolling HOT 2
- Rows sorting? HOT 2
- Cell Selection Persistence HOT 2
- Keypad enter button ignored HOT 2
- Quotes multiplies when i copy text from cell with ctrl+c or popup menu. HOT 2
- Editing out of bounds when changing sheets HOT 2
- Is there a way to set copy and paste bindings on cyrillic layout? HOT 7
- Issues with auto_resize_row_index HOT 1
- KeyError when binding a function (which selects a row) to "cell_select" HOT 8
- Resizing columns automatically to fit the frame if they would be smaller in total than the available space HOT 6
- Can we add a feature where Checkbox fill the entire cell ?
- Deleting popup_menu. HOT 3
- Moving columns/rows to the end is currently broken on 7.2.6
- How to make the Checkbox remain checked after searching in Entry HOT 1
- Copy&Paste HOT 2
- Sheet object takes focus when setting sheet data? How to inhibit? HOT 6
- Dropdown multi-select checkbox filter HOT 1
- function "checkbox" in "other_classes.py" currently creates a dropdown instead of a checkbox HOT 1
- REQUEST : Add a sort function
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tksheet.