Why does adding and deleting of columns work properly in code 1 but not in code 2? Fix code two based on what you learned from code 1. Code 1: import ctypes
import csv
import json
import re
import tkinter as tk
from pathlib import Path
from tkinter import filedialog, messagebox, simpledialog, ttk
from typing import Any, Optional

from tksheet import Sheet

def set_dpi_awareness():
"""Enable DPI awareness for high DPI settings."""
try:
ctypes.windll.shcore.SetProcessDpiAwareness(1)
except Exception as e:
print(f"Error setting DPI awareness: {e}")

def custom_filter_design(master, style: ttk.Style, headers=None, filter_types=None, filter_font=None, filter_combobox_font=None, colors=None):
"""Creates a custom filter frame with all components."""
filter_frame = ttk.Frame(master, style="Custom.TFrame")

# Configure styles
style.configure("Custom.TFrame", background=colors["background"], relief="flat", borderwidth=0)
style.configure("TCombobox", relief="flat", borderwidth=0, background=colors["background"], fieldbackground=colors["background"])
style.map("TCombobox", fieldbackground=[('readonly', colors["background"])], background=[('readonly', colors["background"])])
style.configure("TEntry", relief="flat", borderwidth=0, background=colors["background"])
style.configure("Line.TFrame", background=colors["filter_line"])

# Create widgets
header_combobox = ttk.Combobox(filter_frame, values=headers, width=15, font=filter_combobox_font, state="readonly")
filtertype_combobox = ttk.Combobox(filter_frame, values=filter_types, width=15, font=filter_combobox_font, state="readonly")
filter_entry = ttk.Entry(filter_frame, font=filter_font)
underline = ttk.Frame(filter_frame, height=1, style="Line.TFrame")

# Layout widgets
header_combobox.grid(row=0, column=0, padx=(0, 30), pady=2, sticky='ew')
filtertype_combobox.grid(row=0, column=1, padx=2, pady=2, sticky='ew')
filter_entry.grid(row=1, column=0, columnspan=2, padx=2, pady=(2, 0), sticky='ew')
underline.grid(row=2, column=0, columnspan=2, sticky='ew', pady=(0, 2))

# Prevent text selection in comboboxes
for combobox in (header_combobox, filtertype_combobox):
    combobox.bind("<FocusIn>", lambda event: event.widget.selection_clear())

# Configure column weights
filter_frame.columnconfigure((0, 1), weight=1)

# Ensure the underline doesn't resize vertically
underline.pack_propagate(False)

return filter_frame, header_combobox, filtertype_combobox, filter_entry

def custom_scrollbar_design(style: ttk.Style, colors=None):
"""Configure custom scrollbar style."""
style.configure("Custom.Vertical.TScrollbar", troughcolor=colors["scrollbar_trough"], background=colors["scrollbar_background"], borderwidth=0, arrowcolor=colors["scrollbar_arrow"])
style.map("Custom.Vertical.TScrollbar", background=[('active', colors["scrollbar_active"])])
style.layout("Custom.Vertical.TScrollbar", [('Vertical.Scrollbar.trough', {'children': [('Vertical.Scrollbar.thumb', {'expand': '1', 'sticky': 'ns'})], 'sticky': 'ns'})])

class TableApp:
"""Table Editor with sidebar and table management."""

def __init__(self, root: tk.Tk):
    """Initialize the TableApp."""
    self.root = root
    self.config_dimensions()
    self.config_fonts()
    self.config_colors()
    self.initialize_data()
    self.style = ttk.Style()
    self.style.theme_use("default")
    self.setup_ui()
    self.load_tables()

def config_dimensions(self):
    """Configure app dimensions."""
    self.root.title("Database")
    self.root.geometry("1920x1080")
    self.root.minsize(1435, 910)
    self.dimensions = {
        "sidebar_width": 400,
        "spacer_frame_width": 100,
        "header_height": 190,
        "separator_height": 1,
    }

def config_fonts(self):
    """Configure app fonts."""
    self.fonts = {
        "text": ("Literata", 12),
        "tksheet": ("Literata", 12, "normal"),
        "header_info": ("Literata", 10),
        "filter": ("Literata", 12),
        "filter_combobox": ("Literata", 8),
    }

def config_colors(self):
    """Configure app colors."""
    self.colors = {
        "text": "#333333",
        "background": "#FFFFFF",
        "sidebar": "#F7F8FC",
        "button": "#F7F8FC",
        "button_selected": "#EAEDEF",
        "separator": "#333333",
        "header_info": "#999999",
        "scrollbar_trough": "#F7F8FC",
        "scrollbar_background": "#c0c1c4",
        "scrollbar_arrow": "#333333",
        "scrollbar_active": "#878789",
        "filter_line": "#00bcf0",
    }

def setup_ui(self):
    """Set up the user interface with a 3x2 grid layout."""
    self.root.grid_rowconfigure(0, weight=0)
    self.root.grid_rowconfigure(1, weight=1)

    self.root.grid_columnconfigure(0, weight=0)
    self.root.grid_columnconfigure(1, weight=0, minsize=self.dimensions["spacer_frame_width"])
    self.root.grid_columnconfigure(2, weight=3)

    self.create_sidebar()
    self.create_header_frame()
    self.create_spacer_frame()
    self.create_table_frame()

def create_sidebar(self):
    """Create the sidebar that spans both rows."""
    sidebar = self._create_frame(
        parent=self.root,
        width=self.dimensions["sidebar_width"],
        bg=self.colors["sidebar"]
    )
    sidebar.grid(row=0, column=0, rowspan=2, sticky='ns')
    sidebar.grid_propagate(False)
    sidebar.columnconfigure(0, weight=1)
    sidebar.rowconfigure(0, weight=1)

    functional_sidebar = self._create_frame(
        parent=sidebar,
        width=self.dimensions["sidebar_width"],
        bg=self.colors["sidebar"]
    )
    functional_sidebar.grid(row=0, column=0, sticky='nsew')
    functional_sidebar.columnconfigure(0, weight=1)
    functional_sidebar.rowconfigure(0, weight=0)
    functional_sidebar.rowconfigure(1, weight=1)
    functional_sidebar.rowconfigure(2, weight=0)

    self._add_normal_buttons(functional_sidebar)
    self._add_scrollable_canvas(functional_sidebar)
    self._add_delete_table_section(functional_sidebar)

def create_header_frame(self) -> None:
    """Create the header divided into upper and lower sub-frames."""
    header_frame = self._create_and_configure_header_frame()
    
    upper_header_frame = self._create_upper_header(header_frame)
    self._create_upper_header_content(upper_header_frame)
    
    lower_header_frame = self._create_lower_header(header_frame)
    self._create_filter_controls(lower_header_frame)

def _create_and_configure_header_frame(self) -> tk.Frame:
    """Create and configure the main header frame."""
    header_frame = self._create_frame(parent=self.root, width=None, bg=self.colors["background"])
    header_frame.grid(row=0, column=1, columnspan=2, sticky='ew')
    header_frame.config(height=self.dimensions["header_height"])
    header_frame.grid_propagate(False)
    
    for i in range(2):
        header_frame.grid_rowconfigure(i, weight=0)
    
    for i in range(5):
        weight = 1 if i == 4 else 0
        header_frame.grid_columnconfigure(i, weight=weight)
    
    return header_frame

def _create_upper_header(self, parent: tk.Frame) -> tk.Frame:
    """Create the upper header frame."""
    upper_header = self._create_frame(parent=parent, width=None, bg=self.colors["background"])
    upper_header.grid(row=0, column=0, columnspan=5, sticky='ew', pady=(0, 10))
    upper_header.grid_columnconfigure(5, weight=1)
    return upper_header

def _create_upper_header_content(self, upper_header: tk.Frame) -> None:
    """Create and add content to the upper header frame."""
    self._create_data_label(upper_header)
    self._create_table_name_label(upper_header)
    self._create_settings_label(upper_header)

def _create_data_label(self, parent: tk.Frame) -> None:
    """Create and grid the 'Data >' label."""
    data_label = tk.Label(
        parent,
        text="Data > ",
        bg=self.colors["background"],
        fg=self.colors["header_info"],
        font=self.fonts["header_info"]
    )
    data_label.grid(row=0, column=0, padx=22, pady=(22, 0), sticky='nw')

def _create_table_name_label(self, parent: tk.Frame) -> None:
    """Create and grid the table name label."""
    self.table_name_label = tk.Label(
        parent,
        text=self.current_table_name if self.current_table_name else "No Table Selected",
        bg=self.colors["background"],
        fg=self.colors["text"],
        font=self.fonts["header_info"]
    )
    self.table_name_label.grid(row=0, column=0, padx=(88, 10), pady=(22, 0), sticky='nw')

def _create_settings_label(self, parent: tk.Frame) -> None:
    """Create and grid the settings label with its associated menu."""
    settings_label = tk.Label(
        parent,
        text="...",
        bg=self.colors["background"],
        fg=self.colors["text"],
        cursor="hand2",
        anchor='e',
        font=self.fonts["text"]
    )
    settings_label.grid(row=0, column=5, padx=40, pady=20, sticky='e')
    
    settings_menu = self._create_settings_menu()
    self._bind_settings_label_events(settings_label, settings_menu)

def _create_settings_menu(self) -> tk.Menu:
    """Create the settings dropdown menu."""
    menu = tk.Menu(self.root, tearoff=0)
    menu.add_command(label="Export Table", command=self.export_table)
    menu.add_command(label="Import Table", command=self.import_file)
    menu.add_command(label="Rename Headers", command=self.rename_headers)
    return menu

def _bind_settings_label_events(self, label: tk.Label, menu: tk.Menu) -> None:
    """Bind events to the settings label."""
    label.bind("<Button-1>", lambda e: menu.post(e.x_root, e.y_root))
    label.bind("<Enter>", lambda _: label.config(bg=self.colors["button_selected"]))
    label.bind("<Leave>", lambda _: label.config(bg=self.colors["background"]))

def _create_lower_header(self, parent: tk.Frame) -> tk.Frame:
    """Create the lower header frame."""
    lower_header = self._create_frame(parent=parent, width=None, bg=self.colors["background"])
    lower_header.grid(row=1, column=0, columnspan=5, sticky='ew')
    return lower_header

def _create_filter_controls(self, parent: tk.Frame) -> None:
    """Create and add filter controls to the lower header frame."""
    filter_frame, self.filter_header_dropdown, self.filter_option_dropdown, self.filter_text_entry = custom_filter_design(parent, self.style, headers=["All"] + self.headers.get(self.current_table_name, []), filter_types=[
        "is", "is not", "contains", "does not contain",
        "starts with", "ends with", "is empty", "is not empty"
    ], filter_font=self.fonts["filter"], filter_combobox_font=self.fonts["filter_combobox"], colors=self.colors)
    filter_frame.grid(row=0, column=1, columnspan=4, padx=100, pady=0, sticky='ew')

    self.filter_header_var.set("All")
    self.filter_option_var.set("contains")
    self.filter_text_var.set("")

    self.filter_header_dropdown['textvariable'] = self.filter_header_var
    self.filter_option_dropdown['textvariable'] = self.filter_option_var
    self.filter_text_entry['textvariable'] = self.filter_text_var

    self.filter_header_dropdown.bind("<<ComboboxSelected>>", self.apply_filter)
    self.filter_option_dropdown.bind("<<ComboboxSelected>>", lambda event: [self.update_filter_text_state(event), self.apply_filter()])
    self.filter_text_entry.bind("<KeyRelease>", self.apply_filter)
    self.filter_text_entry.bind("<Return>", self.apply_filter)
       
def update_filter_text_state(self, event=None):
    """Enable or disable the filter text entry based on filter option."""
    option = self.filter_option_var.get()
    if option in ["is empty", "is not empty"]:
        self.filter_text_var.set("")
        self.filter_text_entry.config(state='disabled')
        self.apply_filter()
    else:
        self.filter_text_entry.config(state='normal')

def create_spacer_frame(self):
    """Create a spacer frame in column 1, row 1."""
    spacer = self._create_frame(
        parent=self.root,
        width=self.dimensions["spacer_frame_width"],
        bg=self.colors["background"]
    )
    spacer.grid(row=1, column=1, sticky='nsew')
    spacer.grid_propagate(False)

def create_table_frame(self):
    """Create the table frame in column 2, row 1."""
    self.table_frame = self._create_frame(
        parent=self.root,
        width=None,
        bg=self.colors["background"]
    )
    self.table_frame.grid(row=1, column=2, sticky='nsew')
    self.table_frame.grid_rowconfigure(0, weight=1)
    self.table_frame.grid_columnconfigure(0, weight=1)

def _create_frame(
    self,
    parent: tk.Widget,
    width: Optional[int],
    bg: str
) -> tk.Frame:
    """Create a frame with specified width and background."""
    frame = tk.Frame(parent, width=width, bg=bg, bd=0, relief='flat')
    if width:
        frame.config(width=width)
    return frame

def _add_normal_buttons(self, sidebar: tk.Frame):
    """Add buttons to the sidebar."""
    normal_buttons_frame = self._create_frame(
        parent=sidebar,
        width=self.dimensions["sidebar_width"],
        bg=self.colors["sidebar"]
    )
    normal_buttons_frame.grid(row=0, column=0, sticky='ew', padx=10, pady=(10, 0))
    normal_buttons_frame.columnconfigure(0, weight=1)

    create_table_label = self._create_clickable_label(
        parent=normal_buttons_frame,
        text="Create New Table",
        command=self.create_new_table,
        anchor='center'
    )
    create_table_label.grid(row=0, column=0, pady=10, sticky='ew')
    self.add_custom_hover(create_table_label)

    separator = tk.Frame(normal_buttons_frame, height=self.dimensions["separator_height"], bg=self.colors["separator"])
    separator.grid(row=1, column=0, sticky='ew', pady=5)

def _on_canvas_configure(self, event):
    """Update the table_labels_frame width to match the canvas width."""
    self.canvas.itemconfig(self.table_labels_window, width=event.width)

def _add_scrollable_canvas(self, sidebar: tk.Frame):
    """Add scrollable canvas for table labels within a single frame."""
    scrollable_container = self._create_frame(
        parent=sidebar,
        width=self.dimensions["sidebar_width"],
        bg=self.colors["sidebar"]
    )
    scrollable_container.grid(row=1, column=0, sticky='nsew', padx=10, pady=10)
    scrollable_container.columnconfigure(0, weight=1)
    scrollable_container.rowconfigure(0, weight=1)

    self.canvas = tk.Canvas(
        scrollable_container,
        bg=self.colors["sidebar"],
        highlightthickness=0
    )
    self.canvas.grid(row=0, column=0, sticky='nsew')

    custom_scrollbar_design(self.style, self.colors) 

    self.scrollbar = ttk.Scrollbar(
        scrollable_container,
        orient="vertical",
        command=self.canvas.yview,
        style="Custom.Vertical.TScrollbar"
    )
    self.scrollbar.grid(row=0, column=1, sticky='ns')

    self.canvas.configure(yscrollcommand=self.scrollbar.set)

    self.table_labels_frame = tk.Frame(self.canvas, bg=self.colors["sidebar"])
    
    # Capture the window item ID
    self.table_labels_window = self.canvas.create_window((0, 0), window=self.table_labels_frame, anchor="nw", width=self.dimensions["sidebar_width"])

    self.canvas.bind("<MouseWheel>", self._on_mouse_wheel)
    self.table_labels_frame.bind("<MouseWheel>", self._on_mouse_wheel)

    self.table_labels_frame.bind(
        "<Configure>",
        lambda event: (
            self.canvas.configure(scrollregion=self.canvas.bbox("all")),
            self._update_scrollbar(scrollable_container, self.canvas, self.scrollbar)
        )
    )
    scrollable_container.bind(
        "<Configure>",
        lambda event: self._update_scrollbar(scrollable_container, self.canvas, self.scrollbar)
    )

    # Bind the canvas resize to update the table_labels_frame width
    self.canvas.bind('<Configure>', self._on_canvas_configure)

def _on_mouse_wheel(self, event):
    """Handle mouse wheel scrolling only if scrollbar is visible."""
    if self.scrollbar.winfo_viewable():
        self.canvas.yview_scroll(int(-1 * (event.delta / 120)), "units")

def _update_scrollbar(self, scrollbar_frame, canvas, scrollbar):
    """Update scrollbar visibility based on content size."""
    canvas.update_idletasks()
    canvas_height = scrollbar_frame.winfo_height()
    content_height = self.table_labels_frame.winfo_reqheight()

    if content_height > canvas_height:
        scrollbar.grid()
        canvas.configure(yscrollcommand=scrollbar.set)
        canvas.bind("<MouseWheel>", lambda event: canvas.yview_scroll(int(-1 * (event.delta / 120)), "units"))
    else:
        scrollbar.grid_remove()
        canvas.configure(yscrollcommand=lambda *args: None)
        canvas.unbind("<MouseWheel>")

def _add_delete_table_section(self, sidebar: tk.Frame):
    """Add delete table option to the sidebar."""
    delete_table_frame = self._create_frame(
        parent=sidebar,
        width=self.dimensions["sidebar_width"],
        bg=self.colors["sidebar"]
    )
    delete_table_frame.grid(row=2, column=0, sticky='ew', padx=10, pady=(0, 10))
    delete_table_frame.columnconfigure(0, weight=1)
    delete_table_frame.rowconfigure(1, weight=1)

    separator = tk.Frame(delete_table_frame, height=self.dimensions["separator_height"], bg=self.colors["separator"])
    separator.grid(row=0, column=0, sticky='ew', pady=5)

    delete_table_label = self._create_clickable_label(
        parent=delete_table_frame,
        text="🗑 Delete Selected Table",
        command=self.delete_table,
        anchor='center'
    )
    delete_table_label.grid(row=1, column=0, pady=10, sticky='ew')
    self.add_custom_hover(delete_table_label)

def _create_clickable_label(
    self,
    parent: tk.Widget,
    text: str,
    command,
    allow_rename: bool = False,
    anchor: str = 'w'
) -> tk.Label:
    """Create a clickable label with optional rename functionality."""
    cursor = "arrow" if allow_rename else "hand2"
    label = tk.Label(
        parent,
        text=text,
        bg=self.colors["button"],
        fg=self.colors["text"],
        cursor=cursor,
        anchor=anchor,
        font=self.fonts["text"]
    )
    label.bind("<Button-1>", lambda _: command())

    if allow_rename:
        label.bind("<Double-Button-1>", lambda _: self.begin_rename(text))

    label.bind("<MouseWheel>", self._on_mouse_wheel)

    return label

def add_custom_hover(self, widget: tk.Widget):
    """Add custom hover effects to a widget."""
    widget.bind("<Enter>", lambda e: widget.config(bg=self.colors["button_selected"]))
    widget.bind("<Leave>", lambda e: widget.config(bg=self.colors["button"]))

def initialize_data(self):
    """Initialize data structures."""
    self.save_file_path = Path(__file__).parent / "Data.json"
    self.tables_data: dict[str, dict] = {}
    self.current_sheet: Sheet | None = None
    self.headers: dict[str, list[str]] = {}
    self.current_table_name: str | None = None
    self.rename_entry: tk.Entry | None = None
    self.selected_table_label: tk.Label | None = None
    self.table_labels: dict[str, tk.Label] = {}
        
    self.table_name_label = None

    self.filter_header_var = tk.StringVar(value="All")
    self.filter_option_var = tk.StringVar(value="contains")
    self.filter_text_var = tk.StringVar()

    # Added: Initialize displayed_row_indices
    self.displayed_row_indices: list[int] = []

def sort_table_labels(self):
        """Sort table labels with numeric names first, then alphabetic, then alphanumeric."""
        def sort_key(name):
            # Category 1: Starts with digits (e.g., "1. Movies")
            m = re.match(r'^(\d+)', name)
            if m:
                return (1, int(m.group(1)))
            
            # Category 3: Starts with letters followed by digits (e.g., "T1", "T2")
            m = re.match(r'^([A-Za-z]+)(\d+)', name)
            if m:
                return (3, m.group(1).lower(), int(m.group(2)))
            
            # Category 2: Starts with letters only (e.g., "a", "b", "c")
            m = re.match(r'^([A-Za-z]+)', name)
            if m:
                return (2, m.group(1).lower())
            
            # Category 4: Any other names
            return (4, name.lower())
        
        # Sort the table names using the defined sort key
        sorted_tables = sorted(self.tables_data.keys(), key=sort_key)
        
        # Re-pack the labels in the sorted order
        for table_name in sorted_tables:
            label = self.table_labels.get(table_name)
            if label:
                label.pack_forget()
                label.pack(fill='x', padx=0, pady=5, expand=True)

def create_new_table(self):
    """Create a new table."""
    existing_numbers = [int(name.split(" ")[1]) for name in self.tables_data if name.startswith("Table ") and name.split(" ")[1].isdigit()]
    next_number = max(existing_numbers, default=0) + 1
    table_name = f"Table {next_number}"
    self.add_table(table_name)
    self.load_selected_table(table_name)

def import_file(self):
    """Import table from file."""
    file_path = filedialog.askopenfilename(title="Import File", filetypes=[("All Supported Files", "*.json *.csv"), ("JSON files", "*.json"), ("CSV files", "*.csv")])
    if not file_path:
        return
    try:
        if file_path.endswith('.csv'):
            with open(file_path, newline='', encoding='utf-8') as csvfile:
                data = list(csv.reader(csvfile))
        elif file_path.endswith('.json'):
            with open(file_path, 'r', encoding='utf-8') as jsonfile:
                data = json.load(jsonfile)
        else:
            raise ValueError("Unsupported file format.")
        if not data or not isinstance(data, list) or not all(isinstance(row, list) for row in data):
            raise ValueError("Invalid data format in the file.")
        headers, table_data = data[0], data[1:]
        self.add_table_from_data(file_path, headers, table_data)
    except Exception as e:
        messagebox.showerror("File Import Error", str(e))

def add_table_from_data(self, file_path: str, headers: list[str], table_data: list[list[str]]):
    """Add a table from file data."""
    table_name = Path(file_path).stem
    table_name = self.ensure_unique_table_name(table_name)
    self.add_table(table_name, data=table_data, headers=headers)
    self.load_selected_table(table_name)
    self.save_data()

def ensure_unique_table_name(self, table_name: str) -> str:
    """Ensure table name is unique."""
    original_name = table_name
    counter = 1
    while table_name in self.tables_data:
        table_name = f"{original_name} (New {counter})"
        counter += 1
    return table_name

def save_table_data(self, file_path: str, data: list[list[str]], format: str):
    """Save table data in specified format."""
    match format:
        case 'csv':
            with open(file_path, 'w', newline='', encoding='utf-8') as file:
                csv.writer(file).writerows(data)
        case 'json':
            with open(file_path, 'w', encoding='utf-8') as file:
                json.dump(data, file, indent=4)
        case _:
            raise ValueError("Unsupported file format.")

def export_table(self):
    """Export current table to file."""
    if not self.current_table_name or self.current_table_name not in self.tables_data:
        messagebox.showwarning("No Table Selected", "Please select a table to export.")
        return
    file_path = filedialog.asksaveasfilename(title="Export File", defaultextension=".json", filetypes=[("JSON files", "*.json"), ("CSV files", "*.csv")], initialfile=self.current_table_name)
    if not file_path:
        return
    try:
        data = [self.headers[self.current_table_name]] + self.tables_data[self.current_table_name]["data"]
        if file_path.endswith('.csv'):
            self.save_table_data(file_path, data, 'csv')
        elif file_path.endswith('.json'):
            with open(file_path, 'w', encoding='utf-8') as file:
                json.dump(data, file, indent=4)
        else:
            raise ValueError("Unsupported file format.")
        self.save_data()
        messagebox.showinfo("Export Successful", f"Table '{self.current_table_name}' has been exported successfully.")
    except Exception as e:
        messagebox.showerror("Export Failed", f"An error occurred during export: {e}")

def add_table(self, table_name: str, data: list[list[str]] | None = None, headers: Optional[list[str]] = None):
    """Add a new table."""
    if headers:
        self.headers[table_name] = headers
    else:
        default_headers = ["Column 1", "Column 2", "Column 3", "Column 4", "Column 5"]
        self.headers[table_name] = default_headers
    self.tables_data[table_name] = {"headers": self.headers[table_name], "data": data or [["" for _ in range(len(self.headers[table_name]))] for _ in range(10)]}
    self.create_table_label(table_name)
    self.save_data()

def create_table_label(self, table_name: str):
    """Create label for table."""
    label = self._create_clickable_label(self.table_labels_frame, table_name, lambda: self.load_selected_table(table_name), True)
    label.pack(fill='x', padx=0, pady=5, expand=True)
    self.table_labels[table_name] = label
    self.add_custom_hover(label)
    self.sort_table_labels()

def delete_table(self):
    """Delete selected table."""
    if not self.current_table_name or self.current_table_name not in self.tables_data:
        messagebox.showwarning("No Table Selected", "Please select a valid table to delete.")
        return
    if messagebox.askyesno("Delete Table", f"Are you sure you want to delete the table '{self.current_table_name}'?"):
        self.remove_table(self.current_table_name)

def on_columns_deleted(self, event):
    """Handle column deletion and update filter headers."""
    if not self.current_table_name or not self.current_sheet:
        return
    new_headers = self.current_sheet.headers()
    self.headers[self.current_table_name] = new_headers
    self.filter_header_dropdown['values'] = ["All"] + new_headers
    self.filter_header_var.set("All")
    self.filter_option_var.set("contains")
    self.filter_text_var.set("")
    self.filter_text_entry.config(state='normal')
    self.apply_filter()

def remove_table(self, table_name: str):
    """Remove a table."""
    if self.current_table_name == table_name and self.current_sheet:
        self.current_sheet.destroy()
        self.current_sheet = None
    label = self.table_labels.get(table_name)
    if label:
        label.destroy()
    if table_name in self.tables_data:
        del self.tables_data[table_name]
    if table_name in self.headers:
        del self.headers[table_name]
    if table_name in self.table_labels:
        del self.table_labels[table_name]
    self.current_table_name = None
    self.selected_table_label = None
    self.save_data()
    self.sort_table_labels()

def load_tables(self):
    """Load tables from file."""
    if not self.save_file_path.exists():
        return
    try:
        with self.save_file_path.open('r', encoding='utf-8') as file:
            all_data = json.load(file)
    except Exception as e:
        messagebox.showerror("Load Error", f"Failed to load tables: {e}")
        return
    for table_name, data in all_data.items():
        if not isinstance(data, list) or not data:
            continue
        headers, table_data = data[0], data[1:]
        self.headers[table_name] = headers
        self.tables_data[table_name] = {"headers": headers, "data": table_data}
        self.create_table_label(table_name)
    self.sort_table_labels()

def load_selected_table(self, table_name: str):
    """Display selected table."""
    if self.current_sheet:
        self.current_sheet.pack_forget()
        self.current_sheet.destroy()
        self.current_sheet = None
    if self.selected_table_label:
        try:
            self.selected_table_label.config(bg=self.colors["button"])
        except tk.TclError:
            self.selected_table_label = None

    if table_name not in self.tables_data:
        messagebox.showerror("Error", f"Table '{table_name}' does not exist.")
        self.current_table_name = None
        self.selected_table_label = None
        return

    table_info = self.tables_data[table_name]
    headers = table_info["headers"]
    data = table_info["data"]
    try:
        sheet = Sheet(
            self.table_frame,
            data=data,
            show_table=True,
            headers=headers,
            font=self.fonts["tksheet"],
            header_font=self.fonts["tksheet"],
            auto_resize_columns=True
        )
        sheet.set_options(table_fg=self.colors["text"], header_fg=self.colors["text"])
        sheet.enable_bindings()
        sheet.extra_bindings([
            ("end_edit_cell", self.on_cell_edit),
            ("end_delete_columns", self.on_columns_deleted)  # Added binding for column deletion
        ])
        sheet.pack(expand=True, fill='both')
        self.current_sheet = sheet
        self.current_table_name = table_name

        if self.table_name_label:
            self.table_name_label.config(text=self.current_table_name)
        else:
            self.table_name_label = tk.Label(
                self.root,
                text=self.current_table_name,
                bg=self.colors["background"],
                fg=self.colors["text"],
                font=self.fonts["header_info"]
            )
            self.table_name_label.grid(row=0, column=0, padx=(60, 10), pady=(5, 0), sticky='nw')

        label = self.table_labels.get(table_name)
        if label:
            self.selected_table_label = label
            try:
                self.selected_table_label.config(bg=self.colors["button_selected"])
            except tk.TclError:
                self.selected_table_label = None
                messagebox.showerror("Error", f"Failed to update the label for '{table_name}'.")
        else:
            self.selected_table_label = None
            messagebox.showerror("Error", f"Label for '{table_name}' not found.")
        
        self.filter_header_var.set("All")
        self.filter_header_dropdown['values'] = ["All"] + headers
        
        self.filter_option_var.set("contains")
        self.update_filter_text_state()
        
        self.apply_filter()
    except Exception as e:
        messagebox.showerror("Sheet Error", f"Failed to load table '{table_name}': {e}")
        self.current_table_name = None
        self.selected_table_label = None

def on_cell_edit(self, event=None):
    """Handle cell edits."""
    if self.current_table_name and self.current_sheet:
        sheet_data = self.current_sheet.get_sheet_data()
        for idx, row in enumerate(sheet_data):
            if idx < len(self.displayed_row_indices):
                data_idx = self.displayed_row_indices[idx]
                self.tables_data[self.current_table_name]["data"][data_idx] = row
            else:
                # Added: Handle new rows by appending to the underlying data
                self.tables_data[self.current_table_name]["data"].append(row)
        self.save_data()

def save_data(self):
    """Save all tables data."""
    all_data = {}
    for table_name, table_info in self.tables_data.items():
        all_data[table_name] = [table_info["headers"]] + table_info["data"]
    try:
        with self.save_file_path.open('w', encoding='utf-8') as file:
            json.dump(all_data, file, indent=4)
    except Exception as e:
        print(f"Error saving data: {e}")

def apply_filter(self, event=None):
    """Apply filter to table data based on selected criteria."""
    if not self.current_table_name or not self.current_sheet:
        return
    header = self.filter_header_var.get()
    option = self.filter_option_var.get()
    text = self.filter_text_var.get().lower()
    original_data = self.tables_data[self.current_table_name]["data"]

    def row_matches(row):
        if header == "All":
            cells = row
            target_indices = range(len(cells))
        else:
            try:
                target_indices = [self.headers[self.current_table_name].index(header)]
            except ValueError:
                return False
        
        conditions = {
            "is": lambda cell, text: cell == text,
            "is not": lambda cell, text: cell != text,
            "contains": lambda cell, text: text in cell,
            "does not contain": lambda cell, text: text not in cell,
            "starts with": lambda cell, text: cell.startswith(text),
            "ends with": lambda cell, text: cell.endswith(text),
            "is empty": lambda cell, _: cell == "",
            "is not empty": lambda cell, _: cell != ""
        }
        
        for idx in target_indices:
            cell = str(row[idx]).lower()
            if conditions.get(option, lambda _, __: False)(cell, text):
                return True
        return False

    # Collect both filtered data and their original indices
    filtered_data = []
    self.displayed_row_indices = []

    for i, row in enumerate(original_data):
        if row_matches(row):
            filtered_data.append(row)
            self.displayed_row_indices.append(i)

    try:
        self.current_sheet.set_sheet_data(filtered_data)
    except tk.TclError as e:
        print(f"Error applying filter: {e}")

def rename_headers(self):
    """Rename table headers."""
    if not self.current_table_name:
        messagebox.showwarning("No Table Selected", "Please select a table to rename headers.")
        return
    current_headers = self.headers[self.current_table_name]
    new_headers = simpledialog.askstring(
        "Rename Headers", 
        "Enter new headers (comma-separated):", 
        initialvalue=", ".join(current_headers)
    )
    if new_headers:
        header_list = [header.strip() for header in new_headers.split(',')]
        if not header_list:
            messagebox.showerror("Invalid Headers", "Header list cannot be empty.")
            return
        self.headers[self.current_table_name] = header_list
        self.tables_data[self.current_table_name]["headers"] = header_list
        if self.current_sheet:
            try:
                self.current_sheet.headers(header_list)
            except tk.TclError as e:
                messagebox.showerror("Error", f"Failed to rename headers: {e}")
        
        self.filter_header_var.set("All")
        self.filter_header_dropdown['values'] = ["All"] + header_list
        self.apply_filter()
        
        self.save_data()

def begin_rename(self, table_name: str):
    """Start renaming a table."""
    if table_name not in self.table_labels:
        messagebox.showerror("Error", f"Table '{table_name}' not found.")
        return
    label = self.table_labels[table_name]
    self.cancel_rename()
    self.rename_entry = tk.Entry(self.table_labels_frame, bg=label.cget("bg"), fg=self.colors["text"], relief='flat')
    self.rename_entry.insert(0, table_name)
    self.rename_entry.place(x=label.winfo_x(), y=label.winfo_y(), width=label.winfo_width(), height=label.winfo_height())
    self.rename_entry.focus()
    self.rename_entry.select_range(0, tk.END)
    self.rename_entry.bind('<Return>', lambda event: self.end_rename(table_name))
    self.rename_entry.bind('<FocusOut>', lambda event: self.cancel_rename())

def end_rename(self, old_name: str):
    """Finalize table renaming."""
    new_name = self.rename_entry.get().strip()
    if not new_name:
        messagebox.showerror("Invalid Name", "Table name cannot be empty.")
        self.rename_entry.focus_set()
        return
    if new_name in self.tables_data and new_name != old_name:
        messagebox.showerror("Duplicate Name", f"A table named '{new_name}' already exists.")
        self.rename_entry.focus_set()
        return
    if new_name != old_name:
        self.update_table_name(old_name, new_name)
        self.load_selected_table(new_name)
    self.cancel_rename()

def update_table_name(self, old_name: str, new_name: str):
    """Update table name and resources."""
    self.tables_data[new_name] = self.tables_data.pop(old_name)
    self.headers[new_name] = self.headers.pop(old_name)
    label = self.table_labels.pop(old_name)
    label.config(text=new_name)
    label.bind("<Button-1>", lambda event: self.load_selected_table(new_name))
    label.bind("<Double-1>", lambda event: self.begin_rename(new_name))
    self.table_labels[new_name] = label
    if self.selected_table_label == label:
        try:
            label.config(bg=self.colors["button_selected"])
        except tk.TclError:
            pass
    self.save_data()
    self.sort_table_labels()

def cancel_rename(self):
    """Cancel rename operation."""
    if self.rename_entry:
        self.rename_entry.destroy()
        self.rename_entry = None

def add_custom_hover(self, label: tk.Label):
    """Add hover effects to label."""
    def on_enter(event):
        if label != self.selected_table_label:
            try:
                label.config(bg=self.colors["button_selected"])
            except tk.TclError:
                pass

    def on_leave(event):
        if label != self.selected_table_label:
            try:
                label.config(bg=self.colors["button"])
            except tk.TclError:
                pass

    label.bind("<Enter>", on_enter)
    label.bind("<Leave>", on_leave)

if name == "main":
set_dpi_awareness()
root = tk.Tk()
app = TableApp(root)
root.mainloop()
Code 2: import ctypes
import csv
import json
import re
import tkinter as tk
from pathlib import Path
from tkinter import filedialog, messagebox, simpledialog, ttk
from typing import Any, Optional

from tksheet import Sheet

def set_dpi_awareness():
"""Enable DPI awareness for high DPI settings."""
try:
ctypes.windll.shcore.SetProcessDpiAwareness(1)
except Exception as e:
print(f"Error setting DPI awareness: {e}")

def custom_filter_design(master, style: ttk.Style, headers=None, filter_types=None, filter_font=None, filter_combobox_font=None, colors=None):
"""Creates a custom filter frame with all components."""
filter_frame = ttk.Frame(master, style="Custom.TFrame")

# Configure styles
style.configure("Custom.TFrame", background=colors["background"], relief="flat", borderwidth=0)
style.configure("TCombobox", relief="flat", borderwidth=0, background=colors["background"], fieldbackground=colors["background"])
style.map("TCombobox", fieldbackground=[('readonly', colors["background"])], background=[('readonly', colors["background"])])
style.configure("TEntry", relief="flat", borderwidth=0, background=colors["background"])
style.configure("Line.TFrame", background=colors["filter_line"])

# Create widgets
header_combobox = ttk.Combobox(filter_frame, values=headers, width=15, font=filter_combobox_font, state="readonly")
filtertype_combobox = ttk.Combobox(filter_frame, values=filter_types, width=15, font=filter_combobox_font, state="readonly")
filter_entry = ttk.Entry(filter_frame, font=filter_font)
underline = ttk.Frame(filter_frame, height=1, style="Line.TFrame")

# Layout widgets
header_combobox.grid(row=0, column=0, padx=(0, 30), pady=2, sticky='ew')
filtertype_combobox.grid(row=0, column=1, padx=2, pady=2, sticky='ew')
filter_entry.grid(row=1, column=0, columnspan=2, padx=2, pady=(2, 0), sticky='ew')
underline.grid(row=2, column=0, columnspan=2, sticky='ew', pady=(0, 2))

# Prevent text selection in comboboxes
for combobox in (header_combobox, filtertype_combobox):
    combobox.bind("<FocusIn>", lambda event: event.widget.selection_clear())

# Configure column weights
filter_frame.columnconfigure((0, 1), weight=1)

# Ensure the underline doesn't resize vertically
underline.pack_propagate(False)

return filter_frame, header_combobox, filtertype_combobox, filter_entry

def custom_scrollbar_design(style: ttk.Style, colors=None):
"""Configure custom scrollbar style."""
style.configure("Custom.Vertical.TScrollbar", troughcolor=colors["scrollbar_trough"], background=colors["scrollbar_background"], borderwidth=0, arrowcolor=colors["scrollbar_arrow"])
style.map("Custom.Vertical.TScrollbar", background=[('active', colors["scrollbar_active"])])
style.layout("Custom.Vertical.TScrollbar", [('Vertical.Scrollbar.trough', {'children': [('Vertical.Scrollbar.thumb', {'expand': '1', 'sticky': 'ns'})], 'sticky': 'ns'})])

class TableApp:
"""Table Editor with sidebar and table management."""

def __init__(self, root: tk.Tk):
    """Initialize the TableApp."""
    self.root = root
    self.config_dimensions()
    self.config_fonts()
    self.config_colors()
    self.initialize_data()
    self.style = ttk.Style()
    self.style.theme_use("default")
    self.setup_ui()
    self.load_tables()

def config_dimensions(self):
    """Configure app dimensions."""
    self.root.title("Database")
    self.root.geometry("1920x1080")
    self.root.minsize(1435, 910)
    self.dimensions = {
        "sidebar_width": 400,
        "spacer_frame_width": 100,
        "header_height": 190,
        "separator_height": 1,
    }

def config_fonts(self):
    """Configure app fonts."""
    self.fonts = {
        "text": ("Literata", 12),
        "tksheet": ("Literata", 12, "normal"),
        "header_info": ("Literata", 10),
        "filter": ("Literata", 12),
        "filter_combobox": ("Literata", 8),
    }

def config_colors(self):
    """Configure app colors."""
    self.colors = {
        "text": "#333333",
        "background": "#FFFFFF",
        "sidebar": "#F7F8FC",
        "button": "#F7F8FC",
        "button_selected": "#EAEDEF",
        "separator": "#333333",
        "header_info": "#999999",
        "scrollbar_trough": "#F7F8FC",
        "scrollbar_background": "#c0c1c4",
        "scrollbar_arrow": "#333333",
        "scrollbar_active": "#878789",
        "filter_line": "#00bcf0",
    }

def setup_ui(self):
    """Set up the user interface with a 3x2 grid layout."""
    self.root.grid_rowconfigure(0, weight=0)
    self.root.grid_rowconfigure(1, weight=1)

    self.root.grid_columnconfigure(0, weight=0)
    self.root.grid_columnconfigure(1, weight=0, minsize=self.dimensions["spacer_frame_width"])
    self.root.grid_columnconfigure(2, weight=3)

    self.create_sidebar()
    self.create_header_frame()
    self.create_spacer_frame()
    self.create_table_frame()

def create_sidebar(self):
    """Create the sidebar that spans both rows."""
    sidebar = self._create_frame(
        parent=self.root,
        width=self.dimensions["sidebar_width"],
        bg=self.colors["sidebar"]
    )
    sidebar.grid(row=0, column=0, rowspan=2, sticky='ns')
    sidebar.grid_propagate(False)
    sidebar.columnconfigure(0, weight=1)
    sidebar.rowconfigure(0, weight=1)

    functional_sidebar = self._create_frame(
        parent=sidebar,
        width=self.dimensions["sidebar_width"],
        bg=self.colors["sidebar"]
    )
    functional_sidebar.grid(row=0, column=0, sticky='nsew')
    functional_sidebar.columnconfigure(0, weight=1)
    functional_sidebar.rowconfigure(0, weight=0)
    functional_sidebar.rowconfigure(1, weight=1)
    functional_sidebar.rowconfigure(2, weight=0)

    self._add_normal_buttons(functional_sidebar)
    self._add_scrollable_canvas(functional_sidebar)
    self._add_delete_table_section(functional_sidebar)

def create_header_frame(self) -> None:
    """Create the header divided into upper and lower sub-frames."""
    header_frame = self._create_and_configure_header_frame()
    
    upper_header_frame = self._create_upper_header(header_frame)
    self._create_upper_header_content(upper_header_frame)
    
    lower_header_frame = self._create_lower_header(header_frame)
    self._create_filter_controls(lower_header_frame)

def _create_and_configure_header_frame(self) -> tk.Frame:
    """Create and configure the main header frame."""
    header_frame = self._create_frame(parent=self.root, width=None, bg=self.colors["background"])
    header_frame.grid(row=0, column=1, columnspan=2, sticky='ew')
    header_frame.config(height=self.dimensions["header_height"])
    header_frame.grid_propagate(False)
    
    for i in range(2):
        header_frame.grid_rowconfigure(i, weight=0)
    
    for i in range(5):
        weight = 1 if i == 4 else 0
        header_frame.grid_columnconfigure(i, weight=weight)
    
    return header_frame

def _create_upper_header(self, parent: tk.Frame) -> tk.Frame:
    """Create the upper header frame."""
    upper_header = self._create_frame(parent=parent, width=None, bg=self.colors["background"])
    upper_header.grid(row=0, column=0, columnspan=5, sticky='ew', pady=(0, 10))
    upper_header.grid_columnconfigure(5, weight=1)
    return upper_header

def _create_upper_header_content(self, upper_header: tk.Frame) -> None:
    """Create and add content to the upper header frame."""
    self._create_data_label(upper_header)
    self._create_table_name_label(upper_header)
    self._create_settings_label(upper_header)

def _create_data_label(self, parent: tk.Frame) -> None:
    """Create and grid the 'Data >' label."""
    data_label = tk.Label(
        parent,
        text="Data > ",
        bg=self.colors["background"],
        fg=self.colors["header_info"],
        font=self.fonts["header_info"]
    )
    data_label.grid(row=0, column=0, padx=22, pady=(22, 0), sticky='nw')

def _create_table_name_label(self, parent: tk.Frame) -> None:
    """Create and grid the table name label."""
    self.table_name_label = tk.Label(
        parent,
        text=self.current_table_name if self.current_table_name else "No Table Selected",
        bg=self.colors["background"],
        fg=self.colors["text"],
        font=self.fonts["header_info"]
    )
    self.table_name_label.grid(row=0, column=0, padx=(88, 10), pady=(22, 0), sticky='nw')

def _create_settings_label(self, parent: tk.Frame) -> None:
    """Create and grid the settings label with its associated menu."""
    settings_label = tk.Label(
        parent,
        text="...",
        bg=self.colors["background"],
        fg=self.colors["text"],
        cursor="hand2",
        anchor='e',
        font=self.fonts["text"]
    )
    settings_label.grid(row=0, column=4, padx=40, pady=20, sticky='e')
    
    settings_menu = self._create_settings_menu()
    self._bind_settings_label_events(settings_label, settings_menu)

def _create_settings_menu(self) -> tk.Menu:
    """Create the settings dropdown menu."""
    menu = tk.Menu(self.root, tearoff=0)
    menu.add_command(label="Export Table", command=self.export_table)
    menu.add_command(label="Import Table", command=self.import_file)
    menu.add_command(label="Rename Headers", command=self.rename_headers)
    menu.add_command(label="Change Data Types", command=self.change_data_types)
    return menu

def _bind_settings_label_events(self, label: tk.Label, menu: tk.Menu) -> None:
    """Bind events to the settings label."""
    label.bind("<Button-1>", lambda e: menu.post(e.x_root, e.y_root))
    label.bind("<Enter>", lambda _: label.config(bg=self.colors["button_selected"]))
    label.bind("<Leave>", lambda _: label.config(bg=self.colors["background"]))

def _create_lower_header(self, parent: tk.Frame) -> tk.Frame:
    """Create the lower header frame."""
    lower_header = self._create_frame(parent=parent, width=None, bg=self.colors["background"])
    lower_header.grid(row=1, column=0, columnspan=5, sticky='ew')
    return lower_header

def _create_filter_controls(self, parent: tk.Frame) -> None:
    """Create and add filter controls to the lower header frame."""
    filter_frame, self.filter_header_dropdown, self.filter_option_dropdown, self.filter_text_entry = custom_filter_design(
        parent,
        self.style,
        headers=["All"] + [col['name'] for col in self.headers.get(self.current_table_name, [])],
        filter_types=[
            "is", "is not", "contains", "does not contain",
            "starts with", "ends with", "is empty", "is not empty"
        ],
        filter_font=self.fonts["filter"],
        filter_combobox_font=self.fonts["filter_combobox"],
        colors=self.colors
    )
    filter_frame.grid(row=0, column=1, columnspan=4, padx=100, pady=0, sticky='ew')

    self.filter_header_var.set("All")
    self.filter_option_var.set("contains")
    self.filter_text_var.set("")

    self.filter_header_dropdown['textvariable'] = self.filter_header_var
    self.filter_option_dropdown['textvariable'] = self.filter_option_var
    self.filter_text_entry['textvariable'] = self.filter_text_var

    self.filter_header_dropdown.bind("<<ComboboxSelected>>", self.apply_filter)
    self.filter_option_dropdown.bind("<<ComboboxSelected>>", lambda event: [self.update_filter_text_state(event), self.apply_filter()])
    self.filter_text_entry.bind("<KeyRelease>", self.apply_filter)
    self.filter_text_entry.bind("<Return>", self.apply_filter)
       
def update_filter_text_state(self, event=None):
    """Enable or disable the filter text entry based on filter option."""
    option = self.filter_option_var.get()
    if option in ["is empty", "is not empty"]:
        self.filter_text_var.set("")
        self.filter_text_entry.config(state='disabled')
        self.apply_filter()
    else:
        self.filter_text_entry.config(state='normal')

def create_spacer_frame(self):
    """Create a spacer frame in column 1, row 1."""
    spacer = self._create_frame(
        parent=self.root,
        width=self.dimensions["spacer_frame_width"],
        bg=self.colors["background"]
    )
    spacer.grid(row=1, column=1, sticky='nsew')
    spacer.grid_propagate(False)

def create_table_frame(self):
    """Create the table frame in column 2, row 1."""
    self.table_frame = self._create_frame(
        parent=self.root,
        width=None,
        bg=self.colors["background"]
    )
    self.table_frame.grid(row=1, column=2, sticky='nsew')
    self.table_frame.grid_rowconfigure(0, weight=1)
    self.table_frame.grid_columnconfigure(0, weight=1)

def _create_frame(
    self,
    parent: tk.Widget,
    width: Optional[int],
    bg: str
) -> tk.Frame:
    """Create a frame with specified width and background."""
    frame = tk.Frame(parent, width=width, bg=bg, bd=0, relief='flat')
    if width:
        frame.config(width=width)
    return frame

def _add_normal_buttons(self, sidebar: tk.Frame):
    """Add buttons to the sidebar."""
    normal_buttons_frame = self._create_frame(
        parent=sidebar,
        width=self.dimensions["sidebar_width"],
        bg=self.colors["sidebar"]
    )
    normal_buttons_frame.grid(row=0, column=0, sticky='ew', padx=10, pady=(10, 0))
    normal_buttons_frame.columnconfigure(0, weight=1)

    create_table_label = self._create_clickable_label(
        parent=normal_buttons_frame,
        text="Create New Table",
        command=self.create_new_table,
        anchor='center'
    )
    create_table_label.grid(row=0, column=0, pady=10, sticky='ew')
    self.add_custom_hover(create_table_label)

    separator = tk.Frame(normal_buttons_frame, height=self.dimensions["separator_height"], bg=self.colors["separator"])
    separator.grid(row=1, column=0, sticky='ew', pady=5)

def _on_canvas_configure(self, event):
    """Update the table_labels_frame width to match the canvas width."""
    self.canvas.itemconfig(self.table_labels_window, width=event.width)

def _add_scrollable_canvas(self, sidebar: tk.Frame):
    """Add scrollable canvas for table labels within a single frame."""
    scrollable_container = self._create_frame(
        parent=sidebar,
        width=self.dimensions["sidebar_width"],
        bg=self.colors["sidebar"]
    )
    scrollable_container.grid(row=1, column=0, sticky='nsew', padx=10, pady=10)
    scrollable_container.columnconfigure(0, weight=1)
    scrollable_container.rowconfigure(0, weight=1)

    self.canvas = tk.Canvas(
        scrollable_container,
        bg=self.colors["sidebar"],
        highlightthickness=0
    )
    self.canvas.grid(row=0, column=0, sticky='nsew')

    custom_scrollbar_design(self.style, self.colors) 

    self.scrollbar = ttk.Scrollbar(
        scrollable_container,
        orient="vertical",
        command=self.canvas.yview,
        style="Custom.Vertical.TScrollbar"
    )
    self.scrollbar.grid(row=0, column=1, sticky='ns')

    self.canvas.configure(yscrollcommand=self.scrollbar.set)

    self.table_labels_frame = tk.Frame(self.canvas, bg=self.colors["sidebar"])
    
    # Capture the window item ID
    self.table_labels_window = self.canvas.create_window((0, 0), window=self.table_labels_frame, anchor="nw", width=self.dimensions["sidebar_width"])

    self.canvas.bind("<MouseWheel>", self._on_mouse_wheel)
    self.table_labels_frame.bind("<MouseWheel>", self._on_mouse_wheel)

    self.table_labels_frame.bind(
        "<Configure>",
        lambda event: (
            self.canvas.configure(scrollregion=self.canvas.bbox("all")),
            self._update_scrollbar(scrollable_container, self.canvas, self.scrollbar)
        )
    )
    scrollable_container.bind(
        "<Configure>",
        lambda event: self._update_scrollbar(scrollable_container, self.canvas, self.scrollbar)
    )

    # Bind the canvas resize to update the table_labels_frame width
    self.canvas.bind('<Configure>', self._on_canvas_configure)

def _on_mouse_wheel(self, event):
    """Handle mouse wheel scrolling only if scrollbar is visible."""
    if self.scrollbar.winfo_viewable():
        self.canvas.yview_scroll(int(-1 * (event.delta / 120)), "units")

def _update_scrollbar(self, scrollbar_frame, canvas, scrollbar):
    """Update scrollbar visibility based on content size."""
    canvas.update_idletasks()
    canvas_height = scrollbar_frame.winfo_height()
    content_height = self.table_labels_frame.winfo_reqheight()

    if content_height > canvas_height:
        scrollbar.grid()
        canvas.configure(yscrollcommand=scrollbar.set)
        canvas.bind("<MouseWheel>", lambda event: canvas.yview_scroll(int(-1 * (event.delta / 120)), "units"))
    else:
        scrollbar.grid_remove()
        canvas.configure(yscrollcommand=lambda *args: None)
        canvas.unbind("<MouseWheel>")

def _add_delete_table_section(self, sidebar: tk.Frame):
    """Add delete table option to the sidebar."""
    delete_table_frame = self._create_frame(
        parent=sidebar,
        width=self.dimensions["sidebar_width"],
        bg=self.colors["sidebar"]
    )
    delete_table_frame.grid(row=2, column=0, sticky='ew', padx=10, pady=(0, 10))
    delete_table_frame.columnconfigure(0, weight=1)
    delete_table_frame.rowconfigure(1, weight=1)

    separator = tk.Frame(delete_table_frame, height=self.dimensions["separator_height"], bg=self.colors["separator"])
    separator.grid(row=0, column=0, sticky='ew', pady=5)

    delete_table_label = self._create_clickable_label(
        parent=delete_table_frame,
        text="🗑 Delete Selected Table",
        command=self.delete_table,
        anchor='center'
    )
    delete_table_label.grid(row=1, column=0, pady=10, sticky='ew')
    self.add_custom_hover(delete_table_label)

def _create_clickable_label(
    self,
    parent: tk.Widget,
    text: str,
    command,
    allow_rename: bool = False,
    anchor: str = 'w'
) -> tk.Label:
    """Create a clickable label with optional rename functionality."""
    cursor = "arrow" if allow_rename else "hand2"
    label = tk.Label(
        parent,
        text=text,
        bg=self.colors["button"],
        fg=self.colors["text"],
        cursor=cursor,
        anchor=anchor,
        font=self.fonts["text"]
    )
    label.bind("<Button-1>", lambda _: command())

    if allow_rename:
        label.bind("<Double-Button-1>", lambda _: self.begin_rename(text))

    label.bind("<MouseWheel>", self._on_mouse_wheel)

    return label

def add_custom_hover(self, widget: tk.Widget):
    """Add custom hover effects to a widget."""
    widget.bind("<Enter>", lambda e: widget.config(bg=self.colors["button_selected"]))
    widget.bind("<Leave>", lambda e: widget.config(bg=self.colors["button"]))

def initialize_data(self):
    """Initialize data structures."""
    self.save_file_path = Path(__file__).parent / "Data.json"
    self.tables_data: dict[str, dict] = {}
    self.current_sheet: Sheet | None = None
    self.headers: dict[str, list[dict[str, str]]] = {}
    self.current_table_name: str | None = None
    self.rename_entry: tk.Entry | None = None
    self.selected_table_label: tk.Label | None = None
    self.table_labels: dict[str, tk.Label] = {}
        
    self.table_name_label = None

    self.filter_header_var = tk.StringVar(value="All")
    self.filter_option_var = tk.StringVar(value="contains")
    self.filter_text_var = tk.StringVar()

    # Added: Initialize displayed_row_indices
    self.displayed_row_indices: list[int] = []

def sort_table_labels(self):
    """Sort table labels with numeric names first, then alphabetic, then alphanumeric."""
    def sort_key(name):
        # Category 1: Starts with digits (e.g., "1. Movies")
        m = re.match(r'^(\d+)', name)
        if m:
            return (1, int(m.group(1)))
        
        # Category 3: Starts with letters followed by digits (e.g., "T1", "T2")
        m = re.match(r'^([A-Za-z]+)(\d+)', name)
        if m:
            return (3, m.group(1).lower(), int(m.group(2)))
        
        # Category 2: Starts with letters only (e.g., "a", "b", "c")
        m = re.match(r'^([A-Za-z]+)', name)
        if m:
            return (2, m.group(1).lower())
        
        # Category 4: Any other names
        return (4, name.lower())
    
    # Sort the table names using the defined sort key
    sorted_tables = sorted(self.tables_data.keys(), key=sort_key)
    
    # Re-pack the labels in the sorted order
    for table_name in sorted_tables:
        label = self.table_labels.get(table_name)
        if label:
            label.pack_forget()
            label.pack(fill='x', padx=0, pady=5, expand=True)

def create_new_table(self):
    """Create a new table."""
    existing_numbers = [int(name.split(" ")[1]) for name in self.tables_data if name.startswith("Table ") and name.split(" ")[1].isdigit()]
    next_number = max(existing_numbers, default=0) + 1
    table_name = f"Table {next_number}"
    self.add_table(table_name)
    self.load_selected_table(table_name)

def import_file(self):
    """Import table from file."""
    file_path = filedialog.askopenfilename(title="Import File", filetypes=[("All Supported Files", "*.json *.csv"), ("JSON files", "*.json"), ("CSV files", "*.csv")])
    if not file_path:
        return
    try:
        if file_path.endswith('.csv'):
            with open(file_path, newline='', encoding='utf-8') as csvfile:
                reader = csv.reader(csvfile)
                data = list(reader)
        elif file_path.endswith('.json'):
            with open(file_path, 'r', encoding='utf-8') as jsonfile:
                data = json.load(jsonfile)
        else:
            raise ValueError("Unsupported file format.")
        if not data or not isinstance(data, list) or not all(isinstance(row, list) for row in data):
            raise ValueError("Invalid data format in the file.")
        headers, table_data = data[0], data[1:]
        self.add_table_from_data(file_path, headers, table_data)
    except Exception as e:
        messagebox.showerror("File Import Error", str(e))

def add_table_from_data(self, file_path: str, headers: list[str], table_data: list[list[str]]):
    """Add a table from file data."""
    table_name = Path(file_path).stem
    table_name = self.ensure_unique_table_name(table_name)
    headers_with_types = [{"name": h, "type": "string"} for h in headers]
    self.add_table(table_name, data=table_data, headers=headers_with_types)
    self.load_selected_table(table_name)
    self.save_data()

def ensure_unique_table_name(self, table_name: str) -> str:
    """Ensure table name is unique."""
    original_name = table_name
    counter = 1
    while table_name in self.tables_data:
        table_name = f"{original_name} (New {counter})"
        counter += 1
    return table_name

def save_table_data(self, file_path: str, data: list[list[str]], format: str):
    """Save table data in specified format."""
    match format:
        case 'csv':
            with open(file_path, 'w', newline='', encoding='utf-8') as file:
                csv.writer(file).writerows(data)
        case 'json':
            with open(file_path, 'w', encoding='utf-8') as file:
                json.dump(data, file, indent=4)
        case _:
            raise ValueError("Unsupported file format.")

def export_table(self):
    """Export current table to file."""
    if not self.current_table_name or self.current_table_name not in self.tables_data:
        messagebox.showwarning("No Table Selected", "Please select a table to export.")
        return
    file_path = filedialog.asksaveasfilename(title="Export File", defaultextension=".json", filetypes=[("JSON files", "*.json"), ("CSV files", "*.csv")], initialfile=self.current_table_name)
    if not file_path:
        return
    try:
        if file_path.endswith('.csv'):
            # Extract header names
            headers = [col['name'] for col in self.headers[self.current_table_name]]
            # Convert all data to strings
            data = [headers] + [[str(cell) for cell in row] for row in self.tables_data[self.current_table_name]["data"]]
            self.save_table_data(file_path, data, 'csv')
        elif file_path.endswith('.json'):
            # Prepare data with headers (including types)
            headers = self.headers[self.current_table_name]
            data = [headers] + self.tables_data[self.current_table_name]["data"]
            with open(file_path, 'w', encoding='utf-8') as file:
                json.dump(data, file, indent=4)
        else:
            raise ValueError("Unsupported file format.")
        self.save_data()
        messagebox.showinfo("Export Successful", f"Table '{self.current_table_name}' has been exported successfully.")
    except Exception as e:
        messagebox.showerror("Export Failed", f"An error occurred during export: {e}")

def add_table(self, table_name: str, data: list[list[str]] | None = None, headers: Optional[list[dict[str, str]]] = None):
    """Add a new table."""
    if headers:
        self.headers[table_name] = headers
    else:
        default_headers = [
            {"name": "Column 1", "type": "string"},
            {"name": "Column 2", "type": "string"},
            {"name": "Column 3", "type": "string"},
            {"name": "Column 4", "type": "string"},
            {"name": "Column 5", "type": "string"}
        ]
        self.headers[table_name] = default_headers
    self.tables_data[table_name] = {"headers": self.headers[table_name], "data": data or [["" for _ in range(len(self.headers[table_name]))] for _ in range(10)]}
    self.create_table_label(table_name)
    self.save_data()

def create_table_label(self, table_name: str):
    """Create label for table."""
    label = self._create_clickable_label(self.table_labels_frame, table_name, lambda: self.load_selected_table(table_name), True)
    label.pack(fill='x', padx=0, pady=5, expand=True)
    self.table_labels[table_name] = label
    self.add_custom_hover(label)
    self.sort_table_labels()

def delete_table(self):
    """Delete selected table."""
    if not self.current_table_name or self.current_table_name not in self.tables_data:
        messagebox.showwarning("No Table Selected", "Please select a valid table to delete.")
        return
    if messagebox.askyesno("Delete Table", f"Are you sure you want to delete the table '{self.current_table_name}'?"):
        self.remove_table(self.current_table_name)

def on_columns_deleted(self, event):
    """Handle column deletion and update filter headers."""
    if not self.current_table_name or not self.current_sheet:
        return
    new_headers = self.current_sheet.headers()
    # Since the user might have deleted columns, we need to remove them from headers
    # Assuming that the order of headers in self.headers matches self.current_sheet
    self.headers[self.current_table_name] = [{"name": h, "type": col['type']} for h, col in zip(new_headers, self.headers[self.current_table_name]) if h]
    self.filter_header_dropdown['values'] = ["All"] + [col['name'] for col in self.headers[self.current_table_name]]
    self.filter_header_var.set("All")
    self.filter_option_var.set("contains")
    self.filter_text_var.set("")
    self.filter_text_entry.config(state='normal')
    self.apply_filter()
    self.save_data()

def remove_table(self, table_name: str):
    """Remove a table."""
    if self.current_table_name == table_name and self.current_sheet:
        self.current_sheet.pack_forget()
        self.current_sheet.destroy()
        self.current_sheet = None
    label = self.table_labels.get(table_name)
    if label:
        label.destroy()
    if table_name in self.tables_data:
        del self.tables_data[table_name]
    if table_name in self.headers:
        del self.headers[table_name]
    if table_name in self.table_labels:
        del self.table_labels[table_name]
    self.current_table_name = None
    self.selected_table_label = None
    self.save_data()
    self.sort_table_labels()

def load_tables(self):
    """Load tables from file."""
    if not self.save_file_path.exists():
        return
    try:
        with self.save_file_path.open('r', encoding='utf-8') as file:
            all_data = json.load(file)
    except Exception as e:
        messagebox.showerror("Load Error", f"Failed to load tables: {e}")
        return
    for table_name, data in all_data.items():
        if not isinstance(data, list) or not data:
            continue
        headers, table_data = data[0], data[1:]
        self.headers[table_name] = headers
        # Ensure each header has 'name' and 'type'
        if all(isinstance(col, dict) and 'name' in col and 'type' in col for col in headers):
            pass
        else:
            # Legacy support: Convert list of header names to dict with type 'string'
            self.headers[table_name] = [{"name": h, "type": "string"} for h in headers]
        self.tables_data[table_name] = {"headers": self.headers[table_name], "data": table_data}
        self.create_table_label(table_name)
    self.sort_table_labels()

def load_selected_table(self, table_name: str):
    """Display selected table."""
    if self.current_sheet:
        self.current_sheet.pack_forget()
        self.current_sheet.destroy()
        self.current_sheet = None
    if self.selected_table_label:
        try:
            self.selected_table_label.config(bg=self.colors["button"])
        except tk.TclError:
            self.selected_table_label = None

    if table_name not in self.tables_data:
        messagebox.showerror("Error", f"Table '{table_name}' does not exist.")
        self.current_table_name = None
        self.selected_table_label = None
        return

    table_info = self.tables_data[table_name]
    headers = [col['name'] for col in table_info["headers"]]
    data = table_info["data"]
    try:
        sheet = Sheet(
            self.table_frame,
            data=self.format_data_for_display(data),
            show_table=True,
            headers=headers,
            font=self.fonts["tksheet"],
            header_font=self.fonts["tksheet"],
            auto_resize_columns=True
        )
        sheet.set_options(table_fg=self.colors["text"], header_fg=self.colors["text"])
        sheet.enable_bindings()
        sheet.extra_bindings([
            ("end_edit_cell", self.on_cell_edit),
            ("end_delete_columns", self.on_columns_deleted)  # Added binding for column deletion
        ])
        sheet.pack(expand=True, fill='both')
        self.current_sheet = sheet
        self.current_table_name = table_name

        if self.table_name_label:
            self.table_name_label.config(text=self.current_table_name)
        else:
            self.table_name_label = tk.Label(
                self.root,
                text=self.current_table_name,
                bg=self.colors["background"],
                fg=self.colors["text"],
                font=self.fonts["header_info"]
            )
            self.table_name_label.grid(row=0, column=0, padx=(60, 10), pady=(5, 0), sticky='nw')

        label = self.table_labels.get(table_name)
        if label:
            self.selected_table_label = label
            try:
                self.selected_table_label.config(bg=self.colors["button_selected"])
            except tk.TclError:
                self.selected_table_label = None
                messagebox.showerror("Error", f"Failed to update the label for '{table_name}'.")
        else:
            self.selected_table_label = None
            messagebox.showerror("Error", f"Label for '{table_name}' not found.")
        
        self.filter_header_var.set("All")
        self.filter_header_dropdown['values'] = ["All"] + headers
        
        self.filter_option_var.set("contains")
        self.update_filter_text_state()
        
        self.apply_filter()
    except Exception as e:
        messagebox.showerror("Sheet Error", f"Failed to load table '{table_name}': {e}")
        self.current_table_name = None
        self.selected_table_label = None

def format_data_for_display(self, data: list[list[Any]]) -> list[list[str]]:
    """Convert all data to strings for display in tksheet."""
    return [[str(cell) for cell in row] for row in data]

def on_cell_edit(self, event=None):
    """Handle cell edits with data type validation."""
    if self.current_table_name and self.current_sheet:
        sheet_data = self.current_sheet.get_sheet_data()
        for idx, row in enumerate(sheet_data):
            if idx < len(self.displayed_row_indices):
                data_idx = self.displayed_row_indices[idx]
                validated_row = []
                conversion_errors = False
                for col_idx, cell in enumerate(row):
                    col_type = self.headers[self.current_table_name][col_idx]['type']
                    try:
                        if col_type == "int":
                            validated_cell = int(cell)
                        elif col_type == "float":
                            validated_cell = float(cell)
                        elif col_type == "boolean":
                            validated_cell = cell.lower() in ["true", "1", "yes"]
                        else:
                            validated_cell = str(cell)
                    except ValueError:
                        messagebox.showerror("Invalid Data", f"Invalid data type for column '{self.headers[self.current_table_name][col_idx]['name']}'. Expected {col_type}.")
                        conversion_errors = True
                        break
                    validated_row.append(validated_cell)
                if conversion_errors:
                    return
                self.tables_data[self.current_table_name]["data"][data_idx] = validated_row
            else:
                # Handle new rows by appending to the underlying data
                validated_row = []
                conversion_errors = False
                for col_idx, cell in enumerate(row):
                    col_type = self.headers[self.current_table_name][col_idx]['type']
                    try:
                        if col_type == "int":
                            validated_cell = int(cell)
                        elif col_type == "float":
                            validated_cell = float(cell)
                        elif col_type == "boolean":
                            validated_cell = cell.lower() in ["true", "1", "yes"]
                        else:
                            validated_cell = str(cell)
                    except ValueError:
                        messagebox.showerror("Invalid Data", f"Invalid data type for column '{self.headers[self.current_table_name][col_idx]['name']}'. Expected {col_type}.")
                        conversion_errors = True
                        break
                    validated_row.append(validated_cell)
                if conversion_errors:
                    return
                self.tables_data[self.current_table_name]["data"].append(validated_row)
        self.save_data()

def save_data(self):
    """Save all tables data."""
    all_data = {}
    for table_name, table_info in self.tables_data.items():
        all_data[table_name] = [table_info["headers"]] + table_info["data"]
    try:
        with self.save_file_path.open('w', encoding='utf-8') as file:
            json.dump(all_data, file, indent=4)
    except Exception as e:
        print(f"Error saving data: {e}")

def apply_filter(self, event=None):
    """Apply filter to table data based on selected criteria."""
    if not self.current_table_name or not self.current_sheet:
        return
    header = self.filter_header_var.get()
    option = self.filter_option_var.get()
    text = self.filter_text_var.get().lower()
    original_data = self.tables_data[self.current_table_name]["data"]

    def row_matches(row):
        if header == "All":
            cells = row
            target_indices = range(len(cells))
        else:
            try:
                target_indices = [self.headers[self.current_table_name].index(next(col for col in self.headers[self.current_table_name] if col['name'] == header))]
            except StopIteration:
                return False
        
        conditions = {
            "is": lambda cell, text: cell == text,
            "is not": lambda cell, text: cell != text,
            "contains": lambda cell, text: text in cell,
            "does not contain": lambda cell, text: text not in cell,
            "starts with": lambda cell, text: cell.startswith(text),
            "ends with": lambda cell, text: cell.endswith(text),
            "is empty": lambda cell, _: cell == "",
            "is not empty": lambda cell, _: cell != ""
        }
        
        for idx in target_indices:
            cell = str(row[idx]).lower()
            if conditions.get(option, lambda _, __: False)(cell, text):
                return True
        return False

    # Collect both filtered data and their original indices
    filtered_data = []
    self.displayed_row_indices = []

    for i, row in enumerate(original_data):
        if row_matches(row):
            filtered_data.append(row)
            self.displayed_row_indices.append(i)

    try:
        self.current_sheet.set_sheet_data(self.format_data_for_display(filtered_data))
    except tk.TclError as e:
        print(f"Error applying filter: {e}")

def rename_headers(self):
    """Rename table headers."""
    if not self.current_table_name:
        messagebox.showwarning("No Table Selected", "Please select a table to rename headers.")
        return
    current_headers = self.headers[self.current_table_name]
    new_headers_str = simpledialog.askstring(
        "Rename Headers", 
        "Enter new headers (comma-separated):", 
        initialvalue=", ".join([col['name'] for col in current_headers])
    )
    if new_headers_str:
        header_list = [header.strip() for header in new_headers_str.split(',')]
        if not header_list:
            messagebox.showerror("Invalid Headers", "Header list cannot be empty.")
            return
        if len(header_list) != len(current_headers):
            messagebox.showerror("Header Count Mismatch", "Number of headers must match existing columns.")
            return
        for col, new_name in zip(current_headers, header_list):
            col['name'] = new_name
        if self.current_sheet:
            try:
                self.current_sheet.headers([col['name'] for col in current_headers])
            except tk.TclError as e:
                messagebox.showerror("Error", f"Failed to rename headers: {e}")
        
        self.filter_header_var.set("All")
        self.filter_header_dropdown['values'] = ["All"] + [col['name'] for col in current_headers]
        self.apply_filter()
        
        self.save_data()

def change_data_types(self):
    """Open a dialog to change data types for each column."""
    if not self.current_table_name:
        messagebox.showwarning("No Table Selected", "Please select a table to change data types.")
        return

    change_dialog = tk.Toplevel(self.root)
    change_dialog.title("Change Data Types")
    change_dialog.grab_set()

    columns = self.headers[self.current_table_name]
    available_types = ["string", "int", "float", "boolean"]

    def save_changes():
        conversion_failed = False
        error_messages = []
        for idx, column in enumerate(columns):
            selected_type = type_vars[idx].get()
            if selected_type != column['type']:
                old_type = column['type']
                column['type'] = selected_type
                # Attempt to convert existing data in this column
                for row_idx, row in enumerate(self.tables_data[self.current_table_name]["data"]):
                    cell = row[idx]
                    try:
                        converted_cell = self.convert_cell(cell, selected_type)
                        self.tables_data[self.current_table_name]["data"][row_idx][idx] = converted_cell
                    except ValueError:
                        default = self.get_default_value(selected_type)
                        self.tables_data[self.current_table_name]["data"][row_idx][idx] = default
                        error_messages.append(f"Row {row_idx + 1}, Column '{column['name']}': '{cell}' cannot be converted to {selected_type}. Set to default '{default}'.")
        self.save_data()
        change_dialog.destroy()
        # Refresh the sheet display
        if self.current_sheet:
            try:
                sheet_data = self.format_data_for_display(self.tables_data[self.current_table_name]["data"])
                self.current_sheet.set_sheet_data(sheet_data)
                self.current_sheet.headers([col['name'] for col in columns])
            except tk.TclError as e:
                messagebox.showerror("Error", f"Failed to update sheet: {e}")
        if error_messages:
            messagebox.showwarning("Data Conversion Warnings", "\n".join(error_messages))

    tk.Label(change_dialog, text="Select Data Types for Columns", font=self.fonts["text"]).grid(row=0, column=0, columnspan=2, pady=10)

    type_vars = []
    for idx, column in enumerate(columns):
        tk.Label(change_dialog, text=column['name'], font=self.fonts["text"]).grid(row=idx+1, column=0, padx=10, pady=5, sticky='e')
        var = tk.StringVar(value=column['type'])
        type_vars.append(var)
        combobox = ttk.Combobox(change_dialog, textvariable=var, values=available_types, state="readonly", font=self.fonts["filter_combobox"])
        combobox.grid(row=idx+1, column=1, padx=10, pady=5, sticky='w')

    save_button = tk.Button(change_dialog, text="Save", command=save_changes, font=self.fonts["text"])
    save_button.grid(row=len(columns)+1, column=0, columnspan=2, pady=10)

def convert_cell(self, cell: Any, target_type: str) -> Any:
    """Convert cell to the target data type."""
    if target_type == "int":
        return int(cell)
    elif target_type == "float":
        return float(cell)
    elif target_type == "boolean":
        if isinstance(cell, bool):
            return cell
        return cell.lower() in ["true", "1", "yes"]
    else:
        return str(cell)

def get_default_value(self, target_type: str) -> Any:
    """Get default value based on target type."""
    if target_type == "int":
        return 0
    elif target_type == "float":
        return 0.0
    elif target_type == "boolean":
        return False
    else:
        return ""

def begin_rename(self, table_name: str):
    """Start renaming a table."""
    if table_name not in self.table_labels:
        messagebox.showerror("Error", f"Table '{table_name}' not found.")
        return
    label = self.table_labels[table_name]
    self.cancel_rename()
    self.rename_entry = tk.Entry(self.table_labels_frame, bg=label.cget("bg"), fg=self.colors["text"], relief='flat')
    self.rename_entry.insert(0, table_name)
    self.rename_entry.place(x=label.winfo_x(), y=label.winfo_y(), width=label.winfo_width(), height=label.winfo_height())
    self.rename_entry.focus()
    self.rename_entry.select_range(0, tk.END)
    self.rename_entry.bind('<Return>', lambda event: self.end_rename(table_name))
    self.rename_entry.bind('<FocusOut>', lambda event: self.cancel_rename())

def end_rename(self, old_name: str):
    """Finalize table renaming."""
    new_name = self.rename_entry.get().strip()
    if not new_name:
        messagebox.showerror("Invalid Name", "Table name cannot be empty.")
        self.rename_entry.focus_set()
        return
    if new_name in self.tables_data and new_name != old_name:
        messagebox.showerror("Duplicate Name", f"A table named '{new_name}' already exists.")
        self.rename_entry.focus_set()
        return
    if new_name != old_name:
        self.update_table_name(old_name, new_name)
        self.load_selected_table(new_name)
    self.cancel_rename()

def update_table_name(self, old_name: str, new_name: str):
    """Update table name and resources."""
    self.tables_data[new_name] = self.tables_data.pop(old_name)
    self.headers[new_name] = self.headers.pop(old_name)
    label = self.table_labels.pop(old_name)
    label.config(text=new_name)
    label.bind("<Button-1>", lambda event: self.load_selected_table(new_name))
    label.bind("<Double-Button-1>", lambda event: self.begin_rename(new_name))
    self.table_labels[new_name] = label
    if self.selected_table_label == label:
        try:
            label.config(bg=self.colors["button_selected"])
        except tk.TclError:
            pass
    self.save_data()
    self.sort_table_labels()

def cancel_rename(self):
    """Cancel rename operation."""
    if self.rename_entry:
        self.rename_entry.destroy()
        self.rename_entry = None

def add_custom_hover(self, label: tk.Label):
    """Add hover effects to label."""
    def on_enter(event):
        if label != self.selected_table_label:
            try:
                label.config(bg=self.colors["button_selected"])
            except tk.TclError:
                pass

    def on_leave(event):
        if label != self.selected_table_label:
            try:
                label.config(bg=self.colors["button"])
            except tk.TclError:
                pass

    label.bind("<Enter>", on_enter)
    label.bind("<Leave>", on_leave)

if name == "main":
set_dpi_awareness()
root = tk.Tk()
app = TableApp(root)
root.mainloop()