|
|
|
Forum Master
 
 
Group: Customers
Last Login: 12/26/2008 6:41:08 AM
GenoPro Version: 2.0.1.6
Posts: 552,
Visits: 7,297
|
|
I have a family tree which I imported to GenoPro.
When I open the "Table layout - Individuals", I'm getting that I have 126 individuals in my tree. I then use the "Copy table" button to copy the table and paste it into an excel sheet. Only part of the individuals (15) are being copied to the Excel.This is happening to me only in this tree. I managed to copy another family tree with 400 people to excel without any problem. Did someone else had this problem?
|
|
|
|
|
Legendary Master
Group: Administrators
Last Login: Yesterday @ 8:36:46 AM
GenoPro Version: 2.0.1.6
Posts: 3,534,
Visits: 14,913
|
|
The Copy Table function copies the data from the selected row. Try selecting the first row before copying the data; you should have all your data copied to the clipboard.
|
|
|
|
|
Forum Master
Group: Customers
Last Login: 12/26/2008 6:41:08 AM
GenoPro Version: 2.0.1.6
Posts: 552,
Visits: 7,297
|
|
GenoProSupport (4/26/2006)
The Copy Table function copies the data from the selected row. Try selecting the first row before copying the data; you should have all your data copied to the clipboard.I selected the first row. It copied 51 records (52 lines with the column name) out of 125 individuals.
|
|
|
|
|
Forum Master
Group: Customers
Last Login: 12/26/2008 6:41:08 AM
GenoPro Version: 2.0.1.6
Posts: 552,
Visits: 7,297
|
|
| I just sent you the family tree + GEDCOM file to by email.
|
|
|
|
|
Legendary Master
Group: Administrators
Last Login: Yesterday @ 8:36:46 AM
GenoPro Version: 2.0.1.6
Posts: 3,534,
Visits: 14,913
|
|
Humm... the problem is with a quote (") in the cell EVEN.comment for individual ID I88 (Arnon). If you remove that quote, all the 126 rows will copy in Excel.You will see the data remaining after the quote stored in the cell (in Excel). If you paste the data in Notepad instead of Excel, you will see better what I mean.
|
|
|
|
|
Forum Master
Group: Customers
Last Login: 12/26/2008 6:41:08 AM
GenoPro Version: 2.0.1.6
Posts: 552,
Visits: 7,297
|
|
GenoProSupport (4/26/2006)
Humm... the problem is with a quote (") in the cell EVEN.comment for individual ID I88 (Arnon). If you remove that quote, all the 126 rows will copy in Excel.If I will remove it after the paste or in GenoPro before the copy?
|
|
|
|
|
Legendary Master
Group: Administrators
Last Login: Yesterday @ 8:36:46 AM
GenoPro Version: 2.0.1.6
Posts: 3,534,
Visits: 14,913
|
|
| You can remove the quote, or put double-quotes. When Excel sees a cell starting with a quote, it does store all the data until it finds a matching quote. Since there is no matching closing quote, all the data until the end of the table got stored in that cell. I plan to modify the code to be "Excel friendly".
|
|
|
|
|
Forum Master
Group: Customers
Last Login: 12/26/2008 6:41:08 AM
GenoPro Version: 2.0.1.6
Posts: 552,
Visits: 7,297
|
|
Got it. I removed the quote from the family tree. Worked like a charm  Thanks.
|
|
|
|
|
Legendary Master
Group: Administrators
Last Login: Yesterday @ 8:36:46 AM
GenoPro Version: 2.0.1.6
Posts: 3,534,
Visits: 14,913
|
|
| I modified the code to append a matching closing quote to any cell begining with a quote. This will fix the problem you described. As a result, Excel regards the two quotes as cell delimiters, and therefore removes them during the paste operation. This is not ideal, since the original quote is gone, however it is much better than dumping the remaining of the data into a single cell.
|
|
|
|