View Issue Details

IDProjectCategoryView StatusLast Update
0002957ExpressionsFeaturepublic2021-02-07 13:15
Reporterdprojects Assigned To 
PrioritynormalSeverityfeatureReproducibilityN/A
Status newResolutionopen 
Target Version0.20 
Summary0002957: please add spreadsheet direct printing
DescriptionPlease add spreadsheet direct printing. This will be very helpful for my macro:
https://forum.freecadweb.org/viewtopic.php?f=22&t=21127
Steps To ReproduceFrom https://github.com/dprojects/getDimensions#printing
FreeCAD doesn't not support direct printing for spreadsheets. So as a workaround you have to:

Export your spreadsheet to CSV.
Copy the CSV data to LibreOffice.
Convert text with tabulators in LibreOffice to the table.
Make some corrections (add mm and adjust table columns).
Print it.
Go and cut your chipboards to market or any other woodworking service that provide wood cutting :-)
Additional Informationno such feature already
Tags#lowhangingfruit, printing, spreadsheet
FreeCAD Information

Relationships

related to 0002474 new Expressions Integrate LibreOffice Calc via GUI 
related to 0004556 new File formats allow export and import of ODS files 

Activities

Kunda1

2017-03-09 01:12

administrator   ~0008578

Changed priority of the ticket. Also it makes sense to specify as best as possible what you'd like to achieve to save time for the devs to read the whole thread you're linking to.

Kunda1

2017-07-13 11:28

administrator   ~0009752

@dprojects can you explain in more detail, within this ticket why it would be useful to have this feature?

Kunda1

2017-08-13 16:56

administrator   ~0009915

@dprojects ping

Kunda1

2017-11-10 16:49

administrator   ~0010407

@eivindkvedalen care to weigh in ?

eivindkvedalen

2017-11-11 18:43

developer   ~0010410

I think printing is now supported in Tech draw. Is that enough?

dprojects

2017-11-11 20:12

reporter   ~0010411

For my purposes (https://github.com/dprojects/getDimensions) the TechDraw is useless. I can create table in spreadsheet but I am not able to print it. You can add spreadsheet to TechDraw manually but it not preserve the correct format. In fact I wasn't able to operate effectively TechDraw. It is nice feature but I guess it really need changes to have it working. Now I copy the spreadsheet manually to LibreOffice.

dprojects

2017-11-22 19:26

reporter   ~0010458

For example: on "Spreadsheet" tab I would like to have button with print option. The print button could transform current spreadsheet table into pdf document and open box for print it. This should preserve text color and other formating.

Kunda1

2017-12-08 00:33

administrator   ~0010543

https://forum.freecadweb.org/viewtopic.php?f=4&t=25691&p=203175#p203175

silopolis

2018-01-28 19:19

reporter   ~0010892

Last edited: 2018-01-29 06:33

View 2 revisions

I second this request !
Spreadsheets are first class citizens in projects together with tech drawings, paths, etc.. And one can build excellent documents with them that deserve/need printing feature.
Or again, like requested in 0002474 (https://forum.freecadweb.org/viewtopic.php?f=8&t=23863) delegate spreadsheet handling to Libre Office for mighty powers :) EDIT: @kunda1 oh man hadn't seen your link was just about that ! Such a good news someone is working on this :)

woodmonger

2021-02-02 20:13

reporter   ~0015250

Added post to forum describing recent work on this issue.
https://forum.freecadweb.org/viewtopic.php?f=4&t=25691&start=20#p473653

woodmonger

2021-02-05 00:18

reporter   ~0015271

Last edited: 2021-02-05 00:36

View 2 revisions

So, everything I said yesterday: Yeah, well never mind!! Attached a drawing with a simple sketch, a spreadsheet and a TechDraw view of the spreadsheet. Correct me if I'm wrong, but it appears to me as if the TechDraw spreadsheet view works fine. It is printable via the standard File/Print dialog, which includes (on Windows 10) the ability to print to PDF, and it can also be exported as a PDF. It also seems to keep the spreadsheet formatting, including merged cells. I just hadn't actually tried it out until now. If others can validate, would this pretty much cover this feature?

Added note on forum: https://forum.freecadweb.org/viewtopic.php?f=4&t=25691&p=474500#p474500

Using same build as I've had for the last two or three weeks:
OS: Windows 10 Version 2004
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.19.23721 (Git)
Build type: Release
Branch: master
Hash: 4c323a63258b94903290fb23426be240c8663950
Python version: 3.8.6+
Qt version: 5.15.1
Coin version: 4.0.1
OCC version: 7.5.0
Locale: English/United States (en_US)

dprojects

2021-02-05 20:22

reporter   ~0015278

I use Ubuntu and I have error:
"Printing not implemented for SpreadsheetGui::SheetView"

Export to CSV work only from Spreadsheet view under the button. There is no such option from "Export..." or "Save as...". Nothing change during this time, I guess.

dprojects

2021-02-06 12:52

reporter   ~0015280

The button "Inserts a view of a selected spreadsheet" under "TechDraw" selection works fine. Also, I am able to export to pdf the page with spreadsheet. This is useful for me. However, it is not as good looking as it would be directly in LibreOffice table, because the "TechDraw" page:

- not has column size adjustment,
- not has text position (left, right, center),
- the text can be set to bold only directly in spreadsheet.

Is there any way to save spreadsheet as LibreOffice .odt file with spreadsheet converted to table? This would be what I am looking for to make the whole print process very quick.

Issue History

Date Modified Username Field Change
2017-03-08 20:13 dprojects New Issue
2017-03-08 20:13 dprojects Tag Attached: printing
2017-03-08 20:13 dprojects Tag Attached: spreadsheet
2017-03-08 20:13 dprojects Tag Attached: direct
2017-03-08 20:13 dprojects Tag Attached: feature
2017-03-09 01:12 Kunda1 Priority immediate => normal
2017-03-09 01:12 Kunda1 Product Version 0.15 =>
2017-03-09 01:12 Kunda1 Note Added: 0008578
2017-03-09 13:04 Kunda1 Relationship added related to 0002474
2017-03-09 13:15 Kunda1 Tag Detached: direct
2017-03-09 13:15 Kunda1 Tag Detached: feature
2017-07-12 12:44 Kunda1 Tag Attached: #post-to-forum
2017-07-13 11:27 Kunda1 Tag Attached: #lowhangingfruit
2017-07-13 11:28 Kunda1 Note Added: 0009752
2017-07-13 11:28 Kunda1 Status new => feedback
2017-08-13 16:56 Kunda1 Note Added: 0009915
2017-11-10 16:49 Kunda1 Steps to Reproduce Updated View Revisions
2017-11-10 16:49 Kunda1 Note Added: 0010407
2017-11-11 18:43 eivindkvedalen Note Added: 0010410
2017-11-11 20:12 dprojects Note Added: 0010411
2017-11-11 20:12 dprojects Status feedback => new
2017-11-11 20:41 Kunda1 Tag Detached: #post-to-forum
2017-11-22 19:26 dprojects Note Added: 0010458
2017-12-08 00:33 Kunda1 Note Added: 0010543
2017-12-13 15:27 Kunda1 Project FreeCAD => Expressions
2018-01-28 19:19 silopolis Note Added: 0010892
2018-01-29 06:33 silopolis Note Edited: 0010892 View Revisions
2021-02-02 20:13 woodmonger Note Added: 0015250
2021-02-05 00:18 woodmonger Note Added: 0015271
2021-02-05 00:18 woodmonger File Added: FC Drawing with Spreadsheet - v0.19.FCStd
2021-02-05 00:36 woodmonger Note Edited: 0015271 View Revisions
2021-02-05 20:22 dprojects Note Added: 0015278
2021-02-06 06:30 abdullah Target Version => 0.20
2021-02-06 12:52 dprojects Note Added: 0015280
2021-02-07 13:15 dprojects Relationship added related to 0004556