Ign-addon-ods
Description:	Ignition addon for access ods-files
Download:	ign-addon-ods.lha       (TIPS: Use the right click menu if your browser takes you back here all the time)
Size:	204kb
Version:	0.40
Date:	03 Jul 2024
Author:	A. Pankalla
Submitter:	Samir Hawamdeh
Requirements:	AOS4.1FE and ignitionOS4 >= beta4
Category:	office/spreadsheet
Replaces:	office/spreadsheet/ign-addon-ods.lha
License:	Other
Distribute:	yes
Min OS Version:	4.1
FileID:	12987
Snapshots:
Comments:	0
Snapshots:	3
Videos:	0
Downloads:	142  (Current version)
	1470  (Accumulated)
Votes:	7 (0/0)  (30 days/7 days)

This is a addon for the Ignition beta4 and newer spreadsheet program.
With this tool it is possible to read and write files with the suffix ods. this
files a created by openoffice-calc or libreoffice-calc and maybe other
spreadsheets.
please read the ReadmeFirst/LiesMichzuerst files in the main directory for
further important informations.
!!!this addon only works with 4.1FE and Ignition!!!

For better result, please disable in the src-spreadsheet program the 1000er
separator!
At the moment ignition has problems with values like this:
1.000,00€

V0.40
- correct a error with function code/asc
- implement new fuctions of ignition 1.30

V0.39
- many optimazions to increase read speed

V0.38
- some improvements to prevent endless reading
- remove debug outputs to speedup

V0.37
- now some more functions are converted
- solve a problem with ms ods-files
- corrects a failure in calculation of column and row size

V0.36
- Corrects some bugs in the handling of textattributes

V0.35 
- add new functions og ignition 
- correct the problem, which appears after save a ods-file 

V0.34
- Function mode added
- Function pi() added (>= ignition V1.02)
- Correct an error in the adressing of table with $ parameter

V0.33 little enhancements
- Function Eastersunday implemented (for ignition V1.00)

V0.32 optimations and little enhancements
- Function counta/num implemented
- Function choose/select implemented
- Function product/produkt implemented
- Function var/var implemented
- Speedup the read of ods-files by implementing an sheet analyzing function
- Speedup the hole addon by optimation of the code
- Correct the processing of cell-borders
- some little changes to increase the gnumeric-compatibility
- Reduce the amount of debug-informations
- Correct visualisation of <> in text-cell

V0.31 - error corrections
- now cell sizes in inch are correctly regocnized
- function with a two chraracter name now correctly implemented
- the math-comparsion < > are now known
- in some cases, strings are misinterpreted, this is corected

V0.30 - second function updates and errorcorrections 19-Mär-2018
- vertical and horizontal cell alignment
- all cell-frame feature which are support by ignition

V0.20 - first function updates and errorcorrections 22-Apr-2017
- correcting many minor bugs
- now read/writes fontcolor informations
- now read/writes backcolor informations
- now read/writes column sizes
- now read/writes row sizes

V0.11 - first improvements and errorcorrections 12-Jan-2017
- much better position of the data in right destination cells
- better converting of cell-ranges like a1:c1
- optimizing code for better and faster results
- optimizized handle of special character
- special character in tablenames are now converted
- remove empty rows at the end of a table
- set marks for text-fields
- remove some bugs

V0.10 - first public release 05-dec-2016