Re: [libreoffice-users] Is there a way to have cell format remain with an external link??

On 18 May 2023 at 20:38, Brian Barker wrote:

Date sent:              Thu, 18 May 2023 20:38:46 +0100
To:                     users@global.libreoffice.org
From:                   Brian Barker <b.m.barker@btinternet.com>
Subject:                Re: [libreoffice-users] Is there a way to have cell 
format
        remain with an external link??
Copies to:              "Michael D. Setzer II" <msetzerii@gmail.com>

> 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: users+unsubscribe@global.libreoffice.org
> 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:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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