Description: Calc "export selection" whole exports page Steps to Reproduce: 1. Open any calc spreadsheet 2. Select some range of cells 3. File -> Export -> (check "Selection") ; (file type png | pdf) -> Save Actual Results: It exports the page, but not selection Expected Results: It should export only selected cells Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36
I confirmed the behavior Version: 5.4.0.0.beta1 Build ID: 8672113ead4e403c55e31b1d9a3d1e0f3b299577 CPU threads: 2; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group
I think the issue it's that seems 'selection' refers to selected sheets not range, I understand it creates confusion. In anyway a bug or with not working properly or with a confuse title. But if you have defined the cell range on Menu/Format/Print ranges, it works fine
Assuming that the selection refers to pages instead of cells (does this even work?) is bound to cause confusion because Excel 2016 has a very similar tick-box to export a selection (to HTML) and in that case clearly refers to a cell-range because the cell-range is specified next to the tick-box. In any case I tried using your suggested Menu>Format>PrintRanges approach in attempting to export a range of cells *to HTML* and it did not work any better than selecting the cells and ticking the selection box. It seemed to simply export the entire page of cells (with lots of empty ones on the right and below where the page is larger than the small area of cells I wished to export)
Check it out, guys: https://cgit.freedesktop.org/libreoffice/core/commit/?id=a7a99a574660fc62a9514b2ed3f8ddfe8ad8540c Test with latest master and hopefully mark as fixed.
High! Tested with latest master (this night), patch doesn't work, still exports the page
Master exports the selected cell range, but the PNG is of the size of a page, hence the confusion I guess. Exporting only the selection without any empty space will need further work.
Yes, you are correct. Moreover PNG contains footer and header with page number and sheet title respectively. IMO The desired behaviour would be just cells and nothing else
And it still doesn't work at all with PDF or XHTML. Taking.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d34fa1fc643cc49253e7340b3de1c87a49875e8a Export to PNG: export selected cell range only, not as page, tdf#108317 It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8c0c897c8cb92285e6461cc99ab0f2bbe15be65f Export to PNG: init DPI with screen resolution, tdf#108317 It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b149201a076ed2d39fb95dd1c3d1367c9ef6924d Export to PNG: use proper dialog and filter options, tdf#108317 It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=52a6c68fb2fc817fc58419835cca73f6cd20b8fe Calc: support export to JPEG, just because we can.. tdf#108317 related It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2d0d777fe8830a39a316b01e08864e4694a51964 Export to PNG: selected shapes via drawing::GraphicExportFilter, tdf#108317 It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thanks! Confirm that it's fixed
just tested this with build 6.4.2.2 (x64) under Win 10 and the bug still exists for html export (but it is fixed for png and pdf export). Steps to reproduce: 1) open an existing spreadsheet 2) select a range of cells 3) export - check "selection", pick "html" as export format and save file 4) actual result: html file with entire sheet AND *all* other sheets expected result: html file with only the selected cells of the active sheet
(In reply to chris.siller from comment #15) > just tested this with build 6.4.2.2 (x64) under Win 10 and the bug still > exists for html export (but it is fixed for png and pdf export). > > Steps to reproduce: > > 1) open an existing spreadsheet > 2) select a range of cells > 3) export - check "selection", pick "html" as export format and save file > 4) actual result: html file with entire sheet AND *all* other sheets > expected result: html file with only the selected cells of the active > sheet This is now tracked in bug 132126