ragardner
commented
9 months ago Hello,
Thanks for your excellent questions and sorry for the delay in my reply
I would like to prevent user to write down more than 12 characters in single tksheet cell. So if it is more than 12 characters the end ones shall be trimmed.
Unfortunately with tksheet versions 6.x.x this is rather difficult and verbose so I've made an effort to finish version 7 and changed it's behaviour a little
Here is the changelog for version 7 in case you're interested:
And here is the code I've made to demonstrate how easy this is with versions 7+
All edits including paste should be trimmed to 12 characters
The documentation for the function is available here:
from tksheet import Sheet
import tkinter as tk
class demo(tk.Tk):
def __init__(self):
tk.Tk.__init__(self)
self.grid_columnconfigure(0, weight=1)
self.grid_rowconfigure(0, weight=1)
# create an instance of Sheet()
self.sheet = Sheet(
# set the Sheets parent widget
self,
# optional: set the Sheets data at initialization
data=[[f"Row {r}, Column {c}\nnewline1\nnewline2" for c in range(20)] for r in range(100)],
theme="light green",
height=520,
width=1000,
)
# enable various bindings
self.sheet.enable_bindings()
# set a user edit validation function
# AND bind all sheet modification events to a function
# chained as two functions
# more information at:
# https://github.com/ragardner/tksheet/wiki/Version-7#validate-user-cell-edits
self.sheet.edit_validation(self.validate_edits)
self.sheet.grid(row=0, column=0, sticky="nswe")
def validate_edits(self, event):
# trim the edits to the table
return event.value[:12]
app = demo()
app.mainloop()For your 2nd question
P.S.: I have another question is there maybe a simple way to translate following actions into other languages: cut, copy, paste,...?
I am not sure, perhaps in your code you could create links to the functions using variables/attributes
# i think this is copy in spanish
sheet_copiar = sheet.copy
# or...
# i think this is copy in swedish
sheet_kopiera = sheet.copyand then using the function later on:
sheet_kopiera()Let me know if you run into any issues
Kind regards
janez111
The idea is as follows, i am creating GUI with tksheet tables for data input. I would like to prevent user to write down more than 12 characters in single tksheet cell. So if it is more than 12 characters the end ones shall be trimmed. Here is part of my code, i hope that is relevant.
preglednica_ref.set_sheet_data([['' for i in range(6)] for j in range(20)], reset_col_positions=True) column_widths_ref = [150 width_factor, 127 width_factor, 127 width_factor, 127 width_factor, 127 width_factor, 127 width_factor] preglednica_ref.set_column_widths(column_widths_ref)
P.S.: I have another question is there maybe a simple way to translate following actions into other languages: cut, copy, paste,...?
Best regards, Janez