Gnumeric 1.12.62 Morten: * Test improvements * New function PHI. * New function GAUSS. * New function PERCENTOF. * New function REGEXTEST. * New function REGEXEXTRACT. * New function REGEXREPLACE. * New functions NETWORKDAYS.INTL and WORKDAY.INTL. * New functions PARTITIONS. * Add export option "formulas=true" to txt and csv. * Improve xlsx export. * Improve xl compatibility for multiple functions. * Improve GEOMEAN accuracy. * Fix problem with sylk importer. [#878] * Improve xl compatibility for complex functions. * Fix problems with blanks for database functions. [#887] * Fix auto-filter problem. [#891] * Avoid Wayland auto-filter warnings. * Eliminate reliance on deprecated pango functions. * Eliminate reliance on deprecated python functions. * Fix R.PST in the log case. -------------------------------------------------------------------------- * Fix crash involving document properties and undo/redo. * Avoid re-querying file existence for recent files. [Part of #602] * Fix moving averages, exponential smoothing and principal * Make installation work without scrollkeeper. * Fix ODF roundtrip of "center across selection". [#726010] * Avoid unnecessary sheet specification in analysis tools. [#691892] * Avoid too many hash collisions for dense sheets. * Add underline button to formatted text dialog for sheet objects, comments, etc. * Make selection background visible. [#648676] * Clarify the distinction between open/save and import/export. * Fix cell extent calculation for xlsx export. [#661958] * Improve date format consistency in document properties. [#644217] * Fix column width and row height adjustments when entering in ranges. * Remove range highlighting while not editing expressions. [#625361] * Eliminate almost all remaining GdkGC usage. * Add an initially hidden long format toolbar. * Add superscript and subscript buttons. [#583327] * Fixed libspreadsheet.pc. [#575390] * Fix inconsistency in searching with respect to formats. * Fix cursor in tab labels. [#546981] * ROW/COLUMN return vectors not matrices. [#Harlan Grove] * Extend GDA type conversions, and make compatible with 1.9.103. * Add some drag handles for graphically creating frozen panes. * Enable libspreadsheet build * Buttons in sheet manager dialog should not stretch vertically. * Stub for MS Excel's ASC function, which is unnecessary in gnumeric. * Fix horizontal alignment of rotated numbers broken by fix to * Use non bash specific substitution for autoformat templates [#161782] * Ensure that the preference dialog in the non-gnome build * Fix crash when adding y-errors to an empty plot * Fix graph guru crash in the absence of graph plugins. * kludge around mystery inconsistent autofilters in xls * Fix range selection of multiple items in other locales * Errors default to horizontal alignment == center * Patch warning when quitting with an keyed dialog * Fix text export of non-ascii characters * Fix latex export of non-ascii characters * Fix crash on xls export for autofilters with no conditions. * Decrease dependence on glibc regexp extensions. * Make the behavior of save and save-as more comfortable. * Optional outline markers at the beginning rather than end * No longer pretend to support the Bonobo/PersistFile interface. * Improve memory usage in search centre slightly. * Fix documentation installation to match libgnome's expectations * Create ui to set protection of individual sheets. * Support importing encrypted XLS workbooks (password is temporarily * Destroy outdated dialogs. * Fix expr entry widget: used to get confused on mouse clicks * Fix Exit icon for bonobo build. * Invalidate names referring to deleted expressions. * Fix handling of failure in filter dialog. * Fix missing bonobo menu icon for exit. * Many i/o system improvements (general cleanup, reporting i/o progress, * Added two perl scripts for translation help/maintenance. * Major GUI improvements for Solver, e.g. Solver constraints * Copying cells between different instances of gnumeric. * Explicitly disable password protected XL spreadsheets. * Updated bonobo infrastructure * better range intersection sensitivity and text (rather value) * Totally re-wrote style engine. * Arbitrarily shaped bonobo objects. * Totally re-write libole2's API - its usable now. when copying not cutting. method of computation (Morten Welinder). 1. Morten Welinder implemented a more accurate algorithm for * Jukka-Pekka Iivonen contributed many financial functions: COLUMNS(), HLOOKUP(), ROW(), ROWS(), VLOOKUP() - Bug fix: Applying a cell number format should work again immediately addition and subtraction will be promoted to floating point applications correctly and fix the inter-workbook pastes). - Contributed Spanish documentation from Pablo. - Dependency computation code got fixed. Horribly typo was * Many updates on the Excel side, optimizations, bug fixes, - Fix crashing problems reported when autofilling. attempt at scrolling, it is now definitely usable. the autofill code got definitely simpler and more maintainable). routines now use GLib's gdate instead of the gnome-libs libDate