XL2BB - Excel Range to BBCode 2.1

[psycoperl]

@psycoperl - I tested the add-in in my MacBook with dual monitor settings, found the issue, and also realized why I can't reproduce the same behavior on iMac with dual monitor.

The following screenshot shows my display arrangements on my desktop environment:
View attachment 29316
However, when I am using the MacBook Pro with the external monitor, it is something like the following since I am placing the external monitor in a higher position to be able to see it behind the MacBook screen:
View attachment 29317

There is a special routine in the code that relocates the user form considering the dual-monitors to avoid it to be displayed in the primary monitor if the application window is being used in the secondary monitor. Therefore, the user form is being moved but displayed in the blank area just below the external monitor in this arrangement.

There is no way (or at least a workaround that I am aware of) to calculate this difference between screen top-left coordinates in VBA. Even internal applications like the screenshot tool that remembers the previously selected area messes up when the screen vertical positions are set to be different. I am not sure if it also fails in Windows as well and It is kind of possible to find a workaround by using various API methods in Windows, but this is not in the XL2BB development plans since it should support Windows and Mac platforms at the same time.

However, I am happy to say that the next XL2BB update will also solve this dual monitor issue. Until then, as a workaround that I believe you already figured out, you can launch Excel in the primary monitor, and set the additional information options as you wish (likely selecting all checkboxes), and then you can use the context menu command button to generate mini-sheets.

Thanks again for bringing this up, and for all your help. You'll already receive a notification when the new version is released, however, I will also post here about it.

Thank you. My set up is external on top of the internal
Looking forward to testing the new version out.

 

[smozgur]

smozgur updated XL2BB - Excel Range to BBCode with a new update entry:

v2.0 - User interface update and multiple range selection feature

New features:

• Multiple areas can be selected in the same worksheet to create separated mini-sheets. This is useful if you'd like to post separate ranges by excluding the unrelated rows and/or columns without having to hide them.

Changes:

• Additional info options and settings moved to the ribbon tab instead of displaying the add-in user form during the capture. This also solves the dual monitor issues discussed...

Read the rest of this update entry...

 

[KevCarter]

Thank you for the continual updates!!!

 

[smozgur]

Thank you for the continual updates!!!

Thank you for your support by encouraging members to use XL2BB!

 

[etaf]

Dates test for US / UK format - if still formats as US when UK

Book1
	A
1	Date
2	4/1/21
3	5/1/21
4	5/1/21
5	5/1/21
6	6/1/21
7	7/1/21
8	7/1/21
9	12/1/21
10	12/2/21
11	12/3/21
12	12/4/21
13	12/5/21
14	12/6/21
15	12/17/21
Sheet1

 

[smozgur]

If you have the d/m/yyyy format as I have below, then XL2BB will show how you formatted it.
The following is exactly how I formatted in Excel and captured the range by using XL2BB:

wip.xlsm
	A
1	Date
2	13/12/2020
3	14/12/2020
4	15/12/2020
5	16/12/2020
6	17/12/2020
7	18/12/2020
8	19/12/2020
9	20/12/2020
10	21/12/2020
11	22/12/2020
12	23/12/2020
13	24/12/2020
14	25/12/2020
15	26/12/2020
Sheet3

When you copy it from here to the worksheet by using the BB2XL feature (top left copy button), then it will copy date values as numeric, and it will show exact dates that show in the mini-sheet.

Then you need to set the date format when you paste it into Excel since there is no way to transfer the number format.

The result is just as it is expected - correct data transfer.

 

[etaf]

thanks for the reply , i was not expecting a reply, BUT thankyou

I'm in UK with a Date format DD/MM/YYYY
and when i use 2XLBB
and paste into forum it always changes to MM/DD/YYYY format

 

[smozgur]

Interesting. I have DD/MM/YYYY region settings in my Windows machine, and I have the following sample data:

Selected the range, and captured it. Here is the result.

Book1
	A
1	13/01/2021
2	14/01/2021
3	15/01/2021
4	16/01/2021
5	17/01/2021
6	18/01/2021
7	19/01/2021
8	20/01/2021
9	21/01/2021
10	22/01/2021
11	23/01/2021
12	24/01/2021
Sheet1

 

[smozgur]

Just noticed you are on Mac.
Let me test in Mac and get back.

 

[etaf]

i have a mac using 365 if that makes a difference maybe

Book4
	A
3	12/15/20
4	12/16/20
5	12/17/20
6	12/18/20
7	12/19/20
8	12/20/20
9	12/21/20
10	12/22/20
11	12/23/20
12	12/24/20
13	12/25/20
14	12/26/20
15	12/27/20
16	12/28/20
17	12/29/20
18	12/30/20
Sheet1