View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0002957||Spreadsheet||Feature||public||2017-03-08 20:13||2021-12-04 22:36|
|Target Version||0.20||Fixed in Version||0.20|
|Summary||0002957: please add spreadsheet direct printing|
|Description||Please add spreadsheet direct printing. This will be very helpful for my macro:|
|Steps To Reproduce||From 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).
Go and cut your chipboards to market or any other woodworking service that provide wood cutting :-)
|Additional Information||no such feature already|
|Tags||#lowhangingfruit, printing, spreadsheet|
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.
||@dprojects can you explain in more detail, within this ticket why it would be useful to have this feature?|
||@eivindkvedalen care to weigh in ?|
|I think printing is now supported in Tech draw. Is that enough?|
||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.|
||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.|
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 :)
Added post to forum describing recent work on this issue.
Last edited: 2021-02-05 00:36
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
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)
FC Drawing with Spreadsheet - v0.19.FCStd (9,900 bytes)
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.
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.
||I have already added support for TechDraw printing, so the direct printing is no longer issue for me.|
|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|
|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|
|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|
|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|
|2021-05-19 19:25||dprojects||Note Added: 0015667|
|2021-11-24 15:21||chennes||Project||Expressions => Spreadsheet|
|2021-12-04 22:36||wmayer||Assigned To||=> wmayer|
|2021-12-04 22:36||wmayer||Status||new => closed|
|2021-12-04 22:36||wmayer||Resolution||open => fixed|
|2021-12-04 22:36||wmayer||Fixed in Version||=> 0.20|
|2021-12-04 22:36||wmayer||Note Added: 0016061|