MyBB Community Forums
[Pushed] Pasting From Spreadsheets Issue - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Development (https://community.mybb.com/forum-161.html)
+--- Forum: MyBB 1.8 Development (https://community.mybb.com/forum-165.html)
+---- Forum: 1.8 Bugs and Issues (https://community.mybb.com/forum-157.html)
+----- Forum: Pushed (https://community.mybb.com/forum-183.html)
+----- Thread: [Pushed] Pasting From Spreadsheets Issue (/thread-166801.html)

Pages: 1 2


Pasting From Spreadsheets Issue - Robmeister89 - 2015-02-09

So before the update to 1.8 I had no issues with copying from my Excel spreadsheet to MyBB but now I'm having issues with it... Let me explain...

Back when I was using version 1.6, when I was pasting from a spreadsheet into the post it would initially come out like this:
1)            8.94        NEB        @            STL

2)            8.74        SD           @            SF
3)            5.96        HOU      @            WTX
4)            2.21        LA           @            SAC
5)            1.77        LON       @            WSH
6)            1.55        CR           @            ORL
7)            0.86        NY          @            NJ
8)            0.78        POR       @            SLC
9)            0.08        IA            @            COL
10)          -0.02      TRA        @            CIN
11)          -0.24      BIR         @            CAR
12)          -0.44      TRI          @            SB
13)          -0.53      NO         @            VIC
14)          -0.89      PHI         @            PIT
15)          -0.89      LV           @            SEA
16)          -1.33      ATL         @            BAL

Please notice between each Rank, Rating, Team @ Team there are many spaces.
 
And when I would post in the topic it would auto-correct to just one space (like below):
1) 8.94 NEB @ STL
2) 8.74 SD @ SF
3) 5.96 HOU @ WTX
4) 2.21 LA @ SAC
5) 1.77 LON @ WSH
6) 1.55 CR @ ORL
7) 0.86 NY @ NJ
8) 0.78 POR @ SLC
9) 0.08 IA @ COL
10) -0.02 TRA @ CIN
11) -0.24 BIR @ CAR
12) -0.44 TRI @ SB
13) -0.53 NO @ VIC
14) -0.89 PHI @ PIT
15) -0.89 LV @ SEA
16) -1.33 ATL @ BAL

Please notice between each Rank, Rating, Team @ Team there is only one space.

Now when I do this in version 1.8 it does not auto-correct to the one with just one space.

Is there a way to fix this to how it was in 1.6???


Please also take note of the random line that has been added between 1 and 2 in the top. This is also happening when pasting from a spreadsheet. That line between 1 and 2 should not be there.


RE: Pasting From Spreadsheets Issue - .m. - 2015-02-09

replies here might help in using excel sheets on MyBB forum posts


RE: Pasting From Spreadsheets Issue - Robmeister89 - 2015-02-09

I'm not trying to upload a spreadsheet. Just trying to paste from one and not have it appear like the first one above but appear as the second one above like out used to in 1.6..


RE: Pasting From Spreadsheets Issue - .m. - 2015-02-09

well, you can use suggested ASAP utilities and paste generated html code in posts
(Note: only admins & selected staff should have html posting privileges [see HTML in Posts])


RE: Pasting From Spreadsheets Issue - Robmeister89 - 2015-02-09

Isn't there a setting to turn this !!!!!!!! Into this ! ? I'm sure it would be the same one with spaces, no? I need a setting that will prevent the same character from being used consecutively. Kind of like the setting to turn ALL CAPS words into Words With One Capitalization.


RE: Pasting From Spreadsheets Issue - Ad Bakker - 2015-02-09

I think I'd rather post a screenshot of the Excel sheet.


RE: Pasting From Spreadsheets Issue - Robmeister89 - 2015-02-11

Any word on this??

I just need a way that erases the extra spaces... 1.6 used to do it but now 1.8 doesn't.. And 1.8 is adding extra lines in there for no apparent reason??

1) 17.73 SF @ LA
2) 10.19 NJ @ BIR
3) 4.64 WSH @ ATL
4) 3.43 COL @ NEB
5) 1.57 ORL @ TRI
6) 1.20 WTX @ NO
7) 0.91 STL @ IA
8) 0.43 SAC @ SD
9) 0.20 VIC @ HOU
10) 0.19 SB @ CR
11) 0.03 SEA @ POR
12) 0.01 PIT @ TRA
13) 0.01 BAL @ LON
14) -0.53 CAR @ NY
15) -0.53 CIN @ PHI
16) -0.89 SLC @ LV

Okay so I literally just posted from another spreadsheet and the spaces were automatically eliminated when I hit "post reply"... What is going on with my forum if its working here?

The above list of 16 games originally had all of the spaces before I pressed "post reply". Once it was submitted it auto-corrected.. whats up with that?


RE: Pasting From Spreadsheets Issue - .m. - 2015-02-12

can you use pre MyCode tag to paste the content from the Excel .. eg. [pre]content[/pre]


RE: Pasting From Spreadsheets Issue - Robmeister89 - 2015-02-12

Pre didn't help...

Its really weird that this forum would delete the extra spaces but my forum won't.. In fact, when I paste from the spreadsheet (to my forum) it comes out where everything is on its own line. When I paste into Word then into the forum the extra spaces still remain..


RE: Pasting From Spreadsheets Issue - Destroy666 - 2015-02-12

If you paste it to quick reply, spaces will be removed, unless you're using a plugin that adds an editor to quick reply. When using full reply spaces don't get removed here either.

Not sure if we should consider it as a very very low priority bug (inconsistent behavior) and what we can do, but I'll move it to bug reports.