manual edited GedTool-sheet

Antworten
mariannevanharten
Beiträge: 4
Registriert: Mi 19. Nov 2014, 22:30

manual edited GedTool-sheet

Beitrag von mariannevanharten » Mi 25. Feb 2015, 10:31

I have a gedcom-file (>60,000 persons) which I've loaded into GedTool.
I edited the file and tried to save the new file. Within 1 minute an error appears (I use a Dutch version of Excel, so translated to English):
Error 13: Types do not match.

Maybe the 'problem' can be found here, but I do not know how to solve that.
Some columns contains HTML data.

Code: Alles auswählen

<nt><a href="C:\Users\Guido\Documents\Aldfaer\Materiaal\harten_guido_van_1967_geboorteakte.jpg">Geboorteakte</nt>
I defined these cells as Text

What is the best way to solve this problem, so that I can save my gedcom file?

mariannevanharten
Beiträge: 4
Registriert: Mi 19. Nov 2014, 22:30

Re: manual edited GedTool-sheet

Beitrag von mariannevanharten » Mi 25. Feb 2015, 14:30

I analyzed the partial written file and looked into the GedTool sheet.
I searched for the last written line of the gedcom file. The next field into the GedTool sheet shows me the problem: #VALUE!. This was defined by a formula to define the right content of the cells in that column.
I deleted the #VALUE! (yes, it could be deleted safely) and the problem was solved.

Antworten