Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc: Disabling auto-update and auto-"range correction" of diagrams

I have a sheet with a huge diagram here that I update in irregular intervals (3 sets of several ten thousands of weather values that grow over time) Now whenever I go into the diagram to change the ranges, I have to manually set the new X and Y ranges for all 3 sets. Now here come the problems:

image description

  • As soon as I have edited one of the 6 ranges I want to edit, I have to wait about a minute because the change I made is apparently applied "live" to the diagram (which as I said is huge and will grow bigger). Can I change Calc's behaviour so that the changes are only applied to the diagram as soon as I hit the OK button? (i.e. disabling "auto-update as I type")
  • I also would like to be able to select a bigger range for the diagram in advance than what actual data I currently have in the sheet, but when I for example enter "70000" it automatically "corrects" to "64531" (see image) because I don't have that much data yet. Is it possible to disable this "auto-correction" so that I can simply put in a higher number (maybe even 200000), leaving the diagram at these still non-existent values blank and when the new data is entered to the sheet, I can easily "refresh" the diagram? As it currently is I always have to manually update the ranges in the diagram whenever new data comes in, which is somewhat annoying

Calc: Disabling auto-update and auto-"range correction" of diagrams

I have a sheet with a huge diagram here that I update in irregular intervals (3 sets of several ten thousands of weather values that grow over time) Now whenever I go into the diagram to change the ranges, I have to manually set the new X and Y ranges for all 3 sets. Now here come the problems:

image description

  • As soon as I have edited one of the 6 ranges I want to edit, I have to wait about a minute because the change I made is apparently applied "live" to the diagram (which as I said is huge and will grow bigger). Can I change Calc's behaviour so that the changes are only applied to the diagram as soon as I hit the OK button? (i.e. disabling "auto-update as I type")
  • I also would like to be able to select a bigger range for the diagram in advance than what actual data I currently have in the sheet, but when I for example enter "70000" it automatically "corrects" to "64531" (see image) because I don't have that much data yet. Is it possible to disable this "auto-correction" so that I can simply put in a higher number (maybe even 200000), leaving the diagram at these still non-existent values blank and when the new data is entered to the sheet, I can easily "refresh" the diagram? As it currently is I always have to manually update the ranges in the diagram whenever new data comes in, which is somewhat annoyingannoying EDIT: Oh forgot, version is 4.2.4.2 on Win7 x64 Home Premium, both in German

Calc: Disabling auto-update and auto-"range correction" of diagrams

I have a sheet with a huge diagram here that I update in irregular intervals (3 sets of several ten thousands of weather values that grow over time) Now whenever I go into the diagram to change the ranges, I have to manually set the new X and Y ranges for all 3 sets. Now here come the problems:

image description

  • As soon as I have edited one of the 6 ranges I want to edit, I have to wait about a minute because the change I made is apparently applied "live" to the diagram (which as I said is huge and will grow bigger). Can I change Calc's behaviour so that the changes are only applied to the diagram as soon as I hit the OK button? (i.e. disabling "auto-update as I type")
  • I also would like to be able to select a bigger range for the diagram in advance than what actual data I currently have in the sheet, but when I for example enter "70000" it automatically "corrects" to "64531" (see image) because I don't have that much data yet. Is it possible to disable this "auto-correction" so that I can simply put in a higher number (maybe even 200000), leaving the diagram at these still non-existent values blank and when the new data is entered to the sheet, I can easily "refresh" the diagram? As it currently is I always have to manually update the ranges in the diagram whenever new data comes in, which is somewhat annoying EDIT: Oh forgot, version is 4.2.4.2 on Win7 x64 Home Premium, both in German

Calc: Disabling auto-update and auto-"range correction" of diagrams

I have a sheet with a huge diagram here that I update in irregular intervals (3 sets of several ten thousands of weather values that grow over time) Now whenever I go into the diagram to change the ranges, I have to manually set the new X and Y ranges for all 3 sets. Now here come the problems:

image description

  • As soon as I have edited one of the 6 ranges I want to edit, I have to wait about a minute because the change I made is apparently applied "live" to the diagram (which as I said is huge and will grow bigger). Can I change Calc's behaviour so that the changes are only applied to the diagram as soon as I hit the OK button? (i.e. disabling "auto-update as I type")
  • I also would like to be able to select a bigger range for the diagram in advance than what actual data I currently have in the sheet, but when I for example enter "70000" it automatically "corrects" to "64531" (see image) because I don't have that much data yet. Is it possible to disable this "auto-correction" so that I can simply put in a higher number (maybe even 200000), leaving the diagram at these still non-existent values blank and when the new data is entered to the sheet, I can easily "refresh" the diagram? As it currently is I always have to manually update the ranges in the diagram whenever new data comes in, which is somewhat annoying EDIT: Oh forgot, version is 4.2.4.2 on Win7 x64 Home Premium, both in German