[Libreoffice-bugs] [Bug 143297] New: Saving Calc spreadsheet with many database queries injects spurious rows [FILESAVE, FORMATTING]

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=143297

            Bug ID: 143297
           Summary: Saving Calc spreadsheet with many database queries
                    injects spurious rows  [FILESAVE,FORMATTING]
           Product: LibreOffice
           Version: 7.0.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: spun69 at yahoo.com

Description:
We use LO 7.0 for a reservation tracking database application using an external
HSQLDB server.  One of our reports uses Calc template to generate a daily
report showing reservations for each hour of business day (7AM - 5PM).  Bug is
that on saving the file as either template or regular format results in a large
block of spurious blank rows injected between the 4PM and 5PM time blocks.

Attached is an sample file in post-error state.  

Issue seen in LO 7.0.6.2 & 7.1.4.2 (x64)    

Steps to Reproduce:
1. Load sample file into Calc
2. Do not run database queries when prompted
3. Scroll down to the 4PM block, notice blank rows between 4PM & 5PM
4. Delete all visible blank rows
5. Save file
6. Reopen file
7. Scroll down to 4PM block, see if blank rows again present


Actual Results:
Blank rows injected

Expected Results:
No blank rows to be added to file


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210711/05d11c21/attachment-0001.htm>