![]() ![]() This is the first legacy issue in my opinion. It is grid where the aesthetics of a spreadsheet and the backing data meet. The grid is the dominant feature of a current spreadsheet. One types numbers (or strings) in to cells, as well as formulae and finally use menu-options/ribbon/toolbar to effect style changes. ![]() What we have with the standard Excel design is ‘View’ and ‘Model’ intermingled in a rigid grid. There’s been some insightful analysis that this could change, especially because of tablet computing (I forget the link), but we’re not even being warmed up to alternatives to the same installable, fat ‘Excel’ design for online AND offline use. Notwithstanding valiant efforts from earlier forerunners like Visicalc, Lotus123, latter initiatives like OpenOffice’s Calc, GoogleDocs, and Apple’s Numbers, Microsoft still owns the field. Microsoft has ruled the field of spreadsheets for 20 years now. You can select the green checkmark icon at the same time.Exec Summary: A couple of hot web technologies, with another year’s worth of improvements and productization, could take over from classical fat clients Spreadsheet technologies like Excel. If this solved your problem please go to your first post use the Edit button and add to the start of the title. Tell us which dates are "rubbish" because there is no way we can know if means April 7 or July 4. Better yet, tell us your locale and attach your spreadsheet so we can give you specific instructions for your situation. Saving your data and making backups in the Ten Concepts tutorial. I find that it's helpful to put the date in the backup's name (File as of YYYYMMDD.ods) so that you can tell, months later, that it is old. Be sure you know which copy you're working with, since you now have two of them. Be sure to have a backup of the spreadsheet before attempting to fix the problem with Text to Columns. Advice about fixing dates in a column can be found in Text to Columns Q40/A40 discusses the case where all the dates have the month and year reversed, not quite your situation but perhaps a piece of the solution. Understanding data entry explains how Calc interprets values (including dates) that you enter. Dates in cells in Ten concepts that every Calc user should know, and section 5. Marigold022 wrote:I did a few and closed the sheet, re-opening sent all the dates to rubbish again.Background material on how dates are handled in Open Office can be found in section 3. If none of this helps sort out the problem, can you attach your sheet here so we can see what you're dealing with? If I'm in a situation where I'm not sure what input rules Calc is using, I enter dates in international format: YYYY-MM-DD That works correctly no matter what.įinally, are you still using OO 3.1 as shown in your forum signature (bottom line of your posts)? If your locale is English (US), then dates are always entered as M/D/Y, regardless of the cell format. For input, Calc uses built-in rules, based on what locale it thinks you're working in. Second, and this relates to what I said about knowing the inner workings, the cell format does not affect data input, or the value stored in a cell. If you're not saving as ODF, try that from here on. It's important to know and understand how the insides work.įirst, what document format are you saving to? Saving to any format other than OOo's native ODF format (.ods for spreadsheets) carries some risk of losing formatting or even content. Dates can be troublesome because the internals are different from what you see on the screen.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |