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
Subject:Re: [libreoffice-users] Is there a way to have cell
format
remain with an external link??
Copies to: "Michael D. Setzer II"
> 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+unsubscr...@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:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
++
--
To unsubscribe e-mail to: users+unsubscr...@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