On 18 May 2023 at 20:38, Brian Barker wrote: Date sent: Thu, 18 May 2023 20:38:46 +0100 To: [email protected] From: Brian Barker <[email protected]> Subject: Re: [libreoffice-users] Is there a way to have cell format remain with an external link?? Copies to: "Michael D. Setzer II" <[email protected]>
> At 00:45 19/05/2023 +1000, Michael D. Setzer II wrote: > >Have a spreadsheet that has internal link that is updated on > >loading. 6 of the columns have numbers with either 1 or 2 decimal > >places. But when it imports the cells change to display only the > >non-zero decimals. So numbers that have x.00 are displayed as x, and > >ones with x.y0 are displayed as x.y. Tried selecting column to > >format, but on next update it goes back to the general format. Could > >create a macro to redo formatting, seems there should be a method. > >Other columns have whole numbers so changing spreadsheet default > >would no be a solution. > > I imagine that you have set up the linkage to a named range in the > source spreadsheet, and it appears that doing it this way the > formatting of the source data is carried over - which is not what you want. > > Here are two thoughts: > > 1. There is an alternative way to arrange linkage: just enter "=" (no > quotes) into a cell and then click on the relevant source cell in the > other spreadsheet. This is just as you would do within the same > spreadsheet, of course, and - unlike the other method - it creates a > formula in the cell. It is easier than it sounds, as you can fill > such formulae into other cells in the required range. This technique > appears not to carry over the cell formatting, so it may achieve what > you desire. > > 2. In any case, there is a workaround. Create your link in whatever > way is convenient. Don't worry about the formatting of the values. In > another column, make copies of the values using the "=" technique. > Format this new column as you wish. If preferred, hide the original column. > > I trust this helps. > > Brian Barker > Thanks for the quick reply. I should have been a little clear. The data is being linked to a csv file that contains data that is extracted from cable modem every15 minutes to track status page data of the 32 channels with tracking uncorrectable errors, power levels and SNR levels. Then it creates three graphs of data. One tracks the first two fields in an X/Y graph. Next 3 fields are th max power level of 32 channels, min, and diff. Graphs max and min. Final 3 are the max, min, diff of SNR readings. 2023-05-18 23:42:18,15661,-2.0,-8.8,6.8,37.36,33.96,3.40 2023-05-18 23:57:19,1159,-1.9,-8.8,6.9,37.64,34.35,3.29 2023-05-19 00:12:19,23583,-1.9,-8.8,6.9,37.64,34.48,3.16 2023-05-19 00:27:20,7,-2.0,-8.8,6.8,37.64,34.35,3.29 2023-05-19 00:42:21,0,-2.0,-8.9,6.9,37.64,33.83,3.81 2023-05-19 00:57:21,0,-2.0,-8.8,6.8,37.64,33.83,3.81 2023-05-19 01:12:22,0,-2.0,-8.8,6.8,37.64,33.96,3.68 2023-05-19 01:27:23,0,-2.0,-8.8,6.8,37.64,33.96,3.68 2023-05-19 01:42:23,0,-1.9,-8.8,6.9,37.64,33.96,3.68 When it imports from csv file data is brought in as general format. My solution is a simple macro. I setup 6 cells in another area of spreadsheet that have formatting I want 3 columns with .1 and then 3 columns with .2. Then have it copy the cells formatting contents only over the area where data is copied. Have to run macro every time. Just linked macro to a little image, so just clicking on it. to run. Thanks again fro the quick reply. The data from cable modem, is an html page, so requies extracting info, and pulling data to make th csv files. > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > +------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:[email protected] mailto:[email protected] Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
