Description: Hi Experts, I've database range in $ThisSheet$A$1:$N$5609 and the total row number is 5611 The value in cell A5610 is 'x123' This is step by step how the problem is occured : 1. Opened file with database range (example => database range = $ThisSheet$A$1:$N$5609, but = 5611 row total exist with data) 2. Filter the column A with value = 'x123' (x123 is in cell A5610) 3. The data filtered only show 2 row (1 row header dan 1 row data) 4. Click 'Data'->'Define Range'. The cell range is $ThisSheet$A$1:$N$5611 5. If I clear the filter and click 'Data'->'Define Range'. The cell range is still $ThisSheet$A$1:$N$5611 If I closed this file, reopen and without filter the data, I click 'Data'->'Define Range'. The cell range is show correct range $ThisSheet$A$1:$N$5609 Why the range has changed? The correct range is $ThisSheet$A$1:$N$5609 but it show $ThisSheet$A$1:$N$5611 after I filtered the column Sincerely, Oviedityanto Steps to Reproduce: 1.Opened file with database range (example => database range = $ThisSheet$A$1:$N$5609, but = 5611 row total exist with data) 2.Filter the column A with value = 'x123' (x123 is in cell A5610) 3.The data filtered only show 2 row (1 row header dan 1 row data) 4.Click 'Data'->'Define Range'. The cell range is $ThisSheet$A$1:$N$5611 5.If I clear the filter and click 'Data'->'Define Range'. The cell range is still $ThisSheet$A$1:$N$5611 Actual Results: Incorrect database range cell => $ThisSheet$A$1:$N$5611 Expected Results: Correct database range cell => $ThisSheet$A$1:$N$5609 Reproducible: Always User Profile Reset: No Additional Info: Version: 7.4.4.2 (x64) / LibreOffice Community Build ID: 85569322deea74ec9134968a29af2df5663baa21 CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-GB Calc: CL
Please attach your sample file.
How to attach an xlsx file? If copying to *.txt format, there will be no database range
(In reply to m_a_riosv from comment #1) > Please attach your sample file. How to attach an xlsx file? If copying to *.txt format, there will be no database range
[Automated Action] NeedInfo-To-Unconfirmed
At the beginning of the comments, there is where to click to add an attachment. xslx files are allowed to attach.
(In reply to m_a_riosv from comment #5) > At the beginning of the comments, there is where to click to add an > attachment. xslx files are allowed to attach. Error : The content type xlsx is invalid. Valid types must be of the form foo/bar where foo is one of application, audio, image, message, model, multipart, text, video and bar must not contain any special characters (such as "=", "?", ...).
Created attachment 191836 [details] Test file xlsx Maybe because your file is not a true xlsx, but other type with that extension.
Created attachment 191838 [details] file example with database range
Oh it's because I input 'xlsx' in 'content type' field I choosed 'auto detect' and upload attachment worked
Because of database range, it automatically expands to the last row before a blank row, from its current last row. What happen, in this case, when you applied the filter. And for me after save without filter and reopen, the data range remains: $ThisSheet.$A$1:$N$5611 Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 25276df12abd9d002f7f899900434617b256f745 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded I don't think it is a bug.
Thank you for the report. This is already tracked in bug 127419, marking as duplicate. Thank you! *** This bug has been marked as a duplicate of bug 127419 ***