LiveLedger - A Windows Terminal Spreadsheet Calculator

A powerful, vi-style spreadsheet application that runs entirely in the Windows terminal/console. LiveLedger combines the functionality of a traditional spreadsheet with the efficiency of keyboard-driven navigation, making it perfect for quick calculations, data analysis, and spreadsheet work without leaving the command line.

Features

Core Functionality

Full spreadsheet capabilities with 1000 rows × 100 columns
Multiple data types: Numbers, strings, formulas, and error handling
Real-time formula evaluation with automatic recalculation
Vi-style keyboard navigation for efficient operation
Double-buffered rendering for smooth 60 FPS display
Blinking cursor with visual feedback

Supported Functions

Mathematical: SUM, AVG, MAX, MIN, MEDIAN, MODE, POWER
Conditional: IF(condition, true_value, false_value)
Lookup: XLOOKUP(lookup_value, lookup_array, return_array, [match_mode])
Operators: +, -, *, /, >, <, >=, <=, =, <>
Cell ranges: A1:A10, B1:C5 for aggregate functions
ASCII Charts Generate line, bar, pie, and scatter charts directly in the terminal

Advanced Features

Copy/Paste: Full cell copying with Ctrl+C and Ctrl+V
Range Operations: Select, copy, and paste entire ranges of cells
Data Formatting: Professional formatting options for numbers, dates, and currency
Cell Color Formatting: Customizable text and background colors with 8 preset colors or hex values
Dynamic Column/Row Resizing: Adjustable column widths and row heights using Alt+Arrow keys
Multi-Cell Resizing: Resize multiple columns or rows simultaneously using range selection
Insert/Delete Rows/Columns: Insert and delete rows and columns at cursor position with keyboard shortcuts
Formula dependencies: Automatic dependency tracking and recalculation
Error handling: Division by zero, reference errors, parse errors, and lookup errors
Cell formatting: Width, precision, and alignment support
Command mode: Vi-style commands for advanced operations
Auto-save: Automatic backup every 3 minutes to timestamped files in the AS directory

Installation

Prerequisites

Windows 10/11 or Windows Server 2016+
One of the following compilers:
Visual Studio Build Tools

Building from Source

Clone the repository:

git clone https://github.com/BitEU/LiveLedger.git
cd LiveLedger

Build using the provided script:
```
.\build.bat
```
Run the application:
```
LL.exe
```

Usage

Basic Navigation

h - Move left
j - Move down
k - Move up
l - Move right
Arrow keys - Alternative navigation
Page Up/Down - Jump 10 rows

Data Entry

= - Enter number or formula mode (starts fresh)
" - Enter text/string mode (starts fresh)
e - Edit current cell contents (pre-filled with existing value)
: - Enter command mode
Enter - Confirm input
Escape - Cancel input
Backspace - Delete character before cursor
Delete - Delete character at cursor
Left/Right Arrow - Move cursor within input
Home/End - Jump to start/end of input

Cell Operations

x - Clear current cell
Ctrl+C - Copy current cell (internal)
Ctrl+V - Paste copied cell (internal)
Ctrl+Shift+C - Copy current cell (external)
Ctrl+Shift+V - Paste copied cell (external)
Range Selection:
- Shift+Arrow keys - Select cell ranges
- Shift+C - Copy selected range
- Shift+V - Paste range at current position
Data Formatting:
- Ctrl+Shift+1 - Format as number
- Ctrl+Shift+3 - Cycle through date/time formats (13 different options)
- Ctrl+Shift+4 - Format as currency
- Ctrl+Shift+5 - Format as percentage
Column and Row Resizing:
- Alt+Left Arrow - Decrease column width
- Alt+Right Arrow - Increase column width
- Alt+Up Arrow - Decrease row height
- Alt+Down Arrow - Increase row height
- Works with range selection - Resize multiple columns/rows at once
Insert/Delete Rows and Columns:
- Ctrl+Shift+I - Insert new row at cursor position (default height)
- Ctrl+Shift+O - Insert new column at cursor position (default width)
- Ctrl+Shift+Alt+I - Delete row at cursor position
- Ctrl+Shift+Alt+O - Delete column at cursor position
Ctrl+Q - Quick quit

Command Mode

:q or :quit - Quit application

Formatting Commands:

:format general - Apply general number formatting
:format percentage - Apply percentage formatting
:format currency - Apply currency formatting
:format date - Apply date formatting (MM/DD/YYYY)
:format date dd/mm/yyyy - Apply European date formatting
:format date yyyy-mm-dd - Apply ISO date formatting
:format time - Apply 12-hour time formatting
:format time 24hr - Apply 24-hour time formatting
:format time seconds - Apply time formatting with seconds

Color Commands:

:clrtx <color> - Set text color (e.g., :clrtx red, :clrtx #FF0000)
:clrbg <color> - Set background color (e.g., :clrbg yellow, :clrbg #FFFF00)

Range Formatting Commands:

:range format <type> - Apply formatting to selected range
- :range format percentage
- :range format currency
- :range format date
- :range format time
- :range format general

Available Colors:

Named colors: black, blue, green, cyan, red, magenta, yellow, white
Hex colors: #000000 to #FFFFFF (e.g., #FF0000 for red)

CSV File Operations

LiveLedger provides comprehensive CSV (Comma-Separated Values) file support, allowing you to import data from external sources and export your spreadsheet calculations for use in other applications.

Saving to CSV

To save your current spreadsheet to a CSV file, use the savecsv command in command mode:

Syntax: :savecsv <filename>

Examples:

:savecsv data.csv - Save to data.csv in the current directory
:savecsv C:\Documents\report.csv - Save with full path
:savecsv budget_2024.csv - Save with descriptive filename

When saving to CSV, you'll be prompted to choose between two formats:

CSV Format Options

Flatten Mode (f): Save calculated values

Formulas are evaluated and their results are saved
Best for sharing data with other applications
Preserves the visual output of your spreadsheet
Example: A cell containing =SUM(A1:A5) saves as 150 (the calculated result)

Preserve Mode (p): Save formulas as text

Formulas are saved as text strings with their original expressions
Best for backing up your work or sharing with other LiveLedger users
Maintains the logic and structure of your spreadsheet
Example: A cell containing =SUM(A1:A5) saves as "=SUM(A1:A5)"

Loading from CSV

To load data from a CSV file into your current spreadsheet, use the loadcsv command:

Syntax: :loadcsv <filename>

Examples:

:loadcsv data.csv - Load from data.csv in the current directory
:loadcsv C:\Documents\import.csv - Load with full path
:loadcsv sales_data.csv - Load sales data

Important Notes:

Loading CSV data will overwrite existing cells in the affected range
The data will be loaded starting from cell A1
Text fields containing formulas (from preserve mode) will be interpreted as formulas
Numeric data will be automatically recognized and converted
Empty cells in the CSV will clear corresponding spreadsheet cells

CSV Format Compatibility

LiveLedger's CSV implementation follows standard CSV formatting rules:

Supported Features:

Comma-separated values
Quoted text fields containing commas
Escaped quotes within quoted fields ("" becomes ")
Mixed data types (numbers, text, formulas)
Empty fields and rows
Windows and Unix line endings

Example CSV Format:

Name,Age,Salary,Department
"Smith, John",35,50000,Engineering
"Doe, Jane",28,45000,"Human Resources"
Bob,42,55000,Sales
Alice,31,,Marketing

This CSV would load as:

A1: Name, B1: Age, C1: Salary, D1: Department
A2: Smith, John, B2: 35, C2: 50000, D2: Engineering
A3: Doe, Jane, B3: 28, C3: 45000, D3: Human Resources
A4: Bob, B4: 42, C4: 55000, D4: Sales
A5: Alice, B5: 31, C5: (empty), D5: Marketing

Auto-Save Feature

LiveLedger includes an automatic backup system that saves your work periodically without interruption.

How It Works:

Automatically saves every 3 minutes
Creates timestamped backup files in the AS directory
Saves formulas in preserve mode (formulas are saved as text strings)
Runs silently in the background without interrupting your work

Backup File Format:

Directory: AS/ (created automatically in the program directory)
Filename Format: YYYY-MM-DD HH-MM-SS.csv
Example: AS/2024-12-25 14-30-45.csv

Benefits:

Protection against crashes: Your work is backed up regularly
Version history: Each autosave creates a new file, allowing you to recover from earlier time points
No manual intervention: Autosave happens automatically without requiring user action
Preserves formulas: Saved files maintain your formula logic for easy restoration

Restoring from Autosave: To restore from an autosave backup, use the standard load command:

:loadcsv AS/2024-12-25 14-30-45.csv

Notes:

The first autosave occurs 3 minutes after launching LiveLedger
Autosaves do not overwrite each other - each creates a new timestamped file
You may want to periodically clean old autosave files to save disk space
Autosave files are standard CSV files compatible with Excel and other spreadsheet applications

Charting Features

LiveLedger includes powerful ASCII chart generation capabilities that allow you to visualize your data directly in the terminal. All charts are rendered using ASCII characters and support multiple data series with automatic scaling, legends, and labels.

Supported Chart Types

1. Line Charts

Line charts display data points connected by lines, ideal for showing trends over time or continuous data relationships.

Command: :line [x_label] [y_label]

Examples:

:line - Create a basic line chart with default labels
:line Time Sales - Create a line chart with "Time" as X-axis and "Sales" as Y-axis
:line Month Revenue - Plot monthly revenue trends

Use Cases:

Time series data (sales trends, stock prices, temperature changes)
Continuous variable relationships
Progress tracking over time

2. Bar Charts

Bar charts display data as horizontal or vertical bars, perfect for comparing discrete categories or values.

Command: :bar [x_label] [y_label]

Examples:

:bar - Create a basic bar chart with default labels
:bar Product Sales - Compare sales across different products
:bar Department Budget - Compare budgets by department

Use Cases:

Category comparisons
Ranking data (top performers, best sellers)
Budget allocations
Survey results

3. Pie Charts

Pie charts display data as slices of a circle, showing the proportion of each category to the whole.

Command: :pie

Examples:

:pie - Create a pie chart of selected data

Use Cases:

Market share distribution
Budget breakdowns by category
Percentage distributions
Composition analysis

Note: Pie charts work best with 2-8 categories for clarity.

4. Scatter Plots

Scatter plots display individual data points to show relationships or correlations between two variables.

Command: :scatter [x_label] [y_label]

Examples:

:scatter - Create a basic scatter plot
:scatter Height Weight - Plot height vs. weight correlation
:scatter Study_Hours Test_Score - Analyze study time impact on test scores

Use Cases:

Correlation analysis
Outlier detection
Distribution patterns
Relationship visualization between two variables

Using Charts

Step-by-Step Process:

Select Your Data Range
- Use Shift + Arrow keys to select the data you want to chart
- For most chart types, use at least 2 columns:
  - First column: Categories, labels, or X-axis values
  - Second column: Values or Y-axis data
- Additional columns will be plotted as separate data series
Enter Chart Command
- Press : to enter command mode
- Type the chart command (e.g., :line, :bar, :pie, :scatter)
- Optionally add custom axis labels
- Press Enter to generate the chart
View the Chart
- The chart appears in a popup window overlaying the spreadsheet
- Charts automatically scale to fit the terminal window
- Legends show data series names and symbols
- Grid lines and axes are clearly labeled
Close the Chart
- Press any key to close the chart and return to the spreadsheet
- The range selection is automatically cleared

Chart Data Requirements

Minimum Requirements:

At least 2 columns of data (except for single-series bar/pie charts)
At least 2 rows of data points

Data Structure:

Column A    | Column B    | Column C (optional)
------------|-------------|-------------------
Category 1  | Value 1     | Series 2 Value 1
Category 2  | Value 2     | Series 2 Value 2
Category 3  | Value 3     | Series 2 Value 3

Multiple Data Series:

Columns beyond the first two are treated as additional data series
Each series is plotted with a unique symbol
Legends automatically display all series

Chart Features

Automatic Scaling:

Charts automatically calculate appropriate X and Y axis ranges
Min and max values are determined from your data
Scaling ensures all data points are visible

Axis Labels:

X-axis and Y-axis labels can be customized via command parameters
Default labels are "X" and "Y" if not specified
Labels appear on the chart borders

Legends:

Automatically generated for multi-series data
Shows series name and plotting symbol
Positioned on the right side of the chart

Grid Lines:

Optional grid lines for easier value reading
Scaled tick marks on both axes

Chart Help

For quick reference while working in LiveLedger, use:

:chart help - Display chart command syntax
:help chart - Display chart command syntax

Example: Creating a Sales Chart

1. Enter your data:
   A1: "Q1"    B1: 45000   C1: 42000
   A2: "Q2"    B2: 52000   C2: 48000
   A3: "Q3"    B3: 48000   C3: 51000
   A4: "Q4"    B4: 61000   C4: 58000

2. Select the range A1:C4 using Shift+arrows

3. Enter command: :line Quarter Sales

4. View your line chart showing two series (columns B and C)

5. Press any key to close and return to editing

Functions

LiveLedger supports a comprehensive set of built-in functions for mathematical calculations, statistical analysis, and conditional logic. All functions are case-sensitive and must be entered in UPPERCASE.

1. SUM Function

Syntax: =SUM(range) or =SUM(value1, value2, ...) Description: Calculates the sum of all numeric values in the specified range or arguments.

Examples:

=SUM(A1:A6) - Sum cells A1 through A6
=SUM(B33:G33) - Sum cells B33 through G33 (horizontal range)
=SUM(A1:C3) - Sum all cells in the rectangular range A1 to C3
=SUM(A1:A10, C1:C5) - Sum multiple ranges (if implemented)

2. AVG Function

Syntax: =AVG(range) or =AVG(value1, value2, ...) Description: Calculates the arithmetic mean (average) of all numeric values in the specified range.

Examples:

=AVG(A1:A10) - Average of cells A1 through A10
=AVG(B1:B20) - Average of cells B1 through B20
=AVG(A1:E1) - Average of cells A1 through E1 (horizontal range)
=AVG(A1:C3) - Average of all cells in the rectangular range A1 to C3

3. MAX Function

Syntax: =MAX(range) or =MAX(value1, value2, ...) Description: Returns the largest (maximum) value from the specified range or arguments.

Examples:

=MAX(A1:A10) - Maximum value in cells A1 through A10
=MAX(B1:D1) - Maximum value in cells B1 through D1
=MAX(A1:C5) - Maximum value in the rectangular range A1 to C5
=MAX(A1:A5, C1:C5) - Maximum value across multiple ranges

4. MIN Function

Syntax: =MIN(range) or =MIN(value1, value2, ...) Description: Returns the smallest (minimum) value from the specified range or arguments.

Examples:

=MIN(A1:A10) - Minimum value in cells A1 through A10
=MIN(B1:D1) - Minimum value in cells B1 through D1
=MIN(A1:C5) - Minimum value in the rectangular range A1 to C5
=MIN(A1:A5, C1:C5) - Minimum value across multiple ranges

5. MEDIAN Function

Syntax: =MEDIAN(range) or =MEDIAN(value1, value2, ...) Description: Returns the median (middle value) of the specified range. For even number of values, returns the average of the two middle values.

Examples:

=MEDIAN(A1:A9) - Median of cells A1 through A9 (odd count)
=MEDIAN(A1:A10) - Median of cells A1 through A10 (even count)
=MEDIAN(B1:E1) - Median of horizontal range B1 through E1
=MEDIAN(A1:C3) - Median of all values in rectangular range A1 to C3

6. MODE Function

Syntax: =MODE(range) or =MODE(value1, value2, ...) Description: Returns the most frequently occurring value in the specified range. If multiple values have the same highest frequency, returns the first one encountered.

Examples:

=MODE(A1:A10) - Most frequent value in cells A1 through A10
=MODE(B1:B20) - Most frequent value in cells B1 through B20
=MODE(A1:E1) - Most frequent value in horizontal range A1 through E1
=MODE(A1:C5) - Most frequent value in rectangular range A1 to C5

7. IF Function

Syntax: =IF(condition, true_value, false_value) Description: Evaluates a condition and returns one value if true, another if false. Supports both numeric and string values.

Comparison Operators:

= (equals), <> (not equals)
< (less than), > (greater than)
<= (less than or equal), >= (greater than or equal)

Examples:

=IF(A1>10, "High", "Low") - Return "High" if A1 > 10, otherwise "Low"
=IF(B1=0, "Zero", B1*2) - Return "Zero" if B1 is 0, otherwise double B1
=IF(A1>=B1, A1, B1) - Return the larger of A1 or B1
=IF(C1="Yes", 100, 0) - Return 100 if C1 contains "Yes", otherwise 0
=IF(A1<>B1, "Different", "Same") - Compare two cells for equality

String Comparisons:

=IF(A1="Apple", "Fruit", "Other") - Check if A1 contains "Apple"
=IF(B1<>"", "Has Value", "Empty") - Check if B1 is not empty

8. POWER Function

Syntax: =POWER(base, exponent) Description: Raises a number to a specified power (base^exponent).

Examples:

=POWER(2, 3) - Calculate 2³ = 8
=POWER(A1, 2) - Square the value in A1
=POWER(10, B1) - Calculate 10 raised to the power of B1
=POWER(A1, 0.5) - Calculate square root of A1 (A1^0.5)
=POWER(A1, 1/3) - Calculate cube root of A1

9. XLOOKUP Function

Syntax: =XLOOKUP(lookup_value, lookup_array, return_array, [match_mode]) Description: Searches for a value in a lookup array and returns a value in the same position from a return array. It can search any column/row and return from any column/row.

Parameters:

lookup_value - The value to search for (can be number, string, or cell reference)
lookup_array - The range to search in (e.g., "A1:A10" or "B2:E2")
return_array - The range to return values from (must be same size as lookup_array)
match_mode - Optional: 0 for exact match (default), 1 for approximate match

Examples:

=XLOOKUP("Apple", A1:A10, B1:B10, 0) - Find "Apple" in column A, return corresponding value from column B
=XLOOKUP(B1, D1:D100, F1:F100, 0) - Look up value in B1, return from F column
=XLOOKUP(1001, A1:A50, E1:E50, 0) - Exact match lookup for employee ID
=XLOOKUP("Product X", A2:A100, D2:D100, 0) - Search product names, return from column D
=XLOOKUP(A1, B1:E1, B2:E2, 0) - Horizontal lookup (search in row, return from another row)

Lookup Table Example:

    A        B       C       D
1   Item     Price   Stock   Category
2   Apple    1.20    50      Fruit
3   Banana   0.80    30      Fruit  
4   Carrot   0.60    25      Vegetable
5   Donut    2.50    15      Bakery

XLOOKUP Examples with this table:

=XLOOKUP("Apple", A1:A5, B1:B5, 0) → Returns 1.20 (price of Apple)
=XLOOKUP("Banana", A1:A5, C1:C5, 0) → Returns 30 (stock of Banana)
=XLOOKUP("Carrot", A1:A5, D1:D5, 0) → Returns "Vegetable" (category of Carrot)
=XLOOKUP("Orange", A1:A5, B1:B5, 0) → Returns #N/A! (Orange not found)
=XLOOKUP("Donut", A2:A5, B2:B5, 0) → Returns 2.50 (price of Donut, searching A2:A5)

Error Handling:

#N/A! - Lookup value not found in first column
#REF! - Invalid table range or column index out of bounds
#VALUE! - Invalid parameters or data type mismatch

Mathematical Operators

Arithmetic Operators:

+ Addition: =A1+B1, =SUM(A1:A5)+10
- Subtraction: =A1-B1, =MAX(A1:A5)-MIN(A1:A5)
* Multiplication: =A1*B1, =A1*2.5
/ Division: =A1/B1, =SUM(A1:A5)/5

Complex Formula Examples:

=SUM(A1:A10)/MAX(B1:B10) - Ratio of sum to maximum
=IF(AVG(A1:A10)>50, "Pass", "Fail") - Conditional based on average
=POWER(A1, 2) + POWER(B1, 2) - Sum of squares
=IF(A1>0, POWER(A1, 0.5), 0) - Square root if positive, else 0

Range Notation

Supported Range Formats:

A1:A10 - Vertical range (column A, rows 1-10)
A1:E1 - Horizontal range (row 1, columns A-E)
A1:C3 - Rectangular range (3×3 block)
B5:D10 - Rectangular range (3×6 block)

Range Examples:

Single column: =SUM(A1:A100)
Single row: =AVG(A1:Z1)
Rectangle: =MAX(A1:E10)
Large range: =MIN(A1:Z100)

Data Formatting

LiveLedger now supports professional data formatting options to enhance the appearance and readability of your spreadsheets. Formatting is applied to individual cells and preserved during copy/paste operations.

Supported Format Types

1. General Format (Default)

Description: Standard numeric display with automatic decimal precision. Example: 1234.56789 displays as 1234.57 (with 2 decimal precision)

2. Percentage Format

Keyboard Shortcut: Ctrl+Shift+5 Description: Displays numbers as percentages with the % symbol. Examples:

0.1234 displays as 12.34%
0.5 displays as 50.00%
1.25 displays as 125.00%

3. Currency Format

Keyboard Shortcut: Ctrl+Shift+4 Description: Displays numbers as currency with $ symbol and proper negative formatting. Examples:

1234.56 displays as $1234.56
-500.00 displays as -$500.00
0 displays as $0.00

4. Date and Time Formats

Keyboard Shortcut: Ctrl+Shift+3 (cycles through all date/time formats) Description: Displays numbers as dates and times using Excel-style serial date system. Pressing the shortcut repeatedly cycles through all available formats.

Available Formats:

Date Formats:

MM/DD/YYYY: 12/25/2023 (American format)
DD/MM/YYYY: 25/12/2023 (European format)
YYYY-MM-DD: 2023-12-25 (ISO format)
MM/DD/YY: 12/25/23 (Short date)
Mon DD, YYYY: Dec 25, 2023 (Long format with month name)
DD Mon YYYY: 25 Dec 2023 (European long format)

Time Formats:

12-Hour: 2:30 PM, 11:45 AM
24-Hour: 14:30, 23:45
With Seconds: 14:30:45, 09:15:30
12-Hour with Seconds: 2:30:45 PM, 11:45:30 AM

DateTime Formats:

Short DateTime: 12/25/23 2:30 PM
Long DateTime: Dec 25, 2023 2:30:45 PM
ISO 8601: 2023-12-25T14:30:45

Examples:

44927 displays as 12/25/2023 (Excel serial date)
45000 displays as 04/13/2024
44927.5 displays as 12/25/2023 12:00 PM
45000.75 displays as 04/13/2024 6:00 PM
0.5 displays as 12:00 PM (noon)
0.75 displays as 6:00 PM
0.25 displays as 6:00 AM

Usage: Simply press Ctrl+Shift+3 repeatedly to cycle through all 13 different date/time formatting options. The current format will be displayed in the status bar.

5. Cell Color Formatting

Description LiveLedger now supports customizable text and background colors for individual cells or ranges of cells.

Command Syntax:

Text Color: :clrtx <color> - Sets the text (foreground) color
Background Color: :clrbg <color> - Sets the background color

Supported Colors:

Named Colors: black, blue, green, cyan, red, magenta, yellow, white
Hex Colors: #000000 (black), #FF0000 (red), #00FF00 (green), #0000FF (blue), #FFFFFF (white), etc.

Examples:

:clrtx red          # Set text color to red
:clrbg yellow       # Set background color to yellow
:clrtx #FF0000      # Set text color to red using hex
:clrbg #FFFF00      # Set background color to yellow using hex

Range Application:

Select a range of cells using Shift+Arrow keys
Apply color commands to the entire selected range
Individual cells can have different colors

6. Dynamic Column and Row Resizing

Description Adjust column widths and row heights dynamically using Alt+Arrow keys.

Keyboard Shortcuts:

Alt+Left Arrow: Decrease column width
Alt+Right Arrow: Increase column width
Alt+Up Arrow: Decrease row height
Alt+Down Arrow: Increase row height

Range Resizing:

Select multiple columns/rows using Shift+Arrow keys
Use Alt+Arrow keys to resize all selected columns/rows simultaneously
Minimum column width: 1 character
Maximum column width: 50 characters
Minimum row height: 1 line
Maximum row height: 10 lines

Examples:

Position cursor on column C, press Alt+Right to make column C wider
Select range A1:D10, press Alt+Left to make columns A-D narrower
Select range A1:A10, press Alt+Down to make rows 1-10 taller
Select range A1:E5, press Alt+Up to make rows 1-5 shorter

Format Application

Via Keyboard Shortcuts:

Ctrl+Shift+1 - Apply number formatting
Ctrl+Shift+3 - Cycle through all date/time formats (13 different formats)
Ctrl+Shift+4 - Apply currency formatting (Excel-style)
Ctrl+Shift+5 - Apply percentage formatting (Excel-style)

Via Command Mode:

:format general     - Apply general number formatting
:format percentage  - Apply percentage formatting
:format currency    - Apply currency formatting
:format date        - Apply date formatting
:format time        - Apply time formatting
:clrtx <color>      - Set text color
:clrbg <color>      - Set background color

Format Persistence

Copy/Paste: Formatting is preserved when copying cells or ranges
CSV Export: Formatting is preserved in "preserve mode" CSV exports
Cell Clearing: Clearing cell content (x key) preserves formatting
Value Changes: Changing cell values maintains existing formatting

Architecture

Core Components

Application State (main.c)
- Manages UI rendering and user interaction
- Handles cursor movement and blinking
- Coordinates between console and spreadsheet
Spreadsheet Engine (sheet.h)
- Cell storage and data management
- Formula parsing and evaluation
- Dependency tracking and recalculation
- Built-in function implementations
Console Wrapper (console.h)
- Windows Console API abstraction
- Double-buffered rendering
- Keyboard input handling
- Color and cursor management

Error Handling

LiveLedger provides comprehensive error handling with clear error messages:

#DIV/0! - Division by zero
#REF! - Invalid cell reference or range
#VALUE! - Invalid value or type mismatch
#PARSE! - Formula parsing error
#N/A! - Value not available (XLOOKUP not found)
#DATE! - Invalid date conversion
Range boundary errors - Automatic handling of out-of-bounds operations

Future Enhancements

Continue bugfixing the plotting feature
Conditional formatting
Search and replace
Sorting and filtering
Print preview and printing
Support named ranges
Add a configuration ini file for program defaults
Freeze row 1 or column a while scrolling
Implement a better help system in TUI format

Contributing

Contributions are welcome! Please feel free to submit pull requests or open issues for bugs and feature requests.

Development Setup

Fork the repository
Create a feature branch
Make your changes
Test thoroughly on Windows
Submit a pull request

License

This project is licensed under the GNU General Public License v3.0 - see the LICENSE file for details.

Acknowledgments

Inspired by classical spreadsheet applications like VisiCalc and sc-im
Vi-style navigation inspired by Vim text editor
Built with the Windows Console API for optimal terminal performance
A lot of inspiration taken from MS Excel, the lifeblood of the global economy

Name		Name	Last commit message	Last commit date
Latest commit History 37 Commits
.gitattributes		.gitattributes
.gitignore		.gitignore
IMPROVEMENT_REPORT.md		IMPROVEMENT_REPORT.md
LICENSE		LICENSE
README.md		README.md
build.bat		build.bat
build_tests.bat		build_tests.bat
charts.c		charts.c
charts.h		charts.h
compat.h		compat.h
console.c		console.c
console.h		console.h
constants.h		constants.h
liveledger.ico		liveledger.ico
main.c		main.c
resource.rc		resource.rc
sheet.c		sheet.c
sheet.h		sheet.h
template.csv		template.csv
test_liveledger.c		test_liveledger.c
test_liveledger_advanced.c		test_liveledger_advanced.c

License

WinDOS-CLI/LiveLedger

Folders and files

Latest commit

History

Repository files navigation

LiveLedger - A Windows Terminal Spreadsheet Calculator

Table of Contents

Features

Core Functionality

Supported Functions

Advanced Features

Installation

Prerequisites

Building from Source

Usage

Basic Navigation

Data Entry

Cell Operations

Command Mode

CSV File Operations

Saving to CSV

CSV Format Options

Loading from CSV

CSV Format Compatibility

Auto-Save Feature

Charting Features

Supported Chart Types

1. Line Charts

2. Bar Charts

3. Pie Charts

4. Scatter Plots

Using Charts

Chart Data Requirements

Chart Features

Chart Help

Example: Creating a Sales Chart

Functions

1. SUM Function

2. AVG Function

3. MAX Function

4. MIN Function

5. MEDIAN Function

6. MODE Function

7. IF Function

8. POWER Function

9. XLOOKUP Function

Mathematical Operators

Range Notation

Data Formatting

Supported Format Types

1. General Format (Default)

2. Percentage Format

3. Currency Format

4. Date and Time Formats

5. Cell Color Formatting

6. Dynamic Column and Row Resizing

Format Application

Format Persistence

Architecture

Core Components

Error Handling

Future Enhancements

Contributing

Development Setup

License

Acknowledgments

About

Topics

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases 2

Packages 0

Languages

Packages