| View previous topic :: View next topic |
| Author |
Message |
Lasteph
General User
Joined: 05 Nov 2007
Posts: 6
Location: London
|
 Posted: Fri Nov 09, 2007 7:17 am Post subject: Merging files in calc |
 |
|
Hi
I wonder if you can help me with this problem
I have just started to produce an aged dtrs report in CSV format from our Sage Accounting software
The report is exported into OO Calc and then additional information for particular rows is added in a seperate column
What I then need to do is produce an updated report from Sage and merge is with the original document.
So for example if I produce a report for October I will then add comments in an additional column depending on the outcome of me chasing the dtr.
I will then produce a report in November which will have some dtrs added and some dtrs deleted
I need to merge Nov back to Oct whilst incorporating these changes but not lose any of the notes in the additional column
Hope all that makes sense and thanks for reading
_________________
LASTEPH |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Fri Nov 09, 2007 11:46 am Post subject: Re: Merging files in calc |
|
|
| Lasteph wrote: | Hi
I wonder if you can help me with this problem
I have just started to produce an aged dtrs report in CSV format from our Sage Accounting software
The report is exported into OO Calc and then additional information for particular rows is added in a seperate column
What I then need to do is produce an updated report from Sage and merge is with the original document.
So for example if I produce a report for October I will then add comments in an additional column depending on the outcome of me chasing the dtr.
I will then produce a report in November which will have some dtrs added and some dtrs deleted
I need to merge Nov back to Oct whilst incorporating these changes but not lose any of the notes in the additional column
Hope all that makes sense and thanks for reading |
Err what's a dtrs? 
What I really don't get is the merging where you speak of merging Nov back to Oct. Are you essentially eliminating Oct and Nov and creating a new result Oct-Nov(combined) ?
What happens to the comments columns if there are comments for Oct or Nov or if there are comments for both? Do you need to combine (maybe concatinate these comments for what? Or am I misunderstanding and there will be a comment column for each month. I have been considering only one column for the sheet.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
Lasteph
General User
Joined: 05 Nov 2007
Posts: 6
Location: London
|
| Posted: Mon Nov 12, 2007 2:19 am Post subject: merging documents |
|
|
Hi thanks for the reply
Basically I want to overwrite Oct with Nov
But retain the column with the comments
So if there is a row on Oct that hasn't changed and has comments added I need to preserve it.
If there is a row on Oct which needs to be deleted the comments need to go as well
For Nov there are no comments because this sheet is generated straight off of sage which has no comments
The comments are only added when it is merged or when any subsequent comments are entered.
Hope that makes sense
_________________
LASTEPH |
|
| Back to top |
|
|
|
