### Build and Install SC-IM (bash)

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im-with-xls-support-on-macOS

Cleans previous build artifacts, compiles the SC-IM project, and installs it system-wide. This is the final step to get SC-IM running.

```bash
make clean
make
sudo make install
```

--------------------------------

### Build and Install sc-im

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Fedora-27

Compiles the sc-im project using the 'make' utility and then installs it system-wide. The 'make install' command typically places executables in standard system paths.

```bash
make
sudo make install
```

--------------------------------

### Compile and Install sc-im

Source: https://github.com/andmarti1424/sc-im/wiki/Ubuntu-with-XLSX-import-&-export

Clones the sc-im source code from its GitHub repository, compiles the program using make, and installs it system-wide. This is the final step in setting up sc-im.

```shell
$ cd ..
$ git clone https://github.com/andmarti1424/sc-im.git
$ cd sc-im/src
$ make
$ sudo make install
```

--------------------------------

### Install libxls Dependency (bash)

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im-with-xls-support-on-macOS

Downloads, extracts, configures, builds, and installs the libxls library, a dependency for SC-IM. It involves fetching the source, running configuration, compiling, and installing system-wide.

```bash
curl -L https://github.com/libxls/libxls/releases/download/v1.6.3/libxls-1.6.3.tar.gz | tar -zxvf -
cd libxls-1.6.3
./configure
make
sudo make install
cd ..
```

--------------------------------

### sc-im Configuration Example

Source: https://github.com/andmarti1424/sc-im/wiki/Ubuntu-with-XLSX-import-&-export

An example of the sc-im configuration file (`~/.config/scim/scimrc`). These settings control various aspects of the spreadsheet application's behavior, such as automatic calculation and numeric formatting.

```config
set autocalc
set numeric
set numeric_decimal=0
set overlap
set xlsx_readformulas
```

--------------------------------

### Install sc-im System Dependencies

Source: https://github.com/andmarti1424/sc-im/wiki/Ubuntu-with-XLSX-import-&-export

Installs essential system libraries required for compiling and running sc-im. This includes development tools and libraries for XML, ZIP, and ncurses.

```shell
$ sudo apt-get install bison libncurses5-dev libncursesw5-dev libxml2-dev libzip-dev pkg-config
```

--------------------------------

### Clone sc-im Repository

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Fedora-27

Downloads the source code for the sc-im project from its GitHub repository. This is the first step in obtaining the project files.

```sh
git clone https://github.com/andmarti1424/sc-im.git
```

--------------------------------

### Install libxlsxwriter Library

Source: https://github.com/andmarti1424/sc-im/wiki/Ubuntu-with-XLSX-import-&-export

Downloads, compiles, and installs the libxlsxwriter library, which is necessary for sc-im to handle .xlsx file formats. This involves cloning the repository, building, and installing.

```shell
$ git clone https://github.com/jmcnamara/libxlsxwriter.git
$ cd libxlsxwriter/
$ make
$ sudo make install
```

--------------------------------

### Build and Install sc-im

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im-with-xls-support-on-Debian

Executes the standard make commands to compile the sc-im project and install it to the system. This assumes the Makefile has been correctly configured for the environment.

```bash
make
make install
```

--------------------------------

### Clone SC-IM Repository and Navigate (bash)

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im-with-xls-support-on-macOS

Clones the SC-IM project from its GitHub repository and navigates into the project directory. This is the first step in obtaining the source code.

```bash
git clone https://github.com/andmarti1424/sc-im
cd sc-im
```

--------------------------------

### Install Project Dependencies

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Fedora-27

Installs essential development libraries and tools required for building the sc-im project. This command uses the 'dnf' package manager, common on Fedora-based systems.

```sh
sudo dnf install libzip-devel libxml2-devel ncurses-devel byacc git gcc gnuplot
```

--------------------------------

### Build and Installation Commands

Source: https://github.com/andmarti1424/sc-im/blob/main/Readme.md

These commands outline the process for building and installing sc-im from source. It includes editing the Makefile for system-specific configurations, compiling the project, and optionally installing the binary to the system.

```Shell
# Navigate to the source directory
cd src

# Compile the sc-im project
make

# Optionally, install the binary system-wide (requires privileges)
# make install
```

--------------------------------

### Navigate to Source Directory

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Fedora-27

Changes the current working directory to the 'src' folder within the cloned sc-im project. This is typically where build commands are executed.

```sh
cd sc-im/src/
```

--------------------------------

### Install Xcode Command Line Tools (bash)

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im-with-xls-support-on-macOS

Installs essential command-line developer tools provided by Apple Xcode. This is a prerequisite for many development tasks on macOS.

```bash
xcode-select --install
```

--------------------------------

### Install libxml2 via Homebrew (bash)

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im-with-xls-support-on-macOS

Installs the libxml2 library using the Homebrew package manager. libxml2 is a dependency required for SC-IM's XML processing capabilities.

```bash
brew install libxml2
```

--------------------------------

### Run sc-im

Source: https://github.com/andmarti1424/sc-im/wiki/Ubuntu-with-XLSX-import-&-export

Executes the sc-im program from the command line after installation. This command launches the spreadsheet application.

```shell
$ ./sc-im
```

--------------------------------

### Execute sc-im

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Fedora-27

Runs the sc-im command-line tool. It typically requires a filename as an argument to process.

```bash
scim <filename>
```

--------------------------------

### Install Core Dependencies

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-FreeBSD

Installs essential build tools and version control systems like gmake, bison, git, and pkgconf using the `pkg` package manager.

```shell
# pkg install gmake bison git pkgconf
```

--------------------------------

### Compile and Install sc-im

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Debian

Commands to compile the sc-im source code after configuring the Makefile and then install it to the system. These commands are typically run as a regular user.

```bash
make
make install
```

--------------------------------

### OSX Homebrew and ncurses Setup

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im

Installs Homebrew, the ncurses library, clones the sc-im repository, and forcefully links ncurses, which is a prerequisite for building sc-im on macOS.

```bash
curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh | bash
brew install ncurses
git clone https://github.com/andmarti1424/sc-im
brew link --force ncurses
```

--------------------------------

### Install XLSX Support Dependencies

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-FreeBSD

Installs `libxml2` and `libzip` libraries required for optional XLSX (OOXML) support.

```shell
# pkg install libxml2 libzip
```

--------------------------------

### Recompile sc-im After Lua Include Setup

Source: https://github.com/andmarti1424/sc-im/wiki/Ubuntu-16.04-lua-folder-specific-to-lua-v5.1

After setting up the Lua include paths, these bash commands guide you through cleaning the previous build, recompiling sc-im, and installing it. This step is crucial to apply the fixes and ensure sc-im functions correctly with colors enabled.

```bash
cd ~/replac-your-build-dir/sc-im/src
make clean
make
sudo make install
```

--------------------------------

### Refresh Dynamic Linker Cache

Source: https://github.com/andmarti1424/sc-im/wiki/Ubuntu-with-XLSX-import-&-export

Updates the system's dynamic linker cache after installing new libraries. This ensures that the system can locate and load the newly installed libxlsxwriter.

```shell
$ sudo ldconfig
```

--------------------------------

### Link sc-im Binary to PATH

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Fedora-27

Creates a symbolic link for the sc-im executable in the '/bin' directory, ensuring it can be run from any location in the terminal without specifying its full path. This command uses 'which' to find the executable's current location.

```bash
sudo ln -s $(which scim) /bin/scim
```

--------------------------------

### Install XLS Support Dependency

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-FreeBSD

Installs the `libxls` library required for optional XLS support.

```shell
# pkg install libxls
```

--------------------------------

### Install Build Dependencies

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Debian

Installs essential development libraries and tools required for compiling sc-im on Debian-based systems. This includes libraries for zip, xml, ncurses, and the bison parser generator.

```bash
apt-get install libzip-dev libxml2-dev bison  libncurses5-dev libncursesw5-dev
apt-get install build-essential
```

--------------------------------

### Configure Makefile for SC-IM Build (makefile)

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im-with-xls-support-on-macOS

Adds necessary compiler and linker flags to the Makefile to include libxml2 and libxls. This ensures the SC-IM build process can find and link against these dependencies.

```makefile
CFLAGS  += -DXLS $(shell pkg-config --cflags libxml-2.0 libxls)
LDFLAGS += $(shell pkg-config --libs libxml-2.0 libxls)
LDLIBS  += -lxlsreader
```

--------------------------------

### OSX XLSX Import/Export Setup

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im

Configures sc-im for XLSX import and export on OSX by installing libzip and libxml2, setting PKG_CONFIG_PATH, building libxlsxwriter from source, and creating necessary symbolic links for headers and libraries.

```bash
# necessary for xlsx import
brew install libzip
# necessary for xlsx import
brew install libxml2

# sets up scim Makefile to find libxml2 library
export PKG_CONFIG_PATH=/usr/local/opt/libxml2/lib/pkgconfig

#libxlsxwriter is needed for export, has no brew install formula
git clone https://github.com/jmcnamara/libxlsxwriter.git
cd libxlsxwriter
make

# links into /usr/include where the scim Makefile is looking to determine presence of xlsxwriter library
sudo ln -s `pwd`/include/xlsxwriter.h  /usr/include/
sudo ln -s `pwd`/include/xlsxwriter /usr/include/

sudo ln -s `pwd`/lib/libxlsxwriter.a /usr/lib/
sudo ln -s `pwd`/lib/libxlsxwriter.dylib /usr/lib/
```

--------------------------------

### Install gnuplot for Graphing Support

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Fedora-36--(packaged)

Installs gnuplot, a dependency required for graphing support in sc-im.

```shell
sudo dnf install gnuplot
```

--------------------------------

### sc-im Gentoo Ebuild Configuration

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im-with-xls-support-on-Gentoo

This ebuild file configures the build process for the sc-im spreadsheet calculator on Gentoo. It handles source fetching (from git or tarball), conditional compilation based on USE flags (like gnuplot, xls, xclip), and installation steps.

```bash
EAPI=6

inherit toolchain-funcs

if [[ ${PV} == 9999 ]]; then
	inherit git-r3
	EGIT_REPO_URI="https://github.com/andmarti1424/sc-im.git"
	EGIT_CHECKOUT_DIR="${WORKDIR}/${P}"
	EGIT_BRANCH="freeze"
	SRC_URI=""
	KEYWORDS=""
	S="${WORKDIR}/${P}"
else
	SRC_URI="https://github.com/andmarti1424/sc-im/archive/v${PV}.tar.gz"
	KEYWORDS="~amd64 ~x86"
	S="${WORKDIR}/${P}"
fi

DESCRIPTION="Spreadsheet Calculator Improvised"
HOMEPAGE="https://github.com/andmarti1424/sc-im"

SLOT="0"
LICENSE="BSD"
IUSE="docs lua gnuplot xls tmux xclip"
KEYWORDS="amd64 ppc sparc x86"

COMMON_DEPEND="
	>=sys-libs/ncurses-5.2
"
DEPEND="
	virtual/pkgconfig
"
RDEPEND="
	${COMMON_DEPEND}
	docs? ( app-doc/doxygen )
	lua? ( dev-lang/lua )
	gnuplot? ( sci-visualization/gnuplot )
	xls? ( dev-libs/libxls dev-libs/libxlsxwriter dev-libs/libxml2 dev-libs/libzip )
	mux? ( app-misc/tmux )
	xclip? ( x11-misc/xclip )
"

src_prepare() {
	default
	cd "${S}"/src
	sed -i "s|/usr/local|/usr|g" Makefile || die "Failed to set prefix in Makefile"

	if use gnuplot; then
	echo "Building with gnuplot support"
	else
	sed -i "/-DGNUPLOT/d" Makefile || die "Failed to disable GNUPLOT in Makefile"
	fi

	if use xls; then
	echo "Building with XLS write support"
	else
	sed -i "/-DXLSX/d" Makefile &&
    sed -i "/-lxlsxwriter/d" Makefile &&
    sed -i "/libs libxml-2.0 libzip/d" Makefile || die "Failed to disable XLS write support in Makefile"
	fi

	if use xclip;
		sed -i 's/"tmux load-buffer"/"xclip -i -selection clipboard <"/g' Makefile &&
    sed -i 's/"tmux show-buffer"/"xclip -o -selection clipboard"/g' Makefile ||
    die "Failed to set xclip support in Makefile"
	fi

	eapply_user
}

src_compile() {
    cd "${S}"/src
	tc-export PKG_CONFIG
	# no autoconf
	emake prefix="${D}"/usr
}

src_install() {
	cd "${S}"/src
	dodir /usr/bin
	dodir /usr/$(get_libdir)/sc-im
	dodir /usr/share/man/man1

	emake DESTDIR="${D}" install

	doman sc-im.1
}

```

--------------------------------

### OS X Specific Installation

Source: https://github.com/andmarti1424/sc-im/blob/main/Readme.md

Provides instructions for macOS users, including how to install Lua 5.1 using Homebrew if Lua scripting support is desired, and how to install sc-im directly via Homebrew.

```Shell
# Install Lua 5.1 for scripting support on macOS
brew install lua@5.1

# Install sc-im directly using Homebrew
brew install sc-im
```

--------------------------------

### Modify Makefile for Build Configuration

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Debian

Details the necessary modifications to the Makefile for building sc-im. This includes adjusting the installation prefix, default pager, and enabling specific build flags like XLSX support and linking required libraries (libzip, libxml2, libncursesw).

```diff
-prefix=/usr
+prefix=/usr/local/stow/sc-im
-DFLT_PAGER := -DDFLT_PAGER="less"
+DFLT_PAGER := -DDFLT_PAGER="pager"
-#YACC := bison -y
+YACC := bison -y
-XLSX := 
-#XLSX := -DXLSX
+#XLSX := 
+XLSX := -DXLSX
-LDLIBS := -lm -lncurses
+#LDLIBS := -lm -lncurses
+LDLIBS := -lm -lncursesw -lzip -lxml2
```

--------------------------------

### Install sc-im using COPR Repository

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Fedora-36--(packaged)

Enables the marcusmueller/sc-im COPR repository and installs the sc-im package using dnf. This provides XLS/XLSX, wide ncurses, and lua support.

```shell
sudo dnf copr enable marcusmueller/sc-im 
sudo dnf --refresh install sc-im
```

--------------------------------

### Install Stow for Package Management

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Debian

Installs the 'stow' utility, which is used for managing local software installations by creating symbolic links. This is an optional step for users who prefer to keep packages isolated.

```bash
apt-get install stow
```

--------------------------------

### Clone and Checkout sc-im Source Code

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Debian

Clones the sc-im repository from GitHub. It provides instructions for checking out a specific tagged release (e.g., v0.2.1) or the latest commit from a particular branch.

```bash
# if you want to build a tagged release:
git clone https://github.com/andmarti1424/sc-im.git
cd sc-im/
# select for example tagged release v0.2.1
git checkout -b local-debian-v0.2.1 v0.2.1

# if you want latest commit at depgraph branch, just do:
git clone https://github.com/andmarti1424/sc-im

cd src/
```

--------------------------------

### Deploy sc-im using Stow

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-Debian

Uses the 'stow' utility to deploy the installed sc-im package into the specified directory structure, typically managed by stow. This command requires privileged (staff) user access.

```bash
stow --dir=/usr/local/stow sc-im
```

--------------------------------

### sc-im Formula Examples

Source: https://github.com/andmarti1424/sc-im/wiki/SC‐IM-command-examples

Illustrates the syntax for common formulas used within sc-im. Formulas are typically prefixed with '@' and can include aggregate functions like AVG and SUM.

```APIDOC
`=@avg(B1:B4)`
`=@sum(A2:A10)`
```

--------------------------------

### OSX Core Build Command

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im

The command to compile the sc-im project after all dependencies and setup steps have been completed on macOS.

```bash
make
```

--------------------------------

### Modify Makefile for libxls Integration

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im-with-xls-support-on-Debian

Configures the build process by adding include paths for libxls headers and linking against the libxls library. It also sets the LD_LIBRARY_PATH to ensure the dynamic linker can find the libxls shared library.

```makefile
CFLAGS += -DXLS -I/usr/local/libxls/include
LDFLAGS += -L/usr/local/libxls/lib
LDLIBS += -lxlsreader

export LD_LIBRARY_PATH=/usr/local/libxls/lib
```

--------------------------------

### Configure Makefile for libxls

Source: https://github.com/andmarti1424/sc-im/wiki/Ubuntu-16.04.1-with-libxlsreader

This snippet details the necessary modifications to the project's makefile to enable compilation with the libxls library. It includes setting linker flags (LDFLAGS), compiler flags (CFLAGS) for include paths, and library dependencies (LDLIBS). Ensure libxls is installed in /usr/local/libxls.

```makefile
LDFLAGS="-L/usr/local/libxls/lib"

```

```makefile
CFLAGS := -O2 -Wall -pipe -g -I/usr/include/libxml2 -I/usr/local/libxls/include/libxls -I/usr/local/libxls/include

```

```makefile
LDLIBS := -lm -lncursesw -lxlsreader -lzip -lxml2

```

--------------------------------

### sc-im Configuration File

Source: https://github.com/andmarti1424/sc-im/blob/main/Readme.md

Example configuration settings for the sc-im spreadsheet application. These settings are placed in the ~/.config/sc-im/scimrc file to customize application behavior, such as enabling automatic calculation, setting numeric formats, and managing overlap display.

```config
set autocalc
set numeric
set numeric_decimal=0
set overlap
set xlsx_readformulas
```

--------------------------------

### Setup Lua 5.1 Includes for sc-im on Ubuntu

Source: https://github.com/andmarti1424/sc-im/wiki/Ubuntu-16.04-lua-folder-specific-to-lua-v5.1

This section details the bash commands to check the Lua 5.1 include directory and create symbolic links to resolve potential color issues in sc-im. It ensures the necessary header files are accessible for the build process.

```bash
ls /usr/include/lua5.1
```

```bash
ln -s /usr/include/lua5.1/include* /usr/include/lua5.1
```

--------------------------------

### Build Project

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-FreeBSD

Navigates into the `src` directory and builds the project using the `make` utility.

```shell
$ cd src
$ make
```

--------------------------------

### NetBSD Build Notes

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im

Build instructions for NetBSD, recommending the use of gmake and bison, and providing a workaround for locating the ncurses library by modifying the Makefile.

```APIDOC
NetBSD Build Instructions:
  - Use gmake and bison.
  - Ensure ncurses library is available or symlinked.
  - If ncurses is not found, modify Makefile: replace -lncurses with -lcurses.
```

--------------------------------

### Clone Repository

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-FreeBSD

Clones the sc-im project from its GitHub repository using Git.

```shell
$ git clone https://github.com/andmarti1424/sc-im
```

--------------------------------

### Execute Project

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-FreeBSD

Executes the compiled sc-im program.

```shell
$ ./scim
```

--------------------------------

### Build Project with XLS Support

Source: https://github.com/andmarti1424/sc-im/wiki/Installing-on-FreeBSD

Builds the project with optional XLS support by setting environment variables `CFLAGS` and `LDLIBS` to include necessary paths and libraries for `libxlsreader`.

```shell
$ env CFLAGS="-DXLS -I/usr/local/include" LDLIBS="-L/usr/local/lib -lxlsreader" make
```

--------------------------------

### Run scim on Mac

Source: https://github.com/andmarti1424/sc-im/wiki/Homebrew-formulae

Instructions for executing the scim command on macOS. This command is used for running the project's functionality.

```shell
scim
```

--------------------------------

### Makefile Configuration

Source: https://github.com/andmarti1424/sc-im/blob/main/Readme.md

Instructions for modifying the `src/Makefile` to tailor the build process for different systems and requirements. This is a prerequisite step before running the `make` command.

```Makefile
# Edit the Makefile to match your system and needs
vim src/Makefile
```

--------------------------------

### ArchLinux ncursesw Header Symlink Creation

Source: https://github.com/andmarti1424/sc-im/wiki/Building-sc‐im

A shell script to create symbolic links for ncursesw headers in /usr/include/ncursesw if they are not found, ensuring sc-im can locate them during the build process on ArchLinux.

```shell
if [[ `whereis ncursesw` == "ncursesw: /usr/include/ncursesw" ]]; then
    mkdir /usr/include/ncursesw
    cd /usr/include/ncursesw
    ln -s ../{cursesapp.h,cursesf.h,curses.h,cursesm.h,cursesp.h,cursesw.h,cursslk.h,eti.h,etip.h,form.h,menu.h,nc_tparm.h,ncurses_dll.h,ncurses.h,panel.h,termcap.h,term_entry.h,term.h,tic.h,unctrl.h} ./
fi
```

--------------------------------

### sc-im File Handling Commands

Source: https://github.com/andmarti1424/sc-im/wiki/SC‐IM-command-examples

Details commands for interacting with files, including writing data to different formats like plain text, CSV, and Markdown, as well as saving the sc-im session.

```APIDOC
`:e txt <filename.asc>` — write plain-text file
`:e csv <filename.csv>` — write csv file
`:e mkd <filename.mkd>` — write mark down file
`:w <filename.sc>` — write an .sc file
```

--------------------------------

### sc-im Embedded Help

Source: https://github.com/andmarti1424/sc-im/wiki/SC‐IM-command-examples

Describes how to access the built-in help system within the sc-im application, which provides detailed information on commands and features.

```APIDOC
`:help` — launch the embedded help
```

--------------------------------

### sc-im Navigation Commands

Source: https://github.com/andmarti1424/sc-im/wiki/SC‐IM-command-examples

Details the methods for navigating the spreadsheet grid. This includes standard arrow key movement, vi-style keybindings, direct cell addressing, and page scrolling.

```APIDOC
Arrow keys — cursor keys
`h`, `j`, `k`, `l` — vi keys motion
`gtB13` — go to cell B13
Ctrl-f, Ctrl-b — page up or down (also pgup, pgdown)
```

--------------------------------

### sc-im Cell Marking and Copying

Source: https://github.com/andmarti1424/sc-im/wiki/SC‐IM-command-examples

Explains the functionality for marking specific cells and then copying their content to other locations. This allows for efficient data duplication and reference.

```APIDOC
`ma` (`mb`, `mc`, etc.) — “mark” cell as a (or b, or c, etc.)
`ca` (`cb`, `cc`, etc.) — copy contents previously marked with `ma`
```

--------------------------------

### sc-im Importing xlsx Formulas

Source: https://github.com/andmarti1424/sc-im/wiki/SC‐IM-command-examples

Shows the command-line interface command used to import spreadsheet data, specifically preserving formulas, from an XLSX file into sc-im.

```APIDOC
sc-im --xlsx_readformulas test.xlsx
```

--------------------------------

### sc-im Core Commands and Navigation

Source: https://github.com/andmarti1424/sc-im/blob/main/Readme.md

This section details the primary interactive commands and navigation keys used within the sc-im spreadsheet calculator. It covers cell editing, data insertion, deletion, undo/redo functionality, and basic cursor movement.

```APIDOC
sc-im Interactive Commands:

= : Insert a numeric value into the current cell.
\ : Insert a text value into the current cell.
e : Edit the numeric value of the current cell.
E : Edit the string value of the current cell.
x : Delete the content of the current cell.
u : Undo the last change made.
C-r : Redo the last undone change.
yy : Copy the current cell's content.
p : Paste a previously copied cell or range.

Navigation:
j : Move down one row.
k : Move up one row.
h : Move left one column.
l : Move right one column.
goab12 : Navigate directly to cell AB12.

Row/Column Operations:
ir : Insert a new row above the current row.
ic : Insert a new column to the left of the current column.
dr : Delete the current row.
dc : Delete the current column.

Selection and Range Operations:
v : Begin selecting a range using cursor keys (hjkl).

File Operations:
:q : Quit the sc-im application.
:h : Display the help screen.
:w filename.sc : Save the current spreadsheet to the specified file in sc format.
```

--------------------------------

### LibreOffice CSV Import Configuration

Source: https://github.com/andmarti1424/sc-im/wiki/Import-CSV-files

Configuration settings for importing CSV files into LibreOffice, specifying separators, delimiters, and text handling for SC-IM data. This ensures correct parsing of SC-IM generated files.

```configuration
Separator: comma
Text delimiter: "
Quoted field as text: yes
detect special numbers: no
Column types: US-english
```

--------------------------------

### sc-im Formatting Commands

Source: https://github.com/andmarti1424/sc-im/wiki/SC‐IM-command-examples

Provides commands for adjusting the visual presentation of columns and rows. These commands allow for increasing or decreasing column width and row height.

```APIDOC
`fl` — increase column width
`fh` — decrease column width
`fj` — increase row height
`fk` — decrease row height
```

--------------------------------

### sc-im Row and Column Manipulation

Source: https://github.com/andmarti1424/sc-im/wiki/SC‐IM-command-examples

Covers commands for inserting, deleting, hiding, and showing rows and columns. Supports operations on multiple rows/columns by prefixing the command with a count.

```APIDOC
`ir`, `ic` — insert row, insert column (eg, `5ir` to insert 5 rows)
`dr`, `yr`, `pr` — delete row, yank row, put row
`dc`, `yc`, `pc` — delete column, yank, put column
`dd`, `yd`, `pd` — delete, yank, put a cell (eg, `9dc` to delete 9 columns)
`Zr`, `Zc` — zap (hide) row or column (eg, `30Zr` to zap 30 rows)
`sr`, `sc` — show row or column
```

--------------------------------

### sc-im Basic Cell Input Modes

Source: https://github.com/andmarti1424/sc-im/wiki/SC‐IM-command-examples

Defines the basic modes for entering data into cells in sc-im. These include forcing recalculation, entering numeric values or formulas, and inserting text with different justifications.

```APIDOC
`@` — force re-calculation
`=` — enter a numeric value (eg, `25`, `F13-D14`) or formula (eg. `@sum(A2:A145)`)
`<` — insert left-justified text
`\` — insert centered text
`>` — insert right-justified text
`x` — remove cell content
`e` — edit a numeric value (vi-style editing)
`E` — edit a string value (vi-style editing)
`b` — back
`w` — forward
`r` — redo
`Pc` — paste and adjust cell references
```

--------------------------------

### SC-IM Color Customization Commands

Source: https://github.com/andmarti1424/sc-im/wiki/Changing-colors

SC-IM provides commands to define new colors, redefine existing ones, and apply colors to different cell types and UI elements. This allows for extensive visual customization of the spreadsheet interface.

```APIDOC
:define_color
  - Defines a new custom color using RGB values.
  - Requires terminal support for 256 colors or more.
  - Usage: :define_color <color_name> <rgb_value>
  - Example: :define_color my_blue "#0000FF"

:redefine_color
  - Redefines stock ncurses colors (e.g., BLACK, WHITE, RED, GREEN).
  - Usage: :redefine_color <stock_color_name> <new_definition>
  - Example: :redefine_color RED "255,0,0"

:cellcolor
  - Applies a defined color to a specific type or UI element.
  - Usage: :cellcolor <type> <color_name>
  - Supported types include:
    - HEADINGS: Topmost (header) row and leftmost (header) column.
    - HEADINGS_ODD: Odd columns in the header row/column.
    - MODE: Indicator of the current SC-IM mode.
    - NUMB: Styling for positive number cells.
    - STRG: Styling for string cells.
    - DATEF: Styling for date cells.
    - CELL_SELECTION: Row and column selection styling on HEADINGS.
    - CELL_SELECTION_SC: Styling for the currently focused cell.
    - GRID_EVEN: Color for even columns.
    - GRID_ODD: Color for odd columns.
    - EXPRESSION: Styling for cells resulting from an expression.
    - CELL_ERROR: Styling for cells with expression errors (e.g., division by zero).
    - CELL_NEGATIVE: Styling for negative number cells.
    - INFO_MSG: Info messages in the top left corner.
    - ERROR_MSG: Error messages displayed when a command fails.
    - CELL_ID: Coordinates of the selected cell in the upper top left corner.
    - CELL_FORMAT: Formatting of the selected cell.
    - CELL_CONTENT: Content of the selected cell (shows expression).
    - WELCOME: Text shown when SC-IM is first opened.
    - NORMAL: General text, e.g., in :help.
    - INPUT: Text typed in the input bar.
  - Example: :cellcolor NUMB my_blue
```

--------------------------------

### Lua Scripting Integration

Source: https://github.com/andmarti1424/sc-im/blob/main/Readme.md

This section highlights the capability of sc-im to integrate with Lua scripting. It mentions that external functions can be implemented in various languages and used within sc-im, and that sc-im can be used as a non-interactive calculator by reading input from external scripts.

```Lua
-- Example of using sc-im as a non-interactive calculator
-- (Conceptual - actual script execution details would be in sc-im's documentation)
-- sc-im --script my_calculations.lua

-- Within a Lua script for sc-im:
-- Define functions that can be called from sc-im cells or triggers
-- function my_custom_function(arg1, arg2)
--   return arg1 + arg2
-- end

-- sc-im can also be extended with C dynamic linked modules.
```

=== COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.