LibreOffice with Python 3.5

Having trouble installing or compiling FreeCAD? Get help here.
User avatar
dprojects
Posts: 31
Joined: Mon Mar 06, 2017 6:02 pm
Location: Poland
Contact:

Re: LibreOffice with Python 3.5

Postby dprojects » Thu Feb 04, 2021 11:38 am

cjones6108 wrote: Tue Feb 02, 2021 7:42 pmAfter several days of banging my head against it, my conclusions are
Good developer not think WHY to code something, good developer think HOW to do it to complete the goal. If You start thinking "I don't want to do it", "it is too complicated", "it is not worth it", "why on the Earth I should do it", there always will be many workarounds and reasons not to do it not matter what You do.

I was so long time ago, I don't even remember what was the reason to open the issue, tho. Probably because the FreeCAD spreadsheet was not fully compliant with LibreOffice spreadsheet version. After open more advanced version FreeCAD spreadsheet in LibreOffice You had one big mess. So it was better to copy CVS text manually and correct it manually also.

This issue was opened to point out new good feature and make the FreeCAD better. However, If You feel so big pressure and don't want to do it, just remove it and forget about it. I have my workaround and don't cut chipboards daily to feels so big pain in ass without this feature. I was living so long without it, so probably this feature is not worth to ruin someones life ;-)
FreeCAD macro to get chipboards dimensions to cut : https://github.com/dprojects/getDimensions
User avatar
Kunda1
Posts: 10735
Joined: Thu Jan 05, 2017 9:03 pm

Re: LibreOffice with Python 3.5

Postby Kunda1 » Thu Feb 04, 2021 11:42 am

dprojects wrote: Thu Feb 04, 2021 11:38 am This issue was opened to point out new good feature and make the FreeCAD better. However, If You feel so big pressure and don't want to do it, just remove it and forget about it. I have my workaround and don't cut chipboards daily to feels so big pain in ass without this feature. I was living so long without it, so probably this feature is not worth to ruin someones life ;-)
I think this feature is valid and it makes sense for other applications besides using Calc. Someone(s) just needs to step-up and make it happen, just like the rest of FreeCAD and the open source world. Lets do it.
Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features
User avatar
cjones6108
Posts: 10
Joined: Sat Nov 14, 2020 12:30 am
Location: South-Central USA (GMT -6)

Re: LibreOffice with Python 3.5

Postby cjones6108 » Fri Feb 05, 2021 12:34 am

OK, so now I feel like a complete idjit, which is not terribly unusual. I added an additional note on the bug ticket (#2957), with the new observation that I actually tried out the spreadsheet functionality with the TechDraw workbench and found that it seems to work fine. Also uploaded a sample drawing with the requisite elements included. The spreadsheet view is printable with the standard print dialog, and can also be exported as a PDF. On Windows 10, the standard print dialog also includes an option to print to PDF.

Now, granted, this totally bypasses the issue in the subject line here, which is regarding LibreOffice and Python. These would still be valid topics for development work, but FWIW, the actual bug/feature request I'm guessing is satisfied, pending peer review and validation. :roll:

-----
caj
User avatar
chennes
Posts: 888
Joined: Fri Dec 23, 2016 3:38 pm
Location: Norman, OK, USA
Contact:

Re: LibreOffice with Python 3.5

Postby chennes » Fri Feb 05, 2021 2:36 am

I found this whole discussion interesting and useful: I've added a very short section to the wiki about printing a spreadsheet via TechDraw. Please feel free to add more details to it!
Chris Hennes
Pioneer Library System
User avatar
dprojects
Posts: 31
Joined: Mon Mar 06, 2017 6:02 pm
Location: Poland
Contact:

Re: LibreOffice with Python 3.5

Postby dprojects » Fri Feb 05, 2021 8:27 pm

cjones6108 wrote: Fri Feb 05, 2021 12:34 am OK, so now I feel like a complete idjit
cjones6108 wrote: Fri Feb 05, 2021 12:34 am On Windows 10
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.
FreeCAD macro to get chipboards dimensions to cut : https://github.com/dprojects/getDimensions
User avatar
Kunda1
Posts: 10735
Joined: Thu Jan 05, 2017 9:03 pm

Re: LibreOffice with Python 3.5

Postby Kunda1 » Fri Feb 05, 2021 8:30 pm

dprojects wrote: Fri Feb 05, 2021 8:27 pm I use Ubuntu and I have error: "Printing not implemented for SpreadsheetGui::SheetView"
About info pls
Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features
User avatar
dprojects
Posts: 31
Joined: Mon Mar 06, 2017 6:02 pm
Location: Poland
Contact:

Re: LibreOffice with Python 3.5

Postby dprojects » Fri Feb 05, 2021 8:37 pm

Kunda1 wrote: Fri Feb 05, 2021 8:30 pm About info pls
OS: Ubuntu 20.04.2 LTS
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.18.4.
Build type: Release
Python version: 3.8.2
Qt version: 5.12.5
Coin version: 4.0.0
OCC version: 7.3.0
Locale: English/United States (en_US)
FreeCAD macro to get chipboards dimensions to cut : https://github.com/dprojects/getDimensions
User avatar
Kunda1
Posts: 10735
Joined: Thu Jan 05, 2017 9:03 pm

Re: LibreOffice with Python 3.5

Postby Kunda1 » Fri Feb 05, 2021 9:46 pm

dprojects wrote: Fri Feb 05, 2021 8:37 pm Version: 0.18.4.
Update to v0.19_pre https://github.com/FreeCAD/FreeCAD/rele ... g/0.19_pre
Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features
User avatar
dprojects
Posts: 31
Joined: Mon Mar 06, 2017 6:02 pm
Location: Poland
Contact:

Re: LibreOffice with Python 3.5

Postby dprojects » Sat Feb 06, 2021 12:56 pm

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.

https://tracker.freecadweb.org/view.php?id=2957#c15280
FreeCAD macro to get chipboards dimensions to cut : https://github.com/dprojects/getDimensions
User avatar
Kunda1
Posts: 10735
Joined: Thu Jan 05, 2017 9:03 pm

Re: LibreOffice with Python 3.5

Postby Kunda1 » Sat Feb 06, 2021 1:25 pm

Kunda1 wrote: Fri Feb 05, 2021 9:46 pm
dprojects wrote: Fri Feb 05, 2021 8:37 pm Version: 0.18.4.
Update to v0.19_pre https://github.com/FreeCAD/FreeCAD/rele ... g/0.19_pre
did you update?
Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features
cron