Gnumeric в особом представлении не нуждается, одно только перечисление форматов, с которыми он работает говорит о многом: MS Excel, Lotus, Applix, Quattro Pro, OpenCalc, XBase, DIF, SYLK, HTML, Psion, MPS, oleo, sc, misc, простой текст, свой родной XML, Latex... В текущем нестабильном релизе решены проблемы с диалогом управления таблицей, исправлены давние ошибки. Home_http://www.gnome.org/projects/gnumeric/ Downloads (~12 Mb)_http://ftp.gnome.org/...1.5.90.tar.bz2 Stable_http://ftp.gnome.org/...c-1.4.3.tar.gz
Gnumeric 1.7.6 requires the newly released Goffice 0.3.5
Jody * Fix sax import of autofilters. [Bug 383400]. * Fix autofilter lists with only 1 combo. [Bug 383400]. * Implement sax import of sheet objects. * Implement List and Combo objects. * Avoid pixel dirt when drawing hidden cursor. [Bug 365960]. * XLSX support for import and export of autofilters. * Right click on combos/list always brings up popup. [Bug 135966].
Morten * Fix title problem. [Bug 382643]. * Fix sax loading of comments. * Fix scaling and rtl orientation of comment marker. [Bug 381700]. * Set a saver after loading with the sax loader. * Implement undo for sheet object widgets. [Bug 384136]. * Work around a gcc bug. * Improve number formatting.
December 2007: Gnumeric 1.7.91 is out. This is the second release candidate leading up to 1.8.
Release 1.7.91
* src/workbook-view.c (wb_view_dispose): New function extracted from wb_view_finalize to handle viewe-control disentanglement. * src/workbook-control.c (wbc_dispose): Renamed from wbc_finalize and hooked up accordingly. Fixes #499680. * src/print.c (gnm_begin_print_cb, gnm_request_page_setup_cb): Silence warnings about gtk+ workarounds. * src/print.c (print_sheet_objects): print the sheet objects in reverse order * src/gnm-pane.c (gnm_pane_unrealize): Fix critical. [#499905] * src/wbc-gtk-actions.c (common_cell_goto): Don't try to go to an invisible sheet. Fixes the part of 499723 that Sum1 hasn't even found yet. * src/workbook.c (workbook_cells): Considers cells in sheets only if they are sufficiently visible. * src/search.c (gnm_search_collect_cells): Don't collect cells in deeply hidden sheets. * src/workbook-control.c (wb_control_parse_and_jump): Make target absolute. Fixes #499722. * print-info.c (print_hf_new): use empty strings rather than NULL * src/style-conditions.c (gnm_style_cond_is_valid) : make public. * src/xml-sax-write.c (xml_write_breaks) : new. Manual enum handling for performance. (xml_write_print_info) : use it here. * src/xml-sax-read.c (xml_sax_attr_enum) : Use class_ref/class_unref to force the enum to complete. (xml_sax_page_break) : new with manual enum handling for performance. (xml_sax_page_breaks_begin) : new. (xml_sax_page_breaks_end) : new. * src/sheet.c (sheet_insert_cols, sheet_insert_rows, sheet_delete_cols, sheet_delete_rows): Initialize reloc_info.pos. * src/dependent.c (dependents_relocate): When handling names, get a list of the names as the hash will change during the process. Fixes #498347. * configure.in : post release bump to 1.7.91-rc2
Главная особенность релиза: теперь существует возможность импортировать и экспортировать документы в формате OOXML. Downloads (~13,7 Mb)_ftp://ftp.gnome.org/...-1.8.0.tar.bz2
This release is a bugfix release mostly fixing a large number of problems that Sum1 found by throwing random input at the GUI. Jean Evaluate formulas loaded from a text file. [Bug 525107]. Fix INDEX related crash. [Bug 533247]. Fix LINEST and LOGREG crashes. [Bug 533263]. Handle empty array. [Bug 533516]. Fix SUMPRODUCT criticals. [Bug 533507]. Jon Kaare Receive clipboard from broken apps. [Bug 524756]. Nick Lamb Honour detachable-toolbar preference. [Bug 321867]. Jody Fix R1C1 parsing of refs followed by subtraction. [Bug 533943]. Morten Fix SUMIF problems. [Bug 523250]. Allow opening multiple files in open dialog. [Bug 524479]. Fix check for bogus xls files. [Bug 524926]. Fix inc/dec buttons for General. [Bug 510252]. Fix CONCATENATE's empty case. Improve performance of analysis tools for large ranges. Fix performance repeated VLOOKUP/HLOOKUP/MATCH with constant data range. [Bug 525875]. Fix date pasting problems to/from 1904 workbooks. [Bug 490419]. Fix problems editing times. [Bug 527392]. Implement IFERROR. [Bug 445591]. Implement F9 for evaluating a selected subexpression. Fix problem loading Quattro Pro files. [Bug 530183]. Fix right/center text for Quattro Pro files. Fix problem with sheet changes during range selection. [Bug 529309]. Fix hang. [Bug 533288]. Fix AREAS crash. [Bug 533370]. Fix translation of function description. [Bug 533193]. Fix R.QPOIS (and related functions) hang. [Bug 533515]. Fix critical spew. [Bug 533511]. Fix OPT_BS_DELTA assert. [Bug 533656]. Fix parser crashes. [Bug 533951] [Bug 534131]. Fix RANDEXPPOW hang. [Bug 533965]. Fix array evaluation problem. [Bug 533953]. Fix COUNTBLANK crash. [Bug 534204]. Fix TREND crash. [Bug 534587]. Downloads (~13,5 Mb)_ftp://ftp.gnome.org/...-1.8.3.tar.bz2
ЭЖД, 14.02.2010 - 15:58
gnumeric 1.10.0
Основные улучшения:
Сняты ограничения на размер таблиц, отныне границы расширены с 256 столбцов и 65536 строк до 4096 столбцов и 16 млн. строк;
Улучшены возможности по построению графиков: новые типы графиков для отображения поверхностей и вероятностных характеристик; оптимизация расположения маркеров на осях с датами и временем; поддержка кубической интерполяции сплайнами; учет погрешности для графиков в полярных и радиальных координатах;
Улучшение поддержки формата ODF (OpenDocument). Тем не менее разработчики предупреждают, что пока в стандарте OpenDocument окончательно не определены синтаксис и семантика, связанные с заданием формул в электронных таблицах, могут наблюдаться проблемы переносимости между разными реализациями данного формата;
Проведена работа по улучшению совместимости функций с MS Excel. Сообщается, что в Gnumeric теперь почти полностью реализован набор функций из категории OpenFormula;
Увеличена скорость вычислений. Особенно заметно возрастание скорости обработки страниц с большим числом обращений к HLOOKUP, RANK и PERCENTILE или подобным функциям;
Значительно уменьшено потребление памяти при обработке больших таблиц;
Улучшена работа инструментов для статистического анализа, например, добавлена поддержка оценок Каплана-Мейера, анализа главных компонент, тестов на нормальное распределение, критерия знаков, экспоненциального сглаживания сезонных изменений;
Улучшена поддержка интегрируемых в таблицы объектов, таких как линии, стрелки и виджеты;
Добавлена новая утилита ssgrep для поиска по содержимому в наборе файлов с электронными таблицами в стиле обработки обычных текстовых файлов утилитой grep.
* win32 fixes. * ODF export fixes. * XLS export fixes for cell comments and calls to XIRR. * Alexander Kahl & Sven Mantei o Some documentation updates. * Andreas o Fix build with --disable-solver. [Bug 612820]. o Fix column and row header display under Quartz. [Bug 600085]. o Fix preferences in gconf-less situations. [Bug 613523]. o Implement first letter capitalization. [Bug 613768]. o Extend regression tool to perform multiple simple regressions. [Bug 614031]. o Fix ZTEST description. [Bug 614746]. o Don't write unnecessary manifest entries in ODF export. o Various ODF export fixes. o Adjust regression tool to reflect the changes to TDIST. o Basic import and export of text boxes from ODF files. o Watch for the null date in OOXML import. [Bug 615777]. o Write the null date in OOXML export. * Jean o Print pattern backgrounds. [Bug 615365]. * Morten o Improve object sizing tooltip positioning a bit. o Fix filter critical. [Bug 611073]. o Make more menu entries available when an object is selected. o Improve partitioning of status area. o Fix goal seek problem affecting XIRR. [Bug 614147]. o Fix export xls of XIRR, FVSCHEDULE, and XNPV. [Bug 614257]. o Set win32 stack size to 64M. [Bug 571346]. o Patch gtk+ so GtkEntry widgets on win32 draw right. [Bug 603667]. o Fix xls export of cell comments. [Bug 615845]. o Fix error propagation problem. [Bug 615772]. o Partially clean up INDEX implementation. o Make regression functions return a result when goffice reports that the problem is near singular, but still good. Downloads (~17,1 Mb)_ftp://ftp.gnome.org/...1.10.2.tar.bz2
ЭЖД, 9.05.2010 - 8:58
gnumeric 1.10.3
Noteworthy news in this release:
* ODF fixes for dates and times. * Various filter fixes. * Sheet duplicate fixes.
* Andreas o Fix CHITEST for rectangular ranges. [Bug 615920]. o Fix printing and preview of graph only sheets. [Bug 616475]. o Make even active sheets invisible. [Bug 616474]. o Improve date and time import from and export to ODF. [Bug 617208]. o Protect against accidentally pushing data off the sheet. [Bug 98562]. o Make Advanced Filter (except filter-in-place) undoable. o Fix Data->Filter->ShowAll for Advanced Filter. [Bug 611079]. o Remove undesired interaction between Advanced Filters and Autofilters. o Make the par argument to ACCRINT optional. [Bug 323545]. o Improve keyboard navigation of the configurable text importer. [Bug 614939,Bug 614941]. * Jean o Implement graph only sheets. [Bug 158170]. o Fix chart title import when excel automagically uses the unique series label. [Bug 616262]. o Allow multiple and block selection for graph vector data. [Bug 494685,Bug 616068]. o Use the "combo-activate" signal where appropriate? [Bug 583175]. * Morten o Make sure an empty string is shown with a quote. o Fix problem loading cells with empty strings. [Bug 616139]. o Fix WEEKNUM problems. [Bug 616330]. o Fix hidden-sheet problem. [Bug 616549]. o Fix auto-expr problem. [Bug 575104]. o Fix xls-save problems with custom autofilters. o Fix auto-filter problem. [Bug 383400]. o Fix advanced-filter problem with multiple criteria. [Bug 164169]. o Fix problem parsing complex numbers. o Improve error handle for complex functions. o Improve IMPOWER. o Fix sheet duplicate bugs. [Part of Bug 617469]. o Clean-up handling of pango contexts. o Fix old graph problem. [Bug 142412]. Downloads (~17 Mb)_http://ftp.gnome.org/...1.10.3.tar.bz2
ЭЖД, 21.05.2010 - 17:51
gnumeric 1.10.4
* Include version number in HTML export. * Fixed autofill issues. [#618687] * Linear regression test suite. * Fix TABLE problem. [#618829] * Handle "Jan 2010" and "January 2010" better. * Fix date parsing problems for invalid years. * Fix sheet order dialog layout. [#619056] Downloads (~17,2 Mb)_ftp://ftp.gnome.org/...1.10.4.tar.bz2
* Tooltips assist with entering function argument. * The Statistics menu was moved to the top-level menubar. * The yyyy-mm-dd format will be present in all locales.
In addition there are numerous little fixes all over.
* Andreas o Add Wilcoxon Signed Rank Test tools for one and two populations. o Fix spin button handling in various tool dialogs. [Bug 619971]. o Redesign define-named-expressions dialog. [Bug 465840] . o Add paste-names dialog. [Bug 613325]. o Make changing the scope of a named expression undoable. o Add search tool to paste- and define-names dialogs. [Bug 465840]. o Check whether defined names are in use before deleting them. o Add option to the regression tool to allow for multiple Y. [Bug 620505]. o Ensure that names cannot be mistaken as cell references. [Bug 409997]. o Add search function to function selector. [Bug 495776]. o Add function help menu item. [Bug 156777]. o Improve ACCRINT and its description. [Bug 611436]. o Fix tests for homogeneity and independence for non-square tables. [Bug 621227]. o Show all ranges while editing. [Bug 166653]. o Provide a tool tip showing function syntax. [Bug 56172]. o Provide more navigation options. [Bug 15010]. o Check with user before hiding all rows or columns. [Bug 316976]. o Check with user before pasting too many copies. [Bug 530956]. * Jean o Do not ungrab a not grabbed item. [Bug 620369]. o Always update the right series entry. [Bug 620719]. o Fixed multi-line item edit selection. [Bug 621235]. * Morten o Make sure windows for help commands show up on right screen. o Fix dependency tabulation undo issue. o Fix critical when inserting graph using keys. o Automate win32 help generation. o Mark a sheet dirty when its tab colour is changed. [Bug 621191]. o Fix SERIESSUM issue. o Modernize code for LINEST, LOGEST, and LOGREG. [Bug 317426]. o GEOMDIST: avoid overflow in extreme cases. o SFTEST: improve extreme-case precision. o Fix RANDLEVY. o Fix hidden-sheet problem. [Bug 621463]. o Improve help text sanity checks. o Fix minor parsing problem. o Handle missing data in FORECAST properly. [Bug 621417]. o Handle missing data in GROWTH properly. [Bug 621418]. o Improve BINOM.DIST.RANGE. o Modernize STEYX. o Plug evaluation leak. o Fix memory handling issue for dependents. Downloads (~17,3 Mb)_ftp://ftp.gnome.org/...1.10.6.tar.bz2
ЭЖД, 6.07.2010 - 18:41
gnumeric 1.10.7
* Improve function syntax and formula guru tooltips. * Avoid superfluous redo items under validation failure. [Bug 622509]. * Fix validation for array and range entry. [Bug 622511]. * Autofit column widths in stf import. [Bug 427382]. * Ensure the table range is unlocked before allowing the data table to be configured. * Also store any markup if entering text in several cells at once. [Bug 622530]. * Read HTML files with nested tables. [Bug 594789]. * Fixed autofilter (and other) combo positions. [Bug 621817]. * Improve function syntax tooltips. * Fix excessive memory use problem with xlsx. [Bug 622365]. * Make BackSpace work as Delete on pane. [Bug 622599]. * Improve handling of MS-style HTML in clipboard. [Bug 617801]. Downloads (~17,3 Mb)_ftp://ftp.gnome.org/...1.10.7.tar.bz2
Users of of Gnumeric version 1.10.x are encouraged to update.
* Andreas o Significantly improve chart export and import to/from ODF. o Improve handling of corrupted ODF files. o Fix percentage style import from ODF. [Bug 627517]. o Fix INTERPOLATION documentation. [Bug 627461]. o Provide progress info in ODF export. o Improve warnings dialog in ODF import. o Fix button sensitivity in sort dialog. * Jean o Fix some interpolation and periodogram issues. o Fixed graph scalar data editor behavior. [Bug 628721]. * Morten o Plug sylk importer leak. o Plug xml importer leak. o Plug odf importer leak. [Bug 627759]. o Extend domain of IMPOWER. [Bug 627775]. o Allow use of glib's memory profiler. o Fix some confusion of char vs. xmlChar. o Fix elapsed-time entry. [Bug 628082]. o Fix problems with limits for date axes. o Improve function docs self test. o Fix errors in function docs. Downloads (~17,6 Mb)_ftp://ftp.gnome.org/....10.11.tar.bz2
Урсу, 26.11.2010 - 13:22
Gnumeric 1.10.12
» Нажмите, для открытия спойлера | Press to open the spoiler «
Noteworthy news in this release: •Use GtkBuilder instead of LibGlade. •Taking care of most dead kittens. (Also known as working around Gtk+ API changes.) •Andreas ◦Add argument to FOURIER to separate parts. ◦Extend TREND function to handle multiple regression. ◦Fix selection for sheet object lists and combos. ◦Preserve selection for sheet object lists when we change content. ◦Add option to sheet object lists and combos to enter values rather than index. ◦Fix manual pagebreak handling when printing. ◦Add menu items to remove and add manual page breaks. ◦Improve the sc import. ◦Fix button sensitivity in sort dialog. ◦Fix ODF export of files with large formatted sheets. ◦Fix extensions of supported ODF files. •Hans de Goede ◦Fix import of dib format images in XLS. •Jean ◦Fixed maximum for col/row number in sheet resize dialog. ◦Eliminate glade usage. ◦Fixed crash in print setup. ◦Fixed image bounds in zoomed sheets. •Morten ◦Fix crash related to broken xls. ◦Fix print area problem from broken xls. ◦Fix printing crash. ◦Partially fix problem with undefined names. ◦Fix analysis tools problems when "as values" is chosen. ◦Fix gtk+/X crash with large tooltips. ◦Take care of dead kittens. ◦Fix text object clipping issue. ◦Fix problem with disappearing window for empty file. ◦Fix ranges-in-expression criticals. •Sameer Morar ◦Add key combinations to move sheets. ◦Modify quit dialog to be able to discard multiple files without saving.
» Нажмите, для открытия спойлера | Press to open the spoiler «
•Andreas ◦Calculate residuals when using the regression tool. ◦Permit data entry by-passing autocorrection. ◦Work around OpenOffice date formatting bugs. ◦Export text formats to and import from ODF. ◦Fix ODF import of sheets with far forward references. ◦Add EEK support to EURO and EUROCONVERT. ◦Fix leaks in potentially failing analysis tools. ◦Make the row and column headers and selection match the theme better. ◦Fix locale specific sorting. ◦Ensure we have sub- and superscript icons. ◦Fix advanced filter. ◦Suppress function tooltips on text-formatted cells. ◦Fix documentation of ATAN2. •Jean ◦Only disable the formula bar when a chart sheet is selected. ◦Make sheet objects invisible outline from .xls files persistent. ◦Fixed arrows and line object position when zoomed. ◦Fixed series lines color export to .xls. ◦Fixed sheet objects position on zoomed sheets. ◦Override edition-canceled property for GnmExprEntry. •Morten ◦Fix array intersection problem with IF. ◦Make sure columns are wide enough for dates in csv import. ◦Plug a few leaks. ◦Fix number-match issue regarding fraction. ◦Fix problems with pivot reading from xls. ◦Allow version-agnostic template files.
» Нажмите, для открытия спойлера | Press to open the spoiler «
Noteworthy news in this release: •XLSX import has been greatly improved for graphs. •ODF import and export of validation has been improved. •Gnumeric can use GSettings if Goffice has been compiled for it. •Print-Preview sort-of works on Win32. •Andreas ◦ Fix width of translated lists in various dialogs. ◦ Allow function tooltips to be closed temporarily. ◦ Import and export list validation from and to ODF files. ◦ Minor histogram improvements. ◦ Fix import of LibreOffice created xlsx files using shared formulas. ◦ Fix crash on resaving LibreOffice created xlsx files with unauthored comments. ◦ Trigger configurable text importer on paste of tabs. ◦ Fix ctrl-end in presence of hidden rows. ◦ Fix import of dbf files with more than 65536 rows. ◦ Export workbook-scoped named expressions and ranges to ODF. ◦ Improve reading of named expressions from ODF files. ◦ Fix weighted and Spencer moving averages crashes. •Jean ◦ Fix cursor position inside a cell edited in a zoomed sheet. ◦ Add GSettings schemas. ◦ Import multiple runs chart titles from xlsx. ◦ Import axis crossing position from xlsx. •Morten ◦ Import wide sc files. ◦ Fix problem with single-cell names and 'r'-type arguments. ◦ Plug leaks. ◦ Fix potential crash on quick exit. ◦ Fix stf import problem diagnosed by Andreas. ◦ Restore toolbar positioning code. ◦ Fix solver crash. ◦ Fix xml reading of constraints. ◦ Fix lpsolve/glpk writing of affine part. ◦ Fix xlsx import crash. ◦ Import sheet visibility from xlsx. ◦ Import names from xlsx. ◦ Improve dbf codepage support. ◦ Improve date format consistency in document properies. ◦ Hopefully make print preview work on win32. ◦ Improve quit dialog's non-ascii handling. ◦ Make print-preview work on win32 by avoiding gtk+. ◦ Fix crash related to dynamic deps. ◦ Fix stf import crash. ◦ Allow templates for multi-sheet ssconvert. •Stanley Pinchak ◦ Improve "dif" output.
» Нажмите, для открытия спойлера | Press to open the spoiler «
This release contains improves ODS import and fixes a number of minor problems. •Andreas ◦ Fix shift-arrow movement for sheet objects. ◦ Expand the description of SSMEDIAN. ◦ Redesign autofilter Top10 dialog. ◦ Handle NUL characters in cvs import. ◦ Fix some Statistics tool formatting. ◦ Fix undo crash for column widths. ◦ Indicate vararg functions in function browser and docs. ◦ Fix handling of argument names in docs. ◦ Fix pdf docs. ◦ Handle MS Works formula import. ◦ Restore Gnumeric print range. ◦ Set default, save and restore print file name. ◦ Some ODF 1.2 export fixes including. ◦ Export external references to ODF. ◦ Fix ODF style handling on import. ◦ Import more validations from ODF. ◦ Export all validations to ODF. ◦ Fix printing of background colours. ◦ From ODF also import named expressions with illegal name. ◦ Handle [#REF!] and friends on ODF import. ◦ Handle some invalid expressions in ODF import. •Jean ◦ Fixed critical. •Morten ◦ Fix problems with localized function docs. ◦ Plug leaks. ◦ Fix minor problem reading old xls objects. ◦ Reduce memory usage when new glib is used. ◦ Eliminate col/row infos that are identical to the default. ◦ Fix problems reading some Lotus 1-2-3 files. ◦ Fix paste-special repeat. ◦ Fix ADDRESS problem. ◦ Fix xlsx write problem. •Urmas ◦ Initial support for Works files.
» Нажмите, для открытия спойлера | Press to open the spoiler «
Noteworthy news in this release: •A crash-on-start with some glib versions was fixed. •ODF and XLSX export improvements. •Andreas ◦ Store some print range information in gnumeric files. ◦ Hide Prefer CLIPBOARD preference under MS Windows. ◦ Extend the goto dialog. ◦ Extend the address box to handle both A1 and R1C1 style addresses. ◦ Change the default widget when rolling up or down the default widget. ◦ Import external references from ODF. ◦ Some documentation improvements. ◦ Read fraction formats correctly from ODF 1.2 files. ◦ Fix regression line export to ODF. ◦ Fix font and background colour import of LibreOffice generated xlsx files. ◦ In xlsx files, do not ignore gradient cell background fills completely. ◦ Export some cell formatting to xlsx files. ◦ Fix reading of diagonal borders from xlsx files. ◦ Fix writing to xlsx of file with comments. ◦ Add exporter for ECMA-376 2nd edition. ◦ Fix some font-name handling in ODF import. •Morten ◦ Fix leaks in SHEET. ◦ Fix leaks in SHEETS. ◦ Fix leak in name dialog. ◦ Switch to using goffice's complex math. ◦ Fix graph axis problem. ◦ Drop unneeded value formats.
» Нажмите, для открытия спойлера | Press to open the spoiler «
Andreas: * Fix some style import from ODF. * Import/Export print formatting from/to ODF. * Write and read some document properties to and from XLSX. * Fix xlsx schema violations. * Fix keyword handling in properties dialog. * Allow document properties to be edited and added. * Add an interface for conditional styles. * Fix ODF import of styles with inherited conditional styles. * Provide undo for cut between 2 gnumeric processes. * Fix bar and column chart import/export to ODF. * Speed up frequent calls to INTERPOLATION with the same abscissae/ordinates. * Export defined names to xlsx. * Implement printing of errors as blanks, dashes or NAs. * Fix printing of column headers and borders when formulae are shown. * Fix import of Excel 2003 xml files in non-C locale. Jean: * Fix selection background. Morten: * Fix --with-gnome compilation: * Fix parsing crash.