https://bugs.freedesktop.org/show_bug.cgi?id=51748
--- Comment #4 from Seved Torstendahl <[email protected]> --- Created attachment 70600 --> https://bugs.freedesktop.org/attachment.cgi?id=70600&action=edit Spreadsheet containing errors I have now prepared a spreadsheet where all data that identified persons are replaced. In this anonymization process I used the sheetname and cell position as text. E.g. ”Kalmar-B24” was entered in cell B24 in sheet Kalmar, and similar for ”Växjö-C58”. When many cells in a column were changed ”Kalmar-L*” was used in column L, et c. Later in the process only the first letter of the name of the sheet was used, e.g. ”K-T5”. A lot of cells from Kalmar show up in the Växjö sheet, and vice versa. The Svenljunga sheet has also got many cells populated with info from Kalmar and Växjö but I have not seen any effect in the other direction. All complaints about ”#VALUE!” are consequences from numerical values being destroyed when cell contents have been duplicated from other sheets. The symptom that the value in Kalmar-M58 was doubled in the Sum= info at the bottom has disappeared in the anonymization process. We have a feeling that it all started when a couple of cross references were added. Kalmar-J90 shall be the sum of cells O50+O61+O65 from sheet Växjö, the formula is there and is correctly summed. Kalmar-J91 also refers to sheet Växjö. The file has always been saved in Microsoft Excel 97/2003 format. When saved in ODF format it seemed that there was no duplication of new data to other sheets. I have also built LibreOffice from a source tarball libreoffice-core-3.6.5.2 in a Kubuntu system. This newly built LibreOffice Calc was used here. It is possible for me to check the original spreadsheet but I need some hints on how to start debugging, I would be happy to help you. I am quite experienced, have been programming since 1968 and done a lot of debugging on code from other sources! -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
