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

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 disply 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.

Thanks.

+------------------------------------------------------------+
 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