In my spare free time im working on a simple movie database to have a sortable collection list of my movies. Hitherto i've do that with the Spreadsheet of OpenOffice.
After some time of development i've finished a first betaversion of my tool and starts to work on a importer.
The best way to import ODF files is to extract the content files fromt the zip-encoded files and read the xml. This steps were already done by the OpenOffice team and somebody has implement this steps in a .NET interface library. I've found this project (AODL, Sourceforge) and starts to working with it. Bug it has a bad bug.
I have a big table with many cells in many rows, but some of this cell - also severals side by side - are empty. And OpenOffice creates on this empty cells a XML attribute called "table:number-columns-repeated" which descripes how many copies of this cells came after this one.
The AODL assembly do'snt has this attribute calculation implemented so that if've sit down and do that. So, here's the bugfix and the assembly.
Link: Download
Prüfen ob
IsAlphaNumericString: ein String eine gültige Zahl ist
IsNumeric: ein gültiger Alpha-numerischer String ist
Wer kennt nicht das Problem, Daten Seitenweise aus der Datenbank zu laden. MySQL kann das auch sehr schön mit einem beherzten LIMIT x,y, aber wenn man nun an einem Microsoft SQL Server sitzt und nur T-SQL hat?
Dagegen hilft nur der folgender Code Schnitzel:
To generate a square thumbnail in c#, use this code:







