Feature: Advanced Tables with Spreadsheet Capabilities & SQL Integration

[ImGajeed76]

Description:

This feature proposes the introduction of advanced, Excel-like tables within Axonotes. The goal is to provide users with powerful data organization, calculation, and analysis tools directly within the application, significantly reducing the need for external spreadsheet software like Excel or Google Sheets.

Core Table Functionality:

• Intuitive Interface: Tables should be easy to create and appear as clean, standard tables by default, suitable for simple data organization.
• Formula Support: Users must be able to define formulas within table cells using a syntax familiar to popular spreadsheet programs (e.g., =SUM(A1:A5), =IF(B2>10, "High", "Low"), =VLOOKUP(...)).
• Rich Cell Data: Support for various data types (text, numbers, dates, booleans) and basic cell formatting (bold, italics, alignment, background color).
• Dynamic Recalculation: Formulas should update automatically when dependent cell values change.
• Standard Operations: Include common spreadsheet operations like sorting, filtering, adding/deleting rows and columns, and resizing.

Benefits:

• Unified Workflow: Enables users to manage and analyze structured data directly alongside their notes, research, and project plans within Axonotes, eliminating context switching.
• Reduced Dependency on External Tools: Lessens the need to export/import data or manage separate spreadsheet files for tasks integral to academic work.
• Enhanced Note-Taking: Allows for richer, more dynamic notes where data can be actively manipulated and analyzed in place.

Integration with User's Private SQL Database (Ref: Issue #11):
Issue #11 outlines a proposal for a user-managed, private SQLite database within Axonotes. This database is intended for offline-first access, cross-device synchronization via SpaceTimeDB, and enabling procedural content generation in notes through direct SQL queries. The advanced table feature can be powerfully integrated with this private SQL database in the following ways:

• SQL-Powered Formulas & Data Retrieval: Beyond standard spreadsheet functions, table cells could support a special formula syntax to execute SQL queries against the user's private database. For example, a cell could display the result of a query like AXSQL("SELECT AVG(grade) FROM exam_results WHERE subject='Physics'"). This would unlock sophisticated data aggregation, joining, and filtering capabilities directly within the table interface.
• User-Managed Structure: Users could leverage the table interface to visually manage the structure (columns, data types) of the underlying SQL tables in their private database, offering a more user-friendly approach than raw SQL for common schema modifications.
• Scoped Access: In line with the principles of Issue Feature Proposal: User-Managed Private SQLite Database for Procedural Content in Notes #11, all interactions with the private SQLite database, whether through direct queries or via these advanced tables, would remain strictly scoped to the Axonotes application, ensuring data privacy and preventing misuse as a generic database hosting service.