With base I cannot pin it down, except that it will fail with a specific spreadsheet already open. In my case I do have a suspect because when I calc, or base I will get a crash. But then I thought about it a bit more and wondered how much work it would be, and how much expertise I'd need that I don't have ready to hand. If OO runs stable in that mode you should look for some program/driver that runs in Windows normal mode that interferes with OO." OK, that's all for now, starting Windows in Safe mode, then run OO. Even better is to run the database as an HSQL server and just have the openoffice front end talk to that. Backup every session, and don't do dev work until you've saved your data entry, is what I try to live by, unless I forget.Ī big plus for reliability is to separate the database out from the openoffice front end (see Villeroy et al). If your dev code goes wrong you are liable to lose recent data. AND don't mix dev stuff with data entry (like I do sometimes). Even so, there can be issues so frequent backups are the way to go. I only use AOO base for data entry, most of my procedures and functions are written in HSQL. So there are two things to consider if any of the sys engineers from AOO happen to be passing at the moment. But this may well be an unexpected side-effect of poor memory management because in the past (IIRC !!) I have upped the memory in the java start command. I believe the term "thread-safe" would be a desirable aim if my guess is correct. If the wrong one gets there first you can have a problem. That term applies to two parallel processes which do not synchronise but should. Figure 6.10: “A Chart in Calc” shows the sample chart in its final form.My belief is that there is a race condition which, whether or not it's that, is most prevalent at startup (opening calc or base). Finally, after clicking ‘ Create’, the chart is inserted into your spreadsheet. In this case, use ‘ Monthly Expenses’ as a chart title and ‘ Euro’ on the Y axis. On the next page, give the chart, as well as its X axis and Y axis, a title. Also, a chart legend is added on the right-hand side. If you enable the ‘ Show text elements in preview’ option, the column headers ( January, February, etc.) are displayed on the X axis and the numerical values on the Y axis. For the current example, select ‘ Symbols’. Click ‘ Next’ to proceed to a page in which to choose from different variants of line charts: with or without symbols, stacked, percent, cubic spline, and so on. The most suitable type for our example is the line chart. To the left, the page displays a preview of your data according to the type selected. The types offered include line, area, column, and bar charts. The main page shows the available chart types. Usually, the settings on this page can be accepted without change. The first page in this dialog gives the option to modify the original cell selection and to specify whether to use the first row or column as chart labels. To create a chart, select ‘ Insert’ -> ‘ Chart…’. Basically, the formula is a short form of a longer one, which would read: = B3+B4+B5+D3+D4+D5. Accordingly, the formula = SUM(B3:B5 D3:D5) adds everything from B3 to B5 and from D3 to D5. By contrast, ranges are separated by semicolons. You can also specify several ranges at once.Īs shown in the above formula, a range is defined by two cell addresses separated by a colon. This formula adds all numbers from B3 to B5. An alternative possibility is to click the Sigma ( Sigma) icon next to the input line and enter the range manually. In the field B6, enter the formula =SUM(B3:B5). For example, if you have several items in your A column and want to add them, try the SUM function. A new row is inserted below the current one and can immediately be used for additional input.Įntering formulas in the above way is cumbersome when many cells are involved. For instance, to insert another row between Fuel and Sum, right-click the 5 button to the left and select ‘ Insert Row’ from the context menu. A comprehensive list arranged in categories is available under ‘ Insert’ -> ‘ Function…’. Calc offers many functions beyond the four fundamental arithmetic operations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |