Welcome to DÆLOC

A powerful data acquisition plugin for LibreOffice Calc.

Buy a license

Pricing

We charge a one-time fee for a license.

Download

DAELOC-1.1.0.oxt

Overview

DÆLOC is a LibreOffice Calc extension that enables real-time data acquisition from serial (e.g., Arduino), similar to PLX-DAQ for Excel. The extension allows users to log and visualize incoming data directly in Calc spreadsheets.

Key Features

• ✅ PLX-DAQ Compatibility
• ✅ Real-Time Data Logging

Features

• ✅ Supports multiple baud rates (Free tier limited to 9600 baud)
• ✅ Auto-scrolling to keep the last rows visible
• ✅ Real-time Serial & MQTT* data logging
• ✅ Dynamic chart generation*
• ✅ Support for JSON*

(*) Planned in the Pro Version

Installation

1. Download the latest .oxt file.
2. Open LibreOffice Calc and go to Tools → Extensions Manager.
3. Click Add… and select the .oxt file.
4. Restart LibreOffice to complete the installation.

Usage

1. Open DÆLOC from the Tools menu.
2. Select serial port.
3. Configure baud rate.
4. Start logging, and watch data populate in the spreadsheet!

Example measuring a battery discharge

Supported Commands

Command reference

CLEARSHEET

Clears the entire sheet, including labels and data.

Example:

CLEARSHEET

CLEARDATA

Clears only the data, keeping the column labels intact.

Example:

CLEARDATA

LABEL, col1, col2, ...

Defines column headers for incoming data.

Example:

LABEL, Time, Temperature, Humidity

DATA, value1, value2, ...

Inserts a row of data into the spreadsheet.

Example:

DATA, 12:00:01, 25.6, 55

DATA, value1, value2, ..., AUTOSCROLL_25

Inserts a row of data into the spreadsheet while keeping only 25 lines visible (auto-scroll enabled).

Example:

DATA, 12:00:01, 25.6, 55, AUTOSCROLL_25

CELL,SET,cell,value

Inserts a specific value into a designated cell.

Example:

CELL, SET, A1, 42

CELL,SET,ONSHEET,sheetname,cell,value

Inserts a specific value into a designated cell on a specific sheet.

Example:

CELL, SET, ONSHEET, Info, A1, 42

CELL,GET,cell

Retrieves the value from a specific cell.

Example:

CELL, GET, A1

CELL,GET,FROMSHEET,sheetname,cell

Retrieves the value from a specific cell on a specified sheet.

Example:

CELL, GET, FROMSHEET, Info, A1

CUSTOMBOXn,LABEL,label

Sets the label for a custom box (n=1,2,3,4).

Example:

CUSTOMBOX1, LABEL, Sensor Active

CUSTOMBOXn,SET,value

Sets a value (0 or 1) for a custom box (n=1,2,3,4).

Example:

CUSTOMBOX1, SET, 1

CUSTOMBOXn,GET

Retrieves the value of a custom box (n=1,2,3,4).

Example:

CUSTOMBOX1, GET

ROW,GET

Retrieves the current row where data is being logged.

Example:

ROW, GET

ROW,SET,value

Sets the row number to start logging to.

Example:

ROW, SET, 5

CLEARRANGE, col_start, row_start, col_end, row_end

Clears a specific range of cells.

Example:

CLEARRANGE, A, 2, A, 10

RESETTIMER

Resets the internal timer (used for timestamps).

Example:

RESETTIMER

PAUSELOGGING

Temporarily pauses data logging.

Example:

PAUSELOGGING

RESUMELOGGING

Resumes logging after a pause.

Example:

RESUMELOGGING

STOPLOGGING

Stops logging completely (manual restart required).

Example:

STOPLOGGING

SAVEWORKBOOK

Saves the current workbook.

Example:

SAVEWORKBOOK

SAVEWORKBOOKAS, filename

Saves the current workbook under a new name.

Example:

SAVEWORKBOOKAS, experiment1.ods

MSG, text

Displays a message in the UI message box.

Example:

MSG, Data logging started.

FORCEEXCELQUIT

Forces LibreOffice Calc to quit.
⚠️ Use with caution, data will be lost unless saved!

Example:

FORCEEXCELQUIT

BEEP

Makes LibreOffice emit a beep sound.

Example:

BEEP

DONE

Flush serial buffer.

Example:

DONE

GETRANDOM, min, max

Generates a random number within a specified range.

Example:

GETRANDOM, 1, 100

Example Arduino Sketch

void setup() {
  Serial.begin(9600);
  Serial.println("CLEARDATA");
  Serial.println("LABEL,Time,Temperature (c),Light (%)");
}

void loop() {
  int temp_value = analogRead(A0);
  float temp = (temp_value * 500)/1023;

  int ldr_value = analogRead(A1);
  float ldr_percent = map(ldr_value,0,1023,0,100);

  Serial.print("DATA,TIME,");
  Serial.print(temp);
  Serial.print(",");
  Serial.println(ldr_percent);    
  delay(1000);
}

Versions

Free

• 250 data points
• 5 minutes data collection time
• Baudrate limited to 9600 baud

Basic

• Unlimited data points
• Unlimited data collection time

Pro

• Unlimited data points
• Unlimited data collection time
• Live Charts & Graphs (planned)
• MQTT Support (planned)
• JSON Support (planned)

The Pro version is in development, contact us if you want to know more.

Custom Features or Integration

Contact us if you need custom features or integrations.

Frequently Asked Questions

What is DÆLOC?

DÆLOC is a powerful data acquisition plugin for LibreOffice Calc, allowing seamless real-time logging from serial devices.

How do I install it?

Simply download the OXT file and install it in LibreOffice via Tools → Extensions Manager.

OS compatibility

Works on MacOS, Linux, and Windows.

Contact

For more information, email info@tektonica.com or visit tektonica.com.