[Solved] Real Estate Pipeline Leads not converting?

Discuss the spreadsheet application
Post Reply
SourCreaming
Posts: 2
Joined: Wed Apr 15, 2015 9:19 am

[Solved] Real Estate Pipeline Leads not converting?

Post by SourCreaming »

I recently switched over to OpenOffice suite from the other major guys (M$). I primarily am using Calc for my real estate pipeline leads that come in from Wooforms as a CSV.

When I used MS I didn't have problems opening the CSV's, however I feel like an idiot as when I open the file everything gets pushed into different columns. :crazy:

I know this is user error but this has led to complaints from my prospects as I'm not getting back to them quickly! Can someone help me understand how to open my real estate leads from CSV and have it formatted properly? Before I would just open the file and it would work fine.

Thanks in advance.
Last edited by MrProgrammer on Fri Sep 04, 2020 7:46 pm, edited 2 times in total.
Reason: Removed icon used for threads with link to bug report; Tagged ✓ [Solved]
NeoOffice 2.2.3 with MacOS 10.4
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Real Estate Pipeline Leads not converting?

Post by acknak »

Generally, things work more smoothly using MS tools because everyone makes adjustments for that case. Using OO takes some extra time to understand what you're doing and make the adjustments yourself.

If you want specific suggestions for importing your data, we'll have to see a sample of the data. The best way to do that is to put some csv data into a zip archive and attach that here. If the csv file is large, cut it down to a few lines.

Alternatively, you can copy/paste a few lines into a message here. The forum may not preserve every character perfectly, but it's probably ok.

I usually recommend to stay away from opening csv files directly. Better to first start OO Calc, then use Insert > Sheet From File ... and choose your csv file. Then you can set the import parameters to match the csv file.
AOO4/LO5 • Linux • Fedora 23
User avatar
MrProgrammer
Moderator
Posts: 4883
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Real Estate Pipeline Leads not converting?

Post by MrProgrammer »

[Tutorial] Text to Columns

If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
Post Reply