Questions tagged [spreadsheet]

A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form

Filter by
Sorted by
Tagged with
0
votes
0answers
2 views

Intelligently identifying and analyzing tabular data in Excel spreadsheet

Our company is building an online system that needs to accept Excel files as part of the registration process of our service. Our system will only be interested to consume what looks like columns and ...
0
votes
0answers
4 views

How to configure inner cell spacing in OnlyOffice spreadsheet document?

Hi dear software experts, I want to onfigure the inner table cell spacing (padding) in a spreadsheet document in OnlyOffice. Can't find any appropriate cell configuration dialogue, though. So, how ...
0
votes
0answers
10 views

Search bar using a Google Sheet as database

I would like to know if it's possible to create a simple search form/engine with python using a google spreadsheet as database. Context: I am working on a task to help non-technical colleagues have ...
0
votes
0answers
6 views

Open source integration tool

Can anyone suggest an open-source application for integrating google sheets to Postgres? There are many available but most of them run for a trial period only.
0
votes
0answers
6 views

Print labels after scanning barcode

We want to do the following: 1) Scan a barcode with a mobile scanner 2) print several labels with a labelprinter based on the scaned barcode What software is recomended? bonus feature: get list of ...
1
vote
0answers
10 views

Single tool, ideally open source, for specifying application use cases, requirements, and functional specifications

Is there a free or inexpensive tool that supports the development of Use Cases (or User Stories), Requirements, and Functional Specifications? I know there is a tendency to blur the lines between ...
0
votes
0answers
5 views

Showing private Google data to the public?

Currently running into a problem where I have a lot of data on Google Sheets but it's limited to be shown to specific people (distinguished by a user's email). Without changing the permission on who ...
0
votes
1answer
12 views

Compare two excel sheets

csv spreadsheets with the following data: Sheet 1: ID Name Address City PostalCode Phone Sheet 2: ID Name Address City PostalCode Phone I would like to compare the two sheets for added rows, ...
0
votes
0answers
10 views

Software for barcode registry

I have a fruit harvesting business that I would like to find existing, or implement software to keep a registry of scanned bin barcodes for each day, per team, and block area of an orchard. Any given ...
0
votes
0answers
10 views

OCR with data recognition and organization

I have tons of pictures of patient exams documents of which I need to extract the patient number and exam type and write it into and excel sheet, but this process is very time consuming, is there any ...
1
vote
0answers
12 views

Spreadsheet program where I can paste image and it belongs to a cell?

In Miscrosoft Excel and LibreOffice Calc when I paste image from clipboard, it is appearing above the cells, not belonging to any of them. I need that image data was belong to a single cell I pasted ...
0
votes
0answers
12 views

Create data entry form that loads fields from s3 and enables writing/editing data as spreadsheet back into amazon rds

I am currently maintaining a google spreadsheet to enter/edit several thousand rows for about 100 different entities - i.e. there are 10-20 rows for each entity name key (each key has slightly ...
1
vote
0answers
11 views

Is there an practical SQL interface that feels like excel?

I have used SQL Server Managment Studio, and Azure Data Studio, and MySql Workbench. I wouldn't consider myself an expert on using any of those programs. However, it seems like I still do a large ...
0
votes
0answers
17 views

Gratis Windows spreadsheet which supports 64 bit integer values and has charting

Important: just because it is a 64-bit .EXE does not mean that it supports 64 bit integer values (I'm looking at you, Excel). If you don't understand what 64 bit precision is, please don't just Google ...
0
votes
2answers
38 views

Any spreadsheet provide more then double precision?

Excel is not designed for highly accurate calculations. Its design follows the IEEE 754 specification for floating point math, which calls for only the 15 most significant digits to be stored. If the ...
1
vote
2answers
62 views

Online spreadsheet webapp that can view 10 million rows

I have a data file with 14 columns and 9,523,125 rows. What online spreadsheet program (NOT A DATABASE!) can view at least 9,523,125 rows? I must be able to: upload the CSV file view it (with some ...
1
vote
1answer
29 views

Spreadsheet that understands symbolic numbers

I am about to do some calculations involving Pi. These would be easy to do in a spreadsheet, but I need the result to use Pi as a symbol - not as an approximated value. Eg: A B C 1 =5 =Pi ...
6
votes
2answers
47 views

Wiki for spreadsheets / tabular data

Wikipedia has tables, but they're always part of an article, not standalone editing with VisualEditor is clunky editing with wikicode is a nightmare sometimes they can be sorted, but that's about ...
2
votes
1answer
37 views

What is the best spreadsheet-like tool to manage structured data with tags and multiple columns of different sizes

I'm trying to find a tool which can fit my needs in the management of a list a scientific papers I read during my phd thesis. For each paper I collect title, authors, write a summary, give tags... I ...
0
votes
0answers
19 views

Drag and drop bug reporting tool/software

Currently, my clients are using excel/Google Sheets to report their issues & encountered bugs when they are using the delivered Android APKs. I'm looking for the fastest alternative reporting ...
1
vote
2answers
1k views

Web App front end for Excel (or similar spreadsheet muscle)

I would like to create a web application that steps a user through the building of an economic model, ultimately exportable as a complex multi-worksheet excel with calculations throughout. It would be ...
1
vote
0answers
44 views

Database and Spreadsheet combination

Is there any software that combines spreadsheet and database engine functionality? I would like to be able to paste two tables (for example results of SQL queries, with 20+ different columns each) ...
1
vote
0answers
30 views

Email Client with Excel-Like Interface

I am after an e-mail client that lets me add custom columns, and sort and filter e-mails in a way similar to the way Excel works. I manage a small team of researchers who do interviews with various ...
2
votes
1answer
726 views

Using Microsoft Excel as user interface for a windows form application [closed]

I want to create a windows form application using c#, that uses Microsoft excel as interactive user interface, in the other word, I want to load the data from database to Excel, and after user ...
1
vote
1answer
51 views

Free software to use as aircraft register with photos

I'm sure there's a name for software of this kind, but Google hasn't been particularly helpful. I'm looking for online, self-hosted software that will generate a database/spreadsheet table with ...
0
votes
2answers
48 views

MSExcel/spreadsheet data entry vs traditional form data entry

I don't know if anyone here has a job that involves heavy data entry. I hope to get some opinions, or suggestions to something new. My company has a private database which stores various kind of ...
3
votes
3answers
122 views

Own spreadsheet web application server

I need to embed spreadsheets in my web application, something similar to Google Sheets. I also need to store the data in my server (i.e. embedding Google Sheets and storing the sheet in Google's ...
0
votes
1answer
57 views

Spreadsheet software analog whitch separates Data from Presentation

Microsoft Excel mixes formating, presentation and data, that drives me crazy. I just can't use my poor data this way. Is there a tool which works with data and tunes its reporting separately? I can ...
1
vote
1answer
79 views

Alternative Windows program for editing Excel xml format spreadsheets

I don't have Microsoft Office at home, but would occasionally like to edit spreadsheets from work. We use the Excel .xml format also knows as "SpreadsheetML". Does anybody know of a program that will ...
2
votes
5answers
89 views

Looking for Online Data Storage Software/Web Application

The company that I work for has collected a LOT of data (hundreds of thousands of entries) in Excel spreadsheets that are separated into labelled columns (ex. Name, Number, E-mail, Address, etc.). ...
2
votes
1answer
142 views

Excel alternative that uses JavaScript

I'm looking for a very simple Excel alternative that is cross platform, open source and uses JavaScript instead of the terrible Excel language (whatever it is called). So that every cell can have a ...
1
vote
0answers
70 views

software that combines graph and spreadsheet flexibilities

I'm at the beginning of a big project and I want to find a tool that works somehow like this (using a simple example): Suppose that you have some signal sources (e.x. sensors) that produce a voltage ...
0
votes
1answer
50 views

Social network with unique database capabilities

We're a non-profit organization that coordinates the donation of school supplies from wealthy schools to under-funded schools. My goal is to build an online application that empowers all of the ...
2
votes
1answer
30 views

Spreadsheet with language-agnostic networking API

I'm looking for a spreadsheet that can be controlled from outside, similar to e.g. how LibreOffice can be controlled via the UNO API. I'd like it to have standard manual manipulation functionality - ...
2
votes
4answers
837 views

Spreadsheet for text or text editor with columns and rows

I want to organize text in columns and rows. I want to be able to set a fixed width for the columns. The rows should expand (indefinitely) to fit the text vertically. I want to be able to change row ...
0
votes
1answer
21 views

Opening and sorting huge files

I am working with huge files like 2.000.000.000 rows. I need this file to be sorted, maybe filtered an so on. Can you recommend me a software? Preferably on Linux, but can be in any OS. I am looking ...
2
votes
3answers
130 views

Windows text editor with cells

Is there text editor which treats letters and unoccupied space as cells and allows to copy any rectangular area to any place? Somewhat like Excel, but with one cell for letter.
1
vote
0answers
24 views

What software can be used for logical operations in spreadsheet data

I have a spreadsheet(csv) file with 6 columns and 800 rows which I update daily with new data(file will be deleted and a new one is created). I want to do logical operations in those new data and also ...
1
vote
1answer
108 views

Spreadsheet Software (Javascript Funtions)

With Google Docs you're able to create GoogleScripts which allows to write Javascript Functions which you can use in Google Spreadsheet columns. I looking for a spreadsheet application (offline) ...
1
vote
0answers
20 views

Map of points from non-public Google Sheets containing latitude/longitude, updated automatically

My Google Sheet has the latitude/longitude of my suppliers: Name Latitude Longitude Tube&co 44.878 32.171 Bending2000 44.894 32.140 The sheet has 150 ...
3
votes
1answer
53 views

Distributing and maintaining excel-file

I am responsible for a spreadsheet that contains a database of products and their properties. I need a way to distribute it to people in the organization. Control over rights to write is important, ...
1
vote
1answer
40 views

Generating multiple PDF documents from spreadsheet and images

I am looking for a free or low cost product that i can use to quickly create multiple PDF documents populated with text and images from a spreadsheet. I have a background image which will the a ...
1
vote
0answers
25 views

Several persons/companies sharing one conference room - Which web app for reservations?

My company owns two conference rooms that are sometimes used by other companies as well. At the moment, 15 people can book the room using an Excel sheet on Dropbox. One room is green, the other one ...
2
votes
2answers
99 views

Spreadsheet with rowspan?

I have a list of 105 files. I need to analyze each file and for each file make a list of certain commands found in the file. Thus to each file they correspond several commands. What software do you ...
4
votes
3answers
2k views

Linux alternative to Excel pivot table

My company uses some simple MySQL queries to generate a CSV report of a bunch of stats (about 20 columns, rows in the low thousands). We then use Microsoft Excel to create pivot tables to explore and ...
4
votes
1answer
554 views

Simple spreadsheet for Android

I am looking for a simple spreadsheet app to use on my Android phone. Desired features: Basic spreadsheet functionality, ie entering data in rows and columns, including properly formatted dates/...
1
vote
1answer
166 views

Software to handle large Excel .xls files

Some users receive XLS files from other offices for analysis, but these files are extremely large and the performance of Excel is low. I know the best solution could be transfer this information to a ...
3
votes
2answers
338 views

spreadsheet alternatives Pascal:Basic :: ???:Spreadsheets

I use excel. I use google sheets. I've used Opencalc. And to really date me, I've used Visicalc. I've come to the conclusion that spreadsheets are in essence the 'Basic' of tabular data. I am ...
2
votes
0answers
1k views

unified document editor

There are a lot of "Office" clones, but I'm looking for something that is a bit different. I am looking for a document editor that has a single unified interface and which does not distinguish ...
3
votes
1answer
258 views

Speadsheet software that can handle thousands of columns

Microsoft Excel has a max number of columns of 16,384 Open/Libre Office Calc has max number of columns of 1,024 A summery of the limits for several speadsheet softwares can be found here I have ...