View Issue Details

IDProjectCategoryView StatusLast Update
0002472SpreadsheetFeaturepublic2021-11-24 15:30
ReporterSpindoctor Assigned Toeivindkvedalen  
PrioritynormalSeverityfeatureReproducibilityN/A
Status assignedResolutionopen 
Product Version0.15 
Target Version0.20 
Summary0002472: Spreadsheet - Move Cells
DescriptionTL;DR:
It would be very convenient if there was a way to move (and/or copy/paste) cells in FreeCAD spreadsheets. This would really help to keep the variables stored in the spreadsheet organized.
Additional InformationLong version:
I started to use spreadsheets in FreeCAD 0.16. I use them to set "variables" I can later utilize in my sketches (and other parts of the model). This is a great feature I learned to love in OpenSCAD - I am glad I can do similar things in FreeCAD now.

However, the spreasheet seems to lack some helpful features.

One of them is the possibility to move cells. I would like to keep the spreadsheet (or the data inside) organized.
Maybe I start by adding some basic information, like overall model height. I then leave a blank line below the first one and add some other information - let's say a thread radius. Later I decide the overall width of the model would also be helpful. I'd like to add that just below the overall model height and still have an empty line below. Without copy/paste or moving cells this is not really possible. (I could start over and make a new spreadsheet, but this is not desirable). Therefore the possibility to move cells would be great!
Tagsspreadsheet

Relationships

related to 0002473 closedeivindkvedalen FreeCAD Spreadsheet - additional syntax for aggregate functions 

Activities

eivindkvedalen

2016-04-25 17:23

developer   ~0007005

You can insert and remove both rows and columns if you right click on the header names to the left and at the top. Moving by copy/cut and paste of individual cells are not yet supported (for the time being, FreeCAD only supports copying complete objects).

silopolis

2017-08-08 10:24

reporter   ~0009882

Copy/paste/move of cells and rows is indeed very much needed when the model grows in size and complexity. Designing a kitchen, I found myself modifying the spreadsheets for almost each new part and it's a "pain" not to have the complete basic set of features for cells/rows/columns manipulation.

silopolis

2018-01-27 08:06

reporter   ~0010873

A quick note to mention that the Spreadsheet Tools macro has some copy/cut/paste features, with content/aliases/formating handling (or at least will to). Needs a little of love and a better UI (toolbar buttons ? dockable panel ?) but was a game changer for the last couple of days keeping my spreadsheets in order :)

yorik

2022-03-03 13:55

administrator   ~0016480

This ticket has been migrated to GitHub as issue 5645.

Issue History

Date Modified Username Field Change
2016-03-14 20:54 Spindoctor New Issue
2016-04-25 17:23 eivindkvedalen Note Added: 0007005
2016-04-25 17:23 eivindkvedalen Assigned To => eivindkvedalen
2016-04-25 17:23 eivindkvedalen Status new => assigned
2017-01-19 14:19 Kunda1 Relationship added related to 0002473
2017-01-19 14:23 Kunda1 Tag Attached: spreadsheet
2017-08-08 10:24 silopolis Note Added: 0009882
2017-12-13 15:27 Kunda1 Project FreeCAD => Expressions
2018-01-27 08:06 silopolis Note Added: 0010873
2021-02-06 06:30 abdullah Target Version => 0.20
2021-11-24 15:30 chennes Project Expressions => Spreadsheet