Ask Your Question

Bastian's profile - activity

2015-01-31 08:04:09 +0200 received badge  Famous Question (source)
2013-10-22 08:29:24 +0200 received badge  Notable Question (source)
2013-10-02 21:33:36 +0200 received badge  Popular Question (source)
2013-10-02 16:39:08 +0200 commented answer How can I subtract 500 from all cells in a given selection in Calc?

Awesome, works perfectly! Thank you so much for the help!

2013-10-02 16:38:49 +0200 received badge  Scholar (source)
2013-10-02 15:39:33 +0200 received badge  Supporter (source)
2013-10-02 15:29:01 +0200 received badge  Famous Question (source)
2013-10-02 15:29:01 +0200 received badge  Popular Question (source)
2013-10-02 15:29:01 +0200 received badge  Notable Question (source)
2013-10-02 15:27:48 +0200 asked a question How can I subtract 500 from all cells in a given selection in Calc?

i have all these numbers: http://i.snag.gy/7irWj.jpg and I want to subtract 500 from each number. do I have to do this manually or can I get Calc to automate the process for me?

2013-03-16 11:49:34 +0200 commented answer Calc: Synchronize Cells?

Oh and how do you upload files here? I had to upload to imgur.com because I couldn't find any place to do attachments.

2013-03-16 11:48:01 +0200 commented answer Calc: Synchronize Cells?

However, the timetable is in its full size is very huge, so I wanted to create a summary of that timetable like this: http://i.imgur.com/k9lbSPt.png - It is much easier for me to get an overview this way, but I need column E in the first datasheet and column D in the second datasheet to contain the same values at all time. Linking is possible, but then I can only update values in one of the datasheets. I want to be able to update the values in both datasheets. How can I do this?

2013-03-16 11:35:12 +0200 commented answer Calc: Synchronize Cells?

I am making a timetable for an upcoming local film festival. I have two datasheets. The first datasheet looks like this: http://i.imgur.com/LDV4noS.png - It shows the categories and everything the categories must contain. The E column contains the time each category will take in total and the time in column B updates when I update the timetable. My job is to keep these numbers up to date so we can see whether we are over-schedule or not.

2013-03-06 03:35:04 +0200 received badge  Student (source)
2013-03-05 23:09:45 +0200 asked a question Calc: Synchronize Cells?

Hello,

I have created a long detailed Timetable in Calc. Now I want to make a Summary version of the timetable containing only key items from the timetable. I want to be able to change the values in cells in both the Summary version and the detailed Timetable and I want Calc to keep the values in synchronization with each other. If the value is updated in one, the change should be reflected in the other. Is this possible?

The closest I have got is by using "Link", but I can only change values in the detailed Timetable that way, not in the Summary Timetable. Help is appreciated!