1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135 2136 2137 2138 2139 2140 2141 2142 2143 2144 2145 2146 2147 2148 2149 2150 2151 2152 2153 2154 2155 2156 2157 2158 2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266 2267 2268 2269 2270 2271 2272 2273 2274 2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286 2287 2288 2289 2290 2291 2292 2293 2294 2295 2296 2297 2298 2299 2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2326 2327 2328 2329 2330 2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2341 2342 2343 2344 2345 2346 2347 2348 2349 2350 2351 2352 2353 2354 2355 2356 2357 2358 2359 2360 2361 2362 2363 2364 2365 2366 2367 2368 2369 2370 2371 2372 2373 2374 2375 2376 2377 2378 2379 2380 2381 2382 2383 2384 2385 2386 2387 2388 2389 2390 2391 2392 2393 2394 2395 2396 2397 2398 2399 2400 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 2414 2415 2416 2417 2418 2419 2420 2421 2422 2423 2424 2425 2426 2427 2428 2429 2430 2431 2432 2433 2434 2435 2436 2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 2462 2463 2464 2465 2466 2467 2468 2469 2470 2471 2472 2473 2474 2475 2476 2477 2478 2479 2480 2481 2482 2483 2484 2485 2486 2487 2488 2489 2490 2491 2492 2493 2494 2495 2496 2497 2498 2499 2500 2501 2502 2503 2504 2505 2506 2507 2508 2509 2510 2511 2512 2513 2514 2515 2516 2517 2518 2519 2520 2521 2522 2523 2524 2525 2526 2527 2528 2529 2530 2531 2532 2533 2534 2535 2536 2537 2538 2539 2540 2541 2542 2543 2544 2545 2546 2547 2548 2549 2550 2551 2552 2553 2554 2555 2556 2557 2558 2559 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 2577 2578 2579 2580 2581 2582 2583 2584 2585 2586 2587 2588 2589 2590 2591 2592 2593 2594 2595 2596 2597 2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644 2645 2646 2647 2648 2649 2650 2651 2652 2653 2654 2655 2656 2657 2658 2659 2660 2661 2662 2663 2664 2665 2666 2667 2668 2669 2670 2671 2672 2673 2674 2675 2676 2677 2678 2679 2680 2681 2682 2683 2684 2685 2686 2687 2688 2689 2690 2691 2692 2693 2694 2695 2696 2697 2698 2699 2700 2701 2702 2703 2704 2705 2706 2707 2708 2709 2710 2711 2712 2713 2714 2715 2716 2717 2718 2719 2720 2721 2722 2723 2724 2725 2726 2727 2728 2729 2730 2731 2732 2733 2734 2735 2736 2737 2738 2739 2740 2741 2742 2743 2744 2745 2746 2747 2748 2749 2750 2751 2752 2753 2754 2755 2756 2757 2758 2759 2760 2761 2762 2763 2764 2765 2766 2767 2768 2769 2770 2771 2772 2773 2774 2775 2776 2777 2778 2779 2780 2781 2782 2783 2784 2785 2786 2787 2788 2789 2790 2791 2792 2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805 2806 2807 2808 2809 2810 2811 2812 2813 2814 2815 2816 2817 2818 2819 2820 2821 2822 2823 2824 2825 2826 2827 2828 2829 2830 2831 2832 2833 2834 2835 2836 2837 2838 2839 2840 2841 2842 2843 2844 2845 2846 2847 2848 2849 2850 2851 2852 2853 2854 2855 2856 2857 2858 2859 2860 2861 2862 2863 2864 2865 2866 2867 2868 2869 2870 2871 2872 2873 2874 2875 2876 2877 2878 2879 2880 2881 2882 2883 2884 2885 2886 2887 2888 2889 2890 2891 2892 2893 2894 2895 2896 2897 2898 2899 2900 2901 2902 2903 2904 2905 2906 2907 2908 2909 2910 2911 2912 2913 2914 2915 2916 2917 2918 2919 2920 2921 2922 2923 2924 2925 2926 2927 2928 2929 2930 2931 2932 2933 2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946 2947 2948 2949 2950 2951 2952 2953 2954 2955 2956 2957 2958 2959 2960 2961 2962 2963 2964 2965 2966 2967 2968 2969 2970 2971 2972 2973 2974 2975 2976 2977 2978 2979 2980 2981 2982 2983 2984 2985 2986 2987 2988 2989 2990 2991 2992 2993 2994 2995 2996 2997 2998 2999 3000 3001 3002 3003 3004 3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015 3016 3017 3018 3019 3020 3021 3022 3023 3024 3025 3026 3027 3028 3029 3030 3031 3032 3033 3034 3035 3036 3037 3038 3039 3040 3041 3042 3043 3044 3045 3046 3047 3048 3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 3079 3080 3081 3082 3083 3084 3085 3086 3087 3088 3089 3090 3091 3092 3093 3094 3095 3096 3097 3098 3099 3100 3101 3102 3103 3104 3105 3106 3107 3108 3109 3110 3111 3112 3113 3114 3115 3116 3117 3118 3119 3120 3121 3122 3123 3124 3125 3126 3127 3128 3129 3130 3131 3132 3133 3134 3135 3136 3137 3138 3139 3140 3141 3142 3143 3144 3145 3146 3147 3148 3149 3150 3151 3152 3153 3154 3155 3156 3157 3158 3159 3160 3161 3162 3163 3164 3165 3166 3167 3168 3169 3170 3171 3172 3173 3174 3175 3176 3177 3178 3179 3180 3181 3182 3183 3184 3185 3186 3187 3188 3189 3190 3191 3192 3193 3194 3195 3196 3197 3198 3199 3200 3201 3202 3203 3204 3205 3206 3207 3208 3209 3210 3211 3212 3213 3214 3215 3216 3217 3218 3219 3220 3221 3222 3223 3224 3225 3226 3227 3228 3229 3230 3231 3232 3233 3234 3235 3236 3237 3238 3239 3240 3241 3242 3243 3244 3245 3246 3247 3248 3249 3250 3251 3252 3253 3254 3255 3256 3257 3258 3259 3260 3261 3262 3263 3264 3265 3266 3267 3268 3269 3270 3271 3272 3273 3274 3275 3276 3277 3278 3279 3280 3281 3282 3283 3284 3285 3286 3287 3288 3289 3290 3291 3292 3293 3294 3295 3296 3297 3298 3299 3300 3301 3302 3303 3304 3305 3306 3307 3308 3309 3310 3311 3312 3313 3314 3315 3316 3317 3318 3319 3320 3321 3322 3323 3324 3325 3326 3327 3328 3329 3330 3331 3332 3333 3334 3335 3336 3337 3338 3339 3340 3341 3342 3343 3344 3345 3346 3347 3348 3349 3350 3351 3352 3353 3354 3355 3356 3357 3358 3359 3360 3361 3362 3363 3364 3365 3366 3367 3368 3369 3370 3371 3372 3373 3374 3375 3376 3377 3378 3379 3380 3381 3382 3383 3384 3385 3386 3387 3388 3389 3390 3391 3392 3393 3394 3395 3396 3397 3398 3399 3400 3401 3402 3403 3404 3405 3406 3407 3408 3409 3410 3411 3412 3413 3414 3415 3416 3417 3418 3419 3420 3421 3422 3423 3424 3425 3426 3427 3428 3429 3430 3431 3432 3433 3434 3435 3436 3437 3438 3439 3440 3441 3442 3443 3444 3445 3446 3447 3448 3449 3450 3451 3452 3453 3454 3455 3456 3457 3458 3459 3460 3461 3462 3463 3464 3465 3466 3467 3468 3469 3470 3471 3472 3473 3474 3475 3476 3477 3478 3479 3480 3481 3482 3483 3484 3485 3486 3487 3488 3489 3490 3491 3492 3493 3494 3495 3496 3497 3498 3499 3500 3501 3502 3503 3504 3505 3506 3507 3508 3509 3510 3511 3512 3513 3514 3515 3516 3517 3518 3519 3520 3521 3522 3523 3524 3525 3526 3527 3528 3529 3530 3531 3532 3533 3534 3535 3536 3537 3538 3539 3540 3541 3542 3543 3544 3545 3546 3547 3548 3549 3550 3551 3552 3553 3554 3555 3556 3557 3558 3559 3560 3561 3562 3563 3564 3565 3566 3567 3568 3569 3570 3571 3572 3573 3574 3575 3576 3577 3578 3579 3580 3581 3582 3583 3584 3585 3586 3587 3588 3589 3590 3591 3592 3593 3594 3595 3596 3597 3598 3599 3600 3601 3602 3603 3604 3605 3606 3607 3608 3609 3610 3611 3612 3613 3614 3615 3616 3617 3618 3619 3620 3621 3622 3623 3624 3625 3626 3627 3628 3629 3630 3631 3632 3633 3634 3635 3636 3637 3638 3639 3640 3641 3642 3643 3644 3645 3646 3647 3648 3649 3650 3651 3652 3653 3654 3655 3656 3657 3658 3659 3660 3661 3662 3663 3664 3665 3666 3667 3668 3669 3670 3671 3672 3673 3674 3675 3676 3677 3678 3679 3680 3681 3682 3683 3684 3685 3686 3687 3688 3689 3690 3691 3692 3693 3694 3695 3696 3697 3698 3699 3700 3701 3702 3703 3704 3705 3706 3707 3708 3709 3710 3711 3712 3713 3714 3715 3716 3717 3718 3719 3720 3721 3722 3723 3724 3725 3726 3727 3728 3729 3730 3731 3732 3733 3734 3735 3736 3737 3738 3739 3740 3741 3742 3743 3744 3745 3746 3747 3748 3749 3750 3751 3752 3753 3754 3755 3756 3757 3758 3759 3760 3761 3762 3763 3764 3765 3766 3767 3768 3769 3770 3771 3772 3773 3774 3775 3776 3777 3778 3779 3780 3781 3782 3783 3784 3785 3786 3787 3788 3789 3790 3791 3792 3793 3794 3795 3796 3797 3798 3799 3800 3801 3802 3803 3804 3805 3806 3807 3808 3809 3810 3811 3812 3813 3814 3815 3816 3817 3818 3819 3820 3821 3822 3823 3824 3825 3826 3827 3828 3829 3830 3831 3832 3833 3834 3835 3836 3837 3838 3839 3840 3841 3842 3843 3844 3845 3846 3847 3848 3849 3850 3851 3852 3853 3854 3855 3856 3857 3858 3859 3860 3861 3862 3863 3864 3865 3866 3867 3868 3869 3870 3871 3872 3873 3874 3875 3876 3877 3878 3879 3880 3881 3882 3883 3884 3885 3886 3887 3888 3889 3890 3891 3892 3893 3894 3895 3896 3897 3898 3899 3900 3901 3902 3903 3904 3905 3906 3907 3908 3909 3910 3911 3912 3913 3914 3915 3916 3917 3918 3919 3920 3921 3922 3923 3924 3925 3926 3927 3928 3929 3930 3931 3932 3933 3934 3935 3936 3937 3938 3939 3940 3941 3942 3943 3944 3945 3946 3947 3948 3949 3950 3951 3952 3953 3954 3955 3956 3957 3958 3959 3960 3961 3962 3963 3964 3965 3966 3967 3968 3969 3970 3971 3972 3973 3974 3975 3976 3977 3978 3979 3980 3981 3982 3983 3984 3985 3986 3987 3988 3989 3990 3991 3992 3993 3994 3995 3996 3997 3998 3999 4000 4001 4002 4003 4004 4005 4006 4007 4008 4009 4010 4011 4012 4013 4014 4015 4016 4017 4018 4019 4020 4021 4022 4023 4024 4025 4026 4027 4028 4029 4030 4031 4032 4033 4034 4035 4036 4037 4038 4039 4040 4041 4042 4043 4044 4045 4046 4047 4048 4049 4050 4051 4052 4053 4054 4055 4056 4057 4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 4081 4082 4083 4084 4085 4086 4087 4088 4089 4090 4091 4092 4093 4094 4095 4096 4097 4098 4099 4100 4101 4102 4103 4104 4105 4106 4107 4108 4109 4110 4111 4112 4113 4114 4115 4116 4117 4118 4119 4120 4121 4122 4123 4124 4125 4126 4127 4128 4129 4130 4131 4132 4133 4134 4135 4136 4137 4138 4139 4140 4141 4142 4143 4144 4145 4146 4147 4148 4149 4150 4151 4152 4153 4154 4155 4156 4157 4158 4159 4160 4161 4162 4163 4164 4165 4166 4167 4168 4169 4170 4171 4172 4173 4174 4175 4176 4177 4178 4179 4180 4181 4182 4183 4184 4185 4186 4187 4188 4189 4190 4191 4192 4193 4194 4195 4196 4197 4198 4199 4200 4201 4202 4203 4204 4205 4206 4207 4208 4209 4210 4211 4212 4213 4214 4215 4216 4217 4218 4219 4220 4221 4222 4223 4224 4225 4226 4227 4228 4229 4230 4231 4232 4233 4234 4235 4236 4237 4238 4239 4240 4241 4242 4243 4244 4245 4246 4247 4248 4249 4250 4251 4252 4253 4254 4255 4256 4257 4258 4259 4260 4261 4262 4263 4264 4265 4266 4267 4268 4269 4270 4271 4272 4273 4274 4275 4276 4277 4278 4279 4280 4281 4282 4283 4284 4285 4286 4287 4288 4289 4290 4291 4292 4293 4294 4295 4296 4297 4298 4299 4300 4301 4302 4303 4304 4305 4306 4307 4308 4309 4310 4311 4312 4313 4314 4315 4316 4317 4318 4319 4320 4321 4322 4323 4324 4325 4326 4327 4328 4329 4330 4331 4332 4333 4334 4335 4336 4337 4338 4339 4340 4341 4342 4343 4344 4345 4346 4347 4348 4349 4350 4351 4352 4353 4354 4355 4356 4357 4358 4359 4360 4361 4362 4363 4364 4365 4366 4367 4368 4369 4370 4371 4372 4373 4374 4375 4376 4377 4378 4379 4380 4381 4382 4383 4384 4385 4386 4387 4388 4389 4390 4391 4392 4393 4394 4395 4396 4397 4398 4399 4400 4401 4402 4403 4404 4405 4406 4407 4408 4409 4410 4411 4412 4413 4414 4415 4416 4417 4418 4419 4420 4421 4422 4423 4424 4425 4426 4427 4428 4429 4430 4431 4432 4433 4434 4435 4436 4437 4438 4439 4440 4441 4442 4443 4444 4445 4446 4447 4448 4449 4450 4451 4452 4453 4454 4455 4456 4457 4458 4459 4460 4461 4462 4463 4464 4465 4466 4467 4468 4469 4470 4471 4472 4473 4474 4475 4476 4477 4478 4479 4480 4481 4482 4483 4484 4485 4486 4487 4488 4489 4490 4491 4492 4493 4494 4495 4496 4497 4498 4499 4500 4501 4502 4503 4504 4505 4506 4507 4508 4509 4510 4511 4512 4513 4514 4515 4516 4517 4518 4519 4520 4521 4522 4523 4524 4525 4526 4527 4528 4529 4530 4531 4532 4533 4534 4535 4536 4537 4538 4539 4540 4541 4542 4543 4544 4545 4546 4547 4548 4549 4550 4551 4552 4553 4554 4555 4556 4557 4558 4559 4560 4561 4562 4563 4564 4565 4566 4567 4568 4569 4570 4571 4572 4573 4574 4575 4576 4577 4578 4579 4580 4581 4582 4583 4584 4585 4586 4587 4588 4589 4590 4591 4592 4593 4594 4595 4596 4597 4598 4599 4600 4601 4602 4603 4604 4605 4606 4607 4608 4609 4610 4611 4612 4613 4614 4615 4616 4617 4618 4619 4620 4621 4622 4623 4624 4625 4626 4627 4628 4629 4630 4631 4632 4633 4634 4635 4636 4637 4638 4639 4640 4641 4642 4643 4644 4645 4646 4647 4648 4649 4650 4651 4652 4653 4654 4655 4656 4657 4658 4659 4660 4661 4662 4663 4664 4665 4666 4667 4668 4669 4670 4671 4672 4673 4674 4675 4676 4677 4678 4679 4680 4681 4682 4683 4684 4685 4686 4687 4688 4689 4690 4691 4692 4693 4694 4695 4696 4697 4698 4699 4700 4701 4702 4703 4704 4705 4706 4707 4708 4709 4710 4711 4712 4713 4714 4715 4716 4717 4718 4719 4720 4721 4722 4723 4724 4725 4726 4727 4728 4729 4730 4731 4732 4733 4734 4735 4736 4737 4738 4739 4740 4741 4742 4743 4744 4745 4746 4747 4748 4749 4750 4751 4752 4753 4754 4755 4756 4757 4758 4759 4760 4761 4762 4763 4764 4765 4766 4767 4768 4769 4770 4771 4772 4773 4774 4775 4776 4777 4778 4779 4780 4781 4782 4783 4784 4785 4786 4787 4788 4789 4790 4791 4792 4793 4794 4795 4796 4797 4798 4799 4800 4801 4802 4803 4804 4805 4806 4807 4808 4809 4810 4811 4812 4813 4814 4815 4816 4817 4818 4819 4820 4821 4822 4823 4824 4825 4826 4827 4828 4829 4830 4831 4832 4833 4834 4835 4836 4837 4838 4839 4840 4841 4842 4843 4844 4845 4846 4847 4848 4849 4850 4851 4852 4853 4854 4855 4856 4857 4858 4859 4860 4861 4862 4863 4864 4865 4866 4867 4868 4869 4870 4871 4872 4873 4874 4875 4876 4877 4878 4879 4880 4881 4882 4883 4884 4885 4886 4887 4888 4889 4890 4891 4892 4893 4894 4895 4896 4897 4898 4899 4900 4901 4902 4903 4904 4905 4906 4907 4908 4909 4910 4911 4912 4913 4914 4915 4916 4917 4918 4919 4920 4921 4922 4923 4924 4925 4926 4927 4928 4929 4930 4931 4932 4933 4934 4935 4936 4937 4938 4939 4940 4941 4942 4943 4944 4945 4946 4947 4948 4949 4950 4951 4952 4953 4954 4955 4956 4957 4958 4959 4960 4961 4962 4963 4964 4965 4966 4967 4968 4969 4970 4971 4972 4973 4974 4975 4976 4977 4978 4979 4980 4981 4982 4983 4984 4985 4986 4987 4988 4989 4990 4991 4992 4993 4994 4995 4996 4997 4998 4999 5000 5001 5002 5003 5004 5005 5006 5007 5008 5009 5010 5011 5012 5013 5014 5015 5016 5017 5018 5019 5020 5021 5022 5023 5024 5025 5026 5027 5028 5029 5030 5031 5032 5033 5034 5035 5036 5037 5038 5039 5040 5041 5042 5043 5044 5045 5046 5047 5048 5049 5050 5051 5052 5053 5054 5055 5056 5057 5058 5059 5060 5061 5062 5063 5064 5065 5066 5067 5068 5069 5070 5071 5072 5073 5074 5075 5076 5077 5078 5079 5080 5081 5082 5083 5084 5085 5086 5087 5088 5089 5090 5091 5092 5093 5094 5095 5096 5097 5098 5099 5100 5101 5102 5103 5104 5105 5106 5107 5108 5109 5110 5111 5112 5113 5114 5115 5116 5117 5118 5119 5120 5121 5122 5123 5124 5125 5126 5127 5128 5129 5130 5131 5132 5133 5134 5135 5136 5137 5138 5139 5140 5141 5142 5143 5144 5145 5146 5147 5148 5149 5150 5151 5152 5153 5154 5155 5156 5157 5158 5159 5160 5161 5162 5163 5164 5165 5166 5167 5168 5169 5170 5171 5172 5173 5174 5175 5176 5177 5178 5179 5180 5181 5182 5183 5184 5185 5186 5187 5188 5189 5190 5191 5192 5193 5194 5195 5196 5197 5198 5199 5200 5201 5202 5203 5204 5205 5206 5207 5208 5209 5210 5211 5212 5213 5214 5215 5216 5217 5218 5219 5220 5221 5222 5223 5224 5225 5226 5227 5228 5229 5230 5231 5232 5233 5234 5235 5236 5237 5238 5239 5240 5241
|
Gnumeric 1.6.4
Jean Brefort:
* Don't use auto_shape or auto_dash when plot has no marker/line
and series have while importing from excel. [#319727]
Morten:
* Fix sheet-manage dialog crash. [#336165]
* Fix paste from other gnumerics. [#337215]
--------------------------------------------------------------------------
Gnumeric 1.6.3
Jean Brefort:
* Fix exporting of scaled axes. [#332012].
Jody:
* Backport duping sheet props when sheet is duped.
* Adding an autofilter dirties the sheet.
* Fix xls import of pie outlines.
Klokan Pridal:
* Implement xml saving/loading of "protected" attribute. [#334257]
* Implement xls saving/loading of "protected" attribute. [#330129]
Morten:
* Fix printing issue when sheet is zoomed. [#332932]
* Fix dbf import issue. [#332878]
* Fix stf text import speed regression. [#333407]
* Fix XIRR issues. [#333620] [#333631]
* Fix printing issue with wrapped, right-aligned text. [#334144]
* Fix position of cursor after F2. [#319311]
--------------------------------------------------------------------------
Gnumeric 1.6.2
Ivan, Y.C. Wong:
* Fix Gdk-WARNING when cutting or copying cells. [#314210]
* No more debug command prompt. Error/warning messages will
go to an existing command prompt (if any).
Jody:
* Disable the IRC link in the help menu.
* Use the cannonical web page in case of problems.
* Silence some warnings in the ODS importer.
Morten:
* Fix COUNTBLANK.
* Fix ATAN2(0,0).
* Make AND, OR, and XOR ignore strings as claimed.
* Fix TRIM for non-ASCII case with spaces at end.
* Improve Excel compatibility of BIN2DEC, BIN2HEX, and
BIN2OCT. [#323787]
* Fix crash on xml load. [#323888]
* Fix file corruption on saving scenarios. [#323927]
* Fix a pile of leaks in solver and scenario saving and loading.
* Fix leaks in solver dialog.
* Fix parser leak. [#301127]
* Fix solver dialog crash. [#324585]
* Fix FMR in SUBSTITUTE.
* Fix REPLACE and SEARCH for non-ASCII strings.
* Fix division-by-zero problems in FIXED, ROUND, ROUNDUP,
ROUNDDOWN, TRUNC.
* Fix accuracy of ROUND, ROUNDUP, ROUNDDOWN, TRUNC.
* Fix out-of-memory problem in REPT.
* Fix lots of little XL compatibility problems in string
functions.
* Fix error on Search-and-replace.
* Fix near-infinite loop in FACTDOUBLE.
* Fix text-to-columns crash probably affecting stf import too.
* Fix font preference crash. [#326830]
* Fix memory allocation problem for writing charts.
* Fix loading of boolean constants from ods files.
* Fix MID for out-of-bounds values.
* Fix constructed-range parsing for OO.
* Fix SECOND, MINUTE, HOUR compatibility problems.
* Fix DATE compatibility for bizarre input.
* Cleanup parameter handling in financial functions.
Jon KÃ¥re:
* Hand clipboard off to clipboard manager when exiting.
Nick Lamb:
* Fix CONVERT crash. [#323678]
--------------------------------------------------------------------------
Gnumeric 1.6.1
Allin Cottrell:
* Save configuration in non-gnome case. [#310354]
Jean Brefort:
* Use localized decimal separator. [#80139]
Jody:
* Unfreeze panes if the drag handles are pulled outwards.
* Adjust ctrl-~ vs ctrl-!
* Some R1C1 fixes
* More SpreadsheetML from MS Office XP.
* Some OpenDoc import extensions.
* Minor fixes for auto-fill
* Enable a chart importer in the experimental xml sax importer.
Lukasz Stelmach:
* Fix python binding for RangeRef::end.
Eduardo Lima:
Renato Araujo:
* Maemo/Hildon port to Nokia 770
Morten:
* Fix content probing of csv and tsv files. [#318419]
* Import formats from Lotus 1-2-3 files.
* Import column widths and row heights from Lotus 1-2-3 files.
* Handle Lotus 1-2-3 functions whose names differ from the ones
we use better.
* Read basic info from wk4 files.
* Fix issues with new function docs method.
* Fix OO import crash. [#320818]
* Fix Excel save crash. [#321009]
* Plug minor leak.
Philippe Lelong:
* Fix issue with PRICE (and probably related functions).
--------------------------------------------------------------------------
Gnumeric 1.6.0
Andreas:
* Preload selection in "Define Names" dialog. [#316406]
Jean Brefort:
* Fix crash when deleting plot with dynamic deps.
* Fix localization issues. [#318042][#318043].
Jody:
* Snap objects right in RTL mode. [#316026]
* Finish Data -> Table evaluation
* Avoid entering "" for every keystroke when using gtk-2.8
* Fix xls import/export of markers for radar plots.
* Fix rotated text with pango-1.10 [#316597]
* Update auto-expr after a recalc [#314867]
* Use Emmanuel's ideas to improve the frozen pane drag handles.
* Enable super/subscripts.
* SpreadsheetML importer.
Morten:
* Fix C99ism.
* Fix rare dependency crash.
* Warn if running with buggy pango_attr_list_splice.
* Improve stf import gui for multi-byte encoded text. [#316816]
* Fix xml-io's name parsing. [#317427]
* Fix .gnumeric saving of summary items. [#318254]
* Import some style info from Lotus 1-2-3 files.
* Fix infinite loop in pdhyper.
--------------------------------------------------------------------------
Gnumeric 1.5.90
Jody:
* quotes for pure strings in expressions for xml in/out [#313460]
* Fix F4 cycling of abs/rel in mixed mode range refs
* Check all format tuples for a match [#85950]
* Escape cancels object drag. [#314866]
* F2 while editing jumps focus to entry. [#314869]
* XLS in/out for Data -> Table
* 2d Data -> Table support
Morten:
* Fix tooltip problem. [#314865]
* Throw a minimum of effort at a Lotus importer for modern
versions. [#314875]
--------------------------------------------------------------------------
Gnumeric 1.5.5
(No code changes -- translations only)
--------------------------------------------------------------------------
Gnumeric 1.5.4
Clytie Siddall:
* Audit strings. [#312746] [#312986]
Jean Brefort:
* Fix crash on close related to graph plugins. [#313463]
Jody:
* Fix lost background colours. [#314207 and others]
* Add some drag handles for graphicly creating frozen panes.
* Fix sheetview confusion. [#314208]
Morten:
* Fix harmless, but ugly, error message on xls save.
* Fix solver crash. [#314025]
* Fix solver coefficients.
* Package lp_solve into a single file and sanitize its API.
Update to lp_solve 5.5 in the process.
* Fix dependency crash. [Part of #314207]
* Fix theming bug. [#307783]
* Fix crash related to changing colours of sheet tabs.
* Fix rich text editing problem. [#314209]
* Be consistent about dialog separators. [#314306]
* Fix print problem with page numbers. [#314520]
--------------------------------------------------------------------------
Gnumeric 1.5.3
Ivan, Y.C. Wong:
* Fix recent files list on win32. [#308302]
* Fix non-latin characters rendering of fonts sans, serif and monospace
on win32. [#161027]
Jean Brefort:
* Copy charts (to abiword).
J.H.M. Dassen (Ray):
* Bumped goffice build dependency.
Jody:
* Handle ROW/COLUMN with no argument in an array.
* Fix problems with row height resizing on win32. [#163414]
* XLS, SAX, & DOM in/out for conditional Formating.
* SAX in/out for input messages.
* SAX in for hyperlinks.
* Conditional Formating for backgrounds.
* Conditional Formating for borders.
* Store the current settings before previewing. [#301494]
* Fix F4-abs/rel state rotation after R1C1 breakage.
* Fix leak in xls chart import. [#157058]
* Fix object movement and snap to grid in RTL.
* XLS import of image fills. [#127756]
* XLS import of font for chart labels.
* Don't put extra quotes around exported series names. [#152317]
* Keep images hidden until they are sized. [#308301]
* Warnings when consolidating single columns. [#308431]
* Improve sync of cell editing and editline for autocomplete. [#308303]
Jon KÃ¥re:
* Improve sc/xspread import.
* Export page orientation to Excel.
* Fix top margin/header interaction bug in page setup. [#310055]
Morten:
* Make changes to toolbar visibility permanent.
* Fix stf export quoting problem. [#308109]
* Fix stf export format problem.
* Prevent sheets from being renamed to "".
* Fix IRR. [Debian #315625]
* Eliminate old sheet reorganize support code.
* Make ssconvert able to save to stdout ("fd://1").
* Fix repeat-setting-border crash. [#310924]
* Fix typo that managed to get its own bugzilla entry. [#312823]
* Fix problem with save. [#312930]
* Improve screen-vs-print line breaking situation. [#312912]
* Fix crash changing font. [#313257]
* Fix crash on finalizing sheet with objects in it.
* Fix sheet-remove crash related to dependencies. [#312794]
--------------------------------------------------------------------------
Gnumeric 1.5.2
Andreas:
* permit formula guru to add array functions
Ivan:
* (Win32) Fix opening files with non-ascii names when users "open"
them in explorer. [#304874]
* Enable libspeadsheet build
* (Win32) Fix the bug that d&d from explorer doesn't work in
gnumeric. [#304074]
Jody:
* Tweak the errors from LOGNORMDIST, CONFIDENCE, STANDARDIZE, and
NORMDIST to match MS Excel.
* After a command refocus controls for the current view. [#165700]
* Fix 'Begins with' vs 'Ends With' for autofilters.
* Autofilter string equality is stronger than containment [#172355]
* Buttons in sheet manager dialog should not strech vertically.
* Stub for MS Excel's ASC function, which is unncessary in gnumeric.
* Make range clipping more efficient. [#164950]
* Fix advanced filter for inputs that do not start at col A. [#165734]
* Fix xls import of names calling fwd declared names. [#166611]
* Fix string generation for arrays.
* Don't hide columns < 4pts wide on import. [#304558]
* Rich content from MS Excel clipboard [#305405]
* Fix warning while importing pre XL-95.
* Fix adjustment object handling [#167584].
* Be more careful what we assume is a header [#165061].
* Use sheet specific print settings when printing a workbook. [#163589]
* Fix small positioning glitch when creating widgets. [#304559]
* re-enable experimental sax importer after goffice split.
* Improve handling of some odd XL operators.
* Remove warning when nudging during object creation. [#164779]
* Delete while editing should not clear the cell. [#165172]
* R1C1 support.
Jon KÃ¥re:
* Don't output the xml declaration for xhtml. [#303827]
Michal Kaukic:
* Fix solver for affine objective functions. [#171025]
Morten:
* Fix SUMIF even more. [Debian #308346]
* Fix horizonal alignment of rotated numbers broken by fix to
#303292.
* Fix CRITICAL when undoing borders.
* Improve multiline rotated text. [#167544]
* Fix Excel load crash. [#303923]
* Speed up exit on large sheets with lots of names, such as the
one from #303923.
* Clean up dependencies somewhat.
* Simplify expressions used for defined names for single cells.
* Fix redo crash. [#305007]
* Fix auto-complete deactivation issues. [#305011]
* Fix recognition of accounting formats. [#305314]
* Fix unintentional format currency change. [#305313]
* Plug leaks.
* Work hard at not leaving passwords in memory, just in case.
* Add tooltips for ok_button, cancel_button, and func_button.
[#160344]
* Fix paste problem. [#305404]
* Fix brown bag text import problem. [Later reported as #305624]
* Improve R.QPOIS accuracy, efficiency, and termination.
* Improve R.QNORM's accuracy in the long double case.
* Improve R.QCAUCHY's accuracy.
* Add new R.QHYPER function.
* Fix xml SAX import issue for array formulae.
* Fix xml export of shared array formulae.
* Fix number matching problem. [#306254]
* Fix R.PBETA screwup for log case.
* Fix problem with hiding sheets.
* Fix sheet removal undo to also undo changes to names and
cells in other sheets.
* Save and load visibility sheet attribute.
* Fix 3D deps crash.
* Fix 3D dependencies spanning more than one sheet. (I.e., all.)
* Fix dynamic dependency crash on exit.
* Plug leaks of sheet views.
* Fix CRITICAL in the "manage sheets" dialog.
--------------------------------------------------------------------------
Gnumeric 1.5.1
Andreas:
* Make ROUNDDOWN and ROUNDUP MSExcel compatible including the
strange handling for negative numbers. [#162682]
This breaks backwards compatibility to earlier Gnumeric versions
for these functions.
* Fix text colour in selected item in sheet manage dialog. [#170462]
* Fix NORMDIST description. [#167467]
David J Craigon:
* Allow ssconvert to specify importer. [#160069]
Ivan Wong:
* Fix image filtering for Win32. [#164589]
* Implement the Win32 registry connection.
Jody:
* Major re-org for goffice split.
* Fix xls import for fit to page.
* Fix OFFSET for asymmetric ranges [#166764]
* Fix SUMIF for asymmetric ranges [#166769]
* Import sheet visibility from ms excel
* Split function docs into a distinct catalog
* Decrease memory usage in clipboard.
* Simplify tiling when pasting a copy. [#87477]
* Be more flexible pasting full cols/rows in single cells. [#87528]
* Add vertical alignment DISTRIBUTED
* Fix xls in/out of rotation
Jon KÃ¥re:
* Don't crash on csv file with invalid unicode [#167190]
* Import html hyperlinks as hyperlinks.
* Fix session management bug when gnumeric is minimized. [#166769]
* Paste images from clipboard.
* Copy images and graphs to clipboard.
* Receive and send images by drag and drop.
* Don't clear clipboard when losing primary selection. [#300468]
Kasal:
* Modified the way generated files are handled by Automake.
* Some configure hacks to support po-functions.
Morten:
* Work around Pango bug causing XL save crash. [#166532]
* Fix Save-As GUI problem causing CRITICALs.
* Fix typos that managed to get their own bugzilla entries.
[#167495] [#302306]
* Improve auto-detection of separators for text files. [#167449]
* Fix some #decimals problems with print page setup.
* Fix saving.
* Fix crash when using --quit. Fix leak too.
* Fix rare crash on exit.
* Use unicode minus (U2212) for numbers. [#168467]
* Improve format selection dialog for text import.
* Constification.
* Use FooCanvas for rotation part of cell format dialog.
* Get rid of the last direct GnomeCanvas use.
* Clean up long double configuration.
* Fix save-as for non-local files. [#170308]
* Drop gtk+-bug workaround. [#162952]
* Make sheets even more object-like.
* Fix parsing problem with names that start out with something
that can be parsed as a cell, e.g., "K3P". [#170465]
* Improve auto-fixup of 1.0.x era non-ASCII Gnumeric files.
* Fix minor GUI problem with the format page of text import.
* Create new plugin with R.[DPQ]dist functions using the
R Project's naming and calling conventions.
Note: this is deliberately not yet in po-whatever. There are
tons of autogenerated strings and things need to settle down
a bit first.
* Fix modality issue causing crashes. [#170958]
* Use a better format for auto expressions.
* Improve undo description for rich text style changes. [#171637]
* Don't destroy target file when loading a saver plugin fails.
[#168581].
* Make sure we update our window menu when we create a new view.
* When we reopen insert->image, start in the directory we were
last time. [#143188]
* Fix conversion problems with stf export. [#126513]
* Improve text import for strange encodings. [#167191]
* Rework stf export code and fix crash-on-exit-causing leaks.
* Do something sensible when exporting dates and times as text.
[#128936]
* Fix uncompressed saving of .xml and .gnumeric (when requested).
[#173030]
* Improve extreme-case evaluation of quantile functions that are
computed by root searching, such as =BETAINV(0.52,1e-3,1e6).
* Improve accuracy of R.QF (and thus FINV).
* Fix TRIMMEAN.
* Fix MODE.
* Allocate some clipboard data in pools.
* Fix potential save-as crash.
* Fix spurious criticals. [#301581]
* Change various sheet things to use an object properties.
* Plug leaks with moving sheets.
* Use object properties for much of the {sheet,workbook}-control-gui
to sheet linkage.
* Fix multihead problems with popups.
* Fix crash for sheet-remove on sheets with local dynamic
dependencies.
* Implement CELL("sheetname", ...).
* Fix CELL with explicit sheet in the reference.
* Fix sheet reordering by dragging.
* Fix various theme related bugs. [#302902] [#302880] [#302882]
* Fix undo crash in connection with cloning sheets.
--------------------------------------------------------------------------
Gnumeric 1.5.0
Emmanuel Pacaud:
* Snap to grid mode when moving sheet objects with shift.
Jean Brefort:
* add scatter plots with spline interpolation.
* Box-plots.
* Fix crash in contour plots (#166051).
* Automatic bounds work with negative values in XY chart (#164593).
* Scrollbar and slider max values are now constant (#165173).
* Avoid recalculation of scrollbar and slider values when not
necessary (#166085).
J.H.M. Dassen (Ray):
* Generate an error when no proper UTF-8 filename is produced when
saving [Debian #291265]
Jody:
* RTL support.
* Another step towards the libgoffice split
Kasal:
* Some configure.in cleanup.
Morten:
* When using the new printing code, don't bother to generate
gnome print fonts for the old code.
* Improve search strategy for auto-completion.
* Fix crash for insert/delete column/row. [#165873]
* Fix text import crash. [#165617]
* Fix SUBSTITUTE. [#165996]
* Fix general format's use of "e".
* Plug dependency leak. [#159581]
* Fix fake rounding functions for very large numbers. [#166188]
* Eliminate old printing code.
* Clean out workarounds for old libraries.
* Avoid GnomeFont in printing.
* Fix .dbf import of floating point values. [#166311]
* Plug xls save leak. [#166561]
--------------------------------------------------------------------------
Gnumeric 1.4.2
Caolan McNamara:
* Improve python config test for ia64 [#161547]
* Handle invalid DIMENSIONS records in xls [#161534]
* Fix installation path for the docs [#161404]
Emmanuel Pacaud:
* fix legend update on pie label change.
* don't disable theming for xy plot with line or marker only.
Ivan wong:
* Fix Win32 detection of default date format. [#161793]
Jean Brefort:
* Fix crash in contour plots. [#163626]
* When saving, always ask when file exist and come back to the dialog
when user does not want to overwrite.
J.H.M. Dassen (Ray):
* XLS import for paper sizes for which gnome-print doesn't have a
name.
Jody:
* Install the man pages
* Backport some framework for RTL
* image import from xl95 [#157997]
* Double click on an object brings up prop page
* Fix warnings when selecting a widget
* Hide value for slider objects
* Don't crash when attempting to copy an un-copiable object [#162888]
* Fix crash deleting a shared view [#163452]
* Fix sax export of outlines
* Fix TYPE to allow non-scalar
* Use element 0 of an array returned in a non-scalar context [#162923]
* Fix MATCH. If type is unspecified default to 1 not 0 [#163040]
* Unnecessary row resize undoing format that did not resize [#163407]
* Remove adjustment of copied areas on ins/del col/row [#163408]
* XLS export for booleans and errors in arrays
* Make SUMPRODUCT ignore booleans and strings to match XL, and SUM
* Fix sizes of Bitstream Vera for xls export [#163406]
* Mouse events while editing with other vertical alignments [#163198]
* Fix zoom for rich text with explicit size [#163223]
* Fix race condition when creating drawing objects [#162631]
* XLS export for empty cols with non-default formats [#163409]
* Redo var width content when resizing all cols at once [debian #288157]
* Handle zero sized charts [#163939]
* Fix comment indicator position when zoomed [debian #290388]
* Some support for filled styles [#163438]
* XLS import/export for print header/footer [#155719]
* Some tuning for missing arg export to xls [#163236]
Matthias Drochner:
* Use non bash specific substitution for autformat templates [#161782]
Morten:
* Improve accuracy of pgamma and thus pchisq, ppois, qgamma,
qchisq, qpois, and more for extreme arguments.
* Make it possible to change rotation of formats.
* Draw rotated text.
* Print rotated text.
* Fix torn off undo/redo crash.
* Fix cell format dialog initialization problems.
* Doc fixes for ODD and EVEN.
* Fix rich text crash. [#161621]
* Fix inserting new characters into a rich text string.
* Fix deleting more than one character at once from a rich text
string.
* Fix rich text problem when starting from empty. [#161723].
* Vastly improve sorting speed for large ranges with formulas.
[#161909]
* Fix Help->Contents accelerator. [#162865]
* Make general format use "E", not "e", as appropriate.
* Simplify SUM. [#131588]
* Fix INT(-1) problem. [#163019]
* Fix rich text re-edit problem. [#163415].
* Fix rich-text insertion problem. [#163413].
* Fixed font/size/zoom selection problem. [#163412].
* Implement OOo's BASE and DECIMAL.
* Fix some error cases of LINEST/LOGEST not to crash.
Uwe Steinmann:
* Extend paradox importer to support additional types.
--------------------------------------------------------------------------
Gnumeric 1.4.1
Jody:
* Saved charts were 1 pixel larger than the stated size [#157732]
* Fix path to chart icons for win32 [#160046]
* Fix sax export for Validation [Debian #283999]
* Fix unintended object resize when clicking on the lower right resize
handle of existing object
* Break long words when wrapping text
Morten:
* Add bugzilla version number to desktop file. [#159371]
* Fix arrows' direction used for printing and saving. [#159922]
Spudun:
* tidy up lp_solve code to build under OS/X
--------------------------------------------------------------------------
Gnumeric 1.4.0
Andreas:
* Fix crash on empty file in lotus file probe. [#158126]
* Enable auto-correct initial caps exception list. [#158209]
* Fix removable of items from auto-correct initial caps
exception list. [#158207]
* Protect ABcD style strings from auto-correction [#124858]
* Rename graph guru's okay button [#152514]
* When undoing the deletion of sheet objects also recreate the
original ordering of objects. [#151609]
Jody:
* Pull the file open filters from the openers
* Enable ssindex
* Undo for objects deleted by pasting a cut region [#159365]
Harald Ashburner:
* Update derivatives.gnumeric
J.H.M. Dassen (Ray):
* XLS import for paper sizes known to gnome-print.
Morten:
* Fix crash with weird history items. [#157682]
* Fix print preview leak. [#158566]
* Fix stf import crash. [#159009]
--------------------------------------------------------------------------
Gnumeric 1.3.93
Andreas:
* Keep the recently used function list uptodate. [#156732]
* Fix default font selection in preference dialog. [#157238]
* Fix preference dialog window fraction selection. [#157239]
* Make various preferences setting changes apply to the current
gnumeric instance
* Add screen page to preference dialog and fine-tune its general
layout
* Replace text entry boxes in preference dialog with
checkboxes and spinbuttons.
* Ensure that the preference dialog inthe non-gnome build
looks reasonable.
Jody:
* Fix perl and python tests in configure
* Fix creation of slow sheet objects when there are frozen panes
* Fix the solver and several related reports
* Make the solver dialog's constraint page more usable
Kasal:
* More cleanup in configure
Morten:
* Fix Clear-All crash. [#157376]
Jody:
* Fix display of slow objects when there are frozen panes
--------------------------------------------------------------------------
Gnumeric 1.3.92
Andreas:
* Fix text export dialog [#155437, #154231]
* Skip sheet selection in text export if there is only one
non-empty sheet. [#156604]
* Make print dialog less modal. [#132876]
* Make non-imported columns in configurable text import more
visible [#154139]
* Suppress warnings when filling with large series. [#153527]
* Improve format page in configurable text import [#154138,
#139385]
* Improve schema description [#153631]
* Warn if csv import is dropping columns [#139385]
* Change menu text in fixed cvs import [#154137]
* Add format descriptor to column headers in text import. [#154140]
* Fix various bugs [#156531, #156710]
* Add tooltips to buttons in text export sheet selection.
* Add top and bottom buttons to text export sheet selection.
* Disable buttons in text export sheet selection when not applicable.
* Fix LaTeX export of cells spanning to the left [#157047]
Arief Mulya Utama:
* Erlang (telecommunications engineering) plugin.
Emmanuel Pacaud:
* Add dash styles to chart objects.
* Enables non integer line width for chart objects.
* Fix clipping in svg export.
* Update labels automatically [#152585].
Hal Ashburner:
* Some function documentation cleanups.
Jody:
* Enable selecting and moving multiple drawing objects
* Swap X & Y axis content when importing xls bar plots. [#154734]
* Basic handling for XL 'Forms' Objects
* Fix handling of empty arguments in nested expressions
* Delay gnome-print init to decrease startup time
* Improve OOo import for styles
* Some support for newer Lotus-123 formats
* Translate autoformat categories and descriptions
* Re-enable the ui plugin service
* Rename x-quattro-pro to match freedesktop [#152159]
* Have text in item-edit does reflect zoom
* Show the right rich text format when clicking on edit line
* Finish rich text persistence for gnumeric xml and clipboard
Morten:
* Implement Edit->Select->Input. [#154735]
* Fix sample datasource's recalc. [#154857]
* Make File->Open start in the directory where the current file
was loaded. [#143188]
* Make it possible to unhide sheets. [#154710]
* Add HYPOT function. [#148322]
* Add PFACTOR function.
* Plug leaks.
* Revive logic to add missing parenthesis in parser.
* Fix evil timing issue in about dialog. [#155268]
* Fix window menu in case of "_" in names. [#155235]
* Add support for setting text and markup in buttons.
* Fix XL save crash. [#155371]
* Limit the width of search window. [#136421]
* Protect against crash in inter-process paste.
* Make URLs work from Nautilus. [#156456]
* Fix pgamma accuracy for extreme arguments.
* Improve accuracy of a few complex number functions.
* Make sure basenames of files can be seen during splash for
multiple files.
* Fix undo column crash. [#157045]
Yukihiro Nakai:
* Improve perl plugin.
* Fix various untranslated GUI elements.
* Bullet-proof plugin loader.
--------------------------------------------------------------------------
Gnumeric 1.3.91
Adrian:
* Write the chapter "Graphics: Plots, Images, Widgets and Drawings"
* Write the chapter "Working with Files"
* Update the chapter "Elements".
Andreas:
* Improve `Z-Test for 2 Means'
* Improve `T-Test (Paired Sample)'
Emmanuel Pacaud:
* Grid lines implementation
http://bugzilla.gnome.org/show_bug.cgi?id=152615
* New set of icons for charting engine
http://bugzilla.gnome.org/show_bug.cgi?id=152499
* Fix crash when adding y-erros to an empty plot
http://bugzilla.gnome.org/show_bug.cgi?id=152201
* Fix the performance degradation with too many axis ticks
http://bugzilla.gnome.org/show_bug.cgi?id=153146
* Fix crash when adding series to a radar plot
http://bugzilla.gnome.org/show_bug.cgi?id=153401
* Fix ring plots for center radius = 0
http://bugzilla.gnome.org/show_bug.cgi?id=153402
* Remove unused radar plot editor
Jody:
* XLS import formatted single points in charts (only pie for now)
* Improve theme support for single points in charts
* ctrl-7, ctrl-9, ctrl-(, ctrl-0, ctrl-)
* Rework column size calculation on xls import/export
http://bugzilla.gnome.org/show_bug.cgi?id=152248
* font strangeness when exporting to xls
http://bugzilla.gnome.org/show_bug.cgi?id=152512
* Improve cursor for object resize
http://bugzilla.gnome.org/show_bug.cgi?id=152244
* Fix loss of precision when resizing objects
http://bugzilla.gnome.org/show_bug.cgi?id=152636
* Fix rendering problem when zoomed
* Fix object positioning when zoomed
* Make the status area shorter with GtkStatusbar and fewer frames
* XLS import for arcs, polygons
* Improve XLS object styling
* More win32 build patches
http://bugzilla.gnome.org/show_bug.cgi?id=114099
* Clipboard support for objects
* Support for symmetric object resize, and duplication via ctrl-click
* Cleanout the SheetObject menu code to restore model gui split
* Fix File -> Sendto
* Add ctrl-period == insert current date&time
http://bugzilla.gnome.org/show_bug.cgi?id=114153
* Respect 0 as no-compression for xml export
Jon KÃ¥re:
* Fix the CORBA plugin.
* Add pangoft2 dependency.
http://bugzilla.gnome.org/show_bug.cgi?id=153701
Morten:
http://bugzilla.gnome.org/show_bug.cgi?id=152511
* Fix crash when adding a xy plot over a pie plot
* Work on using pango layouts for printing.
* Fix endless recursion. [#153544.]
* Plug leaks.
* Improve save-as dialog.
* Make sure *.csv and *.tsv are listed as spreadsheets in the
open dialog. [#143135.]
Uwe Steinmann:
* Validate the field names for paradox databases
Yaacov Zamir:
* Fix header/footer printing to use pango layouts.
* Fix graph printing to use pango layouts for text.
* Fix cell printing to use pango layouts.
Yukihiro Nakai:
* Enable editing email links
--------------------------------------------------------------------------
Gnumeric 1.3.90
Andreas:
* Improve `T-Test (Unpaired; Unequal or Equal Variances)' tool
* Fix TDIST for negative x and two tails
Emmanuel Pacaud:
http://bugzilla.gnome.org/show_bug.cgi?id=151529
* Fix markers in xy and line plots.
http://bugzilla.gnome.org/show_bug.cgi?id=151530
http://bugzilla.gnome.org/show_bug.cgi?id=151527
* Fix axis size allocation
http://bugzilla.gnome.org/show_bug.cgi?id=127203
* Align axis title with plot area
Jody:
* XLS import zooming for full page charts
* XLS export for full page charts
* XLS import of autoshapes with/without outlines and fills
* Use the right default palette for XL95
http://bugzilla.gnome.org/show_bug.cgi?id=151628
* Fix resizing sample plot in graph assistant type selector
http://bugzilla.gnome.org/show_bug.cgi?id=152059
* Add full screen toggle
* Auto recognize csv files < 80 characters long
Jon KÃ¥re:
* Export text objects to Excel
Kasal:
* Some typos in various docs
* Cleanup configure.in
Morten:
* Make new windows inherit toolbar visibility from parent.
* Map [Enter] to next-match in search centre.
* Fix F4 ($-cycling) when used in bogus places.
* Improve save-as when selected from a workbook that was not
loaded. (Still, save-as isn't great.)
--------------------------------------------------------------------------
Gnumeric 1.3.2
Andreas:
* Improve `F-Test' tool
http://bugzilla.gnome.org/show_bug.cgi?id=148724
http://bugzilla.gnome.org/show_bug.cgi?id=149247
* Some minor About box changes
http://bugzilla.gnome.org/show_bug.cgi?id=149945
* Fix database functions
Emmanuel Pacaud:
* Add logarithmic mapping and invert axis support.
* Zoom support for markers and error bars.
* Move sharp libart rendering tweaks to pixbuf renderer.
* Improve chart SVG export.
http://bugzilla.gnome.org/show_bug.cgi?id=132063
* Improve chart printing.
* Fix minor tick rendering
http://bugzilla.gnome.org/show_bug.cgi?id=144123
* Add labels to radar axis
http://bugzilla.gnome.org/show_bug.cgi?id=139397
* Don't clip markers to plot area
http://bugzilla.gnome.org/show_bug.cgi?id=142255
Harald Ashburner:
* Updates for the option pricers.
* Pricers for
: American/European options to exchange one asset for another
: Options on spreads between futures
: Payouts on the most favorable state during a period
Jody:
* Use SAX exporter by default.
* Enable 'popup-menu' binding support
* Add tooltip for object resizing
* Misc ancient array formula parsing and entry problems
* Jump to lp_solve 5.0
* Jump to GLPK 4.5
* Add a View -> Windows menu
* Work on tightening up XL compat of array functions
* Improve xls export for obscure xl eval modes
* Improve XL/OO compat for RANK()
* XLS import of full page charts
http://bugzilla.gnome.org/show_bug.cgi?id=150530
* sax export of comments without authors
http://bugzilla.gnome.org/show_bug.cgi?id=150792
* fix breakage in ins/del col/row caused by dsum changes
http://bugzilla.gnome.org/show_bug.cgi?id=150578
* Update the resize handles if the current object's size changes
http://bugzilla.gnome.org/show_bug.cgi?id=151144
* XL can not handle plots with no data, filter them
http://bugzilla.gnome.org/show_bug.cgi?id=151150
* center ticks for bar/col plots too
http://bugzilla.gnome.org/show_bug.cgi?id=143724
* Clip large dbf files to compile time file limits
Jon KÃ¥re:
* Export images to Excel
* Read images from native Gnumeric format
* Read and save images we cannot render without loss to and
from Excel and native Gnumeric format
* Add 'Save As' menu entry for image objects.
* Add format chooser to 'Save As' dialog for images and graphs.
* Resurrect the Psion Sheet importer.
* Fix file drag from nautilus -> gnumeric.
* Fix "Save changes?" bug.
http://bugzilla.gnome.org/show_bug.cgi?id=151152
Morten:
* Add Ctrl-5 for strike-through.
* Add Ctrl-Shift-D for double underline.
* Fix error return for GEOMEAN and HARMEAN.
* Fix IMCONJUGATE and IMABS for reals. [#148323, backported]
* New function INVSUMINV.
* Fix crash with format toolbar in menu mode.
* Fix crash on exit. [backported]
* Fix ssconvert output.
* Fix potential lexer crash.
http://bugzilla.gnome.org/show_bug.cgi?id=150821
* Fix graph guru crash in the absense of graph plugins.
Uwe Steinmann:
* Paradox DB import.
Yukihiro Nakai:
* Export links when saving as html.
* Add actions for www and bug reporting.
http://bugzilla.gnome.org/show_bug.cgi?id=151273
* Fix perl plugin
--------------------------------------------------------------------------
Gnumeric 1.3.1
Andreas:
http://bugzilla.gnome.org/show_bug.cgi?id=142219
* Handle borders in latex export correctly
http://bugzilla.gnome.org/show_bug.cgi?id=142836
* Save current sheet as csv (rather than first sheet)
http://bugzilla.gnome.org/show_bug.cgi?id=140820
* Fix default colour handling in manage sheet dialog
* Add interface to allow the visibility of sheets to be toggled
http://bugzilla.gnome.org/show_bug.cgi?id=142700
* Make sure zoom-box shows current zoom factor
* Improve `Descriptive Statistics' tool
* Improve `One-Factor ANOVA' tool
* Improve `Correlations' tool
* Improve `Covariances' tool
* Add CLIPBOARD over PRIMARY choice to preference dialog
Christian Neumair:
* Put delete actions from edit main menu into their own submenu.
* HIGify some dialogs when it comes to spacing.
Emmanuel Pacaud:
http://bugzilla.gnome.org/show_bug.cgi?id=142212
* In a line graph, don't use '0' if Y value is missing.
* fix a double draw of chart childs.
Jean Brefort:
* Add error bars in bars, columns, lines and areas plots.
Jody:
* Edit and display rich text in cells (no persistence yet)
* Make the last dependency above gtk optional to enable a win32 build
* Major re-org of xls string import to handle rich text
* Improve xls import of old < xl95 variants
* Fix xls chart import for value dimensions
* Fix autoformat dialog
* Fix db functions
* Pango uses _byte_ offsets for attributes. Fix everything
* Fix xls import of chart background and outline
* Support richtext during autofill
* A huge performance improvement when scrolling images
http://bugzilla.gnome.org/show_bug.cgi?id=136363
* Fix font handling in chart labels and titles
http://bugzilla.gnome.org/show_bug.cgi?id=140671
* Fix crash when undoing a cut from a different workbook
* Fix MS XL crash when there are too many strings
* MS XL import for chart gradient backgrounds
* Support series without legend entries, including xls import
* Started on an OOo exporter
http://bugzilla.gnome.org/show_bug.cgi?id=103054
* Tweak XL import and export for named expressions / addins
http://bugzilla.gnome.org/show_bug.cgi?id=142474
* Use first rather than last conditional value fmt as catch-all
* Implicit iteration for operators
* Make the unary operators XL compatible
* basic xls export for charts
* start work on OOo export
* Skip ticks/labels for discrete axes
* Drag files from nautilus -> gnumeric
http://bugzilla.gnome.org/show_bug.cgi?id=143577
* fix grid printing
* fix merged cell printing and diagonal borders
* Allow themed series with gradients
* Fix application prop dialog
* Support repeat for several commands
http://bugzilla.gnome.org/show_bug.cgi?id=147756
* Ancient autofill leak on constant string fills
Morten:
* Fix crash related to database functions (#138600). [backported]
* Fix [h]:mm precision (#138182). [backported]
* Make it possible to hide toolbars.
* Make it possible to hide the statusbar.
* A few multihead fixes.
* Upgrade to R's development version.
* Add cumulative distribution to HYPGEOMDIST.
* Fix pgeom for small x. (Fixes accuracy of GEOMDIST.)
* Fix pbinom for very large n. (Fixes accuracy of BINOMDIST.)
* Replace R's pbeta function. (Fixes accuracy of BETADIST,
BETAINV, FINV.)
* Replace R's pcauchy function . (Fixes accuracy of CAUCHY.)
* Replace R's pf function. (Fixes accuracy of FDIST, FTEST, F-test
tool, regression tool, ANOVA tools..)
* Replace R's phyper function. (Fixes accuracy and evaluation speed
of HYPGEOMDIST.)
* Fix accuracy of our versions of various long-double functions
that Solaris lacks. (Fixes, for example, ERF.)
* Improve accuracy of FISHER.
* Improve accuracy of EFFECT, NOMINAL, MIRR, IRR, XNPV, NPV, PMT,
RATE, PV, FV, IPMT, PPMT for small rates.
* Fix accuracy of ZTEST.
* Improve prevision of the bessel functions.
* Fix validation crash due to excel import. [backported]
* Fix custom validation export. [backported]
* New functions EXPM1 and LN1P.
* Fix image-inside-xls problem. [backported]
* Ignore more spaces in expression entry.
* Improve error handling in xbase plugin. [backported]
* Fix a weird IF semantics where the argument count including
empties matters.
* Fix parser problem with single empty arg after expression. [backported]
* Avoid keeping passwords in memory. (Will need gtk+ fix to be really
effective.)
* Switch to keeping URIs, not filenames, inside and in history.
* Implement copy-right (Ctrl-R) and copy-down (Ctrl-D).
(For those worrying over the pile of accuracy fixes above it should
be noted that prior versions of Gnumeric were already pretty good,
certainly far better than Excel. Most of the fixes above are for
extreme-case arguments where most other software packages will give
totally incorrect answers and/or take extremely long time to
produce any answer at all. We are slowly feeding some of these
fixes back to, say, the R Project.)
--------------------------------------------------------------------------
Gnumeric 1.3.0
Andreas:
* Make new strings translatable.
* Use new widget for output page of analysis tools.
* Add display indicating why the okay button is disabled
to selected analysis tools.
http://bugzilla.gnome.org/show_bug.cgi?id=131343
* Use the paper selected in the print dialog [backported]
http://bugzilla.gnome.org/show_bug.cgi?id=132347
* Fix argument names for RATE.
* Some HIGfication in the print setup dialog
* Make sure that when printing to a file we don't accidentally
overwrite an existing one.
* Don't close the print dialog if a user wants to look at a preview.
* Remove last use of gnome-config
* Fix GtkFileChooser crash (133069)
Emmanuel Pacaud:
* Work on single point formating for charts.
http://bugzilla.gnome.org/show_bug.cgi?id=135621
* Fix rounding issue for markers in xy plots and for axis ticks.
Jean Brefort:
* Add error bars in scatter and bubble plots.
Jody:
* Drop gnome-app-helper in favour of GtkAction
http://bugzilla.gnome.org/show_bug.cgi?id=128524
* COUNTRY record position is xls version specific [backported]
* Generate an SST record even without strings to placate french version
of MS Excel [backported]
* Fix memory error introduced in 1.2.3 when saving to xls [backported]
* Move to glib/gi18n.h and delete the gnumeric specific equivalent
http://bugzilla.gnome.org/show_bug.cgi?id=130579
* We only need selection info in the primary pane
http://bugzilla.gnome.org/show_bug.cgi?id=130577
* Export multiple selections to xls for frozen panes
http://bugzilla.gnome.org/show_bug.cgi?id=130582
* Rangesel doesn't bind the panes during cursor movements either
http://bugzilla.gnome.org/show_bug.cgi?id=130424
* Recalc new expressions even when manual recalc is set
http://bugzilla.gnome.org/show_bug.cgi?id=130700
* Better compatibility with MS Excel's handling of minus sign
http://bugzilla.gnome.org/show_bug.cgi?id=130835
* ISNUMBER() should return false for blank references
http://bugzilla.gnome.org/show_bug.cgi?id=130172
* Do not convert blanks to int(0) for string args
* Allow optional args to receive empty even for booleans
* Install the executable as gnumeric-<version>
http://bugzilla.gnome.org/show_bug.cgi?id=132017
* Support double underline when importing from applix
http://bugzilla.gnome.org/show_bug.cgi?id=127138
* Handle freezing when top or left is non 0
http://bugzilla.gnome.org/show_bug.cgi?id=132448
* Silly crash fix
http://bugzilla.gnome.org/show_bug.cgi?id=131933
* Handle mismatched locales with decimal pt == thousands sep
http://bugzilla.gnome.org/show_bug.cgi?id=132060
* update axis labels when a plot changes a source
http://bugzilla.gnome.org/show_bug.cgi?id=125886
* Data points define the axis, not the number of labels
http://bugzilla.gnome.org/show_bug.cgi?id=132390
* Fix crash when updating chart style combos
http://bugzilla.gnome.org/show_bug.cgi?id=132017
* Support double underline when importing from applix
* Fix our exported xls with macros with named sheets
* Use theme colours in plot type selector
* New about box
* Reorg the text exporter
http://bugzilla.gnome.org/show_bug.cgi?id=74205
* Display the blue range designator even in other panes
http://bugzilla.gnome.org/show_bug.cgi?id=126563
* Fix col/row sizes when copying a sheet with default zoom != 1
http://bugzilla.gnome.org/show_bug.cgi?id=135946
* Add support for mmmmm formats
* persist combos and lists (to gnumeric xml)
* Fix xls import of external 3d references
http://bugzilla.gnome.org/show_bug.cgi?id=136088
* Persist vary-style-by-color for pie plots
* Do not theme colours when using image fills
* Recalc autosized row heights when a font size changes
http://bugzilla.gnome.org/show_bug.cgi?id=135977
* Fix xls import of font and font colours for XL95/XL97 text/labels
* Fix xls import of label outlines for XL95 textboxes
* Make the text probe routine a bit more relaxed
* Fix xls import of cursor position for frozen panes
* Fix xls export of h/v only frozen panes
* Fix xls 97 export of named expressions without addins
http://bugzilla.gnome.org/show_bug.cgi?id=137818
* For immediate rerender, even for simple font changes.
* Support editing rich text in cells (incomplete)
http://bugzilla.gnome.org/show_bug.cgi?id=138533
* handle insufficient data in moving average tool
J.H.M. Dassen (Ray):
http://bugzilla.gnome.org/show_bug.cgi?id=135044
* Incorrect undo label for row autosize
John Gill:
* Tool tips for the sort dialog.
Michael Devine:
* Radar plots.
Morten:
* Clean out work-arounds for old GTK+.
* Turn on multi-head support.
* Switch to file chooser.
* Eliminate use of GnomeEntry.
* Fit scale-fit problem.
* Fix FLOOR and CEILING error case.
* Fix problem with typing in the "decimals" spin button in the
cell format dialog.
http://bugzilla.gnome.org/show_bug.cgi?id=135609
* Fix pretty-print (and thus saving) problem with ranges like
$B$1:$B1.
http://bugzilla.gnome.org/show_bug.cgi?id=136639
* Work around theme engine crash. [backported]
http://bugzilla.gnome.org/show_bug.cgi?id=135000
* Set accessibility role for save-before-exit dialog.
* Improve auto-scrolling when dragging the cursor outside the
window.
* Improve pgeom (and thus GEODIST) accuracy.
* Make filename history UTF-8 safe.
--------------------------------------------------------------------------
Gnumeric 1.2.3
Adrian Bunk:
* Portability fixes.
Andreas:
* http://bugzilla.gnome.org/show_bug.cgi?id=128166
Mark workbook as dirty on sheet deletion/addition
* Bug fixes: 128915, 128611
* Minor changes to the sort dialog
* http://bugzilla.gnome.org/show_bug.cgi?id=128936
Allow text export to use the rendered strings rather than the
stored values
* http://bugzilla.gnome.org/show_bug.cgi?id=129444
Fix printing of non-word-wrapped cells with hard line breaks
* http://bugzilla.gnome.org/show_bug.cgi?id=129049
Make sure dialogs are visible on session manager communications
Jody:
http://bugzilla.gnome.org/show_bug.cgi?id=128565
* Overzealous renaming.
http://bugzilla.gnome.org/show_bug.cgi?id=128169
* Use the right font when editing.
http://bugzilla.gnome.org/show_bug.cgi?id=127625
* kludge around mystery inconsistent autfilters in xls
* Patch a leak in the pattern selector
* Fix a potential crash when changing labels on axis
http://bugzilla.gnome.org/show_bug.cgi?id=127734
* Modernize the sylk importer
http://bugzilla.gnome.org/show_bug.cgi?id=129445
* Fix xls import of plot styles that override defaults
* Fix xml import of ManualRecalc flag
http://bugzilla.gnome.org/show_bug.cgi?id=128837
* Horizontal, and Zoom scroll wheel support
* User selectable format for axis labels
* Tune 'General' format width calculation
* Improve quoting of accounting formats
* Auto format selection for axis value labels
http://bugzilla.gnome.org/show_bug.cgi?id=129833
* Tweak the mime types we claim to handle
John Gill:
* Add a field menu and keyboard shortcuts to the sort dialog
Jon KÃ¥re:
* Fix encoding of author field in summary.
http://bugzilla.gnome.org/show_bug.cgi?id=129702
Jukka:
* GLPK upgrade to version 4.2
Morten:
* Handle fractional seconds correctly for UNIX2DATE.
* Fix display of -0:30 again.
* PCRE upgrade to 4.5.
--------------------------------------------------------------------------
Gnumeric 1.2.2
Andreas:
* Updated some docs.
* Also use fallback-fonts for the page decorations when printing.
http://bugzilla.gnome.org/show_bug.cgi?id=122034
* Add default header/footer font selector to preference dialog.
http://bugzilla.gnome.org/show_bug.cgi?id=125361
* Fix printing from Page Setup dialog.
http://bugzilla.gnome.org/show_bug.cgi?id=125422
* Upon inserting of cells try to guess whether to move cells down
or to the right.
* Upon deleting of cells try to guess whether to move cells up
or to the left.
* Use the number of copies info read from an XL file
http://bugzilla.gnome.org/show_bug.cgi?id=127415
* Fix expr entry interaction with merged cells
http://bugzilla.gnome.org/show_bug.cgi?id=127932
* Fix and adjust sort dialog
Emmanuel Pacaud:
* Add clipping for plot areas.
http://bugzilla.gnome.org/show_bug.cgi?id=125419
Jean Brefort:
* Support text in SVG exporter
Jody:
* More renaming
* Don't install schemas when building an rpm
* Support non-assisted CSV export for ssconvert
* Simple optimization for 30% faster number matching
* Center line plot points on index
* Fix crash when importing truncated xls files
* Update axis labels when bac/col/line/area labels are set/cleared
* Complain loudly when people run without installing the schema
* Improve padding of chart elements
http://bugzilla.gnome.org/show_bug.cgi?id=124244
* Fix xls import of collapsed cols/rows at level 0
http://bugzilla.gnome.org/show_bug.cgi?id=123325
* Fix in 1.2.1 was spewing pointless warnings
http://bugzilla.gnome.org/show_bug.cgi?id=124975
* Handle undoing a paste from a deleted external sheet
http://bugzilla.gnome.org/show_bug.cgi?id=77303
* Don't scroll the other panes unless we absolutely have to.
http://bugzilla.gnome.org/show_bug.cgi?id=125269
* Try to save a current edit before an action
http://bugzilla.gnome.org/show_bug.cgi?id=125045
* Fix tick spacing with manual axis bounds
* Tune clipboard to avoid ultra deep recalc stacks
http://bugzilla.gnome.org/show_bug.cgi?id=125230
* Add epsilon _before_ we scale formats with elapsed hours
http://bugzilla.gnome.org/show_bug.cgi?id=125421
* Tune insert col/row above frozen panes
http://bugzilla.gnome.org/show_bug.cgi?id=124930
* Be more lenient about invalid xml, but put errors in gui
http://bugzilla.gnome.org/show_bug.cgi?id=125604
* Fix OO import in some locales.
http://bugzilla.gnome.org/show_bug.cgi?id=125611
* Fix OO import of integer attributes.
* XLS probe support for misnamed streams
http://bugzilla.gnome.org/show_bug.cgi?id=125577
* Don't forget to recalc after deleting col/row
http://bugzilla.gnome.org/show_bug.cgi?id=125619
* Init the high/low button for axis prefs
http://bugzilla.gnome.org/show_bug.cgi?id=125496
* Update all displayed auto values for axis bounds
http://bugzilla.gnome.org/show_bug.cgi?id=125886
* Have an inverse pull to 0 in case the eps pulls to far
* Actually install the man pages
http://bugzilla.gnome.org/show_bug.cgi?id=126389
* Formatting marks a sheet as dirty
* Support auto-shape/outline/fill for chart markers
* Add UI to restore auto colors for charts
* Update UI when a chart style element changes externally
* Support line plots with no markers by default
* Support xy plots with no markers, no lines, by default
http://bugzilla.gnome.org/show_bug.cgi?id=125886
* x axis label vertical alignment
http://bugzilla.gnome.org/show_bug.cgi?id=125986
* Extend 'is_auto' support.
* Fix round tripping of imported xls macros.
http://bugzilla.gnome.org/show_bug.cgi?id=125416
* Enabled the object re-ordering buttons
http://bugzilla.gnome.org/show_bug.cgi?id=126775
* Be smarter when all the values are the same
http://bugzilla.gnome.org/show_bug.cgi?id=126908
* Set label and text box outline/background to XL defaults
http://bugzilla.gnome.org/show_bug.cgi?id=68794
* default to rows when rows == cols
* Support minor ticks
* Tune chart axis ticks to avoid anti-aliasing blur
* Export 'Manual Recalc' flag to xls
http://bugzilla.gnome.org/show_bug.cgi?id=126907
* Recalc new expressions even when manually recalculating
http://bugzilla.gnome.org/show_bug.cgi?id=116090
* Support DISPLAY-less function dumping
http://bugzilla.gnome.org/show_bug.cgi?id=127095
* Problem introduced in 1.2.1 that breaks xml import in other locales
http://bugzilla.gnome.org/show_bug.cgi?id=127145
* Update status display even on delayed motion.
http://bugzilla.gnome.org/show_bug.cgi?id=127205
* Fix rangeseltion of multiple items in other locales
http://bugzilla.gnome.org/show_bug.cgi?id=127199
* Update the format status UI after a successful read
http://bugzilla.gnome.org/show_bug.cgi?id=127211
* Errors default to horzontal alignment == center
http://bugzilla.gnome.org/show_bug.cgi?id=127204
* Don't add a grid if there wasn't one in the xls
http://bugzilla.gnome.org/show_bug.cgi?id=127238
* Fix memory handling for autoformats
http://bugzilla.gnome.org/show_bug.cgi?id=127262
* Fix minor cosmetic issue with the boarder between frozen panes
http://bugzilla.gnome.org/show_bug.cgi?id=64297
* Cosmetic tweak to keep cursor visible on dark backgrounds
* Fixed xls export of col/row groups
* Support workbook local functions
* Fix xls import of unicode in expressions
* Fix gutter resize when adding groups
Morten:
* Fix crash with STF import and gazillions of columns.
* Drastically reduce memory usage during STF import with lots of
small fields.
* Speed up STF import by not creating field structures for lines
not shown in the preview anyway.
* Fix display of cumulative hours for -1h < time < 0h.
* Fix crash with loss of precision in linear regression of
dimension 2. http://bugzilla.gnome.org/show_bug.cgi?id=125436
* Fix wiiiiiiiide stf dialog with glibc and composite locales.
* Fix stf import of empty files.
http://bugzilla.gnome.org/show_bug.cgi?id=125573
* Fix column selection in stf import.
http://bugzilla.gnome.org/show_bug.cgi?id=125417
* Plug a few leaks.
* Optionally generate pseudo-random (as opposed to random) numbers.
Rodrigo:
* Bump requirement to libgda/libgnomedb 1.0.1
J.H.M. Dassen (Ray):
* Include several missing images in the documentation. (Debian #218580)
--------------------------------------------------------------------------
Gnumeric 1.2.1
Adrian Custer:
* More documentation.
J.H.M. Dassen (Ray):
* Update debian control files.
Jean Brefort:
* Gradient support for svg chart renderer.
* Marker support for svg chart renderer.
Jody:
* Fix infinite loop on empty axis under solaris.
* Fix leak loading charts.
* Don't pad zero sized children.
* Correctly show unqualified sheet local names in array exprs
* Add 'Albany' to excel plugin's font table
* Chart printing now respects scaling
* Fix crash with partial bar/col/line/area/xy series
* Patch warning when quiting with an keyed dialog
* Fix xls export of operand classes
* Minor packaging bug in corba plugin
* Accept blank lines in text to cols.
* Provide a cleaner work around for
http://bugzilla.gnome.org/show_bug.cgi?id=121543
* Re-enable the probe functions in plugins
* Big performance improvement when autosizing row heights.
* Fix recalc for ISBLANK
* Fix deleting a graph object with expr entries.
* Tweak the axis auto range selector to keep things symmetric
* Enable basic style import for chart elements
* Drop in a basic implementatin of ssconvert
* Be anal about exporting unicode chars > 0xfeff to xls
* Fix import typo that broke xls import of local hyperlinks
* Draw marker and lines for legend elements that support them
* Memory error when adding a series to a bar/col/line/area plot
* Tune Planperfect importer.
* Cleanup header inclusion to make things work even with gtk HEAD
* Have ssconvert generate export file name from exporter if needed
http://bugzilla.gnome.org/show_bug.cgi?id=123270
* update the goto box in a few more places
http://bugzilla.gnome.org/show_bug.cgi?id=122085
* Have 'MATCH/LOOKUP/HLOOKUP/VLOOKUP' handle blank criteria XLishly.
http://bugzilla.gnome.org/show_bug.cgi?id=123325 [countif]
* COUNTIF counts empties
* xls import for manual axis bounds and step
* xls import for chart and axis labels
John Gill:
* Heuristics to improve finger feel of autofilter range selection
Jukka:
* Fixed solver's model maximization button.
* Fixed crash with Cancel/OK buttons in Scenarios->View.
* Usability fix for solver's constraint change button.
* Bug fix: don't create a scenario if solver didn't find a solution.
* Layout improvements for Risk Simulation dialog.
* Layout improvements for Scenarios->View dialog.
Nick Lamb:
* Improve import of ancient xls.
Morten:
* Invalid memory read in marker combo.
* Speed up number match by caching localized TRUE and FALSE.
* Speed up number match of batches of partial dates (like "Jun-21").
* Speed up number match by speeding up regexp matching for regexps
with lots of ()s.
* Improve number rendering when showing more decimals than backed
by precision.
* Fix covariance tool.
* Plug leaks.
* Fix space trimming for stf import.
* Clean up FREQUENCY.
* Clean up DOLLAR.
* Plug html import leaks.
Thomas Miesbauer:
* Redo screenshots
--------------------------------------------------------------------------
Gnumeric 1.2.0
Andreas:
* Fix Advanced Filter dialog
* Fix Scaled Printing
* Fix `Fit to' printing
* Fix histogram dialog (122155)
* Fix header/footer dialog preview
* Make &[FILE] Excel compatible
* Add &[PATH]
* Fix &[TIME:hh:mm:ss] and &[DATE:yyyy] style subformatting
* Fix manage-sheet-dialog bug
* Add console warning message for font substitution
* Fix format chooser list (Thanks Etsushi Kato)
Christian Neumair:
* Start adding ATK relations to the dialogs.
Jody:
* Make chart axis prettier.
* Fix crash freeing undo info for a deleted sheet with comments
* Fix File -> SendTo
* Be more verbose when we can not find the default fonts
* Add a grid object for charts
* Install the plugin schema in the sample spec file
* Require libgsf-1.8.2 to fix backward compatibility with libole2 and
Gnumeric-1.0.x
* Support index/implicit axis for scatter plots
* Fix horizontal data sets
* Auto pad between chart child with compass layouts
* XLS import for axis marker/line formats, and axis ticks
* XLS import for ring plots, and fix some pie parameter scales
* XLS import legend position
* Honour and edit manual min/max values for axis
Jon KÃ¥re:
* Ensure that scrollbars always show up in font combo when
needed (http://bugzilla.gnome.org/show_bug.cgi?id=121877).
--------------------------------------------------------------------------
Gnumeric 1.1.90
Andreas:
* Make graph configuration undoable.
* Add image preview to insert image dialog.
Ben Liblit:
* Improve spec file.
Emmanuel Pacaud:
* Initial support for line markers.
* Add a combo for marker selection.
* Make colour combo less ugly for themes.
Jean Brefort:
* Basic SVG renderer for charting engine.
* Implement brightness style gradients
Jon KÃ¥re:
* Add 'Save As' entry for graph objects. Support png for now.
* Persist Styles for charting engine.
* Begin to enable support for is_auto
Jody:
* Get the lifecycle of copied GogGraphs running smoothly.
* Fix printing of graphs.
* Fix expr relocation with cross sheet references.
* Paper over the most common technique for blowing the stack.
* Disable clipboard operations during object editing.
* Enable labels in charts
* Fix Pie/Ring style editor
* Begin font support for chart attributes
* Fix gradient's in pie/ring slices
* http://bugzilla.gnome.org/show_bug.cgi?id=121045
* Adjust the semantics of empty cells passed to optional arguments
* Pretty up the legend a bit
* Be more expansive about what constitutes General.
* Tweak the paramters of what XL thinks the size of 'Courier' is.
* Add basic Scatter plot.
http://bugzilla.gnome.org/show_bug.cgi?id=121560
* Fix dynamic depend leak.
* Improve performance when deleting multiple sheets at once.
* Only export a charting style field if it is interesting.
* Hook up the Jean's SVG exporter to Jon KÃ¥re's Chart Save As
* Bound clipping for xy/bar/col/line/area
* Finish axis life cycle support
Morten:
* Support End+Home key sequence.
* Tidy up gradients for charting engine.
* Handle -hh:mm.
--------------------------------------------------------------------------
Gnumeric 1.1.20
Adrian Custer:
* Get the new documentation building.
Andreas:
* Fix analysis tools dialogs again
* Fix text export of non-ascii charaters
* Fix latex export of non-ascii charaters
* Allow latex export to use utf-8 if required
* Avoid duplicate regression tool error messages
* Added new function SSMEDIAN (social science median, or
median for grouped data)
* Added a locale selector to text import.
* Fix 115542 (cs_CZ bug), 115503 (autofill of dates)
and many others
* Fix landscape printing
* Save header/footer defaults
* Update consolidate dialog
* Permit to ignore any columns during text import
* Add column header menu to format page of text import
* Fix locale specific parsing on paste
* Add undo to inserting of sheets via the tab context menu
* Clarify insert/append sheet commands
* Change layout of preference dialog
* Make fill->series undoable, redesign its dialog
* Make Data->Text_to_Columns undoable
* Add help button to autoformat and plugin manager
* Make Tools->Solver undoable
* Make Tools->GoalSeek undoable
* Make Duplicate Sheet undoable
* Reduce the occasions when the undo chain is being flushed
* Make Edit->Sheet->Remove partly undoable
* Add standard output selector to consolidate tool
* Make Edit->Fill->Tabulate Dependency undoable
* Add simple session management
Ben Liblit:
* Another attempt at configure time path generation.
Emmanuel Pacaud:
* New format selector for stf.
* Ring plots
* Line and Area plots
Gustavo Carneiro:
* Use gnome-common detection for libtool version
Jean Brefort:
* Support image files in chart areas (background, bar/col or pie)
* Initial pass at supporting patterns in chart areas.
Jody:
* Fix the generated source files.
* Cleanout the internals of PreviewGrid.
* Cleanup AutoFormat dialog.
* Printing support for charting engine.
* Fix printing of images.
* Coup de grace to gal, importing the 75 lines of e_xml we used
* Keynav for autoformat dialog
* Fix jumping to internal links in a different sheet
* Add XML persistence for charts
* Misc Charting improvements & fixes
* Add YEARFRAC to put us at 100% coverage
* Fix some format generation bugs
* Rationalize and document the SheetObject::print interface
* Cleanup line/arrow/filled sheet object config dialogs
* An initial implementation of bonobo-less File -> Send To
* Recalc fix for functions that did not use the collect utils
* Work on Charting Engine.
* Function doc patches to go with the new doc framework.
* Function doc spelling and grammar.
* Fix glitch in xls hyperlink import.
* Undocumented flag on cell comments in xls
* Import cell comments from >= xl97 too.
* Object text labels from >= xl97.
* Fix export of strings > 8224 characters in xl97.
* Fix style export in the presence of validation and hyperlinks.
* Spinner/Scrollbar import for xl 95 & 97.
* Fix 118723
* Work on image persistence in xml
* Revamp chart styles and patterns
* Improve behavior of autofilters with ins/del col/row
* Make mmult smarter about what constitutes a 3d ref
* Improve import of gnumeric-1.0.x era graphs
* Fix crash on xls export for autfilters with no conditions.
* Some basic work on axis
John Gill:
* More XLish heuristics for autofill range selection.
* Support End keys, and XL style 'transition' keys
Jon KÃ¥re:
* Improve color combo.
* Fix keynav for various kinds of combos.
* Make splash screen display code clairvoyant.
* Import OpenOffice.org 1.1 from clipboard.
* Export XHTML to clipboard.
* Fix clipboard export of non-Latin 1 content as text.
* Fall back to string when import from clipboard as
table/spreadsheet fails.
* Import incomplete html fragments, as produced by
* e.g. Mozilla, from clipboard.
* Fix bugs in Python loader.
* Polish Python console.
* Add workbook_new() to Python bindings.
Joseph Pingenot:
* Spin buttons
* Slider objects
Morten:
* Hopefully fix NAN issues on Alphas.
* Plug autoformat leak.
* Import all gal widgets we use.
* Fix lots of UTF-8/filename problems.
* Make pixmap combos multihead safe.
* Make color combos multihead safe. Fix latent memory corruption
problem.
* Fix incorrect range highlighting in non-expressions like "10:23".
* Improve character set handling of pastes from other apps.
* Improve stf import's handing of strange line terminators.
* Fix nasty locale-changing problem (localeconv data changing
underneath us).
* Make locale handling UTF-8 safe.
* Unify our three regexp quoting functions into just one (correct)
function.
* Make pretty-printing clarify trees like "-2^2" into "(-2)^2".
* Fix cell entry display for strings with initial quote.
* Fix YIELDDISC, ODDFPRICE, ODDLPRICE, and ODDLYIELD.
* Implement ODDFYIELD.
* Reduce flicker in format selector widgets.
* Fix another O(n^2) problem in stf import.
* Fix YEARFRAC.
* Speed up loading.
* Use pool allocation for cell style tiles.
* Fix rounding and error problems with GCD and LCM.
* Make +/- buttons work for changing precision of fractional formats.
* Fix +/- buttons for cells with value formats.
* Fix +/- buttons for currency formats.
* Make the 1000-separator button do something more useful.
* Improve the support for fractional formats.
* Improve auto-format for date differences.
* Clean up style format code.
* Fix parsing of fractional constants.
* Improve progress display a bit.
* Show default image for types we don't recognize.
* Improve fixed-width stf.
* Fix reading 1.0 xml files lacking encoding.
* Handle file save errors that happen after the initial open.
* Major speed-up for certain dynamic dependencies.
--------------------------------------------------------------------------
Gnumeric 1.1.19
Auto*-wrestling only.
--------------------------------------------------------------------------
Gnumeric 1.1.18
Andreas:
* Some more UTF-8 cleaning in the stf parsers.
* Improve the encoding selector by only showing
supported encodings
* Some small improvements to the Text Import dialog
Ben Liblit:
* Move the various compile time paths into a generated header.
Emmanuel Pacaud:
* HIG compliant quit dialog.
Jean Brefort:
* Initial version of gradient editor for chart style page.
Jody:
* More work on graphs.
* Set alwaysCalc flag when xls exporting dynamic dependencies.
* Fix HIG-ification of validation page in fmt dialog
* Add some mnemonics to the new and improved file open dialog.
* Finish conversion of default font to Sans 10
* Fix http://bugs.debian.org/193276
* Fix rangesel on other sheet in with of sheet local names
* Fix recalc on undo of cut-paste of interior of range
* Sheet data -> charts begins working.
* Some minor tweaking for xls escher import to handle gradients
* Clean up edit item, and support spanning autocompletion
* Fixes for sheet object dependencies.
* Fixes for chart series generation.
* Basic Pie & Bar/Col plots.
* Initial xls import for new plots (no formatting).
* Have HTML exporters handle utf8.
* Extend layout engine in GogChart.
* Nice redraw speedup for images and charts.
* Fix undo bug for moving merged regions (yummy).
* Support Move with cells flag for sheet object.
* Text in charts.
* Fix lots of bugs in the run up to a beta.
* Fix undo of defining an existing named expression placeholder.
* Simplify the recently used file stuff in preparation for egg.
* Fix months old stupidity in my lobotomization of gconf wrapper.
* Remove deprecation from canvas items.
* Finished first pass at an xml SAX based exporter, still rough around
the edges.
Morten:
* New function COLUMNNUMBER.
* Fix ABRs in imported pcre code.
* Leak fix for gnumeric xml saving.
* Leak fix for character encoding selection.
* Fix stf import crash for empty files.
* Improve generation of binomial and negative-binomial random
numbers.
* Fix stf dialog problem with WM close.
* Make stf export quoting UTF-8 safe.
* Make stf export cell separation UTF-8 safe.
* Improve generation of NaN, -Inf, and +Inf.
* Fix 112330.
* Handle character set aliases, more or less.
* Improve remote-DISPLAY start-up time by getting rid of calls to
deprecated gtk_style_get_font function.
* Start getting rid of use of deprecated features.
* Multihead support.
* Fix crash for analysis tools on initial failure.
* Speed up stf import.
* Rewrote stf importer to be GtkTreeView/GPtrArray based instead
of GnomeCanvas/GList.
* Fix a ton of stf bugs.
--------------------------------------------------------------------------
Gnumeric 1.1.17
Andreas:
* Add character encoding menus to the file selector
* Handle specified encoding for csv/tsv files
* Handle specified encoding for configurable text import
* Fix csv parsing (#80806), finally
* Fix #100529, #78355, #99649
Ben Liblit:
* Support for automake 1.6.x
* Modernize the rpm .spec file
Emmanuel Pacaud:
* Add encoding selector to stf export
Jody:
* Improve handling of files with content type != extension
* A few small bugs in XL97 export.
* Simplify defining new services
* Work on graphs
* Fix xbase importer
* Add motion compression for high speed scrolling
* Fix elapsed hour format
* Make the edit item smarter at the right edge
* Handle saving too many merged cells for 1 xls record
* Fix internal hashing bug with styles containing auto colors
* Improve update semantics of ExprEntry in preparation for graphs
* Make sheet_get_extent span when needed.
* Fix old bug exposed by alex's fix to mapping in foocanvas.
Jukka:
* Added shuffling tool.
* Added `Edit'->`Fill'->`Series...' filling tool like in XL.
* Added scenario tools.
Martin Hoffmann:
* Fix autocompletion in the face of multi-byte characters.
Morten:
* Make RenderedValue use a PangoLayout for storing the contents
of a cell. (Operation Snappiness, Part 3.)
* Make mstyle cache pango attributes. (Operation Snappiness,
Part 4.)
* Make sure our pango contexts have language set. (Operation
Snappiness, Part 5.)
* Shave off a few cycles here and there.
* Improve progress display when loading.
* Eliminate rendered_text from struct RenderedValue. (Operation
Snappiness, Part 6.)
* Fix a few stf irritants.
* Security fix for sample data source plugin.
* Security fix for oleo plugin.
* Security fix for sc plugin.
* Fix gnome print configuration.
* Fix latex exporter crash.
* Restore auto-format functionality. (Automatically supply a format
to a new cell based on the formula entered.)
* Work around extremely slow cases in in, e.g., BETAINV.
* Improve speed of generation of many types of random numbers.
* Switch regexp routine to pcre.
--------------------------------------------------------------------------
Gnumeric 1.1.16
Jody:
* Support Mac Office style 1904 date convention.
* Fix recalc problem with MMULT.
* Bump libgsf req to 1.7.0
* Fixed XL export (apologies to all)
* Improve support for negative elapsed time formats.
* Minor lotus-123 import issue.
* Added Skeleton for importing MS Excel XML.
* Changed default toolbar layout to icon only.
Jon KÃ¥re:
* Finish UI for managing hyperlinks of various sorts.
* Skip sheet chooser page in text export when there is only
one sheet (Fixes 84791).
* Paste OpenCalc from clipboard.
* Paste html tables from clipboard.
Morten:
* Fix MDETERM.
* Lower number of matrix LU-decomposition routines from three to
one.
* Add function renaming support for file formats that use function
names different from our.
* Partial buffer overrun audit.
* Improve fraction format.
* Move pango attribute calculation into rendered value. (Operation
Snappiness, Part 1 of many.)
* Eliminate StyleColor member of RenderedValue. (Operation
Snappiness, Part 2.)
Nicolas Peninguy :
http://bugzilla.gnome.org/show_bug.cgi?id=102236
* Decrease depenence on glibc regexp extensions.
Murray Cumming :
* Port to the gnome-print-2.2 api.
Theppitak Karoonboonyanan:
* Improve XIM support.
Wayne Schuller <k_wayne@linuxpower.org>
* Initial implementation of fit-to-pages printing.
--------------------------------------------------------------------------
Gnumeric 1.1.15
Jody:
* Fix some XL95 object issues.
* Find a few undocumented corners of XL's format.
* Fix XL97 export of validation and filters for simple sheets.
* Misc screwups with autofilters
* Ins/Del Col/Row now does mostly the right thing with filters.
* Ins/Del Col/Row now handles frozen panes.
* Lower right of merge extends sheet bounds.
* Fix parser's handling of unknown function.
* Remove unnecessary new/free of dates.
Jon KÃ¥re:
* Open DB connections read only.
* Improve password dialog.
* Show password dialog also for files given on command line.
Morten:
* Fix crash when no undo information is wanted.
* Clean up NULL/FALSE confusion all over.
* Remove GNM_EXPR_PARSE_CREATE_PLACEHOLDER_FOR_UNKNOWN_FUNC.
* New functions GNUMERIC_UNICHAR, GNUMERIC_UNICODE
Nicolas Peninguy:
* Move the generation of the standard formats into StyleFormat
--------------------------------------------------------------------------
Gnumeric 1.1.13/1.1.14
Andreas:
* Fix some stf bugs
Evert Verhellen:
* New icons for +/- precision
* Make bonobo/non-bonobo a whole lot more consistent.
Fernando Herrera:
* Improve desktop file to support bug-buddy.
Jody:
* Make the behavor of save and save-as more comfortable.
* Fix parsing 3d references
* More work on exporting names to xls
* Support the global outline buttons
* Optional outline markers at the begining rather than end
* Make the label object more useful
* Fix XL import for h/v only freeze with non origin start
* More attributes for excel95 objects
* Support pruning 3d references on sheet deletion.
* Clean up some workbook view life cycle issues
* Implement Auto-filters
* Begin support for pivot tables
* Full support for SUBTOTAL magic
* Fix sneaky bug between sheetobjects and frozen panes
* Fix removal of placeholder names
* XLS export for validation and Input Messages
* Improve handling of validation in format dialog
* XL97 export for named expressions
* XLS export for autofilters
* Fix print dialog's entry of repeated cols/rows
Jon KÃ¥re:
* Separate GUI for showing progress and messages before first
spreadsheet window is displayed.
* Fix 98661.
* Port the remaining plugins to gsf output.
* Use desktop font for row and column titles, fixing 98666.
* Fix bugs in the bonobo control version of Gnumeric.
* Install the bonobo control in libexec.
* No longer pretend to support the Bonoobo/PersistFile interface.
* Fix key navigation and scrollbar scrolling in auto-filter combos.
* Clean up editable-label some more.
* Improve image loading. With libwmf-0.2.8 and gtk+-2.1.2 or
later, Gnumeric can now display Windows Metafile images -
common in Excel documents.
* Fix bug in hyperlink import from Excel.
Morten:
* Improve qpro importer.
* Fix 98664 for bonobo.
* Fix sylk importer to do ISO-8859-1 -> UTF-8 conversion.
* Fix dif importer to do ISO-8859-1 -> UTF-8 conversion.
* Attempt a fix for psiconv importer to do ISO-8859-1 -> UTF-8
conversion.
* Make autofill UTF-8 safe and fix a bug with negative numbers.
* Fix FV problem with rate==0.
* Fix DAYS360 incompatibility (with XL).
* Improve parsing infra-structure.
* Fix unnecessary singularities for IPMT, PPMT, and NPER.
* Make print-info use GnomePrintUnit instead of our own half-baked
stuff.
* Overhaul error value layers.
* Fix loading and saving of error values in xml format.
* Fix parser crash. (101658.)
* Fix oleo parser.
--------------------------------------------------------------------------
Gnumeric 1.1.12
Andreas:
* Hide hidden cells in groff/troff export.
* Fix 78356.
* Watch for file extensions not matching filetype when saving.
Evert Verhellen
* Buff up the function guru icon a touch
J.H.M. Dassen (Ray):
* Updates to the build system.
* Some code janitor work.
Jody:
* POISSON is defined for x == 0
* Start work on rotated text
* Enable Excel97 basic export
* Have the importer designate the exporter directly
* Switch to foocanvas for performance
* Just in time rendering for clipboard
* Add 'require_explicit_enable' for plugins
* Support writing dual stream xls files
* http://bugzilla.gnome.org/show_bug.cgi?id=97672
* Rewrite string export for xls (95 & 97)
* Fix inline array export for xls (95 &97)
* Store the xls codepage when importing for use when exporting
* Merge style extent and most common style calcs for xls export
* Improve xls export of custom palettes
* Fix xls export for zoom > 100
* Implement intersheet and 3d references for xls97 export
* Fix xls import of 3d external references
Jon KÃ¥re:
* Merged File/Open and File/Import
* Remove code which supported the File/Open File/Import
distinction.
Morten:
* Spelling fixes all over.
* Add the ability to search expression results.
* Add parameter checks to RAYLEIGH, RAYLEIGHTAIL, EXPPOWDIST,
LAPLACE, PARETO, LOGISTIC functions.
* Plug leaks in function selector dialog.
* Improve memory usage in search centre slighly.
* Fix precision of GAMMALN.
* Fix precision of FACT and extend it to negative non-integers.
* Add BETA and BETALN functions.
* Make CHAR function UTF-8 safe.
* Make CODE function mostly UTF-8 safe.
* Fix SUBSTITUTE (for non-blank fourth argument) and make it UTF-8
safe.
* Make SEARCH function UTF-8 safe.
* Fix sc importer to do ISO-8859-1 -> UTF-8 conversion.
* Fix oleo importer to do ISO-8859-1 -> UTF-8 conversion.
* Make search UTF-8 safe.
Nick Lamb:
* Initial support for pre-ole xls files.
Olaf Till:
* Two new logarithmic regression functions, one of them
with nonlinear fitting of a horizontal curve shift.
--------------------------------------------------------------------------
Gnumeric 1.1.11
Adrian:
* Some LaTeX exporter fixes
Andreas:
* Fix 97246
Dustin Mudryk:
* Hide hidden cells in LaTeX export
Jody:
* Store current sheet in both spots for xls export
* Fix multiple name invalidation within 1 expr on sheet delete
* Work around incorrect XL95 export in OpenCalc
* Enable full simplistic just in time render & span.
* Fix names.
* Tidy and brighten up the name dialog.
* Add more format and alignment support to cell edit.
* Re-enable feedback for autocomplete.
* Fix xls names with unicode ids.
* Fix xls 2000 import for external names.
* Fix edit line behaviour.
Morten:
* Clean up SERIESSUM.
* Fix crash during xml save.
* Fix elusive dependency leak.
* Implemented a new and better qgamma function. (Anything dealing
with the chisq distribution will also benefit from this.)
* More utf8 work.
* Fix ABW in html exporter.
--------------------------------------------------------------------------
Gnumeric 1.1.10
Andreas:
* Add XHTML exporter
* Fix minor bug in the sort dialog
* Fix leak
* Fix 95333
Chris Benedict:
* Do not allow all sheets in a workbook to be deleted.
* Implement a simple configuration dialog for the frame
sheet object
dorami@bu.iij4u.or.jp:
* Add InputMethod support for better international key support
Hal Ashburner:
* Rework derivative valuation routines
Jody:
* Decrease GAL dependence.
* More work on opencalc importer.
* Start clean up of error handling routines.
* Some UTF-8 cleanup.
* Support placeholders for unknown names (incl XL import)
* Restore core <-> split for analysis and random num tools
* Undo support for defining and updating named expressions
* Port Name guru from GtkList -> TreeView
* Fix applix expr parsing now that we consider spaces
* Correct sheet order and naming for Applix import.
* Support named ranges for Applix import.
* XML string quoting in expressions for opencalc importer.
* Fix handling of 3d references in context of sheet reorder
* Some optimization of case insensitive sheet name lookup
* Make named expression ids case sensitive.
* Port cell format dialog to TreeView.
* Handle encryption from 'Tools -> Protection -> Workbook Protected'
* Remove implicit conversion of unquoted strings that are not names
* Import named expressions, arrays and merged regions from OpenCalc
* More cleanup after the big parser rework
* Esoteric XL number formats #,,##0,,
* Simplify some dialog code
* Support Dynamic Depends (eg INDIRECT)
* Add AREAS so that we can finally finish off the lookup functions
* Clean up the function registration api
* Make format parsing utf8 clean
* Fix mishandling of empty strings in xls data validation importer
* Support Horizontal and Vertical only frozen panes
* Some optimizations for filling large regions
* Start work on 'Text from Columns' and 'External Data -> Text File'
* Simple manual recalculation, it won't catch everything yet.
* Some UI for recalc and iteration changes
* Tweak precedence of new operators and clean up the grammar
* Fix parse error reporting
* Fix xls name import for external and builtin names (95 & 2k)
* Fix undo for object movement
* Improve XL95 export and prep framework for 2k
* Add quicky placeholder for importing 'input msg' from xls
Morten:
* Port search center from gal's e-table to gtk's treeview.
* Fix parse-utils to handle large number of columns.
* Reduce the number of source places that need to be changed in
order to get more than 256 columns and/or 65536 rows.
* Fix --geometry, I hope.
* Start handling invalid (== non-utf8) file names.
* Fix minor leak in excel loader.
* Improve precision of GEOMEAN and PRODUCT.
* Fix MOD for non-integer (or just huge) args.
* Fix division by zero in MROUND.
* Fix a bunch of gnum_float issues.
* Fix leaks in COLUMN and ROW.
* Sort names in name dialog.
* SC importer work.
* Various UTF-8 work.
* Fix double replacement problem for search-and-replace with a
regular expression matching an empty string.
* Fix GAMMAINV.
* Improve precision for qgamma (and thus GAMMAINV).
* Fix a few cases of col/row confusion.
Nicolas Peninguy:
* Use regexps to classify currency and accounting formats
Tim A. Garner:
* Hide hidden data in html export
* In the LaTeX exporter optionally export math in italics
Jon KÃ¥re:
* Remove old Python plugin
--------------------------------------------------------------------------
Gnumeric 1.1.9
Andreas:
* Fix #92367, #94300
Christian Neumair:
* Made most dialogs HIG compliant.
Jody:
* Start enabling the graph guru.
* Begin to re-enable xls document metadata.
* Fix translations in the bonobo build.
* Enable translation of function category names.
* Parser support for both syntaxes of 3d reference.
* Parser support for row or col only references (A:C or 1:5)
* Fix some drawing issues related to the pango conversion.
* Remove usage of some deprecated functions.
* Fix handling of files named .xml.gz
* Improvements for ExprEntry
* Make autocorrect unicode-safe, and port dialog to treeview.
* Fix 'address' so that we pass all of the tests.
* Fix handling of optional scalar arguments.
* Convert many of the IS* info functions to nodal:scalar.
* Support implicit iteration for array expressions.
* Fix sheet object ref counting error that Morten found.
* Fix crash when destroying unshared view.
* Start fleshing out support signals to give scripting more power
* Move the CORBA support code into a plugin and make more functional.
* Add some UI for managing hyperlinks of various sorts (unfinished)
* Make the location status box smarter about named ranges
* Begin support for intersection
* Start parsing range sets
* Simple OpenOffice importer (expr and content but no formating)
* Support multi-region version of INDEX
* Handle obscure corner case in xbase importer
Michael Meeks:
* Spruce up the CORBA code to use some bonobo utils.
Morten:
* Leak plugging.
* Leak plugging in support libraries.
* Speeding up a few string value constructions.
* Really make autocorrect utf8 safe.
* Add FIB function.
* Fix loading of sheets with error constants in expressions, such
as #REF!
Lutz Müller:
* Drag & Drop sheet re-ordering
--------------------------------------------------------------------------
Gnumeric 1.1.8
dorami@bu.iij4u.or.jp:
* Begin to use Pango in cells.
Jody:
* Add XL import for polygon colours.
* More pango work.
* Fix icon assignment.
* Support pasting utf8
* Rewrite plan perfect import, significantly more useful now.
Includes some format transfer and uses the wordperfect
charset map from kword (thanks to Ariya Hidayat)
* Cull out a pile of special iconv code in favour of glib
* Fix documentation installtion to match libgnome's expectations
* locale -> utf8 conversion for lotus wk1 importer
* support for BITAND and BITOR in lotus wk1 importer
* Tweak XL export so that MS Excel does not produce a warning when
reading our sheets.
* Partially fix printing images
Jon KÃ¥re:
* Port to new libgsf big file api
Jukka:
* Solver improvements:
- Imported the GLPK (GNU linear programming kit) version 3.2.
It provides a revised simplex algorithm for solving large
scale problems, written by Andrew Makhorin. It performs
much better than lp-solve if the model is large, see
a benchmark in ftp://plato.la.asu.edu/pub/lpsimp.txt.
- Added the algorithm selection into the dialog.
- Other dialog improvements.
* Speed optimizations for the MPS plugin.
Morten:
* Add poor man's utf8 regexp routines.
Christian Meyer:
* Renamed "Print Setup" to "Page Setup" in the file menu and the
gnumeric documents.
Zbigniew:
* Work on the plugins.
* Plugins can now register menu and toolbar items (bonobo only for now)
* Another step towards a gtk only build.
--------------------------------------------------------------------------
Gnumeric 1.1.7
Jody:
* Fix and speed up the XL exporter.
* Make the behaviour for right button consistent in all contexts.
* Fix import of frozen panes.
* Fix XL export of functions with fewer args than XL requires
* Improve the wk1 importer
* Implement some of Harlan's CELL routines to help the wk1 importer
* Make sheet deletion multi-view safe.
* More fixes for named expressions.
* Remove old bogosity when importing the err form of #REF!
* Fix handling of embedded newlines for gtk2
* Fix Chema's bug.
* Don't leak clipboard on exit.
* Have Enter move the edit_pos while in the editline the same way it
does in the cell.
* Support Double click in cell to start editing.
* Change the cursor when the mouse is in the edit item.
* Improve (Fix?) colwidth exporting in xls
* Fix XLS name import in the presence of external links
* Extend XLS array import
* Take a step towards supporting external links in XLS.
* Fix reporting of import errors.
* Fix ref-count problem importing builtin names in XLS.
* Enable and patch the plan perfect importer.
* Fix ref-count problem with cell comments.
* Ultra basic support for Excel 95 Polygon objects.
* Fix colour leak with grid colour change, and small warning.
Jukka:
* New random distribution functions (mostly integrated from the
GNU Scientific Library with some minor modifications):
RANDDISCRETE(), RANDGAUSSIANTAIL() and RANDLANDAU().
* New random distributions for the random number generation tool:
Gaussian Tail, Landau, and Uniform integer.
* New financial function, VDB(), integrated from the OpenOffice
with some modifications and clean up.
* New statistical functions (integrated from the R 1.5.1 and
GSL 1.1.1):
BERNOULLI(), CAUCHY(), EXPPOWDIST(), GEOMDIST(), LANDAU(),
LAPLACE(), LOGISTIC(), PARETO(), RAYLEIGH(), and RAYLEIGHTAIL().
* Added `Filter->Show All'.
* Improved the function description layout in the
`Insert->Function' dialog.
* Function documentation improvements.
* Implemented standard errors output for the exponential
smoothing tool.
* Implemented the `Risk Simulation Tool'. You cannot find it in
XL, you have to pay more to get it as an extra add-in.
* Implemented SIMTABLE() function related to the risk simulation
tool.
* Initial EUROCONVERT() function.
Morten:
* Fix random number generator to really use /dev/urandom.
* More utf8 work.
* Make search utf8 safe (assuming utf8-ready regexp routines).
J.H.M. Dassen (Ray):
* Update desktop to reflect wider mime support.
Zbigniew:
* Work on the plugins.
--------------------------------------------------------------------------
Gnumeric 1.1.6
Andreas:
* Fix and improve html import.
* Make the analysis tools honour the lock state of cells.
* Properly handle output range preparation for analysis tools
even if the user did not want it cleared.
* Create ui to set protection of indiviual sheets.
* Make various edit actions check for locks first.
* Fix 85383, 84396, 88164.
Jody:
* Have the stf dialog use the default font.
* Use GsfInput for importing.
* Improve the Applix importer.
* Fix lifecycle for 3d references.
* Fix goto dialog's handling of invalid addresses.
* forward port missing patches from 1.0
* Finally add SheetView
* Move animated cursor selection to sheetview
* Handle enabling paste special on an application level
* Move selection to SheetView
* Parse and evaluate constructed references, no depends yet.
* Read edit_pos from xls for multi-selection case.
* Save selection correctly for xls.
* Move freeze state to SheetView.
* Decrease dependence on gal in favour of libgsf.
* Move libgsf for XL export
* Remove dependence on libole2 !
* Add a Quattro Pro importer
* Fix Lotus import of relative references, and formulas with strings
* Support url, and in workbook hyper-links, no UI or persistence yet.
* Import url, and in workbook hyper-links from xls
* Take steps towards support implicit iteration for function args.
* Handle cursor changes, and tooltips for hyper-links.
Jukka:
* More solver enhancements:
Reporting improvements.
Documentation updated.
* MPS plugin enhancements.
* New financial functions (integrated from the OpenOffice with
some modifications and clean up):
AMORDEGRC(), AMORLINC(), CUMIPMT(), CUMPRINC(), MDURATION(),
ODDLPRICE(), ODDLYIELD(), and YIELDMAT().
* Renamed Gnumeric's DURATION() as G_DURATION() and implemented
DURATION() like in XL (using OpenOffice code).
* Fixed YIELD().
* Moved all complex number functions from fn-eng plug-in to a
separate plug-in for complex numbers.
* New complex number functions (integrated from the GNU Scientific
Library with some minor modifications):
IMINV(), IMNEG(), IMARCSIN(), IMARCCOS(), IMARCTAN(), IMARCSEC(),
IMARCCSC(), IMARCCOT(), IMSEC(), IMCSC(), IMCOT(), IMSINH(),
IMCOSH(), IMTANH(), IMSECH(), IMCSCH(), IMCOTH(), IMARCSINH(),
IMARCCOSH(), IMARCTANH(), IMARCSECH(), IMARCCSCH(), and IMARCCOTH().
* Moved all random number generation functions from fn-math to a
separate plug-in (fn-random).
* New random distribution functions (mostly integrated from the
GNU Scientific Library with some minor modifications):
RANDBETA(), RANDCAUCHY(), RANDCHISQ(), RANDEXPPOW(), RANDFDIST(),
RANDGAMMA(), RANDGAUSSIAN(), RANDGEOM(), RANDGUMBEL(), RANDHYPERG(),
RANDLAPLACE(), RANDLEVY(), RANDLOG(), RANDLOGISTIC(), RANDLOGNORM(),
RANDPARETO(), RANDRAYLEIGH(), RANDRAYLEIGHTAIL(), RANDTDIST(),
RANDUNIFORM(), and RANDWEIBULL().
* New random distributions for the random number generation tool:
Beta, Cauchy, Chi-Squared, Exponential power, F, Gamma, Geometric,
Laplace, Levy alpha-Stable, Logarithmic, Logistic, Lognormal,
Pareto, Rayleigh, Rayleigh tail, T, Type I Gumbel, Type II Gumbel,
and Weibull.
Morten:
* Improve the Applix importer.
* Update mathfunc.c to R 1.5.1.
* Improve precision of HYPGEOMDIST and NEGBINOMDIST.
* Fix PERMUT crash.
* Fix RANDPOISSON loop and performance.
* Start making Search and Search/Replace UTF-8 safe.
* Resurrect long double support.
Jon KÃ¥re:
* Use GsfInput in the Python plugin loader
* Use GsfInput in the Nautilus component
* Open all probe-able file formats from the Nautilus component
* Added ISOYEAR().
--------------------------------------------------------------------------
Gnumeric 1.1.4
Almer:
* Implement validation criteria checking.
(http://bugzilla.gnome.org/show_bug.cgi?id=72554)
* Port part of the string functions to utf8.
Andreas:
* Improve printing dialogs.
* Make print-setup changes undoable.
* Add zoom factor preference.
* Add sheet selector to print-setup dialog.
* Fix print range selection.
* Added new stats function CRONBACH.
* Improve focus handling in search dialog
(http://bugzilla.gnome.org/show_bug.cgi?id=81087).
* Persist printer information
* Add GUI to plugin manager to add/remove extra plugin
directories
* Add discard all/save all buttons to exit dialog.
* Add a rescan directories button to the plugin manager
(Note: this has seen only minimal testing.)
* Fix bug:
http://bugzilla.gnome.org/show_bug.cgi?id=82272
http://bugzilla.gnome.org/show_bug.cgi?id=80126
http://bugzilla.gnome.org/show_bug.cgi?id=82398
Jody:
http://bugzilla.gnome.org/show_bug.cgi?id=83392
* fix name definition.
http://bugzilla.gnome.org/show_bug.cgi?id=79925
* Only grab if selection succeeds.
* Fix drawing glitch when creating unshared views not at A1
* Copy freeze state and outline info
* Ignore combos associated with filters.
Jukka:
* More solver improvements.
Morten:
* Cleanup fn-database.
* Disentangle fn-stat and fn-database.
* Make fn-database a plugin.
* Make fn-stat a plugin.
* Improve goal seek for the case without a proper df.
* Fix XIRR.
* Plug leaks and improve speed of string functions.
* Fix DOLLAR.
* Fix ROW and COLUMN.
* Prevent gcc 2.96 compilation.
* Fix leaks for unknown function stubs.
Jon KÃ¥re:
* Install bonobo control
* Merge bonobo control commands into container's menus
* Make bonobo control zoomable
* Enable bonobo control to display message dialog.
--------------------------------------------------------------------------
Gnumeric 1.1.3
Andreas:
* Port print-setup dialog.
* Fix print dialog.
* Make all Analysis Tools undoable.
* Add output formatting options to Analysis Tools.
* Make undo-size configurable.
* Plug leaks.
* Add preference dialog.
* Improve treeview cell renderers.
* Make Random Generator Tool undoable.
* Fix and improve row-height dialog.
* Fix hide/show detail and group/ungroup dialog.
* Include more info in HTML 4.0 files.
* Support borders in HTML4.0 exports.
* Fix Sheet-Object-Scrollbar configuration dialog.
* Fix Sheet Object leak.
* Fix Sheet-Object-Checkbox configuration dialog.
* Fix Sheet-Object Arrow/Line configuration dialog.
* Fix Sheet-Object Fill configuration dialog.
* Fix workbook attribute dialog.
* Add preference setting to include sheet name in undo/redo
description
* Fix missing data handling of SUMPRODUCT and friends
* Fix CONCATENATE (http://bugzilla.gnome.org/show_bug.cgi?id=78610)
* Add number of sheets preference
* Start to UTF8 some of the string functions
* Preserve autocorrect exception lists
* Switch plugin manager from gnome-config to gconf
* Add window size preference page to preference dialog
* Add file/xml preference page to preference dialog
* Redesign Error info dialog
* Improve x-selection handling
* Fix http://bugzilla.gnome.org/show_bug.cgi?id=76474
* Add lowering and raising of sheet objects (except widgets).
* Fix http://bugzilla.gnome.org/show_bug.cgi?id=79809
* Add lowering and raising of sheet objects (except widgets) to top and bottom.
* Fix http://bugzilla.gnome.org/show_bug.cgi?id=62127
* Fix http://bugzilla.gnome.org/show_bug.cgi?id=79744
Jody:
* Add password dialog to support encrypted input.
* Make expr parser utf8 clean.
* Fix printing.
* Fix object import from XL.
* Quicky insert image item.
* Tidy drag and Drop.
* Fix dateToUnix.
* Some touchups to bonobo build.
* cleanup autoconf.
* apply some pending japanese patches.
* Improve HIG compliance.
* Start support for filter importing.
* Fix sheetobjects in the presence of panes.
Jon KÃ¥re:
* Enable bonobo
* fix hpux build
* Clean up Guile plugin
* Enable use as a bonobo control
Jukka:
* More solver improvements.
Morten:
* More and better chunk allocation.
* Fixed memory corruption in LINEST and LOGEST.
* Plug gigantic leak in parser.
* Improve gnumeric-expr-entry's utf8 support and speed.
* Plug various little leaks.
* Add logical XOR function.
* Make fn-date a plugin.
* Make fn-eng a plugin.
* Make fn-financial a plugin.
* Make fn-info[rmation] a plugin.
* Make fn-logical a plugin.
* Make fn-lookup a plugin.
* Make fn-math a plugin.
* Make fn-string a plugin.
* Partially untangle remaining fn-files.
--------------------------------------------------------------------------
Gnumeric 1.1.2
Almer:
* Make autoformat edges toggleable.
Andreas:
* Make Single-Factor ANOVA undoable.
* Port search dialog.
* Add merge tool.
* Implement setting and changing of tab colors.
* Port search/replace dialog.
* Reimplementation of function selector.
* Reimplementation of formula guru.
* Add `recently used' to function selector.
* Fix csv importer crash.
* Port summary dialog and make it modeless.
* Make summary changes undoable.
* Fixed #68048.
Jody:
* Fix XL import of external function names.
* plug item-bar leak.
* Rewrite editable-label to use gtkentry and to be utf8 clean.
* Fix scrollbar & checkbox object cloning.
* Support Applix's #AND# #OR# #NOT#
* Rework dependent relocation.
* Improve event handling during sheet-object editing.
* Add dependency support for 3d references. needs work on delete.
* More polish to dependency engine.
* Big ExprTree -> GnmExpr rename in prep for libgnumeric.
* Support importing encrypted XLS workbooks (password is temporarilly
hard coded)
Jukka:
* More solver improvements.
Morten:
* Plug leaks.
* Add aggressive expression sharing during load.
* Add chunk allocators for cells, dependents, and some values.
* Fix conditional formats, more or less.
* Fix F4 key.
* Fix PROB function's argument order.
--------------------------------------------------------------------------
Gnumeric 1.1.0 and 1.1.1
Almer:
* Fixes to the STF exporter. (#72416, #71783)
Andreas:
* Port gnumeric_notice to gnome2.
* Fix #63485.
* Make the autosave dialog non-modal, port to gnome2.
* Make the analysis tools warnings non-modal.
* Make the autocorrect dialog non-modal, port to gnome2.
* Fix gnome2 specific random tool crash.
* Destroy outadated dialogs.
* Port solver dialog to gnome2.
* Make the solver information dialogs non-modal.
* Make the goal-seek warnings non-modal.
* Port consolidate dialog to gnome2.
* Make the consolidate warning dialogs non-modal.
* Allow cross-sheet consolidation.
* Turn sheet-rename dialog into guru.
* Port filter dialog to gnome2 using the expr-entry
widget and improve filter mechanism.
* Port the plugin manager dialog to gnome2.
* Improve numerical precision in single factor ANOVA.
* Correct regression analysis tool (intercept == 0 case).
* Port and redesign sort dialog.
* Reenable the expr entry widgets in gurus.
* Fix about dialog.
* Convert lots of dialogs to use the new expr entry
widget correctly.
* Add help buttons to various dialogs.
* Make reordering of sheets undoable.
* Port zoom dialog and convert it into a guru.
* Improve Sheet-Order dialog.
* Make add/modify comment undoable.
* Make comment clearing undoable.
* Make comment deletion undoable.
* Add `Add/Modify Comments' item to cell context menu.
* Fix 73491.
* Improve comment popup.
* Make adding sheet undoable/redoable
Jakub Steiner:
* Some new icons.
Jody:
* Initial port to gnome2.
* Enable microhash depend mechanism.
* Rework the range relocation logic.
* Rework sheet order dialog and make it a guru.
* Clean sheet object widget creation.
* Improve key handling when there are gurus.
* Crash importing 3d references to external workbooks.
* move libole2 req into excel plugin, and make it optional.
* guruify autoformat dialog, and update autoformat code.
* move format from cell -> value.
* add an icon to the expr-entry (thanks Jacub)
* make images available without bonobo, including printing.
* fix scrollwheels for gnome2.
* more fixage for libxml2.
* improve xl import of images.
* start moving to utf8 internals.
* fix pango context leak.
* improve xl95 export.
* Implement hooks to support per instance depends
(eg data sources or INDIRECT)
* Fix formula guru.
* Initial pass at dumping the translated function docs into a manual.
* Cleanup name import from xls, and handling of fwd sheet decls in xl95.
* Move the font mapping into the core rather than at XL import.
* Cleanup the sheet's use of dependents.
* Improve dependent management.
* Prep for importing external references from XL.
* Better support for 3d references.
* Add a sample external data source.
* fix paste-special.
Jon KÃ¥re:
* More correct import of "automatic" colors from Excel.
* Export "automatic" colors to Excel.
* Simplify and fix bugs in Excel color import and export.
* Support cropping in Excel image import.
Joshua R. Odom:
* Reorganize the custom pixmaps.
Jukka:
* Major rewrite of the Solver. Integrated key parts of the LP
Solve 3.2 written by Michel Berkelaar and others.
Morten:
* Fix DATE2UNIX. (Bug 70814.)
* Fix compiler warnings. (Well, fix the bugs they pointed out.)
* Partially clean up regression code.
* Fix regression's singularity test.
* Fix validation's use of abs to be fabs.
* Improve random number generation using /dev/urandom device.
* Fix Oleo plugin's isdigit usage.
* Support for --with-long-double
* Constify C strings.
* Switch to newer R sources.
* Fix "make -j" in plugins.
* Add extra tests for singularity and near-singularity in
regression.
* Clean up Fourier analysis.
* Fix validation int check.
* Fix analysis tools crashes.
Scott Ananian:
* Update the debian control files.
* Initial support for WorkbookView::is_protected.
Wayne Schuster:
* Implement opening of comment dialog by double clicking marker.
--------------------------------------------------------------------------
Gnumeric 1.0.3
Andreas:
* Redo COUP_ functions one more time, ignoring XL.
* Fix expression entry widget
* Preload selections in analysis tools
Jakub Steiner:
* Update the icon.
Jody:
* Enable Add/Delete Series for Graph Guru.
* Improve usability of Graph Guru data selectors.
* More work on XL import for 3d references.
* Import checkbox links from XL.
* Add scrollbars and import them from XL.
* Update the xml schema.
* Small optimization to shrink xml in .gnumeric files.
* Polish the sheet object editing.
Morten:
* New tabulation tool.
Neil Booth:
* Document the Black-Scholes routines.
Wayne Schuller:
* Audit the dialogs for accelerators.
--------------------------------------------------------------------------
Gnumeric 1.0.2
Andreas:
* Add `autofit columns' checkbox to all analysis tools.
* Add radio buttons to rank dialog to let user choose
behaviour in case of ties.
* Enable Standard Errors Checkbox in Moving Averages Dialog.
* Implement calculated bins in Histogram Tool.
* Implement Fourier Analysis Tool.
* Updated documentation.
* Fixed COUPNCD.
* Complete implementation of COUPDAYSCD
* Implement COUPPCD.
* Implement COUPDAYBS.
* Implement COUPDAYS.
Jody:
* Generate spans after importing a lotus 123 file.
* Add Russian Ruble.
* Improve Data Validation, and add XL import.
* Add new builtin format to Applix importer.
* Fix AREA_3D expressions from Excel.
* Display and import coloured tabs from Excel XP.
* Fix displayed cursor when leaving a sheet object.
* Improve goto box to support names, and inter-sheet jumps.
* Support inter-sheet references in the goal seek.
* Handle totally hidden merges at freeze bound.
* Improve XL import for 3d references.
* Try REALLY hard to find an expression in xml not
marked as being a value.
Jon KÃ¥re:
* Added WEEKNUM and ISOWEEKNUM
Morten:
* Make sure Linux ends up using IEEE_754 code in mathfunc.c.
* Fix search crash.
* Make functions that take numeric arguments accept also strings
that parse as numbers.
* Partly fix ADDRESS.
Neil Booth:
* Handle 1900/Feb/28 the same way MS Excel (tm) does.
--------------------------------------------------------------------------
Gnumeric 1.0.1
Andreas:
* Fix 67878 (help button ref)
* Fix a few ANOVA error messages
* Fix 67289 (PERCENTRANK)
Jody:
* Fix CRASH!! due to last minute translation fix.
* Some missing '...' in menu names
* Rename 'Summary' menu -> 'Properties'
* Support graphs with no data.
* A bit of warning suppression for s390.
* Bump the GAL requirement to 0.16
Morten:
* Added DATE2UNIX and UNIX2DATE.
* Added GETENV.
* Fix WEEKDAY.
J.H.M. Dassen (Ray):
* Lots of bit warning suppression for s390.
--------------------------------------------------------------------------
Gnumeric 1.0.0
Andreas:
* Improve file format documentation
* Fix text colour in html and latex exporters (#67550)
* Fix roff importer (#66457)
Jody:
* Double check that nearest range is not on another sheet.
* Fix undo for range fills with overlapping ranges.
* Do not register commands for pasting a cut onto itself.
* Fix cloning checkboxes.
* Make all openers available on the import menu, just in case.
* Fix sheet objects as inter-sheet dependents.
* Fix undo from keyboard for sheet object deletion.
--------------------------------------------------------------------------
Gnumeric 0.99.1
Andreas:
* Improve documentation incl. analysis tools, files & worksheet
* Implement merges and spans in html exporter
* Make output from HTML4.0 and HTML3.2 exporters validate
* Fix copy multiple cells to single merged cell (#67298)
* Fix expr entry widget: used to fet confised on mouse clicks
(#65894)
Jody:
* Add insert Graph menu item & icon
* Fix Exit icon for bonbo build.
* Delete the CAPS lock feature from autocorrect.
* Fix Chema's sneaky cursor grab.
* Applix import for v4.41, add it to the mime types.
* Inter-Gnumeric pasting support for merges, and shares.
* Fix life cycle of validation styles.
* Undo for pasting a cut was saving too much.
* Parser was not honouring requests to ensure absoluteness.
* Transparent makes no sense for lines & arrows.
* Improve help tokenizer.
* Don't prompt for sheet delete if it is pristine.
* Autofill includes autoformats for expressions.
* Edit position after undoing a merge.
* Partial fix for del col/row undo with dependent objects.
* Support some additional forms of #!REF in XL import.
* Fix importing of graphs with embedded graphs.
* Improve autofill handling of merges & arrays.
* Support pasting transposed merges.
* Ensure that cell sizes never violate absolute minima.
* Fix format leak (thanks Morten)
* Fix data validation.
* Dirty workbook when modifying summary info.
* Invalidate names refering to deleted expressions.
* Fix row height resize when undoing changes to JIT rendering.
Morten:
* Fix DATE.
* Fix a pile of leaks in financial functions.
* Fix COUPNCD, YIELD, PRICE.
* Fix overflow issues.
Wayne Schuller:
* Search and search-replace history persistence.
* Improve documentation: intro and printing
Tino Meinen:
* Make bound errors for INDEX consistent.
--------------------------------------------------------------------------
Gnumeric 0.99.0
Andreas:
* Fix problem in search & search/replace tool #64989
* Permit input from other sheets in Random Number Generator
(discrete distribution), Rank and Percentile Tools and
2-factor ANOVAs
* Check for valid input in Random Number Generator tool
* Fix parsing error in analysis tools expecting sheet references
when none is given
* Fix sheet reference in database function criteria (# 65353 (1))
* Implement -geometry cmd line option
* Fix rank calculation with respect to ties
* Set cell format for percentiles in rank and percentile tool
* Fix crash on copy between different invocations of gnumeric
* Fix search in comments (# 65159)
* Fix crash in parser (# 65896)
* Format all numbers preentered in analysis tools dialogs
according to locale (# 65404)
* In histogram tool add percentage column and format all
percentages appropriately (# 62164)
* Implement text wrap in LaTeX exporter (# 20898)
* Implement math mode in LaTeX exporter (# 63395)
* Use gnumeric column widths in LaTeX exporter
* Implement multirow merges in LaTeX exporter
* Remove default grid in LaTeX exporter
* Implement cell borders in LaTeX exporter
* Fix merged cell to merged cell copy (#65760 & #58691)
* Removed latex209 exporter
* Implement spans in LaTeX exporter
* Improved analysis tools documentation
* Fix bugs (#66433 & #66880 & #66393)
* Fix cellspan bug (#66658)
Jody:
* Tricky corner cases for style applications (Part 2).
* Rework sheetname quoting (Good idea Andreas)
* Support multiple expressions in the parser and clean up
expression lists.
* Memory error when parsing names.
* Fix xml storage of parse position for names.
* sync print code with draw code for merges.
* Fix ins/del col/row in outline mode.
* Support number buttons in outline mode.
* Implement XL export for array formulas.
* Fix handling of failue in filter dialog.
* Remove some dead code.
* Minor etable warning tweak.
* Improve cursor handling for frozen panes.
* Fix sorting with hidden cols/rows before region.
* FIXED now uses the format engine.
* Simplify cell fmt dialog's idea of merges.
* Don't compress file when suffix is .xml.
* Actually put the schema file where we say it is.
* More work on libxml2 compatibility.
* Some simple shared steps towards gnome2.
* Fix autofill crash when shrinking regions.
* Make graph vector header recognition more like XL.
* Fix missing bononbo menu icon for exit.
Morten:
* Fix EXPRESSION crash.
* Fix 65577.
* Fix 66848 (the table of function names in the formula guru
is not alphabetized).
* Sort currencies in cell format's drop-down.
Sultanov Albert:
* http://bugzilla.gnome.org/show_bug.cgi?id=55142
Do charset conversions on summary fields to/from XL.
Toralf Lund:
* http://bugzilla.gnome.org/show_bug.cgi?id=60468
More work on the oleo importer.
Greg Lebalnc:
* Modernize the doc build architecture.
--------------------------------------------------------------------------
Gnumeric 0.76
Alex Barnes:
* Autofill backwards.
Andreas:
* Fix handling of missing observations in F-test, z-test,
one-factor ANOVA, histogram, regression, and t-tests analysis
tools.
* Permit input from other sheets in F-test, z-test, one-factor
ANOVA, histogram, regression, and t-tests analysis tools.
* Fix small errors in F-test, z-test, one-factor
ANOVA, Desc. Stats. and t-tests analysis tools.
* Improve Exponential Smoothing and Moving Averages tools.
* Implement pareto and labels in histogram tool.
* Use confidence level in regression tool.
* Use format parsing in entry fields of analysis tools.
Jody:
* More work on the expr entry.
* Fix outline mode.
* Add keyboard support to sheet objects.
* Add warning when xls imports non-ole file.
* Continue audit and clean out some old code.
* Validate autoformat template before storing undo.
* Fix leaks.
* Fix centering while printing scaled regions.
* Tricky corner cases for style applications.
* Break lines at hyphens to.
* Disable col/row resize while editing.
* Make some dialogs resizable.
* Fix comment placement for merged cells.
* Initial XL import for data validation.
Jukka:
* Improved function documentation.
* Implemented Exponential Smoothing tool.
* Improved COUPDAYSNC().
Morten:
* Leak plugging.
* Fix memory overrun in function guru.
--------------------------------------------------------------------------
Gnumeric 0.75
Andreas:
* Rewrite solver dialog as guru (semi-modal using the
expr-entry widget).
* Fix FTEST docs.
Jody:
* Shink exported XL files.
* Enable per sheet style management to support
validation, conditionals, and simply XL export.
* re-enable compression for .gnumeric files.
* Make cell format dialog only pseudo-modal.
* Fix support for cancel on window manager quit.
* Fix non-bonobo View menu
* Fix sheet extent calculation new complex objects.
* Improve formula guru.
* Support scrollwheel in a larger area.
* Fix Edit -> Fill -> Autofill.
* Fix Autofill with the month of May.
* Improve dbf importer.
* Make autocorrect non-modal and cleaner.
* Make autocompletion a view attribute, with a gui.
* Improve the ExprEntry widget.
* Don't clear the clipboard when Klipper requests things.
Jukka:
* Lots of documentation added.
* Added `Help' buttons for various tools.
* Help button of autosave doesn't kill the dialog any more.
* Added `Filter' submenu into the `Data' menu.
* More work done to support financial functions.
Morten:
* Cleanup various functions' improper access to internal strings.
* Plug leaks.
--------------------------------------------------------------------------
Gnumeric 0.74
Jody:
* Fix regexp handling of escaped characters.
* Improve XL import when faced with corrupt workbooks.
Morten:
* Find and fix leaks.
* Fix an ugly dependency bug.
--------------------------------------------------------------------------
Gnumeric 0.73
Adrian Custer:
* Improve latex exporter to support multiple pages and basic support
for merges.
Almer:
* More work on validation.
* Improve View menu layout.
Andreas:
* Allow analysis tool output to be directed onto a range
on another sheet.
* Allow analysis tool output ranges to be specified using
defined names.
* Change covariance, correlation, descriptive statistics and
sampling tools to allow multiple selections (and defined
names as input.
* Change covariance and correlation tools to handle missing
observations.
* Change sampling tool to permit multiple samples from the
same or different data.
Jody:
* Fix autosizing of indented content.
* Fix jump to bound with end in hidden region.
* Hide objects in hidden regions for display and printing.
* LOG() is valid with base > 0 && base != 1
* Clean out some unused code.
* Fix redo of unmerge to handle redraw spans.
* Fix Name Support and Dialog.
* Improve data allocator for graphs.
* Begin code audit.
* Fix autofill of days with months visible.
* Fix minor leaks.
* Improve recognition of values vs expressions
* Reset grid display cursor after editing an object.
* Resize frozen panes after ins/del col/row.
* Make python version configurable.
Jukka:
* Improved MPS plugin.
* Extended the data analysis tools and function documentation.
* Improved COUPDAYS().
Morten:
* Improve goal seek.
* Fixed parsing of numbers in scientific, monetary, and number
contexts.
* Find and fix leaks.
* Fix dif plugin's use of alloca.
Wayne Schuller:
* Much improved header/footer preview canvas.
* Improve UI for customizing print header/footer.
--------------------------------------------------------------------------
Gnumeric 0.72
Adrian Custer:
* Improve latex exporter.
Almer:
* More work on validation.
* Stf multiple-separators-as-one fix.
Andreas:
* Rewrite remaining analysis tools
to use the gnumeric-expr-entry widget.
* Rewrite goal seek dialog to use the
gnumeric-expr-entry widget.
Jody:
* Offer config var to control compression level
* Fix color selectors for drawing objects.
* Re-enable support for row vectors in graphs.
* Allow string functions to accept numbers as strings.
* Font selector in cell format dialog
* Off by 1 error when undoing unhiding cols/rows
* Improve handling of Cancel during File -> Quit
* Autoscroll support during object creation
* Fix MINVERSE
* CODE assumes unsigned char
* Improve parser's handling of integers larger than int.
* Improve cursor & scroll bounds checking.
* Fix graph leaks.
* Allow xls exporter to (poorly) handle large format regions.
* Fix changing data for graphs
* Format match can match strings, don't assume only numbers.
* Improve XL chart import.
* Plug memory leaks.
John Gotts:
* Make bonobo optional in the sample rpm specfile.
Jukka:
* Improved COUPDAYS() and COUPDAYBS().
Morten:
* New Search Control Center.
* Find/Fix memory leaks.
--------------------------------------------------------------------------
Gnumeric 0.71
Almer:
* Core support for validation and conditional formats.
Andreas:
* Rewrite descriptive statistics, correlation, covariance,
and rank analysis tool dialogs to use the gnumeric-expr-entry widget.
Christopher Keith Fairbairn:
* Add a 'Fill' menu connection to autofill.
Eric Baudais:
* Improve function documentation generator.
Jody:
* Enable XL import for graphs.
* Import/Export/Edit Hidden/Locked attributes.
* Parse using the assigned fmt before checking the builtins.
* Enable basic attributes when importing shapes from XL.
* Add simple bucketing of range dependencies.
* Formating extensions and corrections.
* Some simple recalc tuning speeds things up by a factor of 2.
* Basic version of just in time rendering for another factor of 2.
* Cleanup the DOM based xml import/export utilities.
* Remove irritating frame around bonobo objects.
* Make the sheet object control points prettier.
* Off by 1 pixel/pt error when handling right/center alignment.
* Improve sheet object menus.
* Reworked the Text Combo,
* Remove the eval queue.
* Improve the Histogram tool slightly.
* Improve INDIRECT.
* Sort the function names for the index generator.
* Fix handling of mixed mode references.
* Convert lines/arrows/boxes/ovals to StyleColor.
* Correct sensitivity of menus & toolbars.
* Some initial guess work on how to import conditional XL formats.
* bump bonobo req to 1.0.8 to fix the memory problem.
* bump the gnome-print req to 0.29 in an effort to decrease
the number of problems with gnome-print installs.
Jukka:
* Fixed COUPNUM().
* MPS importer plugin implemented. Reads a linear program in MPS
format and creates a spreadsheet model of it. Currently, the
bounds and ranges are not implemented yet.
Marc Johnson:
* The POI project has contributed an xml schema for .gnumeric files.
Morten:
* Speed up font handling.
* Speed up dependency handling.
* Eliminate deep recursion during dependency dirtying.
* Fix the python and python-loader modules. (Work around mind-
boggling bug in python. Again.)
* Various code cleanup.
* Fix regression.
* Implemented querying in search-and-replace.
* Implemented Search.
Toralf Lund:
* improve the oleo importer.
Wayne Schuller:
* Support gray scale patterns when printing.
* Improve Header/Footer page for printer setup.
Yukihiro Nakai:
* Improve font handling for multi-byte environments.
Zbigniew:
* Support for translations in plugin.xml files using xml-i18n-tools
(modified xml file structure a bit).
* Sped up Gnumeric compilation by replacing #include <gnome.h> with
something smaller in almost all source files.
--------------------------------------------------------------------------
Gnumeric 0.70
Ariel:
* Make guile a proper plugin.
Jody :
* Basic support for M-Enter to add embedded newlines.
Lutz:
* Object printing work.
Morten:
* Make CEIL more as users expect (based on Jody's idea).
--------------------------------------------------------------------------
Gnumeric 0.69
Almer:
* Add extra cut/copy/paste shortcut keys.
* Improve the function selector.
* Simplify background/pattern preview in cell-format dialog.
* Make sure entered text never gets lost.
* Equalize the look of all the dialogs.
* More work on group/ungroup.
Ariel:
* Rewrite guile plugin to use guile 1.5 or later.
Andreas:
* Rewrite descriptive statistics, correlation and covariance
analysis improving error checks and labels for data sets.
* Remove duplicate calculation code in analysis tools.
* Fix sampling tool.
Jody:
* XL export for panes.
* Some autoscroll bugs with panes.
* Cursor support for panes.
* Improve INDIRECT.
* More smarts for autofill by month/year.
* Add some new icons from the Evolution team.
* Fix import of files generated by perl::writeExcel.
* Fix animated cursors and sheet objects.
* Fix XL import of print scaling.
* Locales with different LC_NUMERIC & LC_MONETARY.
* merge in several contributions to improve configure.in
* merge in updated debian control files.
* merge in contributed man page.
Morten:
* Fix MODE.
* Clean up LARGE, SMALL, QUARTILE, PERCENTILE.
* Give the range functions a home of their own.
Frodo Looijaard:
* Add import support for Psion.
Zbigniew:
* i18n fixes.
* Add precedence scheme for importers.
--------------------------------------------------------------------------
Gnumeric 0.68
Almer:
* Fix backspace key.
* Fix autosave dialog.
* Improve scrollbars.
* Fix double-click autofill.
* Shine-up string functions.
* Fix STF for CRLF terminated files.
* Fix bounds handling and leakage in STF.
* Add csv default importing + probing.
* Improve font preview in cell format dialog.
Andreas:
* Fix bugs in analysis-tools' t-test.
* Finish two-factor anova tool in analysis-tools.
* Adjust scrollbars when outputting data analysis results.
Jody:
* Even more missing files.
* Crash after exiting 1 of many shared views.
* Bug when printing wrapped text in merged cells.
* Frozen panes.
* Some span bugs.
* Usability tuning (Thanks to auspex, UnNamed, & jwz)
* Misc bugs.
Morten:
* Improve bsd support.
* Fix CONCATENATE.
* Fix MULTINOMIAL.
* Fix LCM.
* Fix dependency tracking problem.
Rodrigo:
* Update gda support.
Nakai:
* Over-the-Spot style support for XIM.
Lutz:
* Introduction of placeholders named "FileOperations" and
"PrintOperations" that help components to put their own menus into
the right place.
Zbigniew:
* Use temporary files to handle saving to BonoboStream with every
file saver.
--------------------------------------------------------------------------
Gnumeric 0.67
Jody :
* Restore missing files.
John Gotts :
* Update spec file.
Zbigniew:
* Fix libml1 bug exposed by progress monitor.
--------------------------------------------------------------------------
Gnumeric 0.66
Almer:
* Some work on the SAX importer.
* Finish Group/Ungroup.
* Clean-up the STF importer.
* Add support for multicharacter separators
and quoted cells with newlines to the STF
importer.
* Clean-up row naming.
* Fix the STF exporter (it works again).
* Add new consolidation feature.
* Keyboard Shortcuts for moving and formatting.
Elliot:
* Financial functions.
Jody:
* Fix ctrl-enter filling.
* Reorganize the recalc queue to speed things up a bit.
* Support iteration.
* Fix FV arguments.
* Support conditional number formats.
* Obscure referencing bug.
* Scaled printing.
* Some number formating bugs.
Juan Pablo Mendoza:
* Handle {caps,number,scroll}lock.
* Improve sheet name quoting.
Morten:
* Fix PV.
* Applied some much-needed TLC to fn-financial.c and fn-eng.c.
* Speed-up Gnumeric function calls.
* Killed a zillion problems pointed out by gcc 3.0 warnings.
* Improve goal seeking slightly.
* Fix RATE and IRR.
Zbigniew:
* More work on plugin system.
* Many i/o system improvements (general cleanup, reporing i/o progress,
better probing, nicer import dialog, pluggable default savers,
handling single sheet exporters in a special way)
--------------------------------------------------------------------------
Gnumeric 0.65
Almer:
* Fix a variety of bugs and other issues.
* Improve parser error messages.
* Implement undo/redo for Zoom.
* Make undo/redo descriptors more descriptive.
* Complete the CELL function.
* Drastically revise and fix-up the color combo's.
* Architectural improvements for preview-grid, menu state, etc.
Chema:
* GNUMERIC_ENABLE_XL_OVERWRITE
* Implemented clone, write and load for some sheet objects
Jody:
* Restore horizontal FILL alignment.
* Fix array intercept checking.
* Some fine tuning to improve start and exit times.
* Merge cell & hidden column interactions
* Some XL import improvement when parsing objects
* Improve XL95 export and include merged regions & outlines
* Fix some irritating mouse behaviors
* More system portability enhancements.
* Support fraction formatting (not parsing)
* Fix printing of borders.
* Improve checking for array/merged region division.
* Prep for frozen panes.
* Partial support for outline mode
* Misc bugs.
Jon KÃ¥re:
* New architecture for selecting cell ranges into dialogs.
* Fix dialog placement.
Juan Pablo Mendoza:
* Improve col and row sizing when cloning a cell.
* Catch many bugs with merged regions.
* Bug fix for supporting maximized windows.
Morten:
* Changed a large number of dirty diapers.
* Plugged gnumeric leaks too.
* Make search-and-destroy work better on comments.
* Fixed parsing of numbers like "-4,885". (We used to get -3115
== -4 * 1000 + 885...)
* Fixed formulae with leading dash, like "-995/5".
* Fixed MID, FIND, LEFT, RIGHT, LOWER, UPPER, PROPER, CLEAN, LEN,
EXACT, REPT.
* Improve signed-vs-unsigned situation.
* Fixed sorting dialog in the by-row case.
Vlad Harchev
* Improve i18n support for XL import/export
Zbigniew:
* Added support for plugin dependencies
* Made Excel a real plugin.
* Improved plugin system performance & scalability.
--------------------------------------------------------------------------
Gnumeric 0.64
Almer:
* Improve scrollbars.
Jody:
* Fix handling of edit pos while extending out of merged regions.
* Fix format toolbar update.
* Fix merge undo.
* Fix interactions between spans and hidden rows/cols.
* Work around xls files which specify col/row too small.
* Header redraw of shrinking selections with merged full col/row
Morten:
* Make search-and-replace dialog non-modal.
* Released version 2 -- a cute little thing of about 3k. She
leaks, though.
Vlad Harchev:
* Improved themed behaviour.
* Improved character set behaviour.
Zbigniew Chyla:
* More work on plugins.
--------------------------------------------------------------------------
Gnumeric 0.63
Almer:
* menu state improvements.
Jody:
* Fix parenthesis for XL export.
* Enable right/left indent.
* Sheet prefs IO and MVC support.
* MVC fixes.
Morten:
* Column header drawing fix.
* [Linear] Regression fix.
Jon KÃ¥re:
* item-edit fix.
Translations:
* Updated: de (Karl), ja (Yukihiro Nakai), pl (Zbigniew), and maybe
more.
--------------------------------------------------------------------------
Gnumeric 0.62
Chema:
* Massive bug hunting spree.
Jody:
* Finish merged cells.
* Rework style engine.
* Rework borders.
* Improve range selection for expressions.
* Fix sheet objects.
* Fix stupid memory corruption problem in the applix importer.
* Some mis-translations for spanish.
* Improve pixel matching of XL import.
* Add option to manage printing ranges with only styles.
Jon KÃ¥re:
* Improve file save dialog.
Morten:
* Make rounding functions (ROUND, TRUNC, FLOOR, CEIL, ...) behave
more like most users expect. The number 1.54999...9 will now
be rounded to 1.6, not 1.5. In other words, we are assuming that
the number is really meant to be 1.55, but has suffered
floating point effects. (If you ever truly get a number that
is within DBL_EPSILON of a rounding threshold, well, then you
lose. With a binary representation, we cannot all win.)
* Leak plugging as usual.
* Created and/or stole a number of tools to make life easier for
developers.
* Cleaned up gnumeric-bonobo's GUI.
* Search and replace.
JPablo:
* Search and replace.
Zbigniew Chyla:
* Internationalization support for autoformat.
* Rework plugin architecture.
Translations:
* Updated: ca (Pablo), de (Karl), hu (Szabolcs), it (Leandro),
ru (Valek), sk (Stanislav), sv (Christian), tr (Fatih), and
maybe more.
--------------------------------------------------------------------------
Gnumeric 0.61
Alan Cox:
* Fix formatting mistakes in documentation.
Chema:
* Some work on the name dialog.
Jody:
* Work on sheet object persistence.
* Begin honouring the current format when parsing.
* More work on merged cell support.
* Improve cursor rubber banding when selecting a range.
Morten:
* Fix scripts generating documentation.
* Fixed lotus file format loader. (Magic detection,
avoid unaligned memory accesses, leaks.)
--------------------------------------------------------------------------
Gnumeric 0.60
Jody:
* Initial work on supporting merged cells.
* Improve sheet object and cell comment infrastructure.
* More work on expression relocation.
* Bugs.
Jon KÃ¥re:
* Improve XL export of non-builtin functions.
Morten:
* Semi-smart undo/redo list truncation.
* Fix serious crash during gnumeric-format save.
* Plug leaks.
--------------------------------------------------------------------------
Gnumeric 0.59
Almer:
* Minor improvements to the autoformat dialog.
--------------------------------------------------------------------------
Gnumeric 0.58
Ariel:
* Cleanup and general bugfixing in guile plugin.
* Support for values inside the Guile interpreter
Almer:
* Undo for autoformat.
* Beautify stf dialog.
* Stf and other bugfixes.
Chema:
* Massive bug hunting spree.
Jody:
* Massive bug fixing spree.
* Fix popup context menus.
* 'General' number formats.
* Some initial work on an MVC split for workbooks.
* More work on double click fill support.
Jon KÃ¥re:
* When format toolbar is vertical, replace font and size
selectors with a button.
Morten:
* Fixed analysis tools for ranges not starting at A1.
* Isolated floating-point-double reading code with endian-issues
in one spot rather than in all file io plugins.
Kenneth:
* Fixed and updated the i18n subsystem, so it how should work
more smooth - I will consider this very close to finished.
--------------------------------------------------------------------------
Gnumeric 0.57
Almer:
* Fix stf importer bugs.
* Add "Autodiscovery" feature to stf fixed width importer.
* New Autoformat dialog.
Chema:
* Sheet copy routine
Hardy Falk:
* Output the cells in row/col sequence, rather than by hash.
Jody:
* Applix support mostly functional.
* Improve support for named expressions.
* Name and Graph gurus support range selection.
* Improve internation keyboard support.
* Fix XIRR and friends so that they support blanks.
* A few more bugs in printing multiline text.
* Correct handling of number formating in intl locales.
* Lots of formating bugs.
* Handle strings used as arguments to numeric operators.
* Support for non-cell dependencies.
* Improve performance and decrease memory for large row/col resizes.
* Bug fixes for ins/del row/col & cut&paste
* Locale safe formating.
John Gill:
* Double click fill support.
Jon KÃ¥re:
* Make print work with new gnome-print
* Lots of printing/margin bugs.
JPR:
* Put more effort into reverse engineering MATCH (and friends)
than you want to know about.
* Fixed sort to ignore hidden rows/cols.
Jukka:
* Implementation of `Anova: Two-Factor With Replication'
and `Histogram' data analysis tools mostly
* Implemented COUPNUM and COUPNCD
* Implemented TRUE and FALSE logical functions
* Started the implementation of COUPDAYBS and COUPDAYS.
Kenneth:
* Created xml2pot script, and integrated it with Gnumeric
* Update update.pl script to make it more genetic, and work
with the xml2pot script. It actually now requires it.
* Updated the spec file a little.
* Made 'make update-po' and 'make dist' work with new update.pl
Matthew D. Bissiri:
* Paste special arithmetic operations, skip blanks, paste link.
Michael Levy:
* Improve the colour combo box.
Morten:
* Cleanup analysis tool code.
* Eliminate many fixed limits in the code. (Still some to go.)
* Rewrote SUMPRODUCT.
* Fixed array and range traversal order, thus fixing all strict
range functions. (SUM, MIN, ...)
* Fixed many bogusities in xbase plugin.
* Cleanup limits in numtheory. Added BITXOR.
* Fixed RATE, SLD, and SYD.
* Improved RATE's and IRR's root searching.
Pablo De Napoli:
* New NT_MU function in numtheory.
Thomas Canty:
* Updated and improved documentation.
Weston:
* Implement DateDif.
* Fix chitest.
Translations:
* Updated: da (Kenneth and Keld), de (Karl), en_GB (Robert), ko
(Sung-Hyun Nam), no (Kjartan), ru (Valek), uk (Yuri), maybe more.
* Update not new, but not mentioned the last time: pl (Zbigniew).
* Updated: nl (Almer). Not all done yet.
--------------------------------------------------------------------------
Gnumeric 0.55/0.56
Almer:
* Stf importer bug fixes and enhancements.
Jody:
* Speedup workbook exit, copy/paste.
* Improve cut/copy/paste.
* Improve col/row resize.
* Undo for copy/paste, autofill, col/row resize
* More work on formula guru.
* Extend auto-fill to support months and years.
* Some translation bugs.
Jon KÃ¥re:
* Tooltips for combo boxes.
* Synchronize list selection with entry field in combo boxes.
* Make units in print setup dialog user selectable.
* More dialog polishing.
JPR:
* Sorting now moves styles with the elements
* Sorting now detects headers when sorting
Kenneth
* Added two perl scripts for translation help/maintainence.
Also added is a README.tools file, explaining how to use these.
Michael:
* Fix tricky Excel import problem.
* Split libole2 out into a standalone package.
Miguel:
* Added support for autocompletion.
Morten:
* Changed a bunch of internals to work with StyleFormats instead
of throwing strings around.
* Improved the optimization of styles.
* Fix ROUND.
* Make sorts stable.
* Make sorts faster.
Translations:
* Updated: da (Kenneth), de (Karl), ja (Oka/Nakai), no
(Kjartan), pt (Tiago), ru (Valek), maybe more.
* Update not new, but not mentioned the last time: it (Leandro).
--------------------------------------------------------------------------
Gnumeric 0.54
Jacob:
* Enable mini icons when available.
Jody:
* Bug fixes.
* Initial applix import.
* Improve row/col insert/del.
JonKare:
* Lots of dialog polishing.
* Autoscrolling combo boxes.
* Make tearoff combo boxes behave more like tearoff menus.
Michael:
* Get embedded gnumeric working again.
Translations:
* New: gl (Jesus).
* Updated: de (Karl), no (Kjartan), sv (Andreas), and more.
--------------------------------------------------------------------------
Gnumeric 0.53
Morten:
* Fixed QUARTILE.
* Fixed MATCH for types -1 and +1.
Jody:
* Overhaul cell structure to cleanup temp formats, improve spans.
* Improve array formula entry, editing, and xml-io.
* Share formulas persisted using xml.
* Add auto-sum
* Improve versioning.
* Decrease memory usage.
Michael:
* Accelerated intersheet dependencies
Marko:
* Number theory functions. (In new plugin.)
Almer:
* Stf-exporter
* Bug-fix stf importer.
Translations:
* Updated: da (Keld and Kenneth), de (Karl), en_GB (Robert), es
(Pablo), no (Kjartan), ru (Valek), uk (Yuri), and more.
--------------------------------------------------------------------------
Gnumeric 0.52
Jon:
* Tearoff combo boxes
Jody:
* Bugs fixes.
* Correct doc generation.
* Improve update status area (autoexpr, editor, format tools)
* Rework canvas editor to behave nicely at boundaries and
span correctly.
Morten:
* Leak fixes. Bug other people about leaks.
* IPMT, PPMT argument order corrected.
* MIRR fixed (or at least changed) to match Excel.
* RATE, IRR, XIRR use supplied guess.
* Improve precision of IRR.
* Made auto-format work for sheet-relative cellrefs, i.e.,
"=sum(a1:a10)" now takes a default format from the range.
* Made generated postscript files (print to file) contain enough
information to let ghostview go back and forth in them.
* Made landscape previews readable.
--------------------------------------------------------------------------
Gnumeric 0.49
Jukka:
* Added `>=' and `=' constraint support for the Solver tool.
* The Solver input variables can now have the negative values too.
* Added `Int' constraints support by implementing the
Branch-And-Bound algorithm.
* The Solver parameters are now saved/loaded when the workbook
is saved/loaded.
* Implemented `Answer Report' generation for Solver.
* Started implementation of `Sensitivity Report' generation for
Solver (currently, not very useful though).
* Major GUI improvementes for Solver, i.g. Solver constraints
can now be cell ranges, not just cells.
* Solver documentation added.
* Added `Advanced Filter' tool.
* Added the following distributions for the random number
generation tool:
- Poisson
- Binomial
- Negative binomial
- Exponential
* Minor improvements for the AutoSave tool.
* GUI improvements for the Data Analysis tool.
* Added RandExp(), RandPoisson(), RandBinom(), RandNegBinom(),
and RandBernoulli() functions.
Jody:
* Redraw improvements (cursor, selection, spanning, speed, underlining)
* Border improvements (combo, printing, partial double line).
* More work on undo.
* Parse interbook references.
* Mostly correct sizing of MS Excel cols/rows and objects.
* Printing improvements.
* Selecting ranges for formulas on other sheets.
Jon:
* GUI polishing.
* File history improvements.
* Python plugin enhancements.
* Error reporting improvements.
* Cursor fixes and speedups.
* CORBA bugfixes.
ERDI Gergo :
* Add a zoom element to the toolbar.
Michael:
* Style undo/redo
* Gnome Basic integration
Miguel:
* Charting work
* Wizard for charting
* Bug fixes.
* Visual cell references while editing.
* Implemented Gnumeric-side vectors for graphics support.
Dom Lachowicz :
* libgladify the plugin manager.
* Improve color combo.
* Lots of DIV0 cases in functions caught elegantly.
Mike Kestner:
* Add file menu file history.
* Style preserving column/row insertion(configurable, defaults on)
Almer :
* "Structured" Text Format Importer (STF) (Customizable CSV/Fixed Width importer)
- Merged with Gnumeric main source (no longer plug-in) and completely revised.
- Pops-up when pasting from external applications.
- Preview is drawn faster and is interactive.
- More separators to choose from when doing a CSV import.
* Copying cells between different instantances of gnumeric.
Morten:
* Fixed display of pre-1900 dates.
* Fixed display of very large numbers.
* Went on a warning-killing spree.
Ariel:
* Guile plugin can now register functions in user given categories.
JP:
* Add sorting functionality to workbook toolbar
* Sorting fixes
* Add basic attribute support for workbooks
--------------------------------------------------------------------------
Gnumeric 0.48
Miguel:
* Fix annoying flashing cursor bug.
Jody:
* Improve inter{sheet,book} references.
* Beginnings of Undo.
* Row/Col hiding.
* Keep cursor visible, Add Alt-Pg{Up,down}
* Clipboard, Selection, & border fixes.
Morten:
* Revamp the memory handling of the parser.
* Fixed goal seek's behaviour on cancel and failure.
* Bogotised PRODUCT and introduced G_PRODUCT.
* Implemented the auto-format feature.
Jon:
* Found xml io font size loading bug.
* Excel export clean.
* Python plugin update: Allow calling Gnumeric builtins from
Python.
Michael:
* Re-wrote dependency engine; lots more speed.
Ariel:
* Improvements on VALUE_BOOL management on the guile plugin.
* Bug fixes.
Jukka:
* Implemented `AutoSave' tool.
* Started `AutoCorrect' tool.
* Some minor improvements to the Solver tool.
JP:
* Sorting undo/redo
--------------------------------------------------------------------------
Gnumeric 0.47
Michael :
* Fix nasty recalc bug that would hang the app.
* Improve bounding box calculation for printing.
Miguel :
* Improve empty cell loading.
* Re-enable pasting from X.
* Adjust semantics of paste to work even when selection is not
visible.
Jody :
* Fix import plugins.
--------------------------------------------------------------------------
Gnumeric 0.46
Michael:
* Fixed problems closing workbooks
* Add pristine workbook discard
* Fixup html export.
* Fixed print header/footer setup, users should remove
~/.gnome/Gnumeric to speedup load.
Jon:
* Lots of Excel style export work:
format, font, colors, borders, alignment, wrap, rotation.
* Excel export row/col sizing.
* Excel fixed up DBCELL collating to export lots of rows correctly.
JP:
* Added sorting of infinite ranges
* Got rid of blank sheets when printing
Frank:
* Worked on Excel summary export
Jody:
* Begin exception handling for corba vs gui.
* Add some simple version protection for plugins.
* Improve error reporting for file loading.
* Explicitly disable passord protected XL spreadsheets.
* Bug fixing.
Cort:
* Expanded CORBA API.
Andrew:
* Many improvement for multi-dimensional linear regression.
Jukka:
* Implemented Simplex algorithm for Solver
* Solver can now solve some simple LP problems (more interesting
stuff is coming later).
Ariel:
* Added guile plugin documentation.
* Removed redeclaration of functions.
* Removed security hazard on the definition of scm_eval.
* Improvements on VALUE management.
* Added Fibonacci formula
* Split the guile scheme files into gnumeric_startup.scm and
functions.scm
* Bug fixing.
--------------------------------------------------------------------------
Gnumeric 0.45
JP:
* Improved sort dialog
Nat:
* Updated bonobo infastructure
Kevin:
* Plan Perfect plugin
* DIF export / import
Jody:
* Improved clipboard ops.
* import Excel auto-ranges
* better range instersection
* Guile plugin fixed
* Auto fill display fixes.
Jon:
* Style hashing
Michael:
* Misc cleans
* Fix #2110
--------------------------------------------------------------------------
Gnumeric 0.44
Jon:
* Vastly improved col / row sizing in excel import
* ditto for Excel object placement.
JP:
* Expanded sort dialog to allow sorting of rows as well as columns
* Added advanced button to sort dialog to allow sorting but case
sensitivty and text (rather value)
--------------------------------------------------------------------------
Gnumeric 0.43
* Minor build fix.
--------------------------------------------------------------------------
Gnumeric 0.42
Michael:
* Totaly re-wrote style engine.
Jukka:
* Implemented IRR and XIRR financial functions
* Fixed the handling of the database function criterias
* Fixed the non-numeric return values of DGET
* One-dimensional GROWTH and TREND should work now
* Documentation of the db functions improved
Jody:
* Complete transition of cut/paste to cell movement code.
* 1st pass at borders & patterns
* Improve edit popup.
* Rework cell format dialog.
* Some support for inter book references (no dependencies yet)
Daniel:
* Excel Name export.
Federico:
* Improved dragging and zooming behavior in the print preview.
* Added "open hand" and "closed hand" cursors for dragging the
print preview.
Robert:
* Primitive oleo import : supports numbers and text.
Frank:
* Huge chunk of summary-info re-structuring.
* Import and export lots of new summary fields.
JPR:
* Improving sort dialog
Jeff:
* Sylk import filter.
* CSV export filter.
--------------------------------------------------------------------------
Gnumeric 0.41
* More recalculation bugs & other minor issues fixed.
* Base release before Style mangling.
--------------------------------------------------------------------------
Gnumeric 0.40
Miguel:
* Important recalculation bugs fixed.
--------------------------------------------------------------------------
Gnumeric 0.39
Miguel:
* Arbitraryly shaped bonobo objects.
* Formatting engine supports h,m,s correctly and supports [h], [m], and [s]
Jukka:
* Started implementation of GROWTH function
* Optional argument fixes for TREND function
Arturo:
* Split libole2 + test program.
* Large excel file support > 8Mb.
Michael:
* Start of sheet/workbook/global name scoping.
Jody:
* Some Optimization.
* Enhance row/col insert/delete, cell shift, and cell cut/paste.
* Some eye candy.
Jon K Hellan:
* Dialog improvements.
--------------------------------------------------------------------------
Gnumeric 0.36
Jody:
* Improve selection to correctly handle overlapping ranges.
* Improve XL import of 'escher' stream for pictures and objects.
* Enabled import of XL objects by default.
* Rewrite zoom dialog.
Jukka:
* Major clean up to the documentation of functions.
* Added tons of examples to functions.
* Added ``Delete...'' entry to ``Edit'' menu.
* Implemented PERCENTILE function.
* Fixed PERCENTRANK function.
Miguel:
* New toolbar code.
* Report font type, support for reporting size
* New format apply buttons for money, percent.
* More commands to format/row/col/sheet
* Bumped row limit to 64k
Michael:
* Support IO on non-mmap-able excel files.
* Totaly re-write libole2's API - its usable now.
* Excel export 'Add-in' functions.
Frank:
* Excel summary info export.
--------------------------------------------------------------------------
Gnumeric 0.33, 0.34, 0.35
Jukka:
* Implemented ACCRINT, ACCRINTM, DISC, FVSCHEDULE, INTRATE,
ISPMT, RECEIVED, PRICEDISC, PRICEMAT, TBILLEQ, TBILLPRICE,
and TBILLYIELD functions
Michael:
* Re-implemented sheet objects,
* Implemented drop filename -> Bonobo component conversion,
* More intelligent workbook sizing.
* Fixed sheet tab focus / editing.
* Per sheet page setup / preview.
* Print setups XML I/O & Excel importing
* Functions MATCH & INDEX started.
* Array input parser.
--------------------------------------------------------------------------
Gnumeric 0.33, 0.34, 0.35
Jukka:
* Implemented ACCRINT, ACCRINTM, DISC, FVSCHEDULE, INTRATE,
ISPMT, RECEIVED, PRICEDISC, PRICEMAT, TBILLEQ, TBILLPRICE,
and TBILLYIELD functions
Miguel:
* Implemented Print Preview
Jody:
* Bug fixes.
--------------------------------------------------------------------------
Gnumeric 0.32
Jukka:
* More work done on documenting the analysis tools.
* Implemented MDETERM and MINVERSE matrix functions.
* Finished the ROMAN function completing the mathematical
functions.
* Implemented DB, DDB, FREQUENCY, QUARTILE, and XNPV functions.
* Started the implementation of LINEST and TREND functions.
* Fixed DOLLAR, DOLLARDE, DOLLARFR, and PROB functions.
Michael:
* Added GUI for Summary Info.
* Enabled function wizard.
* Initial stab at Lotus 123: 'wk1', 'wks' import.
* Added GUI for Names.
* Better Excel string importing.
* Fix for padded number insertion ( fixes CSV import )
* Implemented ISREF, INDIRECT improved CELL
* Fixed several database functions.
* Non-relative R1C1 style references.
Jody:
* Enable Array formulas.
* Add VALUE_BOOLEAN, VALUE_ERROR, and OPER_PERCENT
* Added EOMONTH, WORKDAY, NETWORKDAYS.
* Work on functions : ROW, COLUMN, ISLOGICAL, ISERR, ISBLANK,
DATEVALUE
* Support implict intersection 'feature' of XL for functions,
NOT operators.
* Support Ctrl-Arrow movement & selection. Make moving corner of
selection visible.
* Support F4 switching between absolute and relative addressing
modes
* Reworked internal handling of absolute/relative addressing.
* Fixed cut/copy/paste to relocate relative references to only
when copying not cuting.
Jay:
* Implemented BESSELI, BESSELK completing the engineering functions.
Miguel:
* Bonobo support is working again.
* Added Moniker support for the Workbooks
* Made the Workbook a GtkObject;
* Made Workbook a GnomeContainer object
* EmbeddableGrids now can be returned from get_object to provide linking support.
* Added a signal for cell_content_changed for the speech support.
* Removed function wizard.
* Fixed locale setting and switching for file IO.
* Updated the CORBA interface for setting cell attributes.
* Killed some dead code.
* All IO code now takes an existing workbook to load information into,
rather than creating a new workbook and returning it.
* Scrolling sheet tabs.
--------------------------------------------------------------------------
Gnumeric 0.31
Jukka:
* Implemented ``Anova: Single Factor'' data analysis tool
* Implemented ``Anova: Two-Factor Without Replication'' data
analysis tool
Jody:
* Added TEXT, HYPERLINK stub, fixed OFFSET, VALUE.
* Improve handling of empty cells, and null strings. Still incomplete.
* Partial fix formating/parsing.
* Bug fixes for Excel import.
Michael:
* Implemented Summary Information
--------------------------------------------------------------------------
Gnumeric 0.30
Jukka:
* Bernoulli distribution added to Random Number Generation tool
* Finished the Rank and Percentile tool
* Lots of bug fixes and documentation updates to the data
analysis tools
Jody:
* Added TRANSPOSE(), MMULT()
* Constification.
* SplitArray exception for array formulas support.
* Better Excel emulation for insert/delete row/col menus.
Miguel:
* New font selector widget for the new gnome-print information.
Rasca:
* New EPS exporter.
--------------------------------------------------------------------------
Gnumeric 0.29
Miguel:
Added EmbeddableGrid Bonobo support for embedding graphics.
Added header/footer printing code.
Extended the CORBA interface for sheets
Added Grid corba interface
Fixed Gnumeric compilation
Include all the plugins again
Rasca Gmelch:
Troff export
Improved HTML export
Improved LaTeX export
Jukka:
- Implemented Moving Average Tool
- Started implementation of Rank and Percentile Tool
- Documented Analysis tools
Jody:
Display embedded newlines in multi-line-cells
Michael
* More improved Excel writing code
--------------------------------------------------------------------------
Gnumeric 0.28
Hello guys,
I have just released version 0.28 of Gnumeric.
This version main feature is that it adds printing support.
Starting with this release you need to install the gnome-print
package.
* Availability
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
* New Features since 0.27
* Print support (miguel)
* Improved function wizard (not yet enabled) (Michael)
*
* New Tools
* Started the implementation of Data Analysis tools (Jukka)
- Implemented Correlation and Covariance tools
- Implemented Descriptive Statistics Tool
- Implemented Sampling Tool
- Implemented t-Test Tools (paired, assuming equal variance, and
assuming unequal variance)
- Implemented z-Test Tool
- Implemented F-Test Tool
- Implemented Random Number Generation Tool with the following
distributions: Discrete, Normal, and Uniform.
* New Functions
* Added the following functions (Jukka)
- FORECAST() and INTERCEPT().
* Excel support
* Patterns now match the Excel ones (Jody)
* Improved writing code (Michael)
* Excel can load our formulas now
* Text/number work correct (Michael)
* Completed Excel color handling (Jody)
* Improved Excel format support for formulas (Jody).
* Worked on embryonic Excel chart code (Jody).
* File I/O
* Working CSV code (miguel, alan)
* Split between importers and loaders (miguel):
Importers basically lack a probing routine, so for
non-deterministic probing, we use importing instead of loading.
* HTML importer (Rasca Gmelch)
* HTML exporter (Rasca)
* Latex exporter (Rasca)
* Random improvements
* Prettified sort slightly (Michael).
* Major Bug fixes
* Pattern selector works again (miguel)
* Memory leak fixes (Morten)
* SUMIF() and N() fixed (Jukka).
* Many translations updated, thanks to our translators.
Best wishes,
Miguel.
Gnumeric 0.27
Hello guys,
New version of Gnumeric has been released. Version 0.27
The next version will most likely merge my code to do printing into
the main branch unless we decide to do a quick bug fix release. Also,
starting with this release, Gnumeric will be supported by
International GNOME Support (http://www.gnome-support.com).
Michael Meeks has redone the function definition code, it is much
better and extensible than the code we had before.
* Getting it
You can get it from:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
* What is new in this release:
Jukka:
* Added the following functions:
- FTEST(), TTEST(), SUMPRODUCT(), SEARCH(), ADDRESS(),
CHITEST(), BETAINV(), PERCENTRANK(), SERIESSUM(), SUMA(),
SUBTOTAL(), SLOPE(), AVERAGEA(), MAXA(), MINA(), STDEVA(),
STDEVPA(), VARA(), and VARPA().
* And fixed these functions:
- BETADIST(), NORMDIST(), RANK(), and POISSON().
* Lots of test files added
Morten:
* Reworked the insert/delete column/row again.
* Reworked the Goal Seek function to produce more accurate
results faster, and fail less often.
* Improved the recalculation engine.
* Shined up date calculations.
* Added WEEKDAY(), DAYS360(), TIMEVALUE().
* Fixed PROPER(), FLOOR(), SERIESSUM(), ROUND(), ROUNDUP(),
ROUNDDOWN(), ATAN2(), MOD(), INT(), COUNT(), COUNTA(),
AND(), OR().
* Improved precision here and there.
* Fixed font-reusage when writing in Gnumeric's default file
format.
* Fixed cell editing code.
* Fixed many internationalisation bugs. Translators, please
make sure the default floating-point format, "0.0########",
has been translated for your locale. (German translators,
please revisit "Zoom factor should be at least 50%" also, :-)
Miguel
* Paste-Special/Transpose.
* Bug fixing.
Sean
* Implemented 'X-base' importing support (DBase, FoxPro etc.1)
Michael
* Re-wrote the OLE block layer again...
* Re-wrote all the function code for more uniformity, lucidity
and expandibility.
* Re-wrote the function documentation.
* Tentative alpha Excel sheet writing
- StarOffice is only tested importer
- Only Excel 95 likely to 'work'
- only basic numbers and text are stored.
* Fix writing code to preserve sheet order.
Nick Lamb
* Added excel function mappings.
* Fixed absolute shared formulae cell references.
* Supplied a spreadsheet to check date functions.
Jody Goldberg
* Supplied many new error and error checking functions.
* Vastly improved Excel color loading.
* Completed Excel funtion mappings, as far as possible.
Several translations updated: thanks to our translators
And lots of bugs fixed.
Thanks to all
Miguel.
Gnumeric 0.25
Hello guys,
Gnumeric 0.25 has been released. Lots of new things are happening
in this new version, here is a list:
* User visible
* New functions: BETADIST(), FDIST(), TDIST(), CHIDIST(),
CHIINV(), GAMMAINV(), GAMMADIST() from Jukka-Pekka.
* New functions: SUMSQ(), MULTINOMIAL(), PRODUCT(), SQRTPI().
I believe these are from Jukka Pekka, but I do not see a
ChangeLog entry.
* Enhanced Excel importing code even more (Michael Meeks).
* Goal seek dialog box from Jukka-Pekka works.
* Round up bug fixed by Morten Welinder.
* Recomputation bugs for cell ranges fixed (some taxpayers
noticed that their loaded sheets were not recalculating at
startup, thanks for their input).
* User visible, not ready
* More Bonobo work. Start of graphics wizard for use with
Guppi, the GNOME plotting engine.
* Foundation work
* Integration of libglade into Gnumeric. Now we can design
our dialog boxes with Glade and use libglade to load the
GUIs. Thanks to Damon Chaplin for Glade and James
Henstridge for libglade and his support with libglade.
* Made the code use 'const' a lot more (Morten Welinder), this
helps making the code more robust.
* Not very visible
* Assorted batch of bug fixes.
* A number of memory leaks have been fixed (Morten Welinder).
* Excel loader can even restore your selection :-) (Michael
Meeks).
* A number of sanity checks from Morten Welinder.
Miguel.
Gnumeric 0.23
Hello guys!
A new version of Gnumeric has been released, version 0.23. Trained
eyes will notice that I have skipped version 0.22. Well, I did not.
I just did not announce it because I had promised not to make a new
release (which I ended up doing) because it included a pile of cool
features.
So, here is the new stuff since 0.21, major features:
* Michael Meeks added multiple-clause sort to the sort dialog.
* GNUMERIC_NORMDIST() function now uses a more efficient
method of computation (Morten Wellinder).
* Should load properly workbooks with references to other
sheets.
* Starts up with a bigger size (Michael).
* Michael has begun a function wizard, it is disabled in this
version by default.
* RAND() function.
* Fixes for some cases of circular references (the other cases
were fine), by Morten.
* IF() now can take variable arguments (Michael).
* Updated documentation
* Many small fixes.
Getting Gnumeric 0.23:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
Miguel.
Gnumeric 0.21
Hello guys,
I know, I know. Too many releases for a day.
But many good things have been done, and we want all of these
features to be available ASAP to all of you :-).
1. Morten Welinder implemented a more accurrate algorithm for
the variance functions.
2. Michael Meeks send me lots of updates and changes to Gnumeric:
a. Column Sorting.
b. Better dragging of text areas.
c. Updated documentation on writing functions.
d. Uses floats on number-entry if the number is
too large (instead of overflowing like it was doing).
e. Updated function documentation to mention optional parameters.
I promise I will be quiet now for a few days. I really do.
* Availability:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
Miguel.
Gnumeric 0.19
Hey Dudes!
New version of Gnumeric has been released.
* New in this version:
* New infrastructure to simplify writing functions
with variable arguments (Michael Meeks).
New token for ranges.
* Many new functions:
* Jukka-Pekka Iivonen contributed many finantial functions:
DOLLARDE(), DOLLARFR(), NOMINAL(), NPV(), PV(), FV(), PMT(),
IPMT(), PPMT(), NPER() and DURATION().
* Michael Meeks wrote the spreadsheet lookup functions: COLUMN(),
COLUMNS(), HLOOKUP(), ROW(), ROWS(), VLOOKLUP()
* Sean Atkinson improved SUBSTITUTE() and he implemented CONCATENATE(), REPT(), FIND(),
FIXED(), PROPER(), REPLACE(), T(), VALUE(), SUBSTITUTE(), DOLLAR()
* Jukka-Pekka wrote CEILING() and COMBIN().
* Jukka-Pekka wrote the statistical functions:
BINOMDIST(), HARMEAN (), HYPEGEOMDIST(), AVEDEV(), CONFIDENCE(), CRITBINOM(),
DEVSQ(), FISHER(), KURT(), NORMDIST(), PERMUT(), SKEW(), STANDARIZE(), WEIBULL(),
FISHERINV(), NORMSDIST() and LOGNORMDIST(), CORREL(),
COVAR(), MODE(), NEGBINOMDIST(), RANK(), TRIMMEAN().
* Michael Meekrs wrote POISSON(), DELTA(), GESTEP().
* Many bug fixes
* Daniel Veillard fixed the bug with saving cells that had the "&" inside.
* Cleanups from Michael to use the new variable arguments code.
* Various typo fixes.
* Availability:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric/gnumeric-0.19.tar.gz
Miguel.
Gnumeric 0.18
Hello guys,
New gnumeric is out.
This is mainly a bug fix release
* Features:
- More functions from Michael Meeks
- Bug fix: Applying a cell number format should work again inmediately
(it was not queuing the re-rendering operation).
- Bug fix: Precedence fixes: when decoding the tree to render a text
representation, I was not properly considering the case for
same-priority but different meaning operations.
Should work now. (ie, it will correctly decode 1/(c4*d4)
again.
- New code: integer overflow/underflow detection code. Now
addition and substraction will be promoted to floating point
values if there is a overflow in the computation.
* Availability:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric/gnumeric-0.18.tar.gz
Gnumeric 0.17
Hello guys,
New version of Gnumeric is out:
* Availability:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
* Changes and new features:
* Financial functions (effect, sln, syd) from Vladimir Vuksan.
* Engineering functions (power, gammaln, poisson, expondist,
sign, trunc) from Michael Meeks.
* Statistical functions (stdev, stdevp, var, varp, gcd,
geomean,) from Michael Meeks.
* Fixes to the clipboard code (should paste formulas to other
applications correctly and fix the inter-worbook pastes).
* External function loading works for Excel files.
* Cleaned up the Excel code (Michael)
* Should compile in AIX again.
* Documentation
* As usual, all of the Gnumeric functions are documented.
Gnumeric 0.16
Hello guys,
New version of Gnumeric is out:
* Availability:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
* Changes and new features:
* Cell ranges will work properly if they are not in their
natural order (fixes the bug reported about SUM (C1:A1) not
working and a whole range of similar problems).
* CLEAN() function fixed.
* New text exporting plugin from Takashi Matsuda.
* We use gdk_fontset_load now to load fonts instead of
gdk_font_load, this should make the code work for various
international users (Takashi).
* Entering data with XIM on the sheet should work now as well
(Takashi).
* Paste-by-value has been fixed by Takashi as well.
* cell_set_format_from_style has been speeded up by Michael
Meeks.
* Excel importer no longer has static buffers (removes various
problems reported by people) (Michael Meeks).
* Excel importing code should be significantly faster and less
verbose now (Michael Meeks).
Miguel.
Gnumeric 0.14
Hey guys!
This is the release of Gnumeric "Simplified Bonobo" 0.14.
The only difference between Gnumeric 0.13 and 0.14 is that 0.14
ships in a way that makes the install process use the documentation as
it was generated in my machine (that means, you do not need the
Docbook tools installed in your system to get the documentation).
Best wishes,
miguel.
Gnumeric 0.13
Hello guys,
I have just released Gnumeric "Superstitious Bonobo" 0.13. This
version is as usual available in:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
These are the new features in this version:
1. Excel loading is much faster now (Michael Meeks)
2. More excel sheets load now (Michael)
3. Various compilation fixes from Tim Mooney for some
strict C compilers (Digital C compiler in this case).
4. Now it recalcs cells when you have cleared values or
removed cells (just a missing call to workbook_recalc was missing).
5. Install/compile fixes from Raja Harinath.
6. Implemented new functions: "ISERROR" and "NOT".
7. Copy/paste fixes in the presence of errors in the spreadsheet.
8. Small display glitch fix.
9. Add type checking to functions that take a constant number of arguments.
10. Upper case format letters are now accepted.
Enjoy!
Miguel.
Gnumeric 0.12
Hello,
New Gnumeric version, this is the miguel-will-be-out-until monday
release of Gnumeric, I will be visiting Boston, so if you are in the
area we could probably meet.
New features:
- New function TRUNC
- Excel loading: Michael Meeks and Sean did lots of work again
on improving our Excel importer.
- Internal fix that the Excel code was hitting.
- Fixes the menu for the quick operations (on the workbook)
- Fix to the rename-sheet function (it was displaying garbage
sometimes)
- Brunno finished the support for coloring the background of
cells, so now we can have nicely colored sheets with nice
backgrounds :-)
- He also finished the foreground setting color code. Thanks!
- Now it warns if you drop a range of cells in a region that
already has values.
- Should include the missing files for the Perl plugin.
- CSV code disabled until it is fixed.
- Stricter control for removing active sheets in the code.
- Michael provided an icon for Excel files.
- Contributed Spanish documntation from Pablo.
You can get this at:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
Best wishes,
Miguel.
Gnumeric 0.11
Hello,
I have released a new version of Gnumeric, pretty much a bug fix
over the Numerically Skillfully Cow release of Gnumeric.
Thanks to all of you who send me good bug reports, here is a list
of the bugs fixed and improvements:
- Excel loading code improved again by Michael Meeks. He also
spotted a number of bugs in the code which were fixed.
- Paste was not properly recomputing formulas pasted.
- Gnumeric no longer crashes on save.
- Dependecy computation code got fixed. Horribly typo was
doing all sorts of nonsense ;-)
Fetch it from:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric/gnumeric-0.11.tar.gz
Miguel.
Gnumeric 0.10
Hello number lovers,
I have released the Numerically Skillfully Cow release of the
Gnumeric Spreadsheet.
New in this version:
* Many updates on the Excel side, optimizaitons, bug fixes,
more features supported (Michael Meeks, Sean Atkinson).
* Support for adding/removing sheets on the notebook tabs
* A small draw fix (g's, j's and y's are no longer cropped).
* Mime types for Excel files are shipped (but no gnome icon
for XL files yet).
* Fixes to the CVS loader (Vincent Renardias).
* Perl plugin is shipped again.
You can get this from:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
Happy sums,
Miguel.
Gnumeric 0.8
Hello guys,
Gnumeric "International Manatee" 0.8 has been released.
This version is available in:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric-0.8.tar.gz
The most important change in International Manatee is the fact that
the documentation that Adrian Likins wrote is now integrated into the
build system. It gets installed and we feature a reference guide for
the internal Gnumeric functions.
These are the features of International Manatee:
- Bruno enabled the coloring page for setting the foreground
color.
- The sheet label name works properly now (it no longer
"slides").
- Correct behaviour of clicking in the presence of editing the
sheet label name.
- Guile support now needs to be explicitly configure
(--with-guile).
- Fix crashing problems repoted when autofilling.
- Documentation is included in the tarball (You need DocBook
if you plan on extending the documentation or fixing my
ugly, ugly, ugly stuff :-). You can find Docbook here:
ftp://ftp.cygnus.com/pub/home/rosalia/docware.
A docbook tutorial is available in:
http://nis-www.lanl.gov/~rosalia/mydocs/docbook-intro.html
The full docbook documentation can be downloaded for free
from the Davenport site (I lost the url to this, but I am
confident all of you documentation-savvy people are good
at altavistaing things).
Enjoy,
Miguel.
Gnumeric 0.7
Hello guys,
Gnumeric "Speedy Manatee" 0.7 has been released.
This version is available in:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric-0.7.tar.gz
The highlights of this version are:
New features dept:
- References to other sheets works, you can use this like this:
=Sheet!A1+1
='Regional sales'!C5*3
- New border code. Getting ready to print the borders on the
cells.
- Menu hints are now available for every menu entry.
- Standarized the menus (Nat Friendman).
- Use the statusbar in the code now.
- You can now rename your sheets by double clicking on the
tabs and typing the new name. How excelish!
Enhancements dept:
- Excel importing code has been enhanced by Michael Meeks and
Nick Lamb.
- When inserting/moving columns or rows, the cells moved now
do not change their formulas (to keep the sheet working).
Bug fixes dept:
- Better default decimal formats
- Page flipping works correctly if you press on the tab names.
- Child dialog boxes no longer ignore keystrokes (in
save/load).
- Fixed the memory leaks on the Excel plugin (Michael).
- Provide better error checking for dates (Havoc Pennington)
Enjoy,
Miguel.
Gnumeric 0.5
Hello guys,
I have just released a new version of Gnumeric (gnumeric-0.5), this
version is available in:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric-0.5.tar.gz
The highlights of this version are:
- A pluggable framework for file formats. No need to hack the
code to add your file loader anymore, routines are provided
to register file loading and saving formats.
- (bug fix) Fixed the broken storage setup I introduced in the
previous version. This means that files are now correctly
loaded and that if an expression renders an error you will
still be able to access the information you stored.
Enjoy this new version,
Miguel
Gnumeric 0.4
From miguel Wed Dec 16 23:16:34 -0600 1998
From: Miguel de Icaza <miguel@nuclecu.unam.mx>
To: gnumeric-list@gnome.org
Subject: New version of Gnumeric has been released.
X-Lost: In case of doubt, make it sound convincing
Hello guys,
A new version of Gnumeric has been released as part of the GNOME
libraries code freeze.
I have not been very active the last two months in Gnumeric due to
the freezing of GNOME (I worked a lot on the file manager issues), but
I will soon be back working in the spreadsheet.
Michael Meeks and Bruno Unna did an awesome job while I was doing
this: They added Excel file importing. That is all I can say. Some
stuff is missing, yes, it will get added, yes.
During the last few weeks Morten Welinder has been reviewing the
Gnumeric code and making very good suggestions to the coding style as
well as making sure we keep Gnumeric in a nice way. I am very
thankful for his input.
Jakub Jelinek made the scrolling code be smarter than my previous
attempt at scrolling, it is now definetly usable.
Code for attaching notes to cell is completely on the code. The
only problem is that right now comment is hardcoded in the source
code. We need a nice dialog box for this.
Mark Probst added some Guile support (this as well as the other
plugins is completely optional), some neat things can be done with it,
make sure you check the distribution directory.
Exponentiation has been implemented (all the code was there, I just
had forgotten to add the line to the grammar).
Some more architectural work has been going on: named-cell range
code is there (not finished but there). Also, some code for
referencing the cells in other sheets or workbook is there.
I still need to figure out a way to encode this into the
expression. I would appreciate any input on this issue: There are
various possible solutions, one of the is creating a special OP_ that
would represent a lookup into an non-local sheet. The other is to
define this as a function and finally, it could be done as a special
cell type.
Also, I have dropped the "entered_text" information I kept on the
cell. Now the cell value is stored either as a value or as an
expression tree and decoded when the user requires it. This was
required for a number of things (one of them being a nicer way to
share cell expressions during copying, and for the excel format and
the autofill code got definetly simpler and more maintainable).
Various display and scrolling glitches were fixed as well. But in
the process, I somehow broke the object-drawing code. I have not
researched this yet.
The initial support for CORBA is in, but it does not actually do
anything, it is just the setup for launching the Gnumeric server.
Owen Taylor made Gnumeric accept dragged files, you can now drag files
from the file manager into the spreadsheet, on this topic: the date
routiens now use GLib's gdate instead of the gnome-libs libDate
routines.
You can fetch it from:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric-0.4.tar.gz
Enjoy,
Miguel.
|