Page 1 of 1

[Solved] Export cell range to an email

Posted: Fri Nov 08, 2024 10:50 am
by DavidBoudz
Hi Guys!

I'm new to Open Office, I was on Windows + Excel (shame on me but corporate world rules) but we recently changed to macOS, and OpenOffice is now becoming my new friend :D

I have a process to send email reports, and what I was usually doing is creating table in excel, as Gmail (again no judgment, I stick to company policies) can't handle table creation.
But since I moved to Calc, when I copy-paste my table to my email draft, it doesn't look good.
I know it's not directly related to the software but did anyone got the same issue and have a workaround ?

* Edit, change my way of inserting tables )

Thanks for your help!
David

Re: Export a table to an email

Posted: Fri Nov 08, 2024 11:35 am
by robleyd
Save the "report" and send it as an attachment to the email?

Re: Export a table to an email

Posted: Fri Nov 08, 2024 5:16 pm
by MrProgrammer
DavidBoudz wrote: Fri Nov 08, 2024 10:50 am But since I moved to Calc, when I copy-paste my table to my email draft, it doesn't look good.
There are many problems with this request for assistance:
• You do not attach a document demonstrating the situation; no one else can reproduce your problem
• You do not tell us what "it doesn't look good" means; that description is too vague for anyone to help
• We don't know what procedure you use on your Mac to access Gmail; there are multiple ways to do that
• People here may not use Gmail and thus won't be able to replicate your problem; I don't use it
• You have not stated what result you see in your email system
• You have not explained in detail why that result does not meet your expectations

DavidBoudz wrote: Fri Nov 08, 2024 10:50 am … [does anyone have] the same issue
I find that copy/paste of a cell range from Calc to a message in Apple Mail produces acceptable results so, no, I don't have this issue. Perhaps you have a Gmail problem. Or perhaps you just need a different procedure when pasting and formatting your Gmail message. You should not expect much help for Gmail difficulties on an OpenOffice forum.

DavidBoudz wrote: Fri Nov 08, 2024 10:50 am … [does anyone have] a workaround?
In addition to the suggestion you've been given already, in Calc use File → Export to PDF and put the PDF in your email message. This is what I would do. Using a PDF ensures that the recipient sees the same report that you do, since you don't control what email system they use. PDF is designed to display reliably in any system.

DavidBoudz wrote: Fri Nov 08, 2024 10:50 am OpenOffice is now becoming my new friend [for sending reports]
Perhaps Numbers (Apple's spreadsheet software) would produce an acceptable result for this task. It's pre-installed on every recent Mac. It's different than OpenOffice. It's different than Excel. You'd have to try it. This is not a Numbers forum.
[Tutorial] Mac FAQ   (see Q59/A59)

DavidBoudz wrote: Fri Nov 08, 2024 10:50 am I'm new to Open Office, I was on Windows + Excel (shame on me but corporate world rules) but we recently changed to macOS
If the company changed from Excel to Calc, surely others there have the same problem with reports and email. You should ask them how they handle the situation. If the company continues to use Excel but the machine you use does not have it, either:
• the company should provide a licence for you to run the software that they mandate, or
• you should view the price of Excel to be a cost of the job, just like office attire or commuting are costs of ones job

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know