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
6 views

Does any SQL database / CMS let you edit the data in spreadsheet / worksheet mode? (Lotus Approach did, but it's long dead.)

Can you fall in love with a database? I did: Lotus Approach. Alas, it no longer exists. PhpMyAdmin is not the same. Can any SQL database / CMS let us: work the backend data (the "worksheet"...
0
votes
0answers
8 views

Software for contact list with category filters?

What software can I use to make a contact list, with categories like company, occupation field, the way I'm connected to them (FB, IG, Twitter, etc), City. Is there a software that can do this and ...
0
votes
0answers
10 views

PrintShop Mail open source alternative

Is there an open source PrintShop Mail alternative. The software should enable to create templates and fill them with data from the spreadsheet (excel or openoffice). It should be able to print from ...
2
votes
4answers
338 views

Looking for 64 bit Windows 7 spreadsheet program

I have used MS Excel 2007 for many years on a 32 bit computer. My newer computer is a 64 bit Windows 7 (yes, it's an antique :-). The 2007 software will not install on my 64 bit computer. I spoke ...
0
votes
0answers
10 views

Transfer content from google sheet to external excel file

I’m trying Google Form and its tool to generate a sheet document based on the answer of the form. Now, I’d like to transfer the content from this sheet to an external excel file, to keep it updated as ...
0
votes
0answers
23 views

Open-source, multi-user self-hostable task management with spreadsheet views?

There are many open-source for task management software these days, as noted in e.g.: https://opensource.com/article/18/2/agile-project-management-tools (2020) https://medium.com/issuehunt/5-open-...
0
votes
1answer
22 views

A league like platform

Me and my friends are having a little competition between us about Football in our country. I would like to ask about a platform which makes it easier to guess and send the results to the server. ...
0
votes
0answers
17 views

Cloud-Based Alternative to Microsoft Excel? Main Requirement = Conditional Formatting

I currently use the desktop version of Microsoft Excel to visualise data tables using data bar gradient conditional formatting. For example like this: https://www.contextures.com/images/...
0
votes
1answer
30 views

JIRA or spreadsheet? (for development of web app with 1 dev and 1 product owner) [closed]

I'm building a web app in a small team of two people - 1 dev & 1 product owner. I can't decide how to capture tasks and I'm wondering whether anyone has experience of doing similar who can make a ...
1
vote
0answers
27 views

Spreadsheet with ability to do scientific and statistical computation?

Is there a spreadsheet program that allows scripting with Sagemath, Python and R? I have learned those and found that some things can be done much easier with those than VBA or Libre Office basic. Or ...
2
votes
3answers
87 views

What's an alternative to spreadsheets that has cells with defined type of value?

I don't like spreadsheets because they are not typed, any cell can have a value of any type. That can cause errors. I'd like to be able to define a type for any cell and the software would prevent the ...
0
votes
0answers
15 views

Tree Layout to automatically update Google Sheet

I am looking for inexpensive online platform that can create an editable tree graph that will automatically update the branch by column in the spreadsheet. Basically an editable interactive graph (...
2
votes
0answers
23 views

Looking for Interactive Charting Software

Looking for charting/visualization software that will provide an interactive line chart. It will need to render tabular data graphically (line or scatter chart). My additional requirement is that ...
0
votes
0answers
20 views

An open-source spreadsheet for Ubuntu with Python 3 scripting?

Is there an open source spreadsheet program for Ubuntu that allows scripting with Python 3?
-1
votes
1answer
15 views

Free windows inventory spreadsheet

I need a simple to use spreadsheet to use for inventory tracking that can be updated daily. I need rows and columns, unlimited rows, 7 columns.
0
votes
1answer
24 views

Interactive spreadsheet survey

I'm looking for an online survey platform which would allow participants to input information into a blank interactive online spreadsheet. The spreadsheet would be blank for each individual ...
0
votes
0answers
4 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
12 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
8 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
8 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 ...
2
votes
0answers
13 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
1answer
16 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 ...
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 ...
1
vote
0answers
14 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
20 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
57 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
78 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
31 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
52 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
42 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
1answer
20 views

Google Sheets integrated with Gmail

I have a spreadsheet that lists customer information and what I would like to do is have a link for each customer that directs me to any email communication I've had with them. Any help would be ...
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
69 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
895 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
53 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
155 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
90 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
92 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
197 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
32 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
1k 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
25 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
153 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.