Re: Calculation of date - please, let me switch it OFF and never see it again
Posted by: Anonymous
[ip: 211.27.188.193]
on October 13, 2008 11:44 PM
4 has existed since openoffice 1.0 and before under paste special.
1 But something that is not noticed is that you can lock formatting settings format cells number section. Same as in Excel if cells are set as type number you enter 1.1 it will stay 1.1. The issue here is that you are not setting the formatting up of your spreed sheet. This leave Calc and Excel to there own devices. It is also possible to turn it off by setting date to a nothing formatting string. I class this is more not knowing how to use calc and excel correctly both are exactly the same in how you deal with this.
2 is why you create forms to insert data to avoid maths processing. You will find openoffice 2.0 and up calc takes that input without issue. There was a processing bug in openoffice 1.0.
Number 3 is about the only complaint that is really valid. I went as far as creating my own macro to turn them on and off in openoffice. Yes its macro solvable so yes a missing feature yes should be done but is not a show stopper if you have someone who can add macros.
Learn about Linux
Download Linux
Get Linux help
Re: Calculation of date - please, let me switch it OFF and never see it again
Posted by: Anonymous [ip: 211.27.188.193] on October 13, 2008 11:44 PM1 But something that is not noticed is that you can lock formatting settings format cells number section. Same as in Excel if cells are set as type number you enter 1.1 it will stay 1.1. The issue here is that you are not setting the formatting up of your spreed sheet. This leave Calc and Excel to there own devices. It is also possible to turn it off by setting date to a nothing formatting string. I class this is more not knowing how to use calc and excel correctly both are exactly the same in how you deal with this.
2 is why you create forms to insert data to avoid maths processing. You will find openoffice 2.0 and up calc takes that input without issue. There was a processing bug in openoffice 1.0.
Number 3 is about the only complaint that is really valid. I went as far as creating my own macro to turn them on and off in openoffice. Yes its macro solvable so yes a missing feature yes should be done but is not a show stopper if you have someone who can add macros.
#