emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Problem: Moving rows in a table changes vsum start and end
@ 2012-09-28  8:37 Torsten Wagner
  2012-09-28  8:46 ` Bastien
  0 siblings, 1 reply; 18+ messages in thread
From: Torsten Wagner @ 2012-09-28  8:37 UTC (permalink / raw)
  To: Org Mode Mailing List

Hi,

I just notice a funny row-shift effect, having a table with a field
calculated by vsum.


| Nr. | value |
|-----+-------|
|   1 |     5 |
|   2 |     5 |
|   3 |     5 |
|   4 |     5 |
|   5 |     5 |
|   6 |     5 |
|-----+-------|
| Sum |    30 |
#+TBLFM: @8$2=vsum(@2..@7)

now shift (sort) the rows by using M-arrowup and M-arrowdown


| Nr. | value |
|-----+-------|
|   1 |     5 |
|   6 |     5 |
|   5 |     5 |
|   3 |     5 |
|   4 |     5 |
|   2 |     5 |
|-----+-------|
| Sum |    10 |
#+TBLFM: @8$2=vsum(@2..@3)

Check, the #+TBLM:-line changed too! This might be desired sometimes
but might also trouble people if they do not give careful attention.

I know someone could do

| Nr. | value |
|-----+-------|
|   1 |     5 |
|   6 |     5 |
|   5 |     5 |
|   3 |     5 |
|   4 |     5 |
|   2 |     5 |
|-----+-------|
| Sum |    30 |
#+TBLFM: @8$2=vsum(@I..@II)

But still I feel that people can too easily trap into wrong calculus.

One solution, I could see is then whenever forms change
"automagically" highlight this changes within the TBFM line, e.g.,  by
a change of the background color in a similar way like matching
parenthesis. That might help to make people more aware of it and shows
which equations are affected by the current operation.


All the best

Torsten

^ permalink raw reply	[flat|nested] 18+ messages in thread

end of thread, other threads:[~2012-09-30  7:30 UTC | newest]

Thread overview: 18+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2012-09-28  8:37 Problem: Moving rows in a table changes vsum start and end Torsten Wagner
2012-09-28  8:46 ` Bastien
2012-09-28 12:32   ` Torsten Wagner
2012-09-28 13:53     ` Bastien
2012-09-28 16:17       ` Torsten Wagner
2012-09-28 16:56         ` Bastien
2012-09-28 16:00     ` Bastien
2012-09-28 16:18       ` Torsten Wagner
2012-09-29  9:17       ` Carsten Dominik
2012-09-29  9:57         ` Achim Gratz
2012-09-29  9:59           ` Bastien
2012-09-29 10:03             ` Achim Gratz
2012-09-29 10:01           ` Carsten Dominik
2012-09-29 10:04             ` Bastien
2012-09-29 10:11             ` Achim Gratz
2012-09-29 10:58               ` Carsten Dominik
2012-09-29 12:02                 ` Achim Gratz
2012-09-30  7:30         ` Torsten Wagner

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).