CVS log for loncom/interface/spreadsheet/Spreadsheet.pm
Up to [LON-CAPA] / loncom / interface / spreadsheet
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
Current tag: MAIN
Revision 1.85: download - view: text, markup, annotated - select for diffs
Sun Apr 6 18:59:20 2014 UTC (10 years, 4 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_12_X,
version_2_11_X,
version_2_11_5_msu,
version_2_11_5,
version_2_11_4_uiuc,
version_2_11_4_msu,
version_2_11_4,
version_2_11_3_uiuc,
version_2_11_3_msu,
version_2_11_3,
version_2_11_2_uiuc,
version_2_11_2_msu,
version_2_11_2_educog,
version_2_11_2,
version_2_11_1,
version_2_11_0_RC3,
version_2_11_0,
HEAD
Diff to previous 1.84: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.84: +2 -2
lines
- Fix spelling.
Revision 1.84: download - view: text, markup, annotated - select for diffs
Fri Feb 28 19:20:11 2014 UTC (10 years, 5 months ago) by bisitz
Branches: MAIN
Diff to previous 1.83: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.83: +2 -2
lines
Fix wording typos
Revision 1.83: download - view: text, markup, annotated - select for diffs
Wed Feb 12 16:54:21 2014 UTC (10 years, 6 months ago) by bisitz
Branches: MAIN
Diff to previous 1.82: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.82: +12 -10
lines
- Internationalization: Added missing &mt() calls
- XHTML
- Standard styles
Revision 1.82: download - view: text, markup, annotated - select for diffs
Fri Aug 9 17:58:15 2013 UTC (11 years ago) by raeburn
Branches: MAIN
CVS tags: version_2_11_0_RC2,
version_2_11_0_RC1
Diff to previous 1.81: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.81: +6 -4
lines
- Bug 6639
- cells previously populated, but now updated to contain nothing, are skipped
when cell contents are retrived using &get_values().
- Spreadsheet functions: &NUM(), &BIN(), &SUM(), &MEAN, &STDDEV(), &PROD()
&MAX(), &MIN(), &SUMMAX, &SUMMIN() all call &get_values().
Revision 1.81: download - view: text, markup, annotated - select for diffs
Wed Dec 16 13:00:53 2009 UTC (14 years, 8 months ago) by bisitz
Branches: MAIN
CVS tags: version_2_9_99_0,
version_2_10_X,
version_2_10_1,
version_2_10_0_RC2,
version_2_10_0_RC1,
version_2_10_0,
loncapaMITrelate_1,
language_hyphenation_merge,
language_hyphenation,
bz6209-base,
bz6209,
PRINT_INCOMPLETE_base,
PRINT_INCOMPLETE,
BZ4492-merge,
BZ4492-feature_horizontal_radioresponse
Diff to previous 1.80: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.80: +8 -4
lines
Error messages:
- Reuse existing phrases; consistent wording
- Adjusted translation files de, es, zh
- Added error style
Revision 1.80: download - view: text, markup, annotated - select for diffs
Fri Sep 12 14:35:46 2008 UTC (15 years, 11 months ago) by bisitz
Branches: MAIN
CVS tags: version_2_9_X,
version_2_9_1,
version_2_9_0,
version_2_8_X,
version_2_8_99_1,
version_2_8_99_0,
version_2_8_2,
version_2_8_1,
version_2_8_0,
version_2_7_X,
version_2_7_99_1,
version_2_7_99_0,
version_2_7_1,
bz5969,
bz2851,
GCI_3,
GCI_2,
GCI_1,
BZ5971-printing-apage,
BZ5434-fox
Diff to previous 1.79: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.79: +4 -4
lines
Wording: "CSV" (comma separated values) everywhere uppercase
Revision 1.79: download - view: text, markup, annotated - select for diffs
Thu Sep 11 14:47:22 2008 UTC (15 years, 11 months ago) by bisitz
Branches: MAIN
Diff to previous 1.78: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.78: +4 -4
lines
Past tense of "occur" is "occurred" (rr!)
Also added some missing &mt() calls and corrected some other little typos
Revision 1.78: download - view: text, markup, annotated - select for diffs
Wed Mar 12 02:45:27 2008 UTC (16 years, 5 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_7_0,
version_2_6_99_1,
version_2_6_99_0
Diff to previous 1.77: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.77: +5 -5
lines
Change arguments accepted by lonnet::appenv() to:
1. reference to hash
2. (optional) reference to array.
Change all instances where lonnet::appenv() is called to replace first argument passed (originally a hash) to a reference to the hash.
- Modify lonnet.pm rev 1.35 code intended to prevent "dangerous" modifications of the environment, so it will actually do this.
- Allow these modifications to be made in certain instances:
DC switching to adhoc role
CC switching to a different course role in the current course.
user self-enrolling as a student
Revision 1.77: download - view: text, markup, annotated - select for diffs
Tue Jan 23 18:22:47 2007 UTC (17 years, 7 months ago) by albertel
Branches: MAIN
CVS tags: version_2_6_X,
version_2_6_3,
version_2_6_2,
version_2_6_1,
version_2_6_0,
version_2_5_X,
version_2_5_99_1,
version_2_5_99_0,
version_2_5_2,
version_2_5_1,
version_2_5_0,
version_2_4_X,
version_2_4_99_0,
version_2_4_2,
version_2_4_1,
version_2_4_0,
version_2_3_99_0
Diff to previous 1.76: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.76: +6 -8
lines
- if you change any sheets we'll need to expire it, not just the default one
Revision 1.76: download - view: text, markup, annotated - select for diffs
Tue Jan 23 02:14:18 2007 UTC (17 years, 7 months ago) by albertel
Branches: MAIN
Diff to previous 1.75: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.75: +6 -6
lines
- tabination
Revision 1.75: download - view: text, markup, annotated - select for diffs
Tue Jan 23 01:48:16 2007 UTC (17 years, 7 months ago) by albertel
Branches: MAIN
Diff to previous 1.74: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.74: +16 -1
lines
- add a &PARM() routine to SPRS
- document &PARM(), &MAXPARM(), &MINPARM()
Revision 1.74: download - view: text, markup, annotated - select for diffs
Tue Jan 23 01:36:26 2007 UTC (17 years, 7 months ago) by albertel
Branches: MAIN
Diff to previous 1.73: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.73: +5 -5
lines
- allow [&EXPANDSUM()] to span lines
Revision 1.73: download - view: text, markup, annotated - select for diffs
Tue Jan 23 01:29:15 2007 UTC (17 years, 7 months ago) by albertel
Branches: MAIN
Branch point for: version_2_3_X
Diff to previous 1.72: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.72: +3 -1
lines
- uniqueify the list parms so they don't substituted multiple times
Revision 1.72: download - view: text, markup, annotated - select for diffs
Sun Sep 3 00:54:05 2006 UTC (17 years, 11 months ago) by albertel
Branches: MAIN
CVS tags: version_2_3_1,
version_2_3_0,
version_2_2_X,
version_2_2_99_1,
version_2_2_99_0,
version_2_2_2,
version_2_2_1
Diff to previous 1.71: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.71: +2 -2
lines
- login was backwards
Revision 1.71: download - view: text, markup, annotated - select for diffs
Sun Sep 3 00:45:51 2006 UTC (17 years, 11 months ago) by albertel
Branches: MAIN
Diff to previous 1.70: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.70: +20 -16
lines
- wasn't properly defaulting to the standard system spreadsheets when
accessing the SPRS for the first time
- add ability to reset a SPRS back to the system standard ones
Revision 1.70: download - view: text, markup, annotated - select for diffs
Sun Sep 3 00:39:57 2006 UTC (17 years, 11 months ago) by albertel
Branches: MAIN
Diff to previous 1.69: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.69: +4 -4
lines
- replacing incorrect E-oh-FFDD with E-zero-FFDD
Revision 1.69: download - view: text, markup, annotated - select for diffs
Tue May 30 12:46:26 2006 UTC (18 years, 2 months ago) by www
Branches: MAIN
CVS tags: version_2_2_0,
version_2_1_99_3,
version_2_1_99_2,
version_2_1_99_1,
version_2_1_99_0
Diff to previous 1.68: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.68: +8 -5
lines
&Apache::lonnet::unescape -> &unescape
&Apache::lonnet::escape -> &escape
Revision 1.68: download - view: text, markup, annotated - select for diffs
Mon May 1 06:17:16 2006 UTC (18 years, 3 months ago) by raeburn
Branches: MAIN
Diff to previous 1.67: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.67: +7 -10
lines
Determination of parameters for spreadsheet now correctly cascades for cases where a user has multiple active groups. Also groups are passed in argument list for Spreadsheet object as array reference. Lastly lonnet::get_users_groups function modified to only return user's active groups, except in case when user status has expired (and default end access date for students has also passed), in which case user's groups which were still active less than 24 hours before default end date are also included in user's groups. [For consistency with students groups returned by loncoursedata::get_students_groups()].
Revision 1.67: download - view: text, markup, annotated - select for diffs
Thu Apr 6 20:24:13 2006 UTC (18 years, 4 months ago) by raeburn
Branches: MAIN
Diff to previous 1.66: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.66: +12 -2
lines
Making group-based parameters apply in spreadsheet, using same cascading precedence scheme as used for parmset.
Revision 1.66: download - view: text, markup, annotated - select for diffs
Thu Apr 6 16:43:49 2006 UTC (18 years, 4 months ago) by albertel
Branches: MAIN
Diff to previous 1.65: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.65: +7 -2
lines
- #self->{'section'} never got set
Revision 1.65: download - view: text, markup, annotated - select for diffs
Sun Mar 5 21:38:27 2006 UTC (18 years, 5 months ago) by bowersj2
Branches: MAIN
Diff to previous 1.64: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.64: +3 -5
lines
Correct extremely low-quality submit.
Revision 1.64: download - view: text, markup, annotated - select for diffs
Sun Mar 5 21:35:10 2006 UTC (18 years, 5 months ago) by bowersj2
Branches: MAIN
Diff to previous 1.63: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.63: +6 -4
lines
Add parentheses around the result generated by EXPANDSUM.
Revision 1.63: download - view: text, markup, annotated - select for diffs
Mon Feb 27 19:36:20 2006 UTC (18 years, 5 months ago) by albertel
Branches: MAIN
Diff to previous 1.62: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.62: +3 -5
lines
- style police
Revision 1.62: download - view: text, markup, annotated - select for diffs
Mon Feb 27 00:56:47 2006 UTC (18 years, 5 months ago) by bowersj2
Branches: MAIN
Diff to previous 1.61: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.61: +28 -7
lines
Fix bug 4556 by introducing the ability to just view the source of the
spreadsheet, without any computation at all.
Revision 1.61: download - view: text, markup, annotated - select for diffs
Tue Jan 10 16:38:47 2006 UTC (18 years, 7 months ago) by albertel
Branches: MAIN
Diff to previous 1.60: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.60: +5 -3
lines
- allowing EXT to take a symb
Revision 1.60: download - view: text, markup, annotated - select for diffs
Thu Dec 8 02:22:15 2005 UTC (18 years, 8 months ago) by albertel
Branches: MAIN
CVS tags: version_2_1_X,
version_2_1_3,
version_2_1_2,
version_2_1_1,
version_2_1_0,
version_2_0_99_1
Diff to previous 1.59: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.59: +2 -2
lines
- when spcifying rows with the * don't include the 0th row
Revision 1.59: download - view: text, markup, annotated - select for diffs
Tue Dec 6 06:04:49 2005 UTC (18 years, 8 months ago) by albertel
Branches: MAIN
Diff to previous 1.58: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.58: +2 -2
lines
- stupid typo bug
Revision 1.58: download - view: text, markup, annotated - select for diffs
Thu Oct 13 10:27:28 2005 UTC (18 years, 10 months ago) by albertel
Branches: MAIN
Diff to previous 1.57: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.57: +2 -2
lines
- sigh
Revision 1.57: download - view: text, markup, annotated - select for diffs
Wed Oct 12 21:48:32 2005 UTC (18 years, 10 months ago) by albertel
Branches: MAIN
CVS tags: version_2_0_X
Diff to previous 1.56: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.56: +26 -18
lines
- wasn't updating the internal memory spreadsheet cache when saving to the external remote spreadsheet cache, now both stay in sync
Revision 1.56: download - view: text, markup, annotated - select for diffs
Thu Sep 1 21:52:56 2005 UTC (18 years, 11 months ago) by albertel
Branches: MAIN
CVS tags: version_2_0_2,
version_2_0_1
Diff to previous 1.55: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.55: +3 -11
lines
- no need to make the round trip since the env is no correct
Revision 1.55: download - view: text, markup, annotated - select for diffs
Thu Sep 1 21:47:14 2005 UTC (18 years, 11 months ago) by albertel
Branches: MAIN
Diff to previous 1.54: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.54: +5 -1
lines
- when changing the course env, need to also change the local users session environment
Revision 1.54: download - view: text, markup, annotated - select for diffs
Fri Aug 26 20:46:46 2005 UTC (19 years ago) by albertel
Branches: MAIN
Diff to previous 1.53: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.53: +24 -12
lines
- fixes bug #4296 spreadsheet can't be edited
Revision 1.53: download - view: text, markup, annotated - select for diffs
Wed Aug 24 18:14:47 2005 UTC (19 years ago) by albertel
Branches: MAIN
Diff to previous 1.52: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.52: +5 -3
lines
- BUG#4287
Revision 1.52: download - view: text, markup, annotated - select for diffs
Thu Jun 23 17:55:01 2005 UTC (19 years, 2 months ago) by albertel
Branches: MAIN
CVS tags: version_2_0_0,
version_1_99_3,
version_1_99_2,
version_1_99_1,
version_1_99_0
Diff to previous 1.51: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.51: +9 -3
lines
- BUG#4151 - spread on brand new course would fail to work
Revision 1.51: download - view: text, markup, annotated - select for diffs
Tue May 17 20:17:03 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
CVS tags: version_1_99_1_tmcc
Diff to previous 1.50: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.50: +12 -5
lines
- cache the parses of the formulas when there are alot of %f it can take a while to parse through them
Revision 1.50: download - view: text, markup, annotated - select for diffs
Sun May 15 04:55:33 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
Diff to previous 1.49: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.49: +2 -2
lines
- err need to set filename in new
Revision 1.49: download - view: text, markup, annotated - select for diffs
Sun May 15 04:49:42 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
Diff to previous 1.48: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.48: +14 -10
lines
- only load the sprs once we actually need it (since if we have it cached no need to load it)
Revision 1.48: download - view: text, markup, annotated - select for diffs
Sun May 15 04:02:17 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
Diff to previous 1.47: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.47: +2 -9
lines
- no reason to expose the home server of either the course or the course
Revision 1.47: download - view: text, markup, annotated - select for diffs
Fri May 13 21:16:09 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
Diff to previous 1.46: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.46: +3 -3
lines
- @os and $f seem to be unused, commenting them out for now (save 0.03 seconds on the student level sheet)
Revision 1.46: download - view: text, markup, annotated - select for diffs
Fri May 13 21:14:46 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
Diff to previous 1.45: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.45: +11 -10
lines
- minimizing the number of elments in %t, and moving sheet_values to be out int Spreadsheet not in the safe space (student level sheet not taking aroun 0.5 seconds to compute)
Revision 1.45: download - view: text, markup, annotated - select for diffs
Fri May 13 15:59:07 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
Diff to previous 1.44: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.44: +47 -101
lines
- elminates the use of
grep eval(/$re/) keys(%sheet_values)
which was a very slow operation
Revision 1.44: download - view: text, markup, annotated - select for diffs
Thu May 12 22:42:57 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
Diff to previous 1.43: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.43: +58 -42
lines
- converting everything to use &get_values instead which right now does the grep
Revision 1.43: download - view: text, markup, annotated - select for diffs
Fri Apr 29 18:13:07 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
Diff to previous 1.42: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.42: +3 -3
lines
- forward port 1.37.2.2
Revision 1.42: download - view: text, markup, annotated - select for diffs
Thu Apr 21 17:29:16 2005 UTC (19 years, 4 months ago) by albertel
Branches: MAIN
Diff to previous 1.41: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.41: +3 -2
lines
- don't put empty cells in the spreadsheet
Revision 1.41: download - view: text, markup, annotated - select for diffs
Thu Apr 7 06:56:23 2005 UTC (19 years, 4 months ago) by albertel
Branches: MAIN
CVS tags: version_1_99_0_tmcc
Diff to previous 1.40: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.40: +31 -31
lines
- ENV -> env
Revision 1.40: download - view: text, markup, annotated - select for diffs
Thu Mar 10 17:33:57 2005 UTC (19 years, 5 months ago) by matthew
Branches: MAIN
Diff to previous 1.39: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.39: +8 -31
lines
Updated to use loncommon::create_workbook. Spreadsheets were slightly
modified to use formats.
Revision 1.39: download - view: text, markup, annotated - select for diffs
Thu Mar 3 17:52:36 2005 UTC (19 years, 5 months ago) by matthew
Branches: MAIN
Diff to previous 1.38: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.38: +4 -1
lines
Changed to use navmaps.
Revision 1.38: download - view: text, markup, annotated - select for diffs
Thu Feb 3 23:59:41 2005 UTC (19 years, 6 months ago) by matthew
Branches: MAIN
Diff to previous 1.37: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.37: +26 -3
lines
Safe space changes
Fix &EXT routine by including all appropriate context information (symb,
name, domain, section).
Fixed bug in which the symb was not actually available in the safe space
(used 'usymb' instead of 'symb' to denote the symb).
Revision 1.37: download - view: text, markup, annotated - select for diffs
Wed Mar 31 05:24:00 2004 UTC (20 years, 4 months ago) by albertel
Branches: MAIN
CVS tags: version_1_3_3,
version_1_3_2,
version_1_3_1,
version_1_3_0,
version_1_2_X,
version_1_2_99_1,
version_1_2_99_0,
version_1_2_1,
version_1_2_0,
version_1_1_99_5,
version_1_1_99_4,
version_1_1_99_3,
version_1_1_99_2,
version_1_1_99_1,
version_1_1_99_0
Branch point for: version_1_3_X
Diff to previous 1.36: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.36: +3 -3
lines
- trying to be UTF8 transparent
Revision 1.36: download - view: text, markup, annotated - select for diffs
Tue Feb 24 20:47:14 2004 UTC (20 years, 6 months ago) by matthew
Branches: MAIN
CVS tags: version_1_1_X,
version_1_1_3,
version_1_1_2
Diff to previous 1.35: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.35: +7 -1
lines
These fixes should go on S10 as soon as possible.
Spreadsheet.pm: Fix to handle the case when a spreadsheet object is
created without a valid username/domain passed to new().
assesscalc.pm: Fix to ignore stored data which does not contain the username
and domain.
lonspreadsheet.pm: Fix to not do stupid things that got us in this mess
in the first place (only accept form parameters which have values and do not
send out form parameters without values).
Revision 1.35: download - view: text, markup, annotated - select for diffs
Tue Feb 24 17:02:04 2004 UTC (20 years, 6 months ago) by albertel
Branches: MAIN
Diff to previous 1.34: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.34: +1 -4
lines
- don't study expressions
Revision 1.34: download - view: text, markup, annotated - select for diffs
Thu Jan 15 21:20:07 2004 UTC (20 years, 7 months ago) by matthew
Branches: MAIN
Diff to previous 1.33: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.33: +4 -5
lines
Fix to xml output of template cells.
Revision 1.33: download - view: text, markup, annotated - select for diffs
Wed Jan 14 16:47:39 2004 UTC (20 years, 7 months ago) by matthew
Branches: MAIN
CVS tags: version_1_1_1
Diff to previous 1.32: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.32: +14 -5
lines
Fix loading of spreadsheet xml from published space. Commented out code
for xml output and fixed some for xml output. For inclusion in 1.1.x.
Revision 1.32: download - view: text, markup, annotated - select for diffs
Mon Dec 8 19:43:03 2003 UTC (20 years, 8 months ago) by matthew
Branches: MAIN
CVS tags: version_1_1_0,
version_1_0_99_3,
version_1_0_99_2,
version_1_0_99_1
Diff to previous 1.31: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.31: +9 -1
lines
Report errors in calculation even when outputing in Excel or CSV format.
Revision 1.31: download - view: text, markup, annotated - select for diffs
Fri Nov 21 21:51:28 2003 UTC (20 years, 9 months ago) by matthew
Branches: MAIN
CVS tags: version_1_0_99
Diff to previous 1.30: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.30: +40 -12
lines
Added new output mode at the course level. It just displays the
students with a link to their spreadsheet. Reworked how output options
are handled to be able to vary them by spreadsheet. Reworked some confusing
(to me) localization code.
Revision 1.30: download - view: text, markup, annotated - select for diffs
Mon Nov 17 19:55:41 2003 UTC (20 years, 9 months ago) by matthew
Branches: MAIN
Diff to previous 1.29: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.29: +57 -2
lines
Fix bug in error reporting where errors in computation of the spreadsheet
were not reported and bad cache values were stored away.
Added in Spreadsheet: &set_badcalc, &badcalc, &set_calcerror, &calcerror,
and &html_report_error. These are used to keep track of computation errors
and to report them to the user. The &save_export_data routines were all
modified to not store data when an error has occured.
Revision 1.29: download - view: text, markup, annotated - select for diffs
Tue Nov 11 14:17:20 2003 UTC (20 years, 9 months ago) by matthew
Branches: MAIN
Diff to previous 1.28: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.28: +2 -2
lines
fix broken html
Revision 1.28: download - view: text, markup, annotated - select for diffs
Sat Oct 11 14:04:54 2003 UTC (20 years, 10 months ago) by www
Branches: MAIN
Diff to previous 1.27: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.27: +13 -12
lines
Internationalize and fix "seperate".
Revision 1.27: download - view: text, markup, annotated - select for diffs
Tue Sep 16 15:36:32 2003 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.26: preferred, unified
Changes since revision 1.26: +6 -1
lines
More sanity checking in &mask.
Revision
1.26:
download - view:
text,
markup,
annotated -
[selected for diffs]
Mon Sep 15 20:31:01 2003 UTC (20 years, 11 months ago) by
matthew
Branches:
MAIN
Diff to previous 1.25:
preferred,
unified
Changes since revision 1.25: +62 -72
lines
Complete rewrite of &mask to return more correct regular expressions.
This is to fix a bug where &mask("X15","X24") would return ^[X-X][5-4]$.
Now it returns ^[X-X](\d+)(?(?{$1>= 15 && $1<=24})|donotmatch)$, which is
actually clearer although it does not appear so at first glance. A comment
was added to &mask to explain the regular expression.
POD documented &mask, added a debugging helper, and modified all of the
calls to &mask to wrap its result in an eval as such complexities require
using an eval. I would reference a bug here but bugzilla is down.
Revision 1.25: download - view: text, markup, annotated - select for diffs
Fri Sep 12 18:59:48 2003 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.24: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.24: +22 -13
lines
All sheets use the same safe space. Tested, seems to work in basic cases.
Requires more testing.
Revision 1.24: download - view: text, markup, annotated - select for diffs
Mon Sep 8 20:32:22 2003 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.23: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.23: +3 -3
lines
There are downsides to making warnings fatal:
my %tmphash = &Apache::lonnet::dump(blah) crashes if the file does not
exist. Not good. I don't feel like detecting this right now, so I am
commenting out the use warnings stuff...
Revision 1.23: download - view: text, markup, annotated - select for diffs
Fri Sep 5 01:57:54 2003 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.22: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.22: +15 -3
lines
Clear package variables on both normal completion and on interruption.
Revision 1.22: download - view: text, markup, annotated - select for diffs
Fri Sep 5 01:06:45 2003 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.21: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.21: +11 -5
lines
Minor modifications brought about due to making warnings fatal.
Revision 1.21: download - view: text, markup, annotated - select for diffs
Tue Aug 26 19:14:06 2003 UTC (21 years ago) by matthew
Branches: MAIN
CVS tags: version_1_0_3,
version_1_0_1
Branch point for: version_1_0_2
Diff to previous 1.20: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.20: +4 -2
lines
HTML::Entities::encode does not encode backslash. How annoying.
Do it ourselves to make sure formulas come up properly when editing
spreadsheet cells.
Revision 1.20: download - view: text, markup, annotated - select for diffs
Fri Aug 1 13:47:26 2003 UTC (21 years ago) by matthew
Branches: MAIN
CVS tags: version_1_0_0,
version_0_99_5,
version_0_99_4
Diff to previous 1.19: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.19: +3 -3
lines
Bug 840, default spreadsheet should show proper available points on
excused and partially excused problems.
Revision 1.19: download - view: text, markup, annotated - select for diffs
Wed Jul 16 16:48:51 2003 UTC (21 years, 1 month ago) by matthew
Branches: MAIN
Diff to previous 1.18: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.18: +18 -9
lines
Fix bug 1221: due date changes not showing up in spreadsheet.
The issue is with expiration dates in &check_expiration_time()
1. Was using 'usymb' when we should have been using 'symb'.
2. We were not checking for the case in which all students have had the
sheet associated with a given symb expired, as happens when you set
a parameter for a problem.
Revision 1.18: download - view: text, markup, annotated - select for diffs
Wed Jun 25 15:33:49 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
CVS tags: version_0_99_3
Diff to previous 1.17: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.17: +9 -7
lines
Bug 1635: Handle ' and " cleanly.
&html_editable_cell:By default &HTML::Entities::encode does
not encode single quotes. By passing our own list of things to encode
(or in this case, not to encode) we take care of all sorts of issues.
Revision 1.17: download - view: text, markup, annotated - select for diffs
Mon Jun 23 19:58:18 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
Diff to previous 1.16: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.16: +14 -7
lines
Bug 1729 - color hints on export/import rows. The color of the export
row of the assessment sheet is the same as the import row of the
student sheet. The export row of the student sheet is the same color
as the import rows of the course level sheet.
Revision 1.16: download - view: text, markup, annotated - select for diffs
Fri Jun 20 16:14:30 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
Diff to previous 1.15: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.15: +4 -1
lines
When changing the default assesscalc spreadsheet we now expire the
student level spreadsheets.
Revision 1.15: download - view: text, markup, annotated - select for diffs
Wed Jun 18 19:09:23 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
Diff to previous 1.14: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.14: +1 -4
lines
Remove unused code. When the system tries to compute a spreadsheet
we first try to load the sheet from the class' directory. If the
sheet is not present we then load the system default for that level.
This allows the user to make changes to a spreadsheet and save it
with the same name as the system default (default_sheetlevel).
Revision 1.14: download - view: text, markup, annotated - select for diffs
Wed Jun 18 17:35:14 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
Diff to previous 1.13: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.13: +11 -9
lines
Attempt to fix bug 1635. Errors in quoting of parameters caused errors.
Revision 1.13: download - view: text, markup, annotated - select for diffs
Wed Jun 18 15:32:37 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
Diff to previous 1.12: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.12: +58 -51
lines
Reworked spreadsheet filename handling.
Revision 1.12: download - view: text, markup, annotated - select for diffs
Thu May 29 18:31:27 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
CVS tags: version_0_99_2,
version_0_99_1,
conference_2003
Diff to previous 1.11: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.11: +26 -13
lines
Fixes bugs 1513 and 1516. Every time a new row is added to a spreadsheet
the spreadsheet will be saved.
&set_row_numbers now actually keeps track of the maximum row found, which
can be useful if you need to add a new row...
Also fixed bug in caching of spreadsheets - was storing the 'join'd version
of the formulas when I expected a hash reference.
Revision 1.11: download - view: text, markup, annotated - select for diffs
Thu May 29 13:39:38 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
Diff to previous 1.10: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.10: +6 -1
lines
Added $spreadsheet->initialize() subroutine to take care of specific
initialization needed for each sheet. assesscalc now has a list of
mandatory parameters (Bug 1514) but is running in to problems with
bug 1513.
Revision 1.10: download - view: text, markup, annotated - select for diffs
Wed May 28 17:38:57 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.9: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.9: +3 -3
lines
Modification to &expandsum: If we cannot locate the parameter, return '""'
instead of a string describing the parameter we could not find. This
keeps a lack of a parameter from blowing up a cell computation.
Revision 1.9: download - view: text, markup, annotated - select for diffs
Wed May 28 15:20:40 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.8: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.8: +7 -6
lines
Fix bug 1518 - spreadsheet temporary filename was changed if you edited
the default spreadsheet.
Revision 1.8: download - view: text, markup, annotated - select for diffs
Tue May 27 21:17:22 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.7: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.7: +9 -10
lines
Fixes to allow loading of files from published resource space.
Removed superflous logthis calls.
Revision 1.7: download - view: text, markup, annotated - select for diffs
Tue May 27 20:36:02 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.6: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.6: +3 -3
lines
Fix display of template rows to not show uneditable cells as editable.
Revision 1.6: download - view: text, markup, annotated - select for diffs
Fri May 23 21:03:29 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
CVS tags: version_0_99_0
Diff to previous 1.5: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.5: +60 -1
lines
CSV output implemented.
Revision 1.5: download - view: text, markup, annotated - select for diffs
Fri May 23 19:36:04 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.4: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.4: +106 -1
lines
Added output selector and implemented excel output.
Moved $spreadsheet->display() to Spreadsheet.pm instead of having it reside
three times in the descendents of the spreadsheet object.
Moved $spreadsheet->outsheet_excel() to Spreadsheet.pm for the same reason.
Created Spreadsheet::output_selector, which allows the user to select the
output mode they desire.
Created $spreadsheet->excel_output_row which takes care of writing a row
to an excel worksheet.
classcalc.pm, studentcalc.pm, and assesscalc.pm each had the same work done
on them:
Created &excel_rows(), which writes the body of the spreadsheets to
an excel file.
Rewrote &get_title to return an array of title lines.
Created &get_html_title to return an HTML version of the results of
&get_title.
classcalc.pm and Spreadsheet.pm each have the following change:
Created &html_header to return appropriate HTML for the spreadsheet.
Revision 1.4: download - view: text, markup, annotated - select for diffs
Fri May 23 14:52:51 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.3: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.3: +16 -1
lines
No longer save the results of computation of temporary spreadsheets.
Added Spreadsheet->temporary() to handle the getting and setting of the flag
which indicates a spreadsheet is temporary. studentcalc.pm and assesscalc.pm
check this flag before saving their export rows.
Revision 1.3: download - view: text, markup, annotated - select for diffs
Thu May 22 21:16:35 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.2: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.2: +11 -1
lines
Added 'blackout' support. A blackout occurs when an assessment has a part
flagged with 'problemstatus' equal to 'no'. This prevents the display of
the students performance on the part until the answerdate has passed.
Spreadsheet.pm contains &blackout, which returns the blackout status of
the current spreadsheet.
assesscalc.pm contains code which
a) causes the computation of the spreadsheet to determine the
blackout status
b) forces the recomputation of the spreadsheet if the user is a student.
Obviously (b) is less than ideal and a new approach should be found.
studentcalc.pm's outsheet_html subroutine now supresses the display of the
export (aka 'summary') row, as well as the rows of any assessments which
are under blackout.
Revision 1.2: download - view: text, markup, annotated - select for diffs
Mon May 19 13:58:05 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.1: preferred, unified to selected 1.26: preferred, unified
Changes since revision 1.1: +4 -2
lines
$spreadsheet->othersheets() returns ('Default') if it is unable to find any
other spreadsheets.
Revision 1.1: download - view: text, markup, annotated - select for diffs
Fri May 16 20:55:11 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to selected 1.26: preferred, unified
Nearly complete reworking of spreadsheet.
lonspreadsheet.pm holds a few utility functions and the handler, which
creates a spreadsheet and tells it to display itself.
Spreadsheet.pm is the base definition of the spreadsheet object.
classcalc.pm, studentcalc.pm, and assesscalc.pm are implementations of the
spreadsheets.
There are missing pieces - excel and csv output, limiting by section
permissions, the ability to add extra 'header' rows to the student and
course level sheets, and students are still allowed to view the assessment
level sheets (will disable this soon).
Computing and editing of the spreadsheet have been tested and have been
given a preliminary seal of approval.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>