Issue Name |
Description |
Status |
col-row-range |
The COLUMNS and ROWS functions give the wrong result for ranges. |
Open 2007-07-18 |
index-bugs |
The INDEX function does not operate correctly for many cases, including involving 0 or missing rows and columns. |
Open 2007-07-18 |
sheetname-adj |
Sheetnames that are cell coordinates (e.g, A5!B3) are not adjusted correctly in insert/delete/paste. |
Open 2007-07-18 |
scroll-csss |
When scrolling back up, returning rows do not show explicit CSS correctly -- line 668 of WKCjs.txt does not take new Live View Modifiable flag into account. |
Open 2007-07-18 |
clear-contents-ok |
Pressing the OK button when editing, and some other cases, does not clear the cmdedit value, so additional typing in the cell after pressing OK gets added to the old rather than overwriting it. |
Open 2007-07-18 |
header-3px |
The selectedcolname and selectedrowname CSS values while editing have 3 pixel borders that should not be there (hold over from old code). This results in a little glitch on the screen next to the headers sometimes. |
Open 2007-07-18 |
product-type |
The product, var, and stdev and related functions use the sum function's method for determining result type. They should just return plain numeric. |
Open 2007-07-18 |
sort-utf8 |
The Sort command does not handle UTF-8 - it just assumes bytes. |
Open 2007-07-18 |
name-needsrecalc |
Code issue: The "name" command does not set the "needsrecalc" value. |
Open 2007-07-18 |
wkchttp-stack |
Calls to wkcHTTP with the optional error value missing caused the program to terminate |
Fixed in 1.0 |
no-loadsheet-list |
When you use the Load From Sheet command, the list of pages to copy from doesn't work and there are Javascript errors on the page. The WKCloadsheetjs.txt file was missing in this build. |
Fixed in 1.0 |
cssc-special-cases |
The Cell CSS Class setting is output incorrectly in a variety of places. It has an "s" as a prefix in some cases and in some embedding cases is not put in the output. |
Fixed in 0.97 |
load-0-ntvf |
Loading the clipboard from another sheet that has a new numeric format of "0" lost that setting for cells. (A common Perl-related coding mistake...) A related bug is that the numeric format of "0" was not being saved as the global default numeric format. (Setting "0" individually -- the format that looks like "1234" -- has been working correctly and was coded appropriately apparently.) |
Fixed in 0.97 |
line-if-nl |
The line-if HTML template commands delete the line break when the tested condition is false. If multiple line-if commands are on one line this can cause extra lines to be inappropriately deleted. This happens with the standard templates if editurl is not provided, which will inappropriately delete the </span> in the footer. |
Fixed in 0.97 |
edit-27-col |
The editing code often has problems when moving the cursor into rows AA and above. There is a bug in the Javascript code. (WKCjs.txt line 66 should have colhigh not collow.) It is best not to edit or format cells in columns AA and above until this is fixed. |
Fixed in 0.97 |
copy-no-log |
Copying a page does not add an entry to the log about the copying. It just starts off where it was last edited without a new log. |
Fixed in 0.97 |
no-mod-author |
Publishing a page after opening it for edit but not modifying it does not change the author attribution |
Fixed in 0.97 |
login-etpurl |
The resume URL from Edit This Page is not saved across a login. |
Fixed in 0.97 |
cgi-lost-cookie |
Running with wikicalccgi.pl and wikicalcmodperl.cgi with a login that is supposed to only be saved for the browser session (as opposed to even after browser quit) may actually not save the cookie information at all. This makes it forget login information. This is mostly a problem for Live View and Edit This Page -- direct access to wikiCalc also saves that data in form fields. |
Fixed in 0.97 |
clipboard-constant |
Values that are entered in the special forms that are converted to numbers (like 3%, 1/2/2006) and stored as "constants" with value and editing representation (not as part of a formula) are not loaded correctly when a saved file is read in for edit. This only applies to such value stored on the clipboard. |
Fixed in 0.96 |
utf-8-handling |
Characters outside of the 96 ASCII ones may have issues. Currencies other than US dollars are not handled. Date/time and thousands separator variations are not implemented yet. |
Fixed in 0.95 |
publish-wrong |
There were cases where publishing from the Page tab of the page you were not editing published the editing page over it instead. This was fixed in the releases after June 9 2am. A retrieved backup would recover the prior version correctly so only the last edits were lost. |
Fixed in 0.91 |
backup-slow-list |
The Tools Backups command can be very slow when it has to go to the server for information when running locally on your PC and the published files are not also resident on your PC. |
Open 2006-06-08 |
csv-newlines |
Importing and exporting csv files may not handle embedded new lines correctly |
Open 2006-06-08 |
ftp-timeouts |
If an FTP operation times out, it can sometimes crash wikiCalc |
Open 2006-06-08 |
reload-reset |
If you press the Reload button on the Page tab when you are not connected to a remote server, the status of the pages may be wiped out until you connect. If you are editing off-line, do not press this button nor attempt to publish. |
Open 2006-02-23 |
ins-col-width |
Inserting or deleting a column does not appropriately update column widths -- they are left unmodified and not inserted/deleted. You have to manually do the effect by changing column widths explicitly until this is fixed. |
Fixed in 0.3 |
edit-this-page1 |
There are a variety of problems with the Edit This Page code. Wait for the next release to try this feature. When working, you should be able to click on an "Edit This Page" link in the HTML results of a published page and be taken right into the wikiCalc editing system editing that page (with a login prompt, if necessary). |
Fixed in 0.91 |
registered-sites |
You can set a list of registered sites that should restrict the sites a logged in user may edit. The list is remembered but it is ignored on editing. |
Fixed in 0.91 |
firefox-mixup |
In some cases, Firefox seems to get confused when rendering the sheet while editing certain cells. Selecting the same cells in IE or Opera do not seem to have the same problem. Perhaps the HTML is bad. |
Hopefully better or fixed in 0.3 |
merge-extend |
When you merge cells and the merge includes a cell beyond the current limits of the sheet (a couple columns and several rows are always shown) the sheet limit is not updated so the merge may not work right. |
Fixed in 0.2 |
browser-text-cursor |
On the Cells tab when using IE (and Opera and Safari) the typing text cursor is not positioned at the end of the field as you would hope. Firefox works fine. This problem makes editing clunky when using those browsers as you constantly have to move the cursor to the end of a field especially when using the formula short-cut of clicking on a cell to enter its address. |
Fixed in 0.2 |
cells-autocomplete |
The browser-provided autocomplete dropdown on the value entry field of the Cells tab covers the buttons and perhaps help text below. Autocomplete should be off for that field. |
Fixed in 0.2 |
too-far-delete |
If you delete rows or columns past the current extent of the sheet (i.e. blank cells past the cells with actual data and/or explicit cell-level formatting) sometimes extent of the sheet was made smaller so that the last existing rows or columns were deleted in the saved data instead of just the blank phantom rows. This would not be noticed until a subsequent redisplay of the data was reloaded from that saved data (usually one or two clicks later). |
Fixed in 0.2 |
blank-cell-erase |
Blanking out the contents of a cell removes formatting too. Work-around for now: Use Edit Erase with Values and Formulas selected. |
Fixed in 0.2 |
space-is-zero |
A cell with just a space character is sometimes treated (and displayed) as a zero. |
Fixed in 0.2 |
| | |