<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN XLSX In Basic code with shortcut keys the keys are ignored"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118248">118248</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX In Basic code with shortcut keys the keys are ignored
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.0.0.alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>BASIC
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kelemeng@ubuntu.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=142934" name="attach_142934" title="Example file from Excel">attachment 142934</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=142934&action=edit" title="Example file from Excel">[details]</a></span>
Example file from Excel
If we use shortcut keys to run macros in Microsoft Excel and open the file with
LibreOffice Calc the shortcut keys do not work.
Steps to reproduce:
1. Create a new spreadsheet with Microsoft Excel 2016/2013
2. Fill a range (for example A1:A2) with numbers
3. Open the Visual Basic window and create a simple visual basic code in a new
module
Sub UnmergeCells()
Range("A3").Formula = "=SUM(A1:A2)"
End Sub
4. Go back to Microsoft Excel spreadsheet and open the developer tab, click
macros and then click “Others..” button.
5. Create a Keyboard shortcut. (Ctrl + Shift + h)
6. Use the Keyboard shortcut which runs the macro.
7. Save the file as *.xlsm and close
8. Open the file LibreOffice Calc.
9. Try to use the Keyboard Shortcut.
Actual results:
The Keyboard shortcut does not work in LibreOffice Calc. If we save the file in
LibreOffice and then open with Microsoft Excel, the Keyboard Shortcut will not
be retained.
Expected results:
The Keyboard shortcuts should work in LibreOffice Calc.
Version: 6.0.0.0.beta1+
Build ID: 29228e83df009cf76ac819ed024527be1092f065
CPU threads: 4; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:libreoffice-6-0, Time: 2017-12-04_23:15:34
Locale: hu-HU (hu_HU); Calc: group threaded</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>