AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
But since some time this feature was picked up by Atlassian's developers and looks like it should be available from 6.0 release, here what was said in the comment: There is a ticket CONF-2814, which has there for a while. Official support of the feature from Atlassian Make sure that the cursor in located in a filled cell when saving, otherwise it cannot be loaded in to Aleph successfully.Python script for creating a copy of a tree of Confluence pages.Ctrl + dragging down the + will copy down.Dragging down the + will create consecutive values (also called copy down).Be careful that the values only increment when they need to several columns need to be copied down, not incremented.You can also do this by clicking on a particular cell in the Description column and choosing Clear contents and then typing whatever you want.The cell will no longer contain a formula, so you can edit it directly.Choose Paste Special, and Paste Values.To make a different description (such as for an Index).If you feel that the formula was messed up someplace because you inserted or deleted a row, then go to the spot where the formula was last working correctly and copy it down again.Reversing this breaks the formula and you will have to start with a new spreadsheet.Never delete rows for missing items until formula has been applied to all items.Fill in the data Before choosing the formula.To delete the data in a column, highlight the contents and hit the delete key on your keyboard.Observe the column names, these match the subfield indicator value.If you delete the column, your data will not go into Aleph in the correct fields and subfields. Do not use special characters except underscore.Use a recognizable form of the title you are itemizing, being sure to observe the following Aleph rules for file names:.When you make changes to your data, the description will automatically update. If the formula seems to be working correctly, copy the cell with the formula as far down the column as you wish.Hit Tab, to stop editing the formula, Or, click at the end of the formula and then hit Enter.Insert "=" at the beginning of the formula.When pasting into a later row, be sure to change the row number BEFORE inserting "=". The formulas all assume you will be pasting into Row 2.Make any necessary changes, such as changing "v." to "Bd.", BEFORE you insert "=".This is usually cell S2, but may be subsequent cells in Column S if a change is required. Paste the formula into the correct cell for the description.(copy the formula only, not the description of the formula) Please observe the following steps in this order: Be sure to fill in the Item Status and Material Type in columns T and U, respectively.įormulas There are useful formulas for creating descriptions on Worksheet 3.You can start over with the next appropriate numbering (e.g.If you want to skip a number, then type in the new starting point in the next cell and continue to Fill Series. The line numbers, called "subfield 8" in column C, can be generated by filling in the first cell (e.g.: 1.1) for whatever the first needed enumeration value and then using the fill function.When pulling down a cell to copy or fill the rest of the column, be sure to check that you have what you want - sometimes you might have consecutive numbers by using 'Fill Series' instead of "Copy Cells.".The "HOL_rec" must have the entire nine-digit Holding Record number (use leading zeroes).Worksheets 2 and 3 are to help you fill out data. Worksheet 1 (Template) is the only one that will be copied into Aleph. If you want to delete all the contents of a column, highlight the faulty data, right click, and choose Clear Contents.If you delete the column, your data will not go into Aleph in the correct fields and sub-fields.Unwanted columns can be hidden, but deleting them will break the formatting,.Do not assume that the sub-field "a" will be in column A, because this is not the way the columns are set up. Observe the column names and fill in the appropriate data.This makes it easy to find your exceptions later. Hint: Use a recognizable form of the title you are itemizing. Do not use special characters except underscore (_).The following instructions assume you already have your own copy of the template.
0 Comments
Read More
Leave a Reply. |