Calculation of date - please, let me switch it OFF and never see it again
Posted by: Anonymous
[ip: 78.31.159.227]
on October 13, 2008 09:44 PM
My complaints are based on 2.x version - is situation in 3.x better? At least I have not seen anything in the article... So:
1. Is it possible to switch off automatic formating and date calculation and words collecting and suggesting
FOREVER?
For example: 1.1=2008-01-01=39448 (Polish locale, after changing cell format into text)
It is a permament OpenOffice Calc and Excel (at least up to 97, later Excels I have not used) horror.
Especially, that Calc has already options for calculations of date in various formats, but without possibility to have it OFF.
2. Another problem:
1=1345 and something - it and many other things have just entered into memory as virus and each pressing "enter" key without screen control may get horrible result, especially if serious data input. All options regarding collecting of words are formally blocked, but no result...
3. I would like have MY data formats in MY sheet, even if I import data from other MY sheets. Just one check box or Format menu item: all autoformat off. Not default on, but just everything off.
I do not want dancing and singing animations or complicated formulas. Just one great OFF.
4. Another dream: place a Calc table into Writer as a table, not as a graphics. It was possible to copy spreadsheet table into text processor between at least since MS Word 2 and Excel 4. When will it be possible in Open Office?
Learn about Linux
Download Linux
Get Linux help
Calculation of date - please, let me switch it OFF and never see it again
Posted by: Anonymous [ip: 78.31.159.227] on October 13, 2008 09:44 PM1. Is it possible to switch off automatic formating and date calculation and words collecting and suggesting
FOREVER?
For example: 1.1=2008-01-01=39448 (Polish locale, after changing cell format into text)
It is a permament OpenOffice Calc and Excel (at least up to 97, later Excels I have not used) horror.
Especially, that Calc has already options for calculations of date in various formats, but without possibility to have it OFF.
2. Another problem:
1=1345 and something - it and many other things have just entered into memory as virus and each pressing "enter" key without screen control may get horrible result, especially if serious data input. All options regarding collecting of words are formally blocked, but no result...
3. I would like have MY data formats in MY sheet, even if I import data from other MY sheets. Just one check box or Format menu item: all autoformat off. Not default on, but just everything off.
I do not want dancing and singing animations or complicated formulas. Just one great OFF.
4. Another dream: place a Calc table into Writer as a table, not as a graphics. It was possible to copy spreadsheet table into text processor between at least since MS Word 2 and Excel 4. When will it be possible in Open Office?
Are they a looser's dreams?
Greetings :-)
Basia
#