https://bugs.documentfoundation.org/show_bug.cgi?id=170237
Bug ID: 170237
Summary: Calc : Reference in formula to database range is not
saved or not reconstituted on reopen of file
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I wished to replace some complicated references to database ranges with the
notation suggested in "Database Table Reference" in LibreOffice 25.8 Help. The
formulas work as intended, but after save and reopen, the notation (ex :
databaserange1[FieldX]) is replaced with the range (ex : $Sheet1.$F$7:$F$29).
Steps to Reproduce:
1. Create a small database, define a database range covering the database
2. Write formulas such as sum of a particular column using the dbrange[field]
notation
3. Save the spreadsheet, close and reopen - the database notation is replace
with range references.
Actual Results:
The formula doesn't report an error but the database notation range is replaced
with range references. The formulas are not dynamic - adding rows to the
database would not be updated in the formulas.
Expected Results:
The database notation would be retained in the formulas, allowing a dynamic
evolution of the database.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.2.5.2 (AARCH64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 10; OS: macOS 15.7.2; UI render: Skia/Raster; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
