![]() This is only in the cells containing data imported from the broker. Those cells all show a red triangle/arrow-symbol that means there is hidden data in that cell. This is where the problem lies - as this resize occurs, I get a column-width for the 9 imported columns that doesn't follow any obvious logic. Narrow columns SHOULD go back to the correct size, and wider columns SHOULD show all the relevant data. When I finish each task, I resize the whole spreadsheet back to having all columns the optimum viewing width, by clicking in the top-left-corner cell and then double-clicking on any of the column width divider lines. For each formula, and there are more than 20, it involves a different combination of re-sizing to visually compare cells. This allows me to see the data in various columns that are not adjacent. In creating/applying my formulae I need to scroll across and down quite a bit, and I usually solve this by re-sizing the columns (by highlighting the column headings, and dragging the column-width to be either really small or hidden). I then move this data into the relevant columns, and apply the formulae I need to double-check broker accuracy and also to summarize the trading results. then try to open it to other unit and see if it works. The CSV files varied in size from a 10s to 100s of rows, each one needing to be. Then Review Tab /Protect/Protect Sheet and choose the appropriate options you want to lock. Drag and drop files or folders Freeze header rows/columns so theyre. Choose Format/Cells and in the Protection tab select Unlock. ![]() Each week I import 9 columns of data from the website of my online broker, via a cut-and paste from their website into this spreadsheet. Answer marjiiee.g Independent Advisor Replied on NovemReport abuse Select your column. The spreadsheet is quite large, currently horizontally to col BN and vertically to row 4239. I use Calc for summary calculations for my Forex trading. Actually the biggest annoyance I have is that I can't think of the right words to describe the problem correctly! Sorry but you still need to set the width which is not automaticly IMO. 2) Tabbing through the last displayed column proceeds to the next record and not the next field. This will keep the locked filed from scrolling but resize columns in maybe an unwanted way.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |