https://bz.apache.org/ooo/show_bug.cgi?id=126552
Issue ID: 126552
Issue Type: DEFECT
Summary: Occasional duplication of the final line in the data
source browser when importing into calc via COPY
Product: Calc
Version: 4.1.1
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: major
Priority: P5
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
Created attachment 84952
--> https://bz.apache.org/ooo/attachment.cgi?id=84952&action=edit
this shows the last few lines of my data source in the D S Browser, all entries
highlighted
With the data source browser open, selecting all rows and right clicking copy
to import into the calc sheet, on some occasions the last line of data is
duplicated.
I have worked round this mostly by transferring functionality to Base but there
are still functions where Calc is essential (e.g. charts). It is a nuisance
because I need to go back and delete lines when it happens.
Here is the list as copy imported into the spreadsheet
---------------------------8><------------------------------
CURRENCY_SORT_ORDER CURRENCY BUDGET_MONTH_END
1 GBP 31/03/15
1 GBP 30/04/15
1 GBP 31/05/15
1 GBP 30/06/15
1 GBP 31/07/15
1 GBP 31/08/15
1 GBP 30/09/15
2 USD 31/03/15
2 USD 30/04/15
2 USD 31/05/15
2 USD 30/06/15
2 USD 31/07/15
2 USD 31/08/15
2 USD 30/09/15
3 EUR 31/03/15
3 EUR 30/04/15
3 EUR 31/05/15
3 EUR 30/06/15
3 EUR 31/07/15
3 EUR 31/08/15
3 EUR 30/09/15
4 PEN 31/03/15
4 PEN 30/04/15
4 PEN 31/05/15
4 PEN 30/06/15
4 PEN 31/07/15
4 PEN 31/08/15
4 PEN 30/09/15
4 PEN 30/09/15
---------------------------8><------------------------------
The last line is duplicated. If required I can email the data separately.
As I said this does not happen every time or indeed every time on the same
spreadsheet. But it happens enough that I had to code a workround when one
process actually depended on the spreadsheet contents and would have broken had
I not been able programmatically to determine and remove the dud repeated line.
AOO 4.1.1 Windows 7.
Thanks
D Denny
--
You are receiving this mail because:
You are the assignee for the issue.
