View Issue Details

IDProjectCategoryView StatusLast Update
0004258SOGoWeb Mailpublic2017-09-08 14:56
Reporterfsoyer Assigned Tofrancis  
Status assignedResolutionreopened 
Platform[Server] LinuxOSRHEL/CentOSOS Version7
Product Version3.2.10 
Fixed in Version4.0.0 
Summary0004258: copying/pasting email addresses from calc (xls, ods) result in bad merged address

After trying to resolv this on, and after a lot of tests, I need to open this bug as continuation of closed bug 0004097.
On Sogo 3.2.9, then updated to 3.2.10 (but same behavior on two versions), copying/pasting email addresses from a calc result in one unique merged (and bad) address. I don't post screenshots, as this is exactly the same as those pposted by nenonano on 0004097.

Steps To Reproduce

Open a calc, add email addresses one by cell (on row or on column, no difference). Copy addresses (by keystroke or with menus, no difference), then paste it in a new mail in Sogo 3. Hit enter or change field with mouse (no difference) : the addresses are merged in one big bad address.

Additional Information

server : SOGo 3.2.9 updated to 3.2.10 on CentOS 7.3
Clients : Ubuntu 16.04 - Windows 7
Tested with :
LibreOffice linux -> Firefox linux
LibreOffice linux -> Chrome linux
LibreOffice windows -> Firefox windows
LibreOffice windows -> Chrome windows
Excel 2016 -> Firefox windows
Excel 2016 -> Chrome windows

All tests give same result.

TagsNo tags attached.




2017-08-24 11:27

reporter   ~0012224

[NOTE] Pasting this addresses in a notepad show that :

  • if copied from one column, some lines, it is pasted with carriage returns
  • if copied from on line, some columns, it is pasted with tabs


2017-09-04 09:56

reporter   ~0012252

Last edited: 2017-09-04 09:59

I'm sorry to inform you that this change doesn't solved the problem for me.
I've replaced the file /usr/lib64/GNUstep/SOGo/WebServerResources/js/Mailer/MessageEditorController.js with the new one, and tried to debug it with Chrome developper tool. First, it confirmed to me that the new script is correctly loaded. But I'm not able to debug more, I'm just a sysadmin :) With a breakpoint on line 297, if I paste adresses copied with carriage return as separator (from calc or even a notepad), the debugger shows me that "recipients = [""]". Same if separator is tabulation. But if I just add ";" between pasted adresses, it shows "recipients = (3) ["", "", ""]" and the adresses are correctly displayed.
Is there something else I can try ?



2017-09-04 11:25

reporter   ~0012253

Note: This Sogo 3.2.10 with the new js file is a test server. If necessary I can give access to it with a test account.



2017-09-04 18:44

administrator   ~0012255

This is not the proper way to try the patch since this JavaScript controller ends in a generated JavaScript file. Use the nightly build to easily test it.



2017-09-06 09:35

reporter   ~0012261

Hi Francis, thank you for that. Can you tell us when the 3.2.11 will be available on the repos ? We use rpms on (but I can see that it's not available for other distros)



2017-09-06 13:04

administrator   ~0012264




2017-09-06 22:36

reporter   ~0012270

Last edited: 2017-09-06 22:36

Ok ! nearly done !
I've updated our test server to It works now when pasting adresses copied vertically (some lines in a column) that give a carriage return as separator. But copied from a line (tabulation as separator) it give a big address as before. I know, this not a common case, but...

In any case, thank you for the work.



2017-09-07 16:07

reporter   ~0012277

This commit fixes the bug for us too.

Thanks Francis.



2017-09-08 14:38

reporter   ~0012278

I notice another thing with the field To:, you will tell me if it is dependant or if I must report it specifically.
When typing (or pasting) address(ses), Enter or Tab or click in another field doesn't quit the field To:, we need to re-enter or re-click.

Related Changesets

sogo: master 84edeb85

2017-09-01 11:09


Details Diff
(js) Fix parsing of pasted email addresses

Fixes 0004258 and fixes 0004097
Affected Issues
0004097, 0004258
mod - NEWS Diff File
mod - UI/WebServerResources/js/Mailer/MessageEditorController.js Diff File

sogo: master 614a1371

2017-09-08 10:50


Details Diff
(js) Fix parsing of tab-delimited email addresses

Fixes 0004258
Affected Issues
mod - UI/WebServerResources/js/Mailer/MessageEditorController.js Diff File

Issue History

Date Modified Username Field Change
2017-08-24 10:27 fsoyer New Issue
2017-08-24 11:27 fsoyer Note Added: 0012224
2017-09-01 15:10 francis Changeset attached => sogo master 84edeb85
2017-09-01 15:10 francis Assigned To => francis
2017-09-01 15:10 francis Resolution open => fixed
2017-09-01 15:10 francis Status new => resolved
2017-09-01 15:10 francis Fixed in Version => 4.0.0
2017-09-04 09:56 fsoyer Note Added: 0012252
2017-09-04 09:56 fsoyer Status resolved => feedback
2017-09-04 09:56 fsoyer Resolution fixed => reopened
2017-09-04 09:59 fsoyer Note Edited: 0012252
2017-09-04 11:25 fsoyer Note Added: 0012253
2017-09-04 11:25 fsoyer Status feedback => assigned
2017-09-04 18:44 francis Note Added: 0012255
2017-09-06 09:35 fsoyer Note Added: 0012261
2017-09-06 13:04 francis Note Added: 0012264
2017-09-06 14:27 ludovic Severity major => minor
2017-09-06 22:36 fsoyer Note Added: 0012270
2017-09-06 22:36 fsoyer Note Edited: 0012270
2017-09-07 16:07 cedric.archambeau Note Added: 0012277
2017-09-08 14:38 fsoyer Note Added: 0012278
2017-09-08 14:56 francis Changeset attached => sogo master 614a1371