Created attachment 86629 [details]
DataArray.ods including DataArray instruction
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
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.
With plaform (Windows XP & Version: 188.8.131.52
Build ID: bf15ac65c2167fb1ef3daf3710609d4a4c369a9) copy
values but the direct formatting is lost.
Also reproduced (qa-fr) with Vista-32b and Version: 184.108.40.206
Build ID: 281b75f427729060b6446ddb3777b32f957a8fb
Last known correct versions : 220.127.116.11 and 18.104.22.168
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 ?
can't reproduce this in 22.214.171.124, and i believe that this fixed it:
Author: Michael Meeks <email@example.com>
AuthorDate: Fri Sep 27 15:59:32 2013 +0200
fdo#69450 - IDF_ATTRIB & IDF_CONTENTS must be disjoint.
*** This bug has been marked as a duplicate of bug 69450 ***
(In reply to comment #1)
> can't reproduce this in 126.96.36.199, and i believe that this fixed it:
Verified. I close.
Thank you :)