| Summary: | Calc: setting print range with the whole column not remember in XLS/X | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | pornchai_kuk |
| Component: | Calc | Assignee: | Andreas Heinisch <andreas.heinisch> |
| Status: | RESOLVED FIXED | ||
| Severity: | minor | CC: | andreas.heinisch, cbuatois |
| Priority: | medium | Keywords: | filter:xls, filter:xlsx |
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=143058 | ||
| Whiteboard: | target:24.8.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 108815 | ||
| Attachments: | This is the file I used and found this bug. | ||
|
Description
pornchai_kuk
2022-03-25 07:39:29 UTC
I don't reproduce. Do you reproduce in any file or just some, which file type? Or you maybe have filtered rows there? I found this when I'm working with my xls file. I created this file with Calc and save as xls format. And I have set filter to some column in the sheet I do print, but I show all data for that column when print. I tried set print rage to other sheet (sheet B) in same file but no filter, then I previewed to check the setting. I closed and reopened the file with sheet B and check with print preview, the setting pring range is reset. Also no repro for xls. Either there's some detail more or it's about your xls. Try creating new XLS for test. If no problem there, attach your XLS with test data. Created attachment 179213 [details] This is the file I used and found this bug. I'm not sure this bug is only with this xls file or other xls file also. I also screen record when I tested, please see from https://youtu.be/yD2xD4GUOu4 I'm not sure this bug is only with this xls file or other xls file also. I also screen record when I tested, please see from https://youtu.be/yD2xD4GUOu4 I confirm now with XLS and XLSX not ODS, only if print range is the whole column. Repro 7.4+ and 4.1 and OO. Seems Inherited. *** Bug 156810 has been marked as a duplicate of this bug. *** .xls supports up to 65,536 rows and if you select an entire col calc tries to export 1,048,576 rows for its print range. Two possible solutions, warn the user that such a print range cannot be exported and/or shrink the print range to 65,536 which may still create some problems. Thoughts? So I checked the implementation and the only way to solve this is to change the address of the form $A$1:$A$1048576 to the form $Sheet1.$A:$A This can be done using the ScCompiler for the print range dialog. However, under print ranges -> define it already selects the correct range without the ScCompiler. Hence, the compiler doesn't reduce the address to the form $Sheet1.$A:$A. I could not find the other way round (creating a reduced ScRange). Andreas Heinisch committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/2d472fae8f1223dc969172951d08ff6e4b4f98ba tdf#148170 - Convert print range to an excel cell range It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |