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