I have spreadsheets from my financial institutions (for tax purposes). Some of them do the deposits as positive and the debits as negative, and others do the reverse.
Is there an easy way to multiply an entire column by -1 so I can make them all fit a uniform convention? What I've done before is convert the spreadsheets to .csv, use a shell script to invert the chosen column and then convert back to .ods. This is really clunky. Thanks in advance. Mark -- 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
