9/12/2023 0 Comments Openoffice lock column widthUnfortunately when the books were started in 1885 by my wife's great grandfather he didn't consider organising the information so it would be easy for someone of my very limited experience with databases to build one 125 years later! I shall have to give it more thought and see if I can come up with a database structure which will deal with all the variations. You can manually resize rows and columns by dragging them to the desired size. Then when scrolling around within the sheet, any frozen columns and rows remain in view. The tables do the former well but not the latter. You can adjust the height of rows and the width of columns in a table in several ways. Freezing locks a number of rows at the top of a sheet or a number of columns on the left of a sheet or both. There is a conflict here between getting all the original information as it was written up at the time reproduced in print and extracting as much knowledge from it as possible as easily as possible. You are probably right that it should be tackled as a database, it would certainly make analysis of the data a lot easier. Have I missed something? I think I really need the information to be tabular as the number of rows varies with the number of men working and can also include the machines - so each week's table can be a different length - but at the same time we want to get as much information as possible on each page, as in my example.Īcknak. This wouldn't be suitable for what I am trying to do. I have tried it and can get columns of the desired width but they are what I would call "Snaking or Newspaper columns", in that you start at the top of Column1 and go down to the bottom and then on to Column2 at the top and down to the bottom and so on. Select the row (s) whose height you wish to change. Resize one or more rows using Format Similarly to resizing columns. I have just realised that you can turn those off in Tools, Options, OpenOffice.Org, General, Tips which makes clicking in the right place to add or edit the data in a great deal easier. The selected columns display with the new width. I agree that the column widths shouldn't get changed but as you move the mouse across the table as the columns are so narrow, in my case at least on a laptop, I just get continual displays of "Adjust table column" or " Adjust table row". Use the arrow keys on the Column line to scroll among the columns. 3)On the Spacing line, enter the amount of space that you want between each column pair. 2)On the Width line, enter a width for each column. There is an example of the desired layout here. To customize the width and spacing of the columns, follow these steps: 1)In the Width and spacing area, clear the AutoWidth check box. I have spent several hours searching for a solution to this but obviously haven't found the critical menu or am using the wrong words to describe what I want to do. As I have set up a table containing the column titles as a header on each page it is important that its columns line up with those of the several tables on the page. I want the row heights to expand to accommodate the varying amounts of information - not a problem - but I also want the column widths to be locked so that they can't inadvertently be changed whilst entering the information. I have set up a blank Writer table for a week and the intention is to paste this blank table in to the document many times(about 1900 times) and fill in the information for each week in turn. All options are optional.We are transcribing a 19th century farm wages book which contains all the work done and the wages paid to the workers on the farm over a period of 37 years. addWorksheet ( 'sheetname', options ) įull Worksheet options. addWorksheet ( 'Sheet 2' ) // Create a reusable style var style = wb. Workbook ( ) // Add Worksheets to the workbook var ws = wb. Is there a way to get the widths of cells to automatically shrink themselves to fit the longest line in a column Stack Exchange Network Stack Exchange network consists of 181 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. Require library var xl = require ( 'excel4node' ) // Create a new instance of a Workbook class var wb = new xl.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |