https://bugs.freedesktop.org/show_bug.cgi?id=69841

          Priority: medium
            Bug ID: 69841
          Keywords: regression
          Assignee: [email protected]
           Summary: SetDataArray removes direct formatting
          Severity: major
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: Other
            Status: NEW
           Version: 4.1.2.1 rc
         Component: BASIC
           Product: LibreOffice

Created attachment 86629
  --> https://bugs.freedesktop.org/attachment.cgi?id=86629&action=edit
DataArray.ods including DataArray instruction

Hello

The following statement should only copy the values ​​in the "target" range:

oTargetRange.DataArray = oSourceRange.DataArray

Actually, values are copied but the direct formatting is lost.

Steps to reproduce:

1 Open the attached spreadsheet (DataArray.ods)
2. Allow macros to run and click on the button
"Copy values."

The expected result is to copy the values  from the range A1:E10 to the range
A15:E24. 

This "target" range is pre-formatted:
- Direct formatting in column A and E  (borders, background color, number...)
- Style formatting in column C.

After clicking the button the values ​​must be introduced in the range and
formats preserved.

Actual result:
With plaform (Windows XP & Version: 4.1.2.1
Build ID: bf15ac65c2167fb1ef3daf3710609d4a4c369a9) copy
values ​​but the direct formatting is lost.

Also reproduced (qa-fr) with Vista-32b and Version: 4.1.2.2
Build ID: 281b75f427729060b6446ddb3777b32f957a8fb 

Last known correct versions : 4.0.5.2 and 4.1.1.2 

This technique is widely used in applications so I select "major" severity even
if there is no data loss.

May be related to bug 69720 ?

Regards
Pierre-Yves

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to