Hello, this is my first bug report / feature request and I really hope I don't file this at the wrong position. I tried to look if this has already been requested but couldn't find any references, so apologies if I created any duplicates. The Request: At the beginning of every year I have to create a report of the last year for my company. To achieve this I would really like to use the "advanced filter" dialog, which is really handy. I'd like to do some transformations on the raw data and then use the advanced filter to copy the results to another sheet, unfortunately, the copy operation copies the formulas instead of the corresponding data and therefore, does not work in my case. Would it be possible to add an option (maybe a tickbox) to only copy the data instead of the reference? Thank you in advance, Mani
Works fine for me, only filtered data are copied, with Version: 24.8.4.2 (X86_64) / LibreOffice Community Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Also in the advanced filter there is an option to copy the result to another range.
Sorry, English is not my primary language, I already expected this to not be very clear... Yes I am aware of the copy to another range option, actually I am referring to that particular option: If I use the copy to range option in advanced filter this copies the cell content => if the cell contains a formula this formula can lose context / its references. Therefore, I'd like to propose an additional option, something like a tickbox "unformatted text" (like in paste special).
Created attachment 198486 [details] Example file to better show my issue with advanced filter I created a (rather stupid) demonstration file to better present this: The ods has 3 sheets In sheet1 (RawData) are two tables 1. the original data, 2. a reference to it (i.e. F3=A3, etc.) as well as the a filter option, filtering out product2 Sheet2 (FilterOnData) is the result of advanced filter applied on the first table and the copy to another range applied Sheet3 (FilterOnDataFromFormula) is the same for the referencing table. As you can see in the referenced case, this does not work at all Please let me know if I can clarify this any further, Thank you for your interest
I am wrong, or you can use a normal copy, and with paste special, past all except formulas.
In any case your request would be for enhancement, not a bug.
I think it is a little bit of both, I can't believe that the result of applying an advanced filter with the copy option should lead to broken references as seen in sheet number 3. But yes, my workflow would be perfectly covered by the proposed workaround with the additional option to copy only unformatted text. I'm sorry, I actually wanted to file this as an enhancement but didn't find see the option, thanks for reassigning.