Issue 126552

Created attachment 84952 [details]
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